London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

Episerver 7.0 - 7.5 Update - Wait Operation Timeout

Vote:
0

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:
0

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:
0

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

#122950
Jun 18, 2015 14:48
Vote:
0

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.