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

ps1 script error when upgrade to Commerce 7.5

Vote:
 

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

 

#87112
Jun 10, 2014 9:53
Vote:
 

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

#87113
Jun 10, 2014 10:01
* 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.