Workflow instance store migration to .Net 4.5

Workflow instance store migration to .Net 4.5

Postby cfuehrmann » Mon 17 Feb 2014 18:41

Hello, on 30 Jan 2014, I sent the question below through the Devart contact form. But I received no ticket number or other kind of acknowledgment, so I must ask in this forum:

From .Net4 to .Net4.5, the workflow instance store schema changes. Accordingly, you provided a new storage schema: "OracleInstanceStoreSchema45.sql". However, I cannot find an upgrade script from 4.0 to 4.5: Microsoft has such a script, "SqlWorkflowInstanceStoreSchemaUpgrade.sql", for Sql Server. It is critical for my company (...) that running workflow instances keep running when the instance store is updated... Can you help us?”
cfuehrmann
 
Posts: 10
Joined: Tue 13 Dec 2011 13:20
Location: Erlangen, Germany

Re: Workflow instance store migration to .Net 4.5

Postby Shalex » Wed 19 Feb 2014 13:03

We will include OracleInstanceStoreSchemaUpdateTo45.sql in the next public build of dotConnect for Oracle (also this file was sent to the e-mail specified in your forum profile).

Run both OracleInstanceStoreSchemaUpdateTo45.sql and \Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\OracleInstanceStoreLogic45.sql to update your schema and logic from .NET4.0 to .NET4.5.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Postby cfuehrmann » Wed 19 Feb 2014 14:23

Thanks! By the way, one detail that surprises me is the small size of the script compared to its Microsoft counterpart, which has 78kB. Do you know the reason for the extreme size difference?
cfuehrmann
 
Posts: 10
Joined: Tue 13 Dec 2011 13:20
Location: Erlangen, Germany

Re: Workflow instance store migration to .Net 4.5

Postby Shalex » Thu 20 Feb 2014 18:02

The OracleInstanceStoreSchemaUpdateTo45.sql script just updates the schema created with \Program Files (x86)\Devart\dotConnect\Oracle\WF Services\OracleInstanceStoreSchema.sql to the \Program Files (x86)\Devart\dotConnect\Oracle\WF Services\NET45\OracleInstanceStoreSchema45.sql schema.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Postby cfuehrmann » Fri 21 Feb 2014 09:35

So, suppose a workflow instance has been created a while ago and resides in the old instance store, waiting in a bookmark caused by a "Receive" activity. Then we apply "OracleInstanceStoreSchemaUpdateTo45.sql". Will we be able to continue the workflow after that?
cfuehrmann
 
Posts: 10
Joined: Tue 13 Dec 2011 13:20
Location: Erlangen, Germany

Re: Workflow instance store migration to .Net 4.5

Postby Shalex » Mon 24 Feb 2014 13:42

If you encounter any problem, please contact us again.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Postby cfuehrmann » Mon 24 Feb 2014 15:17

Hi, it works on an empty instance store, but it fails even when the store contains only one workflow. The script gives an error. Worse, after running the script, *no* workflow can be created or continued. Here is the result of running the script:

@"c:/u45.sql";
Tabelle wurde erstellt.
Index wurde erstellt.
Sequence wurde erstellt.
1 Zeile wurde erstellt.
Tabelle wurde erstellt.
Tabelle wurde geõndert.
1 Zeile wurde aktualisiert.

ALTER TABLE InstancesTable MODIFY SurrogateIdentityId INTEGER NOT NULL
*
FEHLER in Zeile 1:
ORA-02296: (CFU1U.) kann nicht aktiviert werden. Null-Werte gefunden.

Tabelle wurde geõndert.
0 Zeilen wurden aktualisiert.
Tabelle wurde geõndert.
Tabelle wurde geõndert.
1 Zeile wurde aktualisiert.
Tabelle wurde geõndert.
cfuehrmann
 
Posts: 10
Joined: Tue 13 Dec 2011 13:20
Location: Erlangen, Germany

Re: Workflow instance store migration to .Net 4.5

Postby Shalex » Mon 03 Mar 2014 15:14

Thank you for your report. We are processing the request.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Postby Shalex » Wed 05 Mar 2014 12:51

We have sent the corrected script to your e-mail (the differences is in the UPDATE statements, please reapply them). Notify us about the result.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Postby Shalex » Fri 07 Mar 2014 07:35

New version of dotConnect for Oracle 8.3 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=29102.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle