Workflow instance store migration to .Net 4.5

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
cfuehrmann
Posts: 10
Joined: Tue 13 Dec 2011 13:20
Location: Erlangen, Germany

Workflow instance store migration to .Net 4.5

Post by 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?”

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Post by 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.

cfuehrmann
Posts: 10
Joined: Tue 13 Dec 2011 13:20
Location: Erlangen, Germany

Re: Workflow instance store migration to .Net 4.5

Post by 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?

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Post by 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.

cfuehrmann
Posts: 10
Joined: Tue 13 Dec 2011 13:20
Location: Erlangen, Germany

Re: Workflow instance store migration to .Net 4.5

Post by 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?

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Post by Shalex » Mon 24 Feb 2014 13:42

If you encounter any problem, please contact us again.

cfuehrmann
Posts: 10
Joined: Tue 13 Dec 2011 13:20
Location: Erlangen, Germany

Re: Workflow instance store migration to .Net 4.5

Post by 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.

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Post by Shalex » Mon 03 Mar 2014 15:14

Thank you for your report. We are processing the request.

Shalex
Devart Team
Posts: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Post by 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: 8083
Joined: Thu 14 Aug 2008 12:44

Re: Workflow instance store migration to .Net 4.5

Post by 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.

Post Reply