November Happy Hour will be moved to Thursday December 5th.
When I run the Upgrade Commerce to 7.5 from deployment center, I getting many errors, I fix almost all of them, but one I am not getting throw.
This error is throw from deployment center...
Any idea?
C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\Modules\EPiServer Commer
ce 7.5.394.2\ECF\Data\SqlScripts\Update\ecf_db_PricingSystem_update.sql
An error has occured and the transaction will be rolled back
The was an error during the rollback phase. Your system may be left in an unstable condition
Cannot create a file when that file already exists.
System.IO.IOException: Cannot create a file when that file already exists.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalMove(String sourceDirName, String destDirName, Boolean checkHost)
at EPiServer.Install.FileSystem.Installers.RemoveDirectoryInstaller.Rollback(IDictionary savedState)
at EPiServer.Install.InstallationManager.RollbackBulkInstall()
Rolledback
Violation of PRIMARY KEY constraint 'PK_SchemaVersion_PricingSystem'. Cannot insert duplicate key in object 'dbo.SchemaVersion_PricingSystem'.
The statement has been terminated.
An unhandled error has occured:
Violation of PRIMARY KEY constraint 'PK_SchemaVersion_PricingSystem'. Cannot in
sert duplicate key in object 'dbo.SchemaVersion_PricingSystem'.
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\Modules\EPiServer Com
merce 7.5.394.2\Install\ShareLib.ps1:108 char:32
+ Execute-EPiSqlSvrScript <<<< -SqlServerName $csBuilder.DataSource -D
atabaseName $csBuilder.InitialCatalog -ScriptPath $filePath -AvoidDbTransaction
:$avoidTransaction -LoginName $csBuilder.UserID -LoginPassword $csBuilder.Passw
ord
False
=
Get-EPiIsBulkInstalling
At C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\Modules\EPiServer Commerce 7.5.394.2\Install\ShareLib.ps1:108 char:32
+ Execute-EPiSqlSvrScript <<<< -SqlServerName $csBuilder.DataSource -DatabaseName $csBuilder.InitialCatalog -ScriptPath $filePath -AvoidDbTransaction:$avoidTransaction -LoginName $csBuilder.UserID -LoginPassword $csBuilder.Password
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_SchemaVersion_PricingSystem'. Cannot insert duplicate key in object 'dbo.SchemaVersion_PricingSystem'.
at EPiServer.Install.SqlServer.Installers.SqlServerItemInstaller.HandleSqlException(SqlCommand cmd, SqlException ex)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.ExecuteSqlScript(String filePath, IDictionary parameters, IDictionary stateSaver)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.InstallInternal(IDictionary stateSaver)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.Install(IDictionary stateSaver)
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()
ClientConnectionId:a4ac23fd-8a65-4121-ba57-9404f4cb5e86
Thanks
Hi,
The upgrade process should run without error. I suspect that you're trying to run the script on a site many times.
Would you try to run it on a working R3a site?
Regards.
/Q
When I run the Upgrade Commerce to 7.5 from deployment center, I getting many errors, I fix almost all of them, but one I am not getting throw.
This error is throw from deployment center...
Any idea?
C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\Modules\EPiServer Commer
ce 7.5.394.2\ECF\Data\SqlScripts\Update\ecf_db_PricingSystem_update.sql
An error has occured and the transaction will be rolled back
The was an error during the rollback phase. Your system may be left in an unstable condition
Cannot create a file when that file already exists.
System.IO.IOException: Cannot create a file when that file already exists.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalMove(String sourceDirName, String destDirName, Boolean checkHost)
at EPiServer.Install.FileSystem.Installers.RemoveDirectoryInstaller.Rollback(IDictionary savedState)
at EPiServer.Install.InstallationManager.RollbackBulkInstall()
Cannot create a file when that file already exists.
Rolledback
Violation of PRIMARY KEY constraint 'PK_SchemaVersion_PricingSystem'. Cannot insert duplicate key in object 'dbo.SchemaVersion_PricingSystem'.
The statement has been terminated.
Violation of PRIMARY KEY constraint 'PK_SchemaVersion_PricingSystem'. Cannot insert duplicate key in object 'dbo.SchemaVersion_PricingSystem'.
The statement has been terminated.
An unhandled error has occured:
Violation of PRIMARY KEY constraint 'PK_SchemaVersion_PricingSystem'. Cannot in
sert duplicate key in object 'dbo.SchemaVersion_PricingSystem'.
The statement has been terminated.
When executing
At C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\Modules\EPiServer Com
merce 7.5.394.2\Install\ShareLib.ps1:108 char:32
+ Execute-EPiSqlSvrScript <<<< -SqlServerName $csBuilder.DataSource -D
atabaseName $csBuilder.InitialCatalog -ScriptPath $filePath -AvoidDbTransaction
:$avoidTransaction -LoginName $csBuilder.UserID -LoginPassword $csBuilder.Passw
ord
False
=
Get-EPiIsBulkInstalling
At C:\Program Files (x86)\EPiServer\CMS\7.5.394.2\Install\Modules\EPiServer Commerce 7.5.394.2\Install\ShareLib.ps1:108 char:32
+ Execute-EPiSqlSvrScript <<<< -SqlServerName $csBuilder.DataSource -DatabaseName $csBuilder.InitialCatalog -ScriptPath $filePath -AvoidDbTransaction:$avoidTransaction -LoginName $csBuilder.UserID -LoginPassword $csBuilder.Password
System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK_SchemaVersion_PricingSystem'. Cannot insert duplicate key in object 'dbo.SchemaVersion_PricingSystem'.
The statement has been terminated.
at EPiServer.Install.SqlServer.Installers.SqlServerItemInstaller.HandleSqlException(SqlCommand cmd, SqlException ex)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.ExecuteSqlScript(String filePath, IDictionary parameters, IDictionary stateSaver)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.InstallInternal(IDictionary stateSaver)
at EPiServer.Install.SqlServer.Installers.SqlScriptInstaller.Install(IDictionary stateSaver)
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()
ClientConnectionId:a4ac23fd-8a65-4121-ba57-9404f4cb5e86
Thanks