during our workflow development we've had many starts, stops, direction changes, and have a bunch of data in the wf tables that I'd like to clean out of our development environment.
when I attempt to truncate the following tables, I run into an issue with WF_STEP_INSTANCE:
SQL Error [4712] [S0001]: Cannot truncate table 'xdmd_ProductDomain.dbo.WF_STEP_INSTANCE' because it is being referenced by a FOREIGN KEY constraint.
ive successfully truncated the remainder. is there another table im missing? or anything else I need to do to clean this last table out?
Tables ive worked with in our domain:
WF_ATTACHMENT;
WF_BRANCH_INSTANCE;
WF_ERROR;
WF_STEP_INSTANCE;
WF_USER_NOTIFICATION_SETTINGS;
WF_USER_TASK_CANDIDATE;
WF_WORKFLOW_INSTANCE;
WF_WORK_ITEM;
Thank you
Best Answer
A
Alexia SIMOND
said
over 1 year ago
Hello Michael,
The data contained in the workflow tables are linked to actual data in the other tables of your data location.
Thus only truncated those table could lead to data discrepancies.
The easiest way would be to directly reset your whole data location.
This way all dependencies will be addressed together.
But please be careful if you delete your data location, that all custom objects are prefixed by "usr_", otherwise they will get dropped as well.
Best regards,
Alexia
1 Comment
A
Alexia SIMOND
said
over 1 year ago
Answer
Hello Michael,
The data contained in the workflow tables are linked to actual data in the other tables of your data location.
Thus only truncated those table could lead to data discrepancies.
The easiest way would be to directly reset your whole data location.
This way all dependencies will be addressed together.
But please be careful if you delete your data location, that all custom objects are prefixed by "usr_", otherwise they will get dropped as well.
Michael BARTLEY
hi there,
during our workflow development we've had many starts, stops, direction changes, and have a bunch of data in the wf tables that I'd like to clean out of our development environment.
when I attempt to truncate the following tables, I run into an issue with WF_STEP_INSTANCE:
SQL Error [4712] [S0001]: Cannot truncate table 'xdmd_ProductDomain.dbo.WF_STEP_INSTANCE' because it is being referenced by a FOREIGN KEY constraint.
ive successfully truncated the remainder. is there another table im missing? or anything else I need to do to clean this last table out?
Tables ive worked with in our domain:
WF_ATTACHMENT;
WF_BRANCH_INSTANCE;
WF_ERROR;
WF_STEP_INSTANCE;
WF_USER_NOTIFICATION_SETTINGS;
WF_USER_TASK_CANDIDATE;
WF_WORKFLOW_INSTANCE;
WF_WORK_ITEM;
Thank you
Hello Michael,
The data contained in the workflow tables are linked to actual data in the other tables of your data location.
Thus only truncated those table could lead to data discrepancies.
The easiest way would be to directly reset your whole data location.
This way all dependencies will be addressed together.
But please be careful if you delete your data location, that all custom objects are prefixed by "usr_", otherwise they will get dropped as well.
Best regards,
Alexia
Alexia SIMOND
Hello Michael,
The data contained in the workflow tables are linked to actual data in the other tables of your data location.
Thus only truncated those table could lead to data discrepancies.
The easiest way would be to directly reset your whole data location.
This way all dependencies will be addressed together.
But please be careful if you delete your data location, that all custom objects are prefixed by "usr_", otherwise they will get dropped as well.
Best regards,
Alexia
-
Recreate a dev environment. Any side effect?
-
Can you help me configure my REST Client Response Output Value Selector?
-
Is Tomcat Manager Accessible Remotely
-
Cleaning mta_task_def
-
Drop tables within the datalocation schema
-
Which REST API that can be used for "Deploy Model Edition" ?
-
Session timeout settings
-
Audit logs in Semarchy
-
Automatic Deployment
-
Error while creating Model from API
See all 49 topics