AI OnAI Off

Upgrading from 10 to 11 - Invalid object name 'dbo.CatalogEntry_Delete'.

Brian Holt
Brian Holt
Vote:
 

I am trying to upgrade our version of commerece from 10 to 11 but I get this error when trying to update the schema with Update-EpiDatabase.

Server Error in '/' Application.

Invalid object name 'dbo.CatalogEntry_Delete'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'dbo.CatalogEntry_Delete'.

Reading the update docs, it does not mention any database changes.

Thanks

#198476
Oct 29, 2018 14:29
Quan Mai
Quan Mai
Vote:
 

Which upgrade script file throws this exception? Please post the entire log from Package Manager Console 

#198477
Oct 29, 2018 14:40
Brian Holt
Brian Holt
Vote:
 

Here is the enitre log from the update command. Error towards the bottom.

PM> Update-EPiDatabase
Found no files to process
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.8.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.10.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.11.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.12.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.13.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.14.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.16.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.19.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\7.19.1.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\8.0.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\8.4.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\8.6.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\8.7.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\8.9.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\8.10.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.0.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.0.1.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.0.2.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.1.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.1.1.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.2.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.3.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.4.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.5.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.6.2.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.7.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.8.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.8.1.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.8.2.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\9.8.3.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.0.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.1.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.2.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.3.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.3.2.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.4.1.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.5.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.6.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.7.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.8.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.9.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\10.10.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.0.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.2.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.3.3.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.3.4.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.5.4.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.6.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.7.0.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.8.1.sql
Processing C:\devPremier\packages\EPiServer.CMS.Core.11.10.5\tools\epiupdates\sql\11.10.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Azure.11.8.5\tools\epiupdates_CMS\sql\1.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Azure.11.8.5\tools\epiupdates_commerce\sql\1.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Azure.11.8.5\tools\epiupdates_commerce\sql\1.0.1.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_CMS\sql\7.6.0.1.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_CMS\sql\8.0.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_CMS\sql\8.0.1.2.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_CMS\sql\9.0.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.1.0.1.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.1.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.1.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.2.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.2.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.3.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.4.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.5.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.5.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.5.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.6.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\5.6.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.0.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.0.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.0.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.1.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.1.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.2.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.3.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.3.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.3.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.4.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.4.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.4.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.4.3.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.5.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.6.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.7.0.1.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.7.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.8.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.9.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.9.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.9.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.9.3.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.10.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.10.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.10.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.10.3.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.10.4.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.10.5.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\6.10.6.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.3.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.4.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.5.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.6.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.7.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.8.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.9.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.10.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.11.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.12.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.13.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.14.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.15.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.0.16.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.1.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.1.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.2.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.2.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.2.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.3.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.3.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.3.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.4.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.5.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.6.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.7.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.8.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.4.9.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.3.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.4.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.5.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.6.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.7.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.8.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.5.9.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.6.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.6.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.6.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.6.3.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.6.4.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.7.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.8.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.9.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.10.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\7.10.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.0.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.1.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.2.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.3.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.4.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.5.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.6.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.7.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.8.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.9.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.10.0.sql
Processing C:\devPremier\packages\EPiServer.Commerce.Core.11.8.5\tools\epiupdates_commerce\sql\8.0.11.0.sql
epideploy.exe :
At C:\devPremier\packages\EPiServer.Framework.11.10.5\tools\upgrade.psm1:310 char:3
+ &$epiDeployPath -a $action -s $sitePath -p $updatePath\* -c ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:String) [], RemoteException
+ FullyQualifiedErrorId : NativeCommandError

EPiDeploy was stopped due to an exception, more details:


System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.CatalogEntry_Delete'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.Tds
Parser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at EPiDeploy.Sql.ScriptRunner.<>c__DisplayClass5.<ExecuteScript>b__3()
at EPiDeploy.Sql.DatabaseHandler.Execute[T](Func`1 f, Boolean commit)
at EPiDeploy.Sql.ScriptRunner.ExecuteScript(StreamReader stream)
at EPiDeploy.Sql.ScriptRunner.ExecuteScripts(IEnumerable`1 files, Boolean requiresValidation)
at EPiDeploy.Sql.ScriptRunner.<>c__DisplayClass1.<Execute>b__0()
at EPiDeploy.Sql.DatabaseHandler.Execute[T](Func`1 f, Boolean commit)
at EPiDeploy.Common.Executor.Execute(ILocation location)
at EPiDeploy.Common.Executor.Execute(ILocation location)
at EPiDeploy.Common.Executor.Execute(ILocation location)
at EPiDeploy.Common.Executor.Execute(ILocation location)
at EPiDeploy.Common.Executor.Execute(ILocation location)
at EPiDeploy.Common.Executor.Execute(ILocation location)
at EPiDeploy.Common.Executor.Execute(ILocation location)
at EPiDeploy.Common.Executor.Execute(ILocation location)
at EPiDeploy.Deploy.Execute(Options options, ILocation startPosition)
at EPiDeploy.Deploy.Run(Options options)
at EPiDeploy.Program.Main(String[] args)
ClientConnectionId:5871f211-6d19-4004-ada3-bdffbde88707
Error Number:208,State:6,Class:16

Processing C:\devPremier\packages\EPiServer.Find.Cms.12.7.0\tools\epiupdates\sql\1.0.1.sql
Processing C:\devPremier\packages\EPiServer.Find.Cms.12.7.0\tools\epiupdates\sql\12.2.8.sql
Processing C:\devPremier\packages\EPiServer.Find.Cms.12.7.0\tools\epiupdates\sql\12.4.2.sql
Found no files to process

#198478
Oct 29, 2018 14:42
Quan Mai
Quan Mai
Vote:
 

It looks like your database was missing important changes from 7.0.1.0.sql, which created the triggers (CatalogEntry_Delete and related). Those triggers will delete versions when an entry or a node is deleted.

If you can restore the database to before the upgrade, I'd suggest to run this 

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id (N'[dbo].[CatalogEntry_Delete]') AND OBJECTPROPERTY(id, N'IsTrigger') = 1) DROP TRIGGER [dbo].[CatalogEntry_Delete]
GO 
CREATE TRIGGER [dbo].[CatalogEntry_Delete] ON CatalogEntry FOR DELETE
AS
	--Delete all draft of deleted entry
	DELETE d FROM ecfVersion d
	INNER JOIN deleted ON d.ObjectId = deleted.CatalogEntryId AND d.ObjectTypeId = 0

	--Delete all extra info of this entry
	DELETE c FROM CatalogContentEx c 
	INNER JOIN deleted ON c.ObjectId = deleted.CatalogEntryId AND c.ObjectTypeId = 0
GO

-- create CatalogNode_Delete trigger
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id (N'[dbo].[CatalogNode_Delete]') AND OBJECTPROPERTY(id, N'IsTrigger') = 1) DROP TRIGGER [dbo].[CatalogNode_Delete]
GO 
CREATE TRIGGER [dbo].[CatalogNode_Delete] ON CatalogNode FOR DELETE
AS
	--Delete all draft of deleted entry
	DELETE d FROM ecfVersion d
	INNER JOIN deleted ON d.ObjectId = deleted.CatalogNodeId AND d.ObjectTypeId = 1

	--Delete all extra info of this entry
	DELETE c FROM CatalogContentEx c 
	INNER JOIN deleted ON c.ObjectId = deleted.CatalogNodeId AND c.ObjectTypeId = 1
GO
-- end of creating CatalogNode_Delete trigger

-- create Catalog_Delete trigger
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id (N'[dbo].[Catalog_Delete]') AND OBJECTPROPERTY(id, N'IsTrigger') = 1) DROP TRIGGER [dbo].[Catalog_Delete]
GO 
CREATE TRIGGER [dbo].[Catalog_Delete] ON [Catalog] FOR DELETE
AS
	--Delete all draft of deleted catalog
	DELETE d FROM ecfVersion d
	INNER JOIN deleted ON d.ObjectId = deleted.CatalogId AND d.ObjectTypeId = 2
GO
-- end of creating Catalog_Delete trigger

Then try again 

-EDIT: Missed the first one, fixed now 

#198479
Edited, Oct 29, 2018 14:52
Brian Holt
Brian Holt
Vote:
 

The script created the two triggers, but the update is still failing on dbo.CatalogEntry_Delete

#198480
Oct 29, 2018 15:02
Brian Holt
Brian Holt
Vote:
 

I created an empty trigger for dbo.CatalogEntry_Delete and that seemed to fix the error.

#198482
Oct 29, 2018 15:26
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.