Upload data from Invantive Control for Excel raises "itgenase034: The field 'SalId' has no .NET data type."

Questions
,
1

I have created a model in Invantive Control for Excel to upload address information in a SQL Server-database (versie 2019).

When downloading data, everything works fine. When changing a record and then uploading, the following error ocurrs on release 23.0.55:

itgenase034: The field 'SalId' has no .NET data type.

Message ID: d3ce2894-a0dc-46d2-9511-4a88afda9172

Occurred (UTC): 09-10-2023 14:19:48

select * from DB.Adresse.Adresser e

InvantiveSystemException
   at Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId, String url, Nullable`1 partyUid)
   at Invantive.Data.AnsiSqlProviderBase.Update(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameterValues, ResultSet sourceContext)
   at Invantive.Data.ConnectionManager.TI(GlobalState , ExecutionOptions , EntityFieldCollection , QueryObject , ParameterList , ResultSet )
   at Invantive.Data.ConnectionManager.Update(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameterList, ResultSet sourceContext)
   at Invantive.Data.ActionProceduresBase.PassthroughUpdate(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameterList, ResultSet sourceContext)
   at Invantive.Producer.Control.SyncToDatabaseForm.SyncUpload(GlobalState owner, ExecutionOptions executionOptions, DoWorkEventArgs e)
   at Invantive.Producer.Control.SyncToDatabaseForm.syncBackGroundWorker_DoWork(Object sender, DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)
   at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   at System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
   at System.Threading.ThreadPoolWorkQueue.Dispatch()
   at Invantive.Data.AnsiSqlProviderBase.Update(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameterValues, ResultSet sourceContext)
   at Invantive.Data.ConnectionManager.TI(GlobalState , ExecutionOptions , EntityFieldCollection , QueryObject , ParameterList , ResultSet )
   at Invantive.Data.ConnectionManager.Update(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameterList, ResultSet sourceContext)
   at Invantive.Data.ActionProceduresBase.PassthroughUpdate(GlobalState owner, ExecutionOptions executionOptions, EntityFieldCollection entityFields, QueryObject queryObject, ParameterList parameterList, ResultSet sourceContext)
   at Invantive.Producer.Control.SyncToDatabaseForm.SyncUpload(GlobalState owner, ExecutionOptions executionOptions, DoWorkEventArgs e) in c:\smoke\ws-23.0\Invantive.Control\src\Invantive.Producer.Control\ThisAddIn.cs:line 849

The same error occurs when changing other fields.

2

The problem has been solved in release 23.0.

3

Dit topic is 7 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.