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?
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