We are running the upgrade script for Commerce R3=>7.5 and are getting following error:
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.
An unhandled error has occured:
Cannot drop type 'dbo.udttCatalogKey' because it is being referenced by object
'ecf_Pricing_GetCatalogEntryPrices'. There may be other objects that reference
this type.
So this is the second time we are doing the upgrade(this is the production db upgrade) and we didn't get this error the last time.
Anyone experienced this?
/J
Problem solved after I setup a new database, I tried to rerun the script on a failed database upgrade.
We are running the upgrade script for Commerce R3=>7.5 and are getting following error:
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.
An unhandled error has occured:
Cannot drop type 'dbo.udttCatalogKey' because it is being referenced by object
'ecf_Pricing_GetCatalogEntryPrices'. There may be other objects that reference
this type.
So this is the second time we are doing the upgrade(this is the production db upgrade) and we didn't get this error the last time.
Anyone experienced this?
/J