November Happy Hour will be moved to Thursday December 5th.

Episerver 7.0 - 7.5 Update - Wait Operation Timeout

Vote:
 

Hey all,

I'm experiencing difficulty with upgrading our site to 7.5...

When I run the upgrade site and sql database from the EpiServer deployement center i get this:

Verifying whether specific add-ons should be updated before site upgrade.
Started a transacted install
productPath: C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0000_0318_0113to0006_0002_0127_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0000_0318_0113to0006_0002_0127_0000.sql" because it has already been executed.
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0128_0000to0006_0002_0130_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0128_0000to0006_0002_0130_0000.sql" because it has already been executed.
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0131_0000to0006_0002_0138_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0131_0000to0006_0002_0138_0000.sql" because it has already been executed.
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0139_0000to0006_0002_0228_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0139_0000to0006_0002_0228_0000.sql" because it has already been executed.
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0229_0000to0006_0002_0256_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0229_0000to0006_0002_0256_0000.sql" because it has already been executed.
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0257_0000to0006_0002_0312_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0006_0002_0257_0000to0006_0002_0312_0000.sql" because it has already been executed.
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0007_0000_0258_0000to0007_0000_0259_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0007_0000_0258_0000to0007_0000_0259_0000.sql" because it has already been executed.
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0007_0000_0259_0000to0007_0000_0260_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0007_0000_0259_0000to0007_0000_0260_0000.sql" because it has already been executed.
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0007_0000_0260_0000to0007_0000_0936_0021.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\Framework\7.5.394.2\Install\System Scripts\
Install Site (SqlServer).ps1:139 char:26
+ Execute-EPiSqlSvrScript <<<< `

True
=
Get-EPiIsBulkInstalling

An unhandled error has occured:
The wait operation timed out
When executing

At C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Install\System Scripts\
Install Site (SqlServer).ps1:139 char:26
+ Execute-EPiSqlSvrScript <<<< `

=
Get-EPiIsBulkInstalling

At C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Install\System Scripts\Install Site (SqlServer).ps1:139 char:26
+ Execute-EPiSqlSvrScript <<<< `
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()

It seems to timeout - we've tried turning off the timeout on the sql server itself, but that doesn't seem to help... any clue as to what we can do?

#86830
Jun 02, 2014 20:50
Vote:
 

Maybe you can try to run the script (C:\Program Files (x86)\EPiServer\Framework\7.5.394.2\Upgrade\Database\sql\0007_0000_0260_0000to0007_0000_0936_0021.sql) that causes the timeout manually?

#86937
Jun 04, 2014 16:07
Vote:
 

We are experiencing the same problem. How did you get around it?

#122950
Jun 18, 2015 14:48
Vote:
 

Solved. Cause: Limitation in the EPiServerInstall.exe.config. See http://world.episerver.com/forum/developer-forum/EPiServer-7-CMS/Thread-Container/2013/4/Error-upgrading-a-large-db-from-CMS6-to-CMS7-using-Deployment-Center

#123048
Jun 23, 2015 14:29
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.