Page 1 of 1

Workflow getInstance fails

Posted: Thu 21 Feb 2013 13:06
by 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

Re: Workflow getInstance fails

Posted: Fri 22 Feb 2013 17:35
by Shalex
We have reproduced the error and are investigating the issue.

Re: Workflow getInstance fails

Posted: Wed 27 Feb 2013 15:58
by mksabre
Hi,

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

MK

Re: Workflow getInstance fails

Posted: Mon 04 Mar 2013 13:57
by Shalex
We are going to include the fix in the next public build of dotConnect for Oracle. We will post here about the result.

Re: Workflow getInstance fails

Posted: Fri 05 Apr 2013 12:35
by 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.

Re: Workflow getInstance fails

Posted: Tue 07 May 2013 11:38
by EmilyFong
I already used the latest version (7.7.216.0), but still fail.

Re: Workflow getInstance fails

Posted: Wed 08 May 2013 07:28
by 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?