Search code examples
episerver

Is there a way to override the connection timeout when upgrading site from CMS 6 R2 to 7?


I'm having a problem upgrading a site from CMS 6 R2 to 7. I'm getting a wait timeout error while upgrading using the Deployment Center.

I already tried to add the following configuration in C:\Program Files (x86)\EPiServer\Shared\Install\EPiServerInstall.exe.config:

 <appSettings>
  <add key="commandTimeout" value="600"/>
 </appSettings>

but no avail.

As much as I don't want to resort to manual upgrade, is there a way to override the connection timeout?

Thanks in advance for any help.

Edit:

Upgrade log (too long so I cut it just to display the error message):

....
Executing database script "C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\Database\sql\0007_0000_0041_0000to0007_0000_0147_0000.sql"
An error has occured and the transaction will be rolled back
Rolledback
The wait operation timed out
The wait operation timed out

An unhandled error has occured:
The wait operation timed out
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\System Scripts\Upgrad
e Site Database (SqlServer).ps1:9 char:2
+     Execute-EPiSqlSvrScript -EPiServerScript -ScriptPath $file -SqlServerName
 $dbCo ...
+    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~

=
Get-EPiIsBulkInstalling
At C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\System Scripts\Upgrade Site Database (SqlServer).ps1:9 char:2
+     Execute-EPiSqlSvrScript -EPiServerScript -ScriptPath $file -SqlServerName $dbCo ...
+    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
   at EPiServer.Install.InstallationManager.Install(Installer installer)
   at EPiServer.Install.SqlServer.SqlServerInstallationManager.ExecuteDatabaseScript(String sqlServerName, Nullable`1 sqlServerPort, String databaseName, String loginName, String loginPassword, String scriptFilePath, Boolean avoidDbTransaction, Boolean isEPiServerScript, IDictionary parameters)
   at EPiServer.Install.SqlServer.Cmdlets.ExecuteSqlScriptCmdlet.ProcessRecord()
   at System.Management.Automation.Cmdlet.DoProcessRecord()
   at System.Management.Automation.CommandProcessor.ProcessRecord()

Solution

  • I restarted the site then refreshed the site in DC and it worked now. Looks like the settings are cached in DC.