Unable to cast object of type 'DevExpress.Xpo.DB.Helpers.MSSql2005SqlDependencyCacheRoot' to type 'DevExpress.Xpo.DB.DataCacheRoot'.

[pavlovboris]

𝗗𝗲𝘀𝗰𝗿𝗶𝗯𝗲 𝘁𝗵𝗲 𝗯𝘂𝗴

Hello,

With the last version Im getting the following error:

Unable to cast object of type 'DevExpress.Xpo.DB.Helpers.MSSql2005SqlDependencyCacheRoot' to type 'DevExpress.Xpo.DB.DataCacheRoot'.

at Xpand.Extensions.XAF.Xpo.XpoExtensions.Connection(UnitOfWork unitOfWork) at Xpand.Extensions.XAF.Xpo.ObjectSpaceExtensions.ObjectSpaceExtensions.Connection(IObjectSpace objectSpace) at Xpand.XAF.Modules.SequenceGenerator.SequenceGeneratorService.<>c__DisplayClass19_0.b_2(IObjectSpace t) at System.Reactive.Linq.ObservableImpl.SelectMany`2.ObservableSelector..OnNext(TSource value)

No issue with 4.241.3.

BR

[apobekiaris]

is this with the lab version?

[pavlovboris]

I is 4.241.3.2

[apobekiaris]

revisions mean lab, I will look at it the tenant support is to blame see #1066

[pavlovboris]

aight thank you!

[apobekiaris]

The pre-release 4.241.3.0 in the Reactive.XAF lab branch includes commits that relate to this task:

• SequenceGenerator: throws when cache enabled #1069

To minimize version conflicts we recommend that you use the Xpand.XAF.Core.All, Xpand.XAF.Win.All, Xpand.XAF.Web.All packages. Doing so, all packages will be at your disposal and .NET will add a dependecy only to those packages that you actually use and not to all (see the Modules installation-registrations youtube video).

Released packages:

No packages released.

Please update the related Nuget packages and test if issues is addressed. These are nightly nuget packages available only from our NugetServer.

If you do not use these packages directly but through a module of the main eXpandFramework project, please wait for the bot to notify you again when integration is finished or update the related packages manually.

Thanks a lot for your contribution.

[apobekiaris]

The pre-release 4.241.3.0 in the Reactive.XAF lab branch includes commits that relate to this task:

• SequenceGenerator: Fails if ConnectionString has creds #1066 #1069

To minimize version conflicts we recommend that you use the Xpand.XAF.Core.All, Xpand.XAF.Win.All, Xpand.XAF.Web.All packages. Doing so, all packages will be at your disposal and .NET will add a dependecy only to those packages that you actually use and not to all (see the Modules installation-registrations youtube video).

Released packages:

No packages released.

Please update the related Nuget packages and test if issues is addressed. These are nightly nuget packages available only from our NugetServer.

If you do not use these packages directly but through a module of the main eXpandFramework project, please wait for the bot to notify you again when integration is finished or update the related packages manually.

Thanks a lot for your contribution.

[apobekiaris]

is the fix ok with you? planning to push it public so if you have some time please test

[pavlovboris]

I keep getting the same exception;

[apobekiaris]

I was able to reproduce the case with a blank Xaf solution where I enable Xpo caching, after this patch all works fine on my side. Can you provide a solution that fails?

[apobekiaris]

I assume you are on the latest version 4.241.3.4

[pavlovboris]

yup. Im using the 4.241.3.4 version and custom datastore provider with MSSql2005SqlDependancyCacheRoot to utilize service broker. Will try to repro now

[pavlovboris]

DXApplication2.zip

The win version

[apobekiaris]

The pre-release 4.241.3.0 in the Reactive.XAF lab branch includes commits that relate to this task:

• SequenceGenerator: Unable to cast object #1069

To minimize version conflicts we recommend that you use the Xpand.XAF.Core.All, Xpand.XAF.Win.All, Xpand.XAF.Web.All packages. Doing so, all packages will be at your disposal and .NET will add a dependecy only to those packages that you actually use and not to all (see the Modules installation-registrations youtube video).

Released packages:

No packages released.

Please update the related Nuget packages and test if issues is addressed. These are nightly nuget packages available only from our NugetServer.

If you do not use these packages directly but through a module of the main eXpandFramework project, please wait for the bot to notify you again when integration is finished or update the related packages manually.

Thanks a lot for your contribution.

[pavlovboris]

the previous issue is fixed in 4.241.3.5, but now :

An item with the same key has already been added. Key: Password

at System.Collections.Generic.Dictionary2.TryInsert(TKey key, TValue value, InsertionBehavior behavior) at System.Collections.Generic.Dictionary2.Add(TKey key, TValue value) at DevExpress.Xpo.DB.Helpers.ConnectionStringParser.AddPart(String partName, String partValue) at Xpand.Extensions.XAF.Xpo.ObjectSpaceExtensions.ObjectSpaceExtensions.ConnectionString(IObjectSpace objectSpace) at Xpand.XAF.Modules.SequenceGenerator.SequenceGeneratorService.SequenceGeneratorDataLayer(IObjectSpace space) at Xpand.Extensions.LinqExtensions.LinqExtensions.GetOrAdd[TKey,TValue](IDictionary2 dictionary, TKey key, Func1 valueCreator, String caller) at Xpand.XAF.Modules.SequenceGenerator.SequenceGeneratorService.<>c__DisplayClass19_0.b_2(ValueTuple2 t) at System.Reactive.Linq.ObservableImpl.SelectMany2.ObservableSelector..OnNext(TSource value)

[apobekiaris]

detail me on repro steps please

[pavlovboris]

just try using connection string of type XpoProvider=MSSqlServer;

the one I'm using is like : XpoProvider=MSSqlServer;Pooling=true;Server=tcp:zzz,1433;Persist Security Info=True;User ID=zzz;Password=zzz;initial catalog=zzz;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=True;Connection Timeout=60;

[apobekiaris]

The pre-release 4.241.3.0 in the Reactive.XAF lab branch includes commits that relate to this task:

• SequenceGenerator: Unable to cast object fails when creds #1069

To minimize version conflicts we recommend that you use the Xpand.XAF.Core.All, Xpand.XAF.Win.All, Xpand.XAF.Web.All packages. Doing so, all packages will be at your disposal and .NET will add a dependecy only to those packages that you actually use and not to all (see the Modules installation-registrations youtube video).

Released packages:

No packages released.

Please update the related Nuget packages and test if issues is addressed. These are nightly nuget packages available only from our NugetServer.

If you do not use these packages directly but through a module of the main eXpandFramework project, please wait for the bot to notify you again when integration is finished or update the related packages manually.

Thanks a lot for your contribution.

[pavlovboris]

Everything looks great now to me. Thank you for your efforts. Efharistó para poli!