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()
I restarted the site then refreshed the site in DC and it worked now. Looks like the settings are cached in DC.