MSCRM Migration 3.0 to 4.0 failure with exception "Microsoft.Crm.Setup.Server.WorkFlowUpgradeAction" failed.
-
Tuesday, 5 August, 2008 8:34 PM
I am working on migartion from MSCRM 3.0 to 4.0 version by running MSCRM 4.0 upgrade over existing 3.0 installation. I am facing a sever problem in migration of workflows and migration wizard is not reaching successful stage. Migration ran for more than 20 hrs but didn't succeed. For Initial 2 hrs wizard completed few of activities and reached the Workflow migration stage and after 18 hrs finally thrown the error message - "Microsoft.Crm.Setup.Server.WorkFlowUpgradeAction" failed.
I followed the whitepaper published by MS on CRM Optimizing Performance page 16-18 at location http://www.microsoft.com/downloads/details.aspx?FamilyID=6B32E0B3-5520-48A7-B3CD-D8477D084821&displaylang=en.
Originally there were 400000 records in wfprocessInstance table which got reduced to 60,000 after we ran the query to purge old workflow log records with the exception of sales process log information.
No of records in WFlowProcessInstance - 59,256
· No of records in wfRuleLog - 124508
· No of records in wfActionLog - 585586
Total size of CRM database – 12GB.
Disk space available on CRM database drive – 65 GB.
Disk Space available on TempDb database is 30 GB.
Available RAM - 16GB
Please let me know if anyone faced such a problem and how to handle this situation.
Appreciate help.
Thanks,
Vijayendra
All Replies
-
Wednesday, 6 August, 2008 12:45 PMModerator
plz remove duplicate posts
did you stop the workflow before migration
For More see MS CRM Support section
http://support.microsoft.com/ph/12976
Regards,
Imran
-
Wednesday, 6 August, 2008 4:14 PM
Thanx Imran for your reply.. Yes workflow service was stopped before running the Upgrade.
Sending you a snap from the log file generated. This block is getting generated many times in log for different GUIDs and as seen from the log timestamp. the processing stops for near abt 10 min and it gets time out and then starts processing another GUID and many process gets completed successful also in between the reoccurence of the mention error block..
Appreciate Help!!
----------------xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx-------------------------
00:59:20| Info| Upgrading instance workflow: Name
tandard Sales Process ProcessInstanceId:{465ec77f-f0a0-dc11-befb-0017a4a7cd08}
01:09:23| Info| Deleting: failed activation {465ec77f-f0a0-dc11-befb-0017a4a7cd08}
01:09:23|Warning| Exception while upgrading instance workflow: Nametandard Sales Process ProcessInstanceId:{465ec77f-f0a0-dc11-befb-0017a4a7cd08}| Microsoft.Crm.CrmException: SdkCommand Publish ---> Microsoft.Crm.CrmException: Workflow compilation failed:
348: Compilation failed. Timed out waiting for a program to execute. The command being executed was "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths @"C:\Documents and Settings\crmadmin\Local Settings\Temp\1\1gozmrd8.cmdline". ---> Microsoft.Crm.CrmException: Workflow compilation failed:
348: Compilation failed. Timed out waiting for a program to execute. The command being executed was "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths @"C:\Documents and Settings\crmadmin\Local Settings\Temp\1\1gozmrd8.cmdline".
at Microsoft.Crm.ObjectModel.WorkflowServiceInternal`1.CompileWorkflow(ExecutionContext context, WorkflowEntity definition, List`1 dependencies, List`1 customActivityIds, Guid activationId)
--- End of inner exception stack trace ---
at Microsoft.Crm.ObjectModel.WorkflowServiceInternal`1.CompileWorkflow(ExecutionContext context, WorkflowEntity definition, List`1 dependencies, List`1 customActivityIds, Guid activationId)
at Microsoft.Crm.ObjectModel.WorkflowServiceInternal`1.CompletePublishing(WorkflowEntity definition, List`1 dependencies, List`1 customActivityIds, ExecutionContext context)
at Microsoft.Crm.ObjectModel.WorkflowServiceInternal`1.PublishInPlace(WorkflowEntity definition, ExecutionContext context)
at Microsoft.Crm.Workflow.Upgrade.SdkCommand.PublishWorkflow(DynamicEntity definition, Guid parentId, Guid activationId, IUpgradeContext upgradeContext, Boolean isInstance, Boolean isInactiveActivation)
--- End of inner exception stack trace ---
at Microsoft.Crm.Workflow.Upgrade.SdkCommand.PublishWorkflow(DynamicEntity definition, Guid parentId, Guid activationId, IUpgradeContext upgradeContext, Boolean isInstance, Boolean isInactiveActivation)
at Microsoft.Crm.Workflow.Upgrade.WorkflowAdapter.Publish(Guid parentId, Guid activationId, IUpgradeContext context, Boolean isInstance, Boolean isInactiveActivation)
at Microsoft.Crm.Workflow.Upgrade.WorkflowUpgradeOrchestration.UpgradeInstances(IUpgradeContext upgradeContext, IDataProvider`1 dataProvider)
01:09:23| Info| Deleting: failed activation {465ec77f-f0a0-dc11-befb-0017a4a7cd08} -
Thursday, 7 August, 2008 5:29 AMModerator
i suggest you contact microsoft for this
For More see MS CRM Support section
http://support.microsoft.com/ph/12976
Regards,
Imran
-
Friday, 22 August, 2008 7:16 AM
Hi,
Did you find out anything about this?
I'm having the same problem here.
When you got the error message, did CRM work afterwards?
/frank
-
Friday, 22 August, 2008 8:36 AM
This type of error (failure to compile) usually indicates a low memory problem. Can you post more details about the box running crm / sql?
-
Friday, 22 August, 2008 8:44 AM
CRM server
Intel Xeon 5110 @ 1.6Ghz, 2Gb RAM, raid 1.
The job is still going, and the usage of the cpu/mem are:
Microsoft.Crm.Setup.Servere.exe is using approx. 25% CPU
Memory usage is 880Mb
-------------------
SQL server
Is the same specs, only 1Gb extra memory. (3Gb)
Memory usage here is 2.4Gb
/f
-
Friday, 22 August, 2008 10:25 AM can you open / find the @"C:\Documents and Settings\crmadmin\Local Settings\Temp\1\1gozmrd8.cmdline
file. it might give you more details on which csc step is failing.
- Marked As Answer by Donna EdwardsMVP, Owner Monday, 1 June, 2009 4:37 PM
-
Friday, 22 August, 2008 11:21 AM
There is *a lot* of directory's in the \1 folder, but not 1gozmfrd8...
And each of them contains one file;
CompiledWorkflow17b942047f25dd1194dc001b78cc2c1e.pdb
any idea?
/f
-
Friday, 22 August, 2008 3:19 PM
Frank only want to say, dont worry, you are not alone.
I have the same problem.
-
Monday, 25 August, 2008 5:19 PMWe have the same problem. Please try to install .NET Framework 2.0 SP1 on the server to solve this particular issue.
Now we have the following error:
348: Compilation failed. Could not find file 'C:\Documents and Settings\Administrator.CRMTEST\Local Settings\Temp\th5p5_qt\CompiledWorkflow686a4b01475edd1198c70016356d339d.dll'. -
Monday, 25 August, 2008 8:34 PM
I have .NET 2.0 installed, but this happened on a customer's prodution enviroment, so I can't do so much "testing".
What i did to "resolve" the problem, was to terminate the microsoft.crm.setup.exe process, and restarted the machine.
I have now tested a lot of things and everything seems to be perfectly fine.
I also found this in the CRM 4.0 Implementation guide:
“One or more workflows could not be upgraded” message received during upgrade
Because of changes in workflow and sales process functionality with Microsoft Dynamics CRM 4.0, some workflows cannot be upgraded. Although Setup indicates that the upgrade was not successful, in most cases the rest of the Microsoft Dynamics CRM 4.0 application will function as expected.
For a list of those workflows, including an explanation, see the server Setup log file. By default, the log file is located at:
<systemdrive>:\Documents and Settings\<User>\Application Data\Microsoft\MSCRM\Logs\crm40svrsetup.log
For more information about how workflows are upgraded, see “Chapter 4: Planning Deployment” in the Microsoft Dynamics CRM 4.0 Planning Guide.
So now the customer is back in production, and I haven't heard a singel complaint...yet
Thanks for all your help.
- Marked As Answer by Donna EdwardsMVP, Owner Monday, 1 June, 2009 4:37 PM
