Type of activity instance_id in TrackingSchema

Type of activity instance_id in TrackingSchema

Postby Andrei Lisin » Thu 13 Mar 2014 14:22

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).
Andrei Lisin
 
Posts: 6
Joined: Wed 25 Sep 2013 14:06

Re: Type of activity instance_id in TrackingSchema

Postby Shalex » Wed 19 Mar 2014 15:02

Andrei Lisin wrote: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.

Andrei Lisin wrote: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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: Type of activity instance_id in TrackingSchema

Postby Andrei Lisin » Thu 20 Mar 2014 11:42

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?
Andrei Lisin
 
Posts: 6
Joined: Wed 25 Sep 2013 14:06

Re: Type of activity instance_id in TrackingSchema

Postby Shalex » Mon 24 Mar 2014 17:13

Thank you for the explanation. We will investigate the issue and notify you about the result as soon as possible.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: Type of activity instance_id in TrackingSchema

Postby Shalex » Wed 26 Mar 2014 15:20

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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: Type of activity instance_id in TrackingSchema

Postby Andrei Lisin » Thu 27 Mar 2014 12:03

Thanks, it's not urgent, I will need it in 2 months.
Andrei Lisin
 
Posts: 6
Joined: Wed 25 Sep 2013 14:06

Re: Type of activity instance_id in TrackingSchema

Postby Shalex » Thu 27 Mar 2014 15:52

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.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle