Workflow getInstance fails

[fifty]

hi,

I have a WPF application with a workflow, which is persisted when state is Idle. After the persist action I check the database and INSTANCESTABLE contains the right instance. Then I try to obtain the instance with:

Code: Select all

    WorkflowApplicationInstance instance =
                WorkflowApplication.GetInstance(WorkflowInstanceId, GetStore());

and I always get the following error:

The execution of an InstancePersistenceCommand was interrupted because the instance owner registration has become invalid. This error indicates that the in-memory copy of all instances locked by this owner have become stale and should be discarded, along with the InstanceHandles. Typically, this error is best handled by restarting the host.

This is how my store is configured:

Code: Select all

var store = new Devart.Data.Oracle.DurableInstancing.OracleInstanceStore(OracleDbConnectionString)
                {
                    HostLockRenewalPeriod = new TimeSpan(0, 0, 10),
                    RunnableInstancesDetectionPeriod = new TimeSpan(0, 0, 10)
                };

Even if I wait 2-3 minutes, I get the same.
In the database the LOCKOWNERSTABLE table contains a row, should not this row deleted when HostLockRenewalPeriod exceeds and move the instance to the RUNNABLEINSTANCESTABLE?

thx,
fifty

[Shalex]

We have reproduced the error and are investigating the issue.

[mksabre]

Hi,

Any update on this? I'm facing the same problem.

MK

[Shalex]

We are going to include the fix in the next public build of dotConnect for Oracle. We will post here about the result.

[Shalex]

New version of dotConnect for Oracle 7.7 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=26313.

[EmilyFong]

I already used the latest version (7.7.216.0), but still fail.

[Shalex]

Please create a new schema using the scripts from the \Program Files\Devart\dotConnect\Oracle\WF Services\NET45 folder and add the reference to the new \Program Files\Devart\dotConnect\Oracle\WF Services\NET45\Devart.Data.Oracle.WorkflowFoundation.dll assembly. Does it work?