AI OnAI Off
Guess you can run SQL Trace and see what's going on in SQL server then? How big is solution? We have successfully migrated quite large solutions without issues.
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
I'm getting a "The wait operation timed out" when upgrading our site from EPiServer CMS 6 R2 to 7:
Started a transacted install
productPath: C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\Upgrade\Database\sql\0006_0000_0318_0113to0006_0002_0127_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\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.0.859.1\Upgrade\Database\sql\0006_0002_0128_0000to0006_0002_0130_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\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.0.859.1\Upgrade\Database\sql\0006_0002_0131_0000to0006_0002_0138_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\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.0.859.1\Upgrade\Database\sql\0006_0002_0139_0000to0006_0002_0228_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\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.0.859.1\Upgrade\Database\sql\0006_0002_0229_0000to0006_0002_0256_0000.sql"
Not executing database script "C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\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.0.859.1\Upgrade\Database\sql\0006_0002_0257_0000to0006_0002_0312_0000.sql"
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\Upgrade\Database\sql\0007_0000_0258_0000to0007_0000_0259_0000.sql"
Executing database script "C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\Upgrade\Database\sql\0007_0000_0259_0000to0007_0000_0260_0000.sql"
installedVersion: 6.2.267.1
frameworkVersion: 7.0.859.1
Skipping web config modification of EPiServer Framework (6.0.318.113 < 6.2.267.
1)
Skipping web config modification of EPiServer Framework (6.1.79.0 < 6.2.267.1)
Skipping web config modification of EPiServer Framework (6.2.267.1 < 6.2.267.1)
Applying web config modification for EPiServer Framework 7.0.859.1
Removing assembly redirect for EPiServer.Shell.UI
Copying C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\bin to C:\EPiServer\Sites\AABnetEpiserver_Beta\bin
Assembly redirect for EPiServer.ApplicationModules.dll: 1.0.0.0-7.0.859.1
Adding/Updating assembly redirect for EPiServer.ApplicationModules
Assembly redirect for EPiServer.Data.Cache.dll: 1.0.0.0-7.0.859.1
Adding/Updating assembly redirect for EPiServer.Data.Cache
Assembly redirect for EPiServer.Data.dll: 1.0.0.0-7.0.859.1
Adding/Updating assembly redirect for EPiServer.Data
Assembly redirect for EPiServer.Events.dll: 1.0.0.0-7.0.859.1
Adding/Updating assembly redirect for EPiServer.Events
Assembly redirect for EPiServer.Framework.dll: 1.0.0.0-7.0.859.1
Adding/Updating assembly redirect for EPiServer.Framework
Assembly redirect for EPiServer.Licensing.dll: 1.0.0.0-7.0.859.1
Adding/Updating assembly redirect for EPiServer.Licensing
Assembly redirect for EPiServer.Shell.dll: 1.0.0.0-7.0.859.1
Adding/Updating assembly redirect for EPiServer.Shell
Adding/Updating assembly redirect for System.Web.Mvc
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\9e784598377043a7bb2cb140df751053\content to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\CMS
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\9e784598377043a7bb2cb140df751053\lib to C:\EPiServer\Sites\AABnetEpiserver_Beta\modulesbin
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\9e784598377043a7bb2cb140df751053\lib to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\CMS\bin
Copying C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\Install\Configuration\ to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules
Copying C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\packages to C:\EPiServer\VPP\AABnetEpiserver_Beta\ModulesRepository
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\bb5ea7fd0575433eafe6322506b16957\content to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\EPiServer.Packaging
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\bb5ea7fd0575433eafe6322506b16957\lib to C:\EPiServer\Sites\AABnetEpiserver_Beta\modulesbin
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\bb5ea7fd0575433eafe6322506b16957\lib to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\EPiServer.Packaging\bin
Copying C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\packages to C:\EPiServer\VPP\AABnetEpiserver_Beta\ModulesRepository
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\c0767b052a4a458b8fc19e3e48583a3c\content to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\EPiServer.Packaging.UI
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\c0767b052a4a458b8fc19e3e48583a3c\lib to C:\EPiServer\Sites\AABnetEpiserver_Beta\modulesbin
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\c0767b052a4a458b8fc19e3e48583a3c\lib to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\EPiServer.Packaging.UI\bin
Copying C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\packages to C:\EPiServer\VPP\AABnetEpiserver_Beta\ModulesRepository
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\11e9c4e0801e444e959e4ec0f4f17892\content to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\Shell
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\11e9c4e0801e444e959e4ec0f4f17892\lib to C:\EPiServer\Sites\AABnetEpiserver_Beta\modulesbin
Copying C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\11e9c4e0801e444e959e4ec0f4f17892\lib to C:\EPiServer\VPP\AABnetEpiserver_Beta\Modules\Shell\bin
Copying C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\packages to C:\EPiServer\VPP\AABnetEpiserver_Beta\ModulesRepository
Adding/Updating assembly redirect for System.Web.Mvc
Adding/Updating assembly redirect for System.ComponentModel.Composition
Adding/Updating assembly redirect for System.Web.Extensions
Adding/Updating assembly redirect for System.Web.DataVisualization
Removed System.Web.Mvc.dll
Removed System.ComponentModel.Composition.dll
Copying C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\bin to C:\EPiServer\Sites\AABnetEpiserver_Beta\bin
Copying C:\Program Files (x86)\EPiServer\Framework\7.0.859.1\bin to C:\EPiServer\Sites\AABnetEpiserver_Beta\bin
Copying C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\application\App_Browsers to C:\EPiServer\Sites\AABnetEpiserver_Beta\App_Browsers
Removed contentChannelText.xml
Removed languageDA.xml
Removed languageDE.xml
Removed languageEN.xml
Removed languageES.xml
Removed languageFI.xml
Removed languageFR.xml
Removed languageJA.xml
Removed languageNL.xml
Removed languageNO.xml
Removed languagePT.xml
Removed languageSV.xml
Removed languageZH.xml
Removed newtext.xml
Removed newtext_OnlineCenter.xml
Removed newtext_OnlineCenter_sent_to_translation.xml
Removed newtext_sent_to_translation.xml
Removed OnlineCenter_DA.xml
Removed OnlineCenter_DE.xml
Removed OnlineCenter_EN.xml
Removed OnlineCenter_ES.xml
Removed OnlineCenter_FI.xml
Removed OnlineCenter_FR.xml
Removed OnlineCenter_JA.xml
Removed OnlineCenter_NL.xml
Removed OnlineCenter_NO.xml
Removed OnlineCenter_PT.xml
Removed OnlineCenter_SV.xml
Removed OnlineCenter_ZH.xml
Removed tinyMCE.da.lang.xml
Removed tinyMCE.de.lang.xml
Removed tinyMCE.en.lang.xml
Removed tinyMCE.es.lang.xml
Removed tinyMCE.fi.lang.xml
Removed tinyMCE.fr.lang.xml
Removed tinyMCE.ja.lang.xml
Removed tinyMCE.nl.lang.xml
Removed tinyMCE.no.lang.xml
Removed tinyMCE.pt.lang.xml
Removed tinyMCE.sv.lang.xml
Removed tinyMCE.zh.lang.xml
Removed workflowFoundation.xml
Removed workflowFoundation_DA.xml
Removed workflowFoundation_DE.xml
Removed workflowFoundation_EN.xml
Removed workflowFoundation_ES.xml
Removed workflowFoundation_FI.xml
Removed workflowFoundation_FR.xml
Removed workflowFoundation_JA.xml
Removed workflowFoundation_NL.xml
Removed workflowFoundation_NO.xml
Removed workflowFoundation_PT.xml
Removed workflowFoundation_SV.xml
Removed workflowFoundation_ZH.xml
Removing assembly redirect for EPiServer.Cms.Shell.UI
Adding/Updating assembly redirect for EPiServer.BaseLibrary
Adding/Updating assembly redirect for EPiServer.Blog
Adding/Updating assembly redirect for EPiServer.Configuration
Adding/Updating assembly redirect for EPiServer
Adding/Updating assembly redirect for EPiServer.Enterprise
Adding/Updating assembly redirect for EPiServer.ImageLibrary
Adding/Updating assembly redirect for EPiServer.Implementation
Adding/Updating assembly redirect for EPiServer.LinkAnalyzer
Adding/Updating assembly redirect for EPiServer.Scheduler
Adding/Updating assembly redirect for EPiServer.Scheduler.WKTL
Adding/Updating assembly redirect for EPiServer.UI
Adding/Updating assembly redirect for EPiServer.Web.WebControls
Adding/Updating assembly redirect for EPiServer.WebDav
Adding/Updating assembly redirect for EPiServer.WebParts
Adding/Updating assembly redirect for EPiServer.WorkflowFoundation
Adding/Updating assembly redirect for EPiServer.XForms
Adding/Updating assembly redirect for EPiServer.XmlRpc
Adding/Updating assembly redirect for Castle.Core
Adding/Updating assembly redirect for Castle.Windsor
Adding/Updating assembly redirect for EPiServer.ApplicationModules
Adding/Updating assembly redirect for EPiServer.Data.Cache
Adding/Updating assembly redirect for EPiServer.Data
Adding/Updating assembly redirect for EPiServer.Events
Adding/Updating assembly redirect for EPiServer.Framework
Adding/Updating assembly redirect for EPiServer.Licensing
Adding/Updating assembly redirect for EPiServer.Shell
Executing database script "C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\Database\sql\0006_0001_0379_0000to0006_0001_0418_0000.sql"
Executing database script "C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\Database\sql\0006_0001_0419_0000to0006_0001_0502_0000.sql"
Executing database script "C:\Program Files (x86)\EPiServer\CMS\7.0.586.1\Upgrade\Database\sql\0006_0001_9999_0000to0007_0000_0040_0000.sql"
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()
Any help in getting this worked?