1
Vote

Workflow MySql Persistance

description

Hi,
 
My environment details are:
 
MySQL 5.1.4.0 SP1
 
.NET Connector 5.1.7
 
.NET Framework 3.5 with WCF
 
I have created a workflow service and calling a WCF service with Send & Receive Activities. I am able to persist the workflow using WFTools and able to complete the rest of the flow. But sometimes not able to get the context to the workflow instance from the persistance and getting the exception as shown below.
 
Is it issue with the WFTools or Transactions?
 
Type : System.ServiceModel.FaultException`1[[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]], System.ServiceModel, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Object reference not set to an instance of an object.
Source : mscorlib
Help link :
Detail : An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
System.NullReferenceException: Object reference not set to an instance of an object.
at System.Workflow.Runtime.ContextActivityUtils.ContextId(Activity activity)
at System.Workflow.Runtime.WorkflowExecutor.RegisterDynamicActivity(Activity dynamicActivity, Boolean load)
at System.Workflow.Runtime.WorkflowExecutor.ReloadHelper(Activity rootActivity)
at System.Workflow.Runtime.WorkflowRuntime.InitializeExecutor(Guid instanceId, CreationContext context, WorkflowExecutor executor, WorkflowInstance workflowInstance)
at System.Workflow.Runtime.WorkflowRuntime.Load(Guid key, CreationContext context, WorkflowInstance workflowInstance)
at System.Workflow.Runtime.WorkflowRuntime.GetWorkflow(Guid instanceId)
at System.ServiceModel.Dispatcher.WorkflowDurableInstance.GetWorkflowInstance(Boolean canCreateInstance)
at System.ServiceModel.Dispatcher.WorkflowOperationAsyncResult..ctor(WorkflowOperationInvoker workflowOperationInvoker, WorkflowDurableInstance workflowDurableInstance, Object[] inputs, AsyncCallback callback, Object state, Int64 time)
at System.ServiceModel.Dispatcher.WorkflowOperationInvoker.InvokeBegin(Object instance, Object[] inputs, AsyncCallback callback, Object state)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
Action : http://schemas.microsoft.com/net/2005/12/windowscommunicationfoundation/dispatcher/fault
Code : System.ServiceModel.FaultCode
Reason : Object reference not set to an instance of an object.
Data : System.Collections.ListDictionaryInternal
TargetSite : Void HandleReturnMessage(System.Runtime.Remoting.Messaging.IMessage, System.Runtime.Remoting.Messaging.IMessage)
Stack Trace :
Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)
 
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Wipro.HIS.WF.MedicalRecordsFacade.MedicalRecordsWF.IMedicalRecords.UpdateMRWorklist(UpdateMRWorklistRequest request)
at Wipro.HIS.WF.MedicalRecordsFacade.MedicalRecordsWF.MedicalRecordsClient.UpdateMRWorklist(UpdateMRWorklistRequest request) in D:\ESICITR1\HISApps\Wipro.HIS.WF\MedicalRecords\Wipro.HIS.WF.MedicalRecordsFacade\Service References\MedicalRecordsWF\Reference.cs:line 1898
at Wipro.HIS.WF.MedicalRecordsFacade.MedicalRecordsFacade.UpdateMRWorklist(MRConsumer mrConsumer, MRDWorkList mrdWorkList) in D:\ESICITR1\HISApps\Wipro.HIS.WF\MedicalRecords\Wipro.HIS.WF.MedicalRecordsFacade\MedicalRecordsFacade.cs:line 301
 
Additional Info:
 
MachineName : D-219002276
TimeStamp : 12/18/2009 3:06:41 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AppDomainName : /LM/W3SVC/1/ROOT/Wipro.HIS.WF.MedicalRecordsFacade-16-129056127702356069
ThreadIdentity : WHCIT\Rajut
WindowsIdentity : D-219002276\ASPNET
 
Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: D-219002276
App Domain: /LM/W3SVC/1/ROOT/Wipro.HIS.WF.MedicalRecordsFacade-16-129056127702356069
ProcessId: 3884
Process Name: c:\winnt\microsoft.net\framework\v2.0.50727\aspnet_wp.exe
Thread Name:
Win32 ThreadId:7408
Extended Properties:
 
Please, need Help.

comments

sajidh wrote Jun 19, 2014 at 9:07 AM

Hi Riyaz
I am trying since many days to persist my state machine workflow according to giving instruction but i am not able to persist and track my workflow in MySQL. i am using Chain-set 94877 if you kindly tell me what i am doing wrong.I have same db for tracking and persistence.Kindly tell me what setting i need as i am totally stuck with this WFTools.It is storing workflow instance in instance_state table only,not inserting anything in other tables.
Please guide me where i am doing wrong


Regards

Sajid