Persistance service exception

Aug 25, 2009 at 12:01 PM

I'm running a workflow using wftools as the persistance service, but after it has finished running (I know it has, I can check some tables a local service is writing to and I see them filled) , a couple seconds after it finished running I get an exception. It isn't triggering the WorkflowTerminated event, which makes me think its related to the persistance service.

I´m running change set 15786.  Can anyone give me any pointers on where the problem might be? Is WFTool production ready?

Related trace:

System.Workflow.Runtime Information: 0 : Activity Status Change - Activity: PruebaNotificacionInformativa Old:Executing; New:Closed
System.Workflow.Runtime.Tracking Information: 0 : TrackingListener::ActivityStatusChange - Received Activity Status Change Event for activity PruebaNotificacionInformativa
GenericTrackingChannel::Send
System.Workflow.Runtime Information: 0 : pending work hc 7299092 added workItem hc 42112153
GenericTrackingChannel::MustCommit
GenericTrackingChannel::Send
System.Workflow.Runtime Information: 0 : pending work hc 7299092 added workItem hc 14645814
GenericTrackingChannel::InstanceCompletedOrTerminated
GenericTrackingChannel::Send
System.Workflow.Runtime Information: 0 : pending work hc 7299092 added workItem hc 51678514
System.Workflow.Runtime Information: 0 : Workflow Runtime: WorkflowExecutor: Calling SaveWorkflowInstanceState for instance 59722e65-3191-4a0f-82d9-263304f32ed3 hc 721416
GenericPersistenceService::SaveWorkflowInstanceState
System.Workflow.Runtime Information: 0 : pending work hc 33056860 added workItem hc 15144272
GenericTrackingChannel::MustCommit
GenericTrackingChannel::MustCommit
GenericPersistenceService::MustCommit
System.Workflow.Runtime Information: 0 : Workflow Runtime: WorkflowExecutor: Calling CommitTransaction for instance 59722e65-3191-4a0f-82d9-263304f32ed3 hc 721416
GenericWorkBatchService::CommitWorkBatch
AdoWorkBatchService::TransactionCreated
System.Workflow.Runtime Information: 0 : pending work hc 7299092 added workItem hc 4678963

[...]

(A bunch of that repeats with different numbers)

GenericTrackingChannel::Commit
GenericPersistenceService::Commit
'aspnet_wp.exe' (Managed): Loaded 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\ejemplo.userinterfase\81c2b91a\ff384ba7\assembly\dl3\7de02c86\f60c9a75_9721ca01\WFTools.Resources.resources.DLL', No symbols loaded.
A first chance exception of type 'WFTools.Services.Persistence.PersistenceException' occurred in WFTools.Services.DLL
GenericPersistenceService::Commit - An unexpected exception occurred while performing a workflow persistence operation. WFTools.Services.Persistence.PersistenceException: Instance with identifier 59722e65-3191-4a0f-82d9-263304f32ed3 could not be loaded.
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.CheckResult(DbCommand dbCommand, String resultParameter, String instanceParameter) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 449
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.InsertInstanceState(PendingWorkItem workItem, Guid ownerId, DateTime ownedUntil) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 256
   at WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\GenericPersistenceService.cs:line 688
System.Workflow.Runtime.Hosting Critical: 0 : WorkflowRuntime:ServicesExceptionNotHandled event raised for instance Id 00000000-0000-0000-0000-000000000000 WFTools.Services.Persistence.PersistenceException: An unexpected exception occurred while performing a workflow persistence operation. WFTools.Services.Persistence.PersistenceException: Instance with identifier 59722e65-3191-4a0f-82d9-263304f32ed3 could not be loaded.
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.CheckResult(DbCommand dbCommand, String resultParameter, String instanceParameter) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 449
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.InsertInstanceState(PendingWorkItem workItem, Guid ownerId, DateTime ownedUntil) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 256
   at WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\GenericPersistenceService.cs:line 688 ---> WFTools.Services.Persistence.PersistenceException: Instance with identifier 59722e65-3191-4a0f-82d9-263304f32ed3 could not be loaded.
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.CheckResult(DbCommand dbCommand, String resultParameter, String instanceParameter) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 449
   at WFTools.Services.Persistence.Ado.AdoPersistenceResourceAccessor.InsertInstanceState(PendingWorkItem workItem, Guid ownerId, DateTime ownedUntil) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\Ado\AdoPersistenceResourceAccessor.cs:line 256
   at WFTools.Services.Persistence.GenericPersistenceService.Commit(Transaction transaction, ICollection items) in C:\sources\Cajval.FrameworkComun\Workflow\wftools\Services\Persistence\GenericPersistenceService.cs:line 688
   --- End of inner exception stack trace ---
A first chance exception of type 'WFTools.Services.Persistence.PersistenceException' occurred in WFTools.Services.DLL
AdoWorkBatchService::WorkBatchRolledback
A first chance exception of type 'WFTools.Services.Persistence.PersistenceException' occurred in WFTools.Services.DLL