Hi,
i'm testing workflow hosting and when I created a simple workflow (1 code activity that do nothing) and start, will completed with sucess.
But when I addservice SqlWorkflowPersistenceService after start my workflow it was aborted. Why?
The problem is:
System.Workflow.Runtime.Hosting.PersistenceException: MSDTC on server 'machine' 'is unavailable. > System.Data.SqlClient.SqlException: MSDTC on server 'machine' is unavailable.
I'm using SQLServer 2000 on localhost.
I solver stating "Distribuited Transaction Coordinador" on Enterprise Manager
[ Console Root / Microsoft Sql Servers / (local) / Support Services ]
Seems someone is catching the exception and if trace is not enabled no one notices something went wrong. Is this so?
To enable wftrace:
<system.diagnostics>
<switches>
<add name="WorkflowTraceToDefault" value="1" />
<add name="Host" value="All" />
<add name="Runtime" value="All" />
<add name="Tracking" value="All" />
<add name="Activity" value="All" />
<add name="Rules" value="All" />
</switches>
<trace autoflush="true" indentsize="4">
<listeners>
<add name="myListener"
type="System.Diagnostics.TextWriterTraceListener"
initializeData="WFTrace.log" />
</listeners>
</trace>
</system.diagnostics>
