We are using the OracleInstanceStore, Devart version 6.80.
And when we use a ParallelForEach in a workflow then we got the next exception saving the workflow instance:
Instance c4a49a9e-13dd-4dd0-adea-deb8ac659cff has aborted. Error: System.Runtime.DurableInstancing.InstancePersistenceCommandException: The execution of the InstancePersistenceCommand named {urn:schemas-microsoft-com:System.Activities.Persistence/command}SaveWorkflow was interrupted by an error. ---> Devart.Data.Oracle.OracleException: ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: en "INSTANCESTORELOGIC", línea 772
ORA-06512: en línea 2
at Devart.Data.Oracle.a5.b(Int32 A_0)
at Devart.Data.Oracle.a7.a(Int32 A_0, bt A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.OracleCommand.ExecuteNonQuery()
at Devart.Data.Oracle.DurableInstancing.r.a(Boolean A_0)
at Devart.Data.Oracle.DurableInstancing.a.c()
--- End of inner exception stack trace ---
at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result)
at System.Activities.WorkflowApplication.IdleEventHandler.OnStage2Complete(IAsyncResult lastResult, WorkflowApplication instance, Boolean isStillSync)
at System.Activities.WorkflowApplication.EventFrame(IAsyncResult result)
Any idea where it comes from?
Thanks in advance!
WF4 - Persistence: Error using ParallelForEach
Re: WF4 - Persistence: Error using ParallelForEach
Please turn on the dbMonitor tool to find out which statement fails to execute. If this doesn't help to solve the issue, send us a small test project to reproduce the issue in our environment. Also specify the exact (6.80.xxx) build of dotConnect for Oracle you are using: the Tools > Oracle > About menu of Visual Studio.