--STEP ONE, SET DELETION STATE TO 2 SO THAT DELETION SERVICE WILL DELETE
update wfprocessinstance
set deletionstatecode = 2
where statecode in (3,4)--where complete (3) or where canceled (4)
--where objecttype in (4) "USE THIS TO REMOVE WORK FLOW FOR A SPECIFIC ENTITY
*CLICK ON THE LINK BELOW FOR A FULL LIST OF OBJECT TYPE CODES
--STEP TWO, DELETE THE DEPENDENCIES
delete wfactionlog
where processinstanceid in
(select processinstanceid from wfprocessinstance where deletionstatecode = 2)
--select * from wfactionlog
--STEP THREE, DELETE THE DEPENDENCIES
delete wfrulelog
where processinstanceid in
(select processinstanceid from wfprocessinstance where deletionstatecode = 2)
--select * from wfrulelog
--STEP FOUR, YOU CAN RUN THE SQL BELOW TO DELETE THE PROCESS INSTANCE
--OR, YOU CAN USE THE DELETION SERVICE MOST COMMONLY FOUND AT THE FOLLOWING
--FILE PATH ON THE CRM SERVER
--C:\PROGRAM FILES\MICROSOFT CRM\SERVER\BIN
--ONCE IN THE DIRETORY, TYPE THE FOLLOWING COMMAND WITHOUT THE QUOTES "CRMDELETIONSERVICE.EXE /RUNONCE"
delete wfprocessinstance
where deletionstatecode = 2
|