AnsweredAssumed Answered

Nintex.Workflow.NWActionExecutionException: Failed to commit workflow. ---> System.Workflow.Runtime.Hosting.PersistenceException: The transaction has aborted.

Question asked by pdhameliya on Aug 5, 2014
Latest reply on Dec 3, 2015 by frank.field@nintex.com

We have Nintex workflow which is working fine in our DEV and TEST environment, it never stuck in error. The Nintex workflow in production stuck mostly at the same stage(few cases it is stuck in different stage but it is rare) but after canceling and restarting workflow it perfectly working fine. The workflow stuck after setting the access of the user group and stuck at commit pending changes; 8 out of 10 workflow got in error and required to restart workflow to process the record.

nintex.PNG

Infrastructure:

Windows Server 2008

SharePoint Server 2010 with SP2

 

Nintex workflow

Product version: 2.3.13.0

Database version: 2.0.2.0

 

Application/Data:

SharePoint Library Total fields: 73

Currently in process workflow on this library: 2700+

Nearly 200-300 items added per day in this library sometimes may be less.

 

The below findings from the ULS logs

Stack Trace Description:

(/_layouts/NintexWorkflow/preview.aspx?ListId=0f7ca4d3-ecee-4db5-89d3-7ffbe667a4b9&ItemId=26574&InstanceId=453a9fc8-c20e-4094-b4fa-46c3a8e59ec7): Nintex.Workflow.NWActionExecutionException: Failed to commit workflow. ---> System.Workflow.Runtime.Hosting.PersistenceException: The transaction has aborted. ---> System.Transactions.TransactionAbortedException: The transaction has aborted. ---> System.TimeoutException: Transaction Timeout     -

-- End of inner exception stack trace ---   

at System.Transactions.TransactionStateAborted.CreateAbortingClone(InternalTransaction tx)   

at System.Transactions.DependentTransaction..ctor(IsolationLevel isoLevel, InternalTransaction internalTransaction, Boolean blocking)   

at System.Transactions.Transaction.DependentClone(DependentCloneOption cloneOption)   

at System.Transactions.TransactionScope.SetCurrent(Transaction newCurrent)   

at System.Transactions.TransactionScope.PushScope()   

at System.Transactions.TransactionScope..ctor(TransactionScopeOption scopeOption)   

at Microsoft.SharePoint.Workflow.SPWinOePersistenceService.Commit(Transaction transaction, ICollection items)   

at System.Workflow.Runtime.WorkBatch.PendingWorkCollection.Commit(Transaction transaction)   

at System.Workflow.Runtime.WorkBatch.Commit(Transaction transaction)   

at System.Workflow.Runtime.Hosting.WorkflowCommitWorkBatchService.CommitWorkBatch(CommitWorkBatchCallback commitWorkBatchCallback)   

at System.Workflow.Runtime.Hosting.DefaultWorkflowCommitWorkBatchService.CommitWorkBatch(CommitWorkBatchCallback commitWorkBatchCallback)   

at System.Workflow.Runtime.WorkflowExecutor.CommitTransaction(Activity activityContext)   

at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)     -

-- End of inner exception stack trace ---   

at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)   

at System.Workflow.Runtime.WorkflowExecutor.System.Workflow.ComponentModel.IWorkflowCoreRuntime.PersistInstanceState(Activity activity)   

at System.Workflow.ComponentModel.Activity.MarkClosed()   

at System.Workflow.ComponentModel.ActivityExecutionContext.CloseActivity()   

at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)   

at System.Workflow.Runtime.Scheduler.Run()     -

-- End of inner exception stack trace --- (Build:23130)

 

 

WinWF Internal Error, terminating workflow Id# 453a9fc8-c20e-4094-b4fa-46c3a8e59ec7

 

 

System.Workflow.Runtime.Hosting.PersistenceException: The transaction has aborted. ---> System.Transactions.TransactionAbortedException: The transaction has aborted. ---> System.TimeoutException: Transaction Timeout     -

-- End of inner exception stack trace ---   

at System.Transactions.TransactionStateAborted.CreateAbortingClone(InternalTransaction tx)   

at System.Transactions.DependentTransaction..ctor(IsolationLevel isoLevel, InternalTransaction internalTransaction, Boolean blocking)   

at System.Transactions.Transaction.DependentClone(DependentCloneOption cloneOption)   

at System.Transactions.TransactionScope.SetCurrent(Transaction newCurrent)   

at System.Transactions.TransactionScope.PushScope()   

at System.Transactions.TransactionScope..ctor(TransactionScopeOption scopeOption)   

at Microsoft.SharePoint.Workflow.SPWinOePersistenceService.Commit(Transaction transaction, ICollection items)   

at System.Workflow.Runtime.WorkBatch.PendingWorkCollection.Commit(Transaction transaction)   

at System.Workflow.Runtime.WorkBatch.Commit(Transaction transaction)   

at System.Workflow.Runtime.Hosting.WorkflowCommitWorkBatchService.CommitWorkBatch(CommitWorkBatchCallback commitWorkBatchCallback)   

at System.Workflow.Runtime.Hosting.DefaultWorkflowCommitWorkBatchService.CommitWorkBatch(CommitWorkBatchCallback commitWorkBatchCallback)   

at System.Workflow.Runtime.WorkflowExecutor.CommitTransaction(Activity activityContext)   

at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)     -

-- End of inner exception stack trace ---   

at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)   

at System.Workflow.Runtime.WorkflowExecutor.System.Workflow.ComponentModel.IWorkflowCoreRuntime.PersistInstanceState(Activity activity)   

at System.Workflow.ComponentModel.Activity.MarkClosed()   

at System.Workflow.ComponentModel.ActivityExecutionContext.CloseActivity()   

at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)   

at System.Workflow.Runtime.Scheduler.Run()

 

 

Detected use of SPRequest for previously closed SPWeb object.  Please close SPWeb objects when you are done with all objects obtained from them, but not before.  Stack trace:  

at Nintex.Workflow.Activities.CancelWorkflowJob.<DoWork>b__0()   

at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()   

at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)   

at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)   

at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)   

at Nintex.Workflow.Activities.CancelWorkflowJob.DoWork()   

at Nintex.Workflow.Activities.NintexWorkflowService.Commit(Transaction transaction, ICollection items)   

at System.Workflow.Runtime.WorkBatch.PendingWorkCollection.Commit(Transaction transaction)   

at System.Workflow.Runtime.WorkBatch.Commit(Transaction transaction)   

at System.Workflow.Runtime.Hosting.WorkflowCommitWorkBatchService.CommitWorkBatch(CommitWorkBatchCallback commitWorkBatchCallback)   

at System.Workflow.Runtime.Hosting.DefaultWorkflowCommitWorkBatchService.CommitWorkBatch(CommitWorkBatchCallback commitWorkBatchCallback)   

at System.Workflow.Runtime.WorkflowExecutor.CommitTransaction(Activity activityContext)   

at System.Workflow.Runtime.WorkflowExecutor.Persist(Activity dynamicActivity, Boolean unlock, Boolean needsCompensation)   

at System.Workflow.Runtime.WorkflowExecutor.System.Workflow.ComponentModel.IWorkflowCoreRuntime.PersistInstanceState(Activity activity)   

at System.Workflow.ComponentModel.Activity.MarkClosed()   

at System.Workflow.ComponentModel.ActivityExecutionContext.CloseActivity()   

at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)   

at System.Workflow.Runtime.Scheduler.Run()   

at System.Workflow.Runtime.WorkflowExecutor.RunScheduler()   

at System.Workflow.Runtime.WorkflowExecutor.RunSome(Object ignored)   

at System.Workflow.Runtime.Hosting.DefaultWorkflowSchedulerService.WorkItem.Invoke(WorkflowSchedulerService service)   

at System.Workflow.Runtime.Hosting.ManualWorkflowSchedulerService.RunOne(Guid workflowInstanceId)   

at System.Workflow.Runtime.Hosting.ManualWorkflowSchedulerService.RunWorkflow(Guid workflowInstanceId)   

at Microsoft.SharePoint.Workflow.SPWinOeHostServices.Send(SPWorkflow workflow, SPWinOeWorkflow winoeworkflow, SPWorkflowEvent e)   

at Microsoft.SharePoint.Workflow.SPWinOeEngine.RunWorkflow(SPWorkflowHostService host, SPWorkflow workflow, Collection`1 events, TimeSpan timeOut)   

at Microsoft.SharePoint.Workflow.SPWorkflowManager.RunWorkflowElev(SPWorkflow workflow, Collection`1 events, SPWorkflowRunOptionsInternal runOptions)   

at Microsoft.SharePoint.Workflow.SPWorkflowManager.StartWorkflowElev(Object context, SPWorkflowAssociation association, DateTime elevationTimeUtc, SPWorkflowEvent startEvent, SPWorkflowRunOptions runOptions)   

at Microsoft.SharePoint.Workflow.SPWorkflowManager.<>c__DisplayClass13.<StartWorkflow>b__12(SPSite superUserSite, SPWeb superUserWeb)   

at Microsoft.SharePoint.SPSecurity.<>c__DisplayClassc.<RunWithSystemSiteAndWeb>b__a()   

at Microsoft.SharePoint.SPSecurity.<>c__DisplayClass4.<RunWithElevatedPrivileges>b__2()   

at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)   

at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)   

at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)   

at Microsoft.SharePoint.Workflow.SPWorkflowManager.StartWorkflow(Object context, SPWorkflowAssociation association, SPWorkflowEvent startEvent, SPWorkflowRunOptions runOpts)   

at Microsoft.SharePoint.Workflow.SPWorkflowManager.StartWorkflow(Object context, SPWorkflowAssociation association, String eventData, SPWorkflowRunOptions runOptions)   

at Nintex.Workflow.ConditionalWorkflowStartReceiver.oBY=(SPItemEventProperties uBk=, AutoStartRuleType uRk=, Boolean uhk=)   

at Nintex.Workflow.ConditionalWorkflowStartReceiver.ItemUpdated(SPItemEventProperties properties)   

at Microsoft.SharePoint.SPEventManager.RunItemEventReceiver(SPItemEventReceiver receiver, SPUserCodeInfo userCodeInfo, SPItemEventProperties properties, SPEventContext context, String receiverData)   

at Microsoft.SharePoint.SPEventManager.RunItemEventReceiverHelper(Object receiver, SPUserCodeInfo userCodeInfo, Object properties, SPEventContext context, String receiverData)   

at Microsoft.SharePoint.SPEventManager.<>c__DisplayClassc`1.<InvokeEventReceivers>b__6()   

at Microsoft.SharePoint.SPSecurity.RunAsUser(SPUserToken userToken, Boolean bResetContext, WaitCallback code, Object param)   

at Microsoft.SharePoint.SPEventManager.InvokeEventReceivers[ReceiverType](SPUserToken userToken, Guid tranLockerId, RunEventReceiver runEventReceiver, Object receivers, Object properties, Boolean checkCancel)   

at Microsoft.SharePoint.SPEventManager.InvokeEventReceivers[ReceiverType](Byte[] userTokenBytes, Guid tranLockerId, RunEventReceiver runEventReceiver, Object receivers, Object properties, Boolean checkCancel)   

at Microsoft.SharePoint.SPEventManager.ExecuteItemEventReceivers(Byte[]& userToken, Guid& tranLockerId, Object& receivers, ItemEventReceiverParams& itemEventParams, Object& changedFields, EventReceiverResult& eventResult, String& errorMessage)   

at Microsoft.SharePoint.Library.SPRequestInternalClass.ProcessBatchData(String bstrUrl, String bstrData, ISPDataCallback pResultCallback)   

at Microsoft.SharePoint.Library.SPRequest.ProcessBatchData(String bstrUrl, String bstrData, ISPDataCallback pResultCallback)   

at Microsoft.SharePoint.SoapServer.ListDataImpl.UpdateListItems(String strListName, String strXmlData)   

at Microsoft.SharePoint.SoapServer.ListDataValidatorImpl.UpdateListItems(String strListName, String strXmlData)   

at Microsoft.SharePoint.SoapServer.Lists.UpdateListItems(String listName, SoapXmlElement updates)   

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)   

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)   

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)   

at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)   

at System.Web.Services.Protocols.WebServiceHandler.Invoke()   

at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()   

at System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)   

at System.Web.Script.Services.ScriptHandlerFactory.HandlerWrapper.ProcessRequest(HttpContext context)   

at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()   

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)   

at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)   

at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)   

at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)   

at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   

at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   

at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)   

at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr managedHttpContext, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Outcomes