Workflow instance store migration to .Net 4.5

[cfuehrmann]

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]

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]

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]

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]

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]

If you encounter any problem, please contact us again.

[cfuehrmann]

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]

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

[Shalex]

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]

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.