Type of activity instance_id in TrackingSchema

[Andrei Lisin]

In WF tracking schema activity_id field in wf_activity_info table is declared as raw(16). It's obviously mistaken for workflow instance id, but activity instance id serves a different purpose. The type is string, so in the database the field probably should be declared as varchar(1000).

[Shalex]

In WF tracking schema activity_id field in wf_activity_info table is declared as raw(16).

The datatype is raw(16) because this field stores GUIDs.

It's obviously mistaken for workflow instance id, but activity instance id serves a different purpose. The type is string, so in the database the field probably should be declared as varchar(1000).

Please describe a particular problem you have encountered with our implementation of Workflow Tracking. If possible, send us a small test project and specify the steps we should follow for reproducing the issue.

[Andrei Lisin]

I need to have tracking storage in mssql and oracle and access it with single EF model, in mssql the field is string, in oracle it's raw, so the question is what type to choose for the field in EF model. It can't be guid, because oracle tracking participant doesn't guarantee it's guid, it simply passes the string straight to the raw parameter.

MSDN documentation I linked specifies the instance id as string and doesn't guarantee it's guid. How a string can be a guid?

[Shalex]

Thank you for the explanation. We will investigate the issue and notify you about the result as soon as possible.

[Shalex]

The behaviour is changed: the instance_id field of the wf_activity_info table in Workflow Tracking implementation is of varchar(1000) type now. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

[Andrei Lisin]

Thanks, it's not urgent, I will need it in 2 months.

[Shalex]

New build of dotConnect for Oracle 8.3.125 is available for download!
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=29243.