Type of activity instance_id in TrackingSchema
-
- Posts: 6
- Joined: Wed 25 Sep 2013 14:06
Type of activity instance_id in TrackingSchema
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).
Re: Type of activity instance_id in TrackingSchema
The datatype is raw(16) because this field stores GUIDs.Andrei Lisin wrote:In WF tracking schema activity_id field in wf_activity_info table is declared as raw(16).
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 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).
-
- Posts: 6
- Joined: Wed 25 Sep 2013 14:06
Re: Type of activity instance_id in TrackingSchema
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?
MSDN documentation I linked specifies the instance id as string and doesn't guarantee it's guid. How a string can be a guid?
Re: Type of activity instance_id in TrackingSchema
Thank you for the explanation. We will investigate the issue and notify you about the result as soon as possible.
Re: Type of activity instance_id in TrackingSchema
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.
-
- Posts: 6
- Joined: Wed 25 Sep 2013 14:06
Re: Type of activity instance_id in TrackingSchema
Thanks, it's not urgent, I will need it in 2 months.
Re: Type of activity instance_id in TrackingSchema
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.
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.