Jul 31, 2012 at 6:03 AM
Edited Jul 31, 2012 at 6:26 AM
I have encountered the situation where I can't upload / update an activity because it already exists in the db.
It's not present in the trident workflow composer under activities or used in a workflow. I tried to delete in the trident management studio under assemblies, it can't be deleted because it states its Active even though it isn't.
I decided to look at the database directly through the MS SQL Server Management Studio, and found a number of records in dbo.Activitys table column isDeleted set to 1. These are the activities that I deleted previously I assumed I could reinsert the
activity with the same name. Even changing the name of the dll doesn't make a difference.
Tried deleting these records using SQL no success.
delete from dbo.Activitys where IsDeleted=1
The DELETE statement conflicted with the REFERENCE constraint "FK_ActivityInstance_Activity_33". The conflict occurred in database "Trident", table "dbo.ActivityInstances", column 'ActivityID'.
The statement has been terminated.
Is there a workaround or solution for this?