INSTANCEPROMOTEDPROPERTIES table not been populated by StateMachineTrackingElement extension

INSTANCEPROMOTEDPROPERTIES table not been populated by StateMachineTrackingElement extension

Postby andreash » Fri 11 Dec 2015 10:31

Enabling state tracking as per http://wf.codeplex.com/wikipage?title=Tracking%20states%20with%20WorkflowServices 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.
andreash
 
Posts: 4
Joined: Fri 11 Dec 2015 10:25

Re: INSTANCEPROMOTEDPROPERTIES table not been populated by StateMachineTrackingElement extension

Postby Shalex » Fri 18 Dec 2015 19:27

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/library/hh925568(v=vs.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/oracle/docs/?WorkflowInstanceStore.html.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: INSTANCEPROMOTEDPROPERTIES table not been populated by StateMachineTrackingElement extension

Postby andreash » Mon 18 Jan 2016 12:23

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/latest#labs/Microsoft.Activities.Extensions/Microsoft.Activities.Extensions/Tracking/StateTracker.cs

I am using .NET 4.5 with WFv4.5
andreash
 
Posts: 4
Joined: Fri 11 Dec 2015 10:25

Re: INSTANCEPROMOTEDPROPERTIES table not been populated by StateMachineTrackingElement extension

Postby Shalex » Wed 20 Jan 2016 18:23

We have just sent a test project (its description) to your forum profile email. It populates the INSTANCEPROMOTEDPROPERTIES table.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle