INSTANCEPROMOTEDPROPERTIES table not been populated by StateMachineTrackingElement extension

[andreash]

Enabling state tracking as per http://wf.codeplex.com/wikipage?title=T ... owServices records state information in [InstancePromotedProperties] table in MSSql.
Changing the web.config to use Devart.Data.Oracle.Activities.Configuration.OracleInstanceStoreElement stores all Workflow information (instance etc) as expected. However, the INSTANCEPROMOTEDPROPERTIES table remains empty.

[Shalex]

Thank you for your report. Please give us an additional information:

1. Tell us the .NET Framework version installed on your workstation (https://msdn.microsoft.com/en-us/librar ... .110).aspx).

2. When switching to Oracle, which Workflow implementation did you use (WFv4.0 or WFv4.5)?

• WFv4.0
  "C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\Devart.Data.Oracle.WorkflowFoundation.dll"
  "C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\OracleInstanceStoreSchema.sql"
  "C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\OracleInstanceStoreLogic.sql"
• WFv4.5
  "C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\Devart.Data.Oracle.WorkflowFoundation.dll"
  "C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\OracleInstanceStoreSchema45.sql"
  "C:\Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\OracleInstanceStoreLogic45.sql"

JIC: the corresponding dotConnect for Oracle documentation is available at https://www.devart.com/dotconnect/oracl ... Store.html.

[andreash]

Finally I worked this out.

The extension for tracking the state machine's possible transitions (located in Microsoft.Activities.Extensions) specifically references SqlWorkflowInstanceStore and therefore does not work with OracleInstanceStore.

See http://wf.codeplex.com/SourceControl/la ... Tracker.cs

I am using .NET 4.5 with WFv4.5

[Shalex]

We have just sent a test project (its description) to your forum profile email. It populates the INSTANCEPROMOTEDPROPERTIES table.