Upgrade from CRM 3.0 to CRM 4.0 fails

Upgrade from CRM 3.0 to CRM 4.0 fails

Post by VGlt » Sat, 26 Jan 2008 09:40:02


To: Toma Voduek (or anyone who can assit)

Can you please re-post your reply to our issue. (Someone deleted the thread
we were posting to.) You previously posted the following text:

<< If i Understand right the error your Workflow SalesProcess
(opportunity) is stuck in a waiting for a task or something there is defined
in a sales process.

The workflow monitor can show you paused processes. In our Case the
workflows were not visible in Workflow Monitor so I used brutal force to find
them en deleted them. >>

Can you pleaes explain again how you solved this problem? What SQL command
did you perform on the database? Can you tell me again?

We appreciate your assistance.

Sincerely,

Tim Ziegner
Austin, Texas
 
 
 

Upgrade from CRM 3.0 to CRM 4.0 fails

Post by Tomaz Vodu » Tue, 29 Jan 2008 04:08:22

i, Tim

Yes I can assist you with this issue of deleting this stuck processes.

I tried to use only the stored procedure p_deleteprocess @processis=' GUID
of your process'

but the sistem refusses to delete this process because of some restrictions
so i deleted some actions and steps maped to my stuck process I must remind
you to backup the database )i some times forget this important step :) )
DELETE FROM WFParameter

FROM WFRule INNER JOIN

WFStep ON WFRule.StepId = WFStep.StepId INNER JOIN

WFCondition ON WFRule.RuleId = WFCondition.RuleId INNER JOIN

WFParameter ON WFCondition.ConditionId = WFParameter.ConditionId

WHERE (WFStep.ProcessId IN (GUID of your process))


DELETE FROM WFCondition

FROM WFRule INNER JOIN

WFStep ON WFRule.StepId = WFStep.StepId INNER JOIN

WFCondition ON WFRule.RuleId = WFCondition.RuleId

WHERE (WFStep.ProcessId IN (GUID of your process))

DELETE FROM WFRuleLog

FROM WFRule INNER JOIN

WFStep ON WFRule.StepId = WFStep.StepId INNER JOIN

WFRuleLog ON WFRule.RuleId = WFRuleLog.RuleId

WHERE (WFStep.ProcessId IN (GUID of your process))

DELETE FROM WFRule

FROM WFRule INNER JOIN

WFStep ON WFRule.StepId = WFStep.StepId

WHERE (WFStep.ProcessId IN (GUID of your process))

DELETE FROM WFActionLog

FROM WFStep INNER JOIN

WFAction ON WFStep.StepId = WFAction.StepId INNER JOIN

WFActionLog ON WFAction.ActionId = WFActionLog.ActionId

WHERE (WFStep.ProcessId IN (GUID of your process))

DELETE FROM WFParameter

FROM WFStep INNER JOIN

WFAction ON WFStep.StepId = WFAction.StepId INNER JOIN

WFParameter ON WFAction.ActionId = WFParameter.ActionId

WHERE (WFStep.ProcessId IN (GUID of your process))

DELETE FROM WFAction

FROM WFStep INNER JOIN

WFAction ON WFStep.StepId = WFAction.StepId

WHERE (WFStep.ProcessId IN (GUID of your process))

DELETE FROM WFActionLog

FROM WFStep INNER JOIN

WFProcess ON WFStep.ProcessId = WFProcess.ProcessId INNER JOIN

WFProcessInstance ON WFProcess.ProcessId = WFProcessInstance.ProcessId INNER
JOIN

WFActionLog ON WFProcessInstance.ProcessInstanceId =
WFActionLog.ProcessInstanceId

WHERE (WFStep.ProcessId IN (GUID of your process))

DELETE FROM WFProcessInstance

FROM WFStep INNER JOIN

WFProcess ON WFStep.ProcessId = WFProcess.ProcessId INNER JOIN

WFProcessInstance ON WFProcess.ProcessId = WFProcessInstance.ProcessId

WHERE (WFStep.ProcessId IN (GUID of your process))



DELETE FROM WFProcess

FROM WFStep INNER JOIN

WFProcess ON WFStep.ProcessId = WFProcess.ProcessId

WHERE (WFStep.ProcessId IN (GUID of your process))

DELETE FROM WFStep

WHERE (ProcessId IN (GUID of your process))

p_DeleteProcess @processid='(GUID of your process)' ----- in this procedure
you can use only 1 Guid at the time.



This procedure is allready sorted so you copy paste this procedure in a
Query -sql data managment studio for the MSCRM database - CRM 3.0



if you have some other questions feel fre to contact me..






"Tim" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...