Try our conversational search powered by Generative AI!

SQL error upgrade script R3=>7.5


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?


Jun 26, 2014 14:14

Problem solved after I setup a new database, I tried to rerun the script on a failed database upgrade.


Jun 26, 2014 16:56
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
* 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.