WF4 - Persistence: Error using ParallelForEach

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
mcanals
Posts: 1
Joined: Mon 08 Oct 2012 07:57

WF4 - Persistence: Error using ParallelForEach

Post by mcanals » Mon 08 Oct 2012 08:09

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!

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: WF4 - Persistence: Error using ParallelForEach

Post by Shalex » Mon 15 Oct 2012 14:35

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.

Post Reply