AI OnAI Off
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?
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
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?