CRM upgrade from 1.2 to 3 is failing with a timeout issue on a very large db
(almost 16Gb).
Any ideas?
Event Logs:
15:06:31| Info| Adding attribute :StatusCode To Entity : Email
16:06:55| Error| Install exception.System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Reflection.TargetInvocationException: Exception has been thrown by the
target of an invocation. ---> System.Data.SqlClient.SqlException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.Upgrade.ActivityUpgrade.Upgrade(String path)
--- End of inner exception stack trace ---
at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean verifyAccess)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags invokeAttr,
Binder binder, Object target, Object[] args, ParameterModifier[] modifiers,
CultureInfo culture, String[] namedParameters)
at Microsoft.Crm.Setup.DatabaseInstaller.DllMethodAction.Execute()
at Microsoft.Crm.Setup.DatabaseInstaller.DatabaseInstaller.Install(Int32
languageCode, String file, Boolean upgrade)
at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary
parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
at Microsoft.Crm.Setup.Server.DatabaseInstaller.Install(IDictionary
stateSaver)
at
Microsoft.Crm.Setup.Common.ComposedInstaller.InternalInstall(IDictionary
stateSaver)
at Microsoft.Crm.Setup.Common.ComposedInstaller.Install(IDictionary
stateSaver)
at Microsoft.Crm.Setup.Server.ServerSetup.Upgrade(IDictionary data)
at Microsoft.Crm.Setup.Server.ServerSetup.Run()
16:06:55| Info| Microsoft CRM 3.0 Server Setup Failed.
16:06:55| Info| Microsoft CRM 3.0 Server Setup Setup did not complete
successfully.
Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed.
Exception has been thrown by the target of an invocation.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
and
15:06:31| Info| Adding attribute :StatusCode To Entity : Email
16:06:55| Error| Install exception.System.Exception: Action
Microsoft.Crm.Setup.Server.InstallDatabaseAction failed. --->
System.Reflection.TargetInvocationException: Exception has been thrown by the
target of an invocation. ---> System.Data.SqlClient.SqlException: Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Crm.Upgrade.ActivityUpgrade.Upgrade(String path)
--- End of inner exception stack trace ---
at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean verifyAccess)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags invokeAttr,
Binder binder, Object target, Object[] args, ParameterModifier[] modifiers,
CultureInfo culture, String[] namedParameters)
at Microsoft.Crm.Setup.DatabaseInstaller.DllMethodAction.Execute()
at Microsoft.Crm.Setup.DatabaseInstaller.DatabaseInstaller.Install(Int32
languageCode, String file, Boolean upgrade)
at Microsoft.Crm.Setup.Server.InstallDatabaseAction.Do(IDictionary
parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
at Microsoft.Crm.Setup.Server.DatabaseInstaller.Install(IDictionary
stateSaver)
at
Microsoft.Crm.Setup.Common.ComposedInstaller.InternalInstall(IDictionary
stateSaver)
at Microsoft.Crm.Setup.Common.ComposedInstaller.Install(IDictionary
stateSaver)
at Microsoft.Crm.Setup.Server.ServerSetup.Upgrade(IDictionary data)
at Microsoft.Crm.Setup.Server.ServerSetup.Run()
16:06:55| Info| Microsoft CRM 3.0 Server Setup Failed.
16:06:55| Info| Microsoft CRM 3.0 Server Setup Setup did not complete
successfully.
Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed.
Exception has been thrown by the target of an invocation.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.