1

Closed

ORA-02089: COMMIT is not allowed in a subordinate session--InsertInstanceState

description

I am getting the above mentioned exception when I am creating new workflow instance.
 
This only happens when it is being executed second time. If I try to create instance and if everything successful, there is no exception.
But if it fails and try it again, i am getting that exception... Any pointers are greatly appreciated......
 
 
Thanks!
Here is the TRACE.
 
GenericTrackingChannel::MustCommit
GenericWorkBatchService::CommitWorkBatch
AdoWorkBatchService::TransactionCreated
GenericTrackingChannel::Commit
A first chance exception of type 'System.InvalidOperationException' occurred in Oracle.DataAccess.dll
GenericPersistenceService::Commit
A first chance exception of type 'Oracle.DataAccess.Client.OracleException' occurred in Oracle.DataAccess.dll
GenericPersistenceService::Commit - An unexpected exception occurred while performing a workflow persistence operation. Oracle.DataAccess.Client.OracleException ORA-02089: COMMIT is not allowed in a subordinate session at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src)
at Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery()
at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.InsertInstanceState(PendingWorkItem workItem, Guid ownerId, DateTime ownedUntil) in ..\WFTools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 254
at WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) in ..\WFTools\Services\Persistence\GenericPersistenceService.cs:line 687
Closed Jun 12, 2008 at 3:34 PM by deanward

comments

vasu wrote May 6, 2008 at 5:44 PM

Transactionscope is causing this issue and I had to use dependent transaction in my code to make it part of the transaction used by WF Persistence. and now it is working . Dean, you can close this issue.

wrote Jun 12, 2008 at 3:34 PM

Closed at vasu's request

spdude wrote Sep 8, 2008 at 1:36 PM

hi dean ,
can we have a sample code (console host will do) showing how to use dependent transaction. I am aslo facing same issue

wrote Feb 13, 2013 at 8:53 PM

wrote May 16, 2013 at 4:19 AM