London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!
AI OnAI Off
SQL error upgrade script R3=>7.5
Problem solved after I setup a new database, I tried to rerun the script on a failed database upgrade.
/J
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.
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