Error when installing VFS Actions

unknown

Hello,

we used Network Client for a long time, no web components. With 8.3 the web server was installed as well; basically it is up and running.

But every time when installing a "VFS Actions" Bundle in AppArchitect I get an error when it comes to installing "plugins" and "picklists" (other actions did work):

System.InvalidCastException: Specified cast is not valid.
at System.Data.OleDb.ColumnBinding.ValueInt32()
at System.Data.OleDb.OleDbDataReader.GetInt32(Int32 ordinal)
at Sage.SalesLogix.Orm.IdGenerator.SlxDbSystemInfo..ctor(IDbConnection connection)
at Sage.SalesLogix.Orm.IdGenerator.SlxDbSystemInfo.GetSystemInfo(IDbConnection connection)

...

For me this seems to be an error in .net when converting the XML data to an actual data type before inserting into the DB.

Does anyone have an idea how to solve this? Maybe there is some configuration missing? Any idea?

Thank you!

Martin

winfried-andreas

The process seems to read from the SYSTEMINFO-table and then fault. One of the columns is expected to hold a value of the .net datatype System.Int32, but seems to yield another, incompatible Datatype.

I suspect that you miss some previous, AppArchitect related Schema-Updates on that table. This because in previous Version-Upgrades you maybe skipped some of the Upgrade-Steps that seem to be exclusively related to the web client.

I have made the experience in the 8.x-Versions, that you always should follow all upgrade steps (Web and SNC-related), even if you just use SNC.

As a suggestion: If you have an EVAL-DB at hands that is on the exact same version, try to compare the schema of your production database and the EVAL-version, regarding the SYSTEMINFO-Table. I am quite convinced that they will differ.

You could also run the SLXProfiler as well as the SQLProfiler while installing the bundle in AppArch to see what queries are used in the above context.