Failed upgrade to 7.9.1

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

epideploy.exe : At C:\code\BankOfEnglandPRA\packages\EPiServer.CMS.7.9.1\tools\Install.ps1:48 char:2 + &$EpidpeployEXEPath -a sql -s $sitePath -p $cmsCoreDbPath -v false -c "EPiSer ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:String) [], RemoteException + FullyQualifiedErrorId : NativeCommandError EPiDeploy was stopped due to an exception, more details: System.Data.SqlClient.SqlException (0x80131904): The type 'dbo.ChangeNotificationStringTable' already exists, or you do not have permission to create it. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Ac tion`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.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 asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at EPiDeploy.Sql.ScriptRunner.<>c__DisplayClass5.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.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.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:64047910-1db8-49f3-9cf8-806061f572a6

(1 row(s) affected) The following operation was generated from a refactoring log file 017676df-a76b-4e52-b4b1-3a0ea4fc3400 Rename [dbo].[tblContentLanguage].[PublishedVersion] to Version Msg 15248, Level 11, State 1, Procedure sp_rename, Line 215 Either the parameter @objname is ambiguous or the claimed @objtype (COLUMN) is wrong. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'beg'. Dropping DF__tblContent__Pending__31D75E8D... Msg 3728, Level 16, State 1, Line 1 'DF__tblContent__Pending__31D75E8D' is not a constraint. Msg 3727, Level 16, State 0, Line 1 Could not drop constraint. See previous errors. Dropping DF__tblContentLanguage__PendingPublish... Msg 3728, Level 16, State 1, Line 1 'DF__tblContentLanguage__PendingPublish' is not a constraint. Msg 3727, Level 16, State 0, Line 1 Could not drop constraint. See previous errors. Dropping DF__tblWorkPa__HasBe__4F67C174... Msg 3728, Level 16, State 1, Line 1 'DF__tblWorkPa__HasBe__4F67C174' is not a constraint. Msg 3727, Level 16, State 0, Line 1 Could not drop constraint. See previous errors. Dropping DF__tblWorkPa__Ready__4D7F7902... Msg 3728, Level 16, State 1, Line 1 'DF__tblWorkPa__Ready__4D7F7902' is not a constraint. Msg 3727, Level 16, State 0, Line 1 Could not drop constraint. See previous errors. Dropping DF__tblWorkPa__Rejec__505BE5AD... Msg 3728, Level 16, State 1, Line 1 'DF__tblWorkPa__Rejec__505BE5AD' is not a constraint. Msg 3727, Level 16, State 0, Line 1 Could not drop constraint. See previous errors. Dropping DF__tblWorkPa_Delayed... Msg 3728, Level 16, State 1, Line 1 'DF__tblWorkPa_Delayed' is not a constraint. Msg 3727, Level 16, State 0, Line 1 Could not drop constraint. See previous errors. Dropping [dbo].[editCheckInContentVersion]... Msg 3701, Level 11, State 5, Line 1 Cannot drop the procedure 'dbo.editCheckInContentVersion', because it does not exist or you do not have permission. Dropping [dbo].[editCheckOutContentVersion]... Msg 3701, Level 11, State 5, Line 1 Cannot drop the procedure 'dbo.editCheckOutContentVersion', because it does not exist or you do not have permission. Dropping [dbo].[editRejectCheckedInContentVersion]... Msg 3701, Level 11, State 5, Line 1 Cannot drop the procedure 'dbo.editRejectCheckedInContentVersion', because it does not exist or you do not have permission. Dropping [dbo].[netMasterLicenseGet]... Msg 3701, Level 11, State 5, Line 1 Cannot drop the procedure 'dbo.netMasterLicenseGet', because it does not exist or you do not have permission. Dropping [dbo].[netMasterLicenseSet]... Msg 3701, Level 11, State 5, Line 1 Cannot drop the procedure 'dbo.netMasterLicenseSet', because it does not exist or you do not have permission. Dropping [dbo].[netPageDataLoadVersion]... Msg 3701, Level 11, State 5, Line 1 Cannot drop the procedure 'dbo.netPageDataLoadVersion', because it does not exist or you do not have permission. Dropping [dbo].[netPageListPaged]... Msg 3701, Level 11, State 5, Line 1 Cannot drop the procedure 'dbo.netPageListPaged', because it does not exist or you do not have permission. Dropping [dbo].[netPageDataLoad]... Msg 3701, Level 11, State 5, Line 1 Cannot drop the procedure 'dbo.netPageDataLoad', because it does not exist or you do not have permission. Altering [dbo].[tblWorkContent]... Msg 2705, Level 16, State 4, Line 1 Column names in each table must be unique. Column name 'Status' in table 'dbo.tblWorkContent' is specified more than once. Msg 207, Level 16, State 1, Line 4 Invalid column name 'HasBeenPublished'. Msg 207, Level 16, State 1, Line 5 Invalid column name 'Rejected'. Msg 207, Level 16, State 1, Line 6 Invalid column name 'ReadyToPublish'. Msg 207, Level 16, State 1, Line 6 Invalid column name 'DelayedPublish'. Msg 207, Level 16, State 1, Line 7 Invalid column name 'ReadyToPublish'. Altering [dbo].[tblContent]... Msg 4924, Level 16, State 1, Line 1 ALTER TABLE DROP COLUMN failed because column 'PendingPublish' does not exist in table 'tblContent'. Altering [dbo].[tblContentLanguage]... Msg 2705, Level 16, State 4, Line 2 Column names in each table must be unique. Column name 'Status' in table 'dbo.tblContentLanguage' is specified more than once. (6 row(s) affected) (0 row(s) affected) Msg 4924, Level 16, State 1, Line 1 ALTER TABLE DROP COLUMN failed because column 'PendingPublish' does not exist in table 'tblContentLanguage'. Creating [dbo].[tblContentLanguage].[IDX_tblContentLanguage_Version]... Msg 1913, Level 16, State 1, Line 1 The operation failed because an index or statistics with name 'IDX_tblContentLanguage_Version' already exists on table 'dbo.tblContentLanguage'. Altering [dbo].[tblWorkContent]... Creating [dbo].[tblWorkContent].[IDX_tblWorkContent_StatusFields]... Msg 1913, Level 16, State 1, Line 1 The operation failed because an index or statistics with name 'IDX_tblWorkContent_StatusFields' already exists on table 'dbo.tblWorkContent'. Creating FK_tblContentLanguage_tblWorkContent... Msg 2714, Level 16, State 4, Line 1 There is already an object named 'FK_tblContentLanguage_tblWorkContent' in the database. Msg 1750, Level 16, State 0, Line 1 Could not create constraint. See previous errors. Altering [dbo].[tblPageLanguage]... Altering [dbo].[tblPage]... Altering [dbo].[tblWorkPage]... Altering [dbo].[netCategoryContentLoad]... Altering [dbo].[editDeletePageInternal]... Altering [dbo].[editDeleteProperty]... Altering [dbo].[editSavePropertyCategory]... Altering [dbo].[netPageChangeMasterLanguage]... Altering [dbo].[netPageDeleteLanguage]... Altering [dbo].[netPropertySave]... Altering [dbo].[netReportSimpleAddresses]... Altering [dbo].[editSaveContentVersionData]... Altering [dbo].[netContentCreate]... Altering [dbo].[netContentCreateLanguage]... Altering [dbo].[netFindContentCoreDataByContentGuid]... Altering [dbo].[netFindContentCoreDataByID]... Altering [dbo].[netPersonalNotReadyList]... Altering [dbo].[netPersonalRejectedList]... Altering [dbo].[netReadyToPublishList]... Altering [dbo].[editSetCommonDraftVersion]... Altering [dbo].[netDelayPublishList]... Altering [dbo].[netUnifiedPathDeleteAll]... Altering [dbo].[sp_DatabaseVersion]... Creating [dbo].[editSetVersionStatus]... Msg 2714, Level 16, State 3, Procedure editSetVersionStatus, Line 47 There is already an object named 'editSetVersionStatus' in the database. Creating [dbo].[netContentDataLoad]... Msg 2714, Level 16, State 3, Procedure netContentDataLoad, Line 136 There is already an object named 'netContentDataLoad' in the database. Creating [dbo].[netContentListPaged]... Msg 2714, Level 16, State 3, Procedure netContentListPaged, Line 164 There is already an object named 'netContentListPaged' in the database. Creating [dbo].[netContentListVersionsPaged]... Msg 2714, Level 16, State 3, Procedure netContentListVersionsPaged, Line 177 There is already an object named 'netContentListVersionsPaged' in the database. Creating [dbo].[netContentLoadVersion]... Msg 2714, Level 16, State 3, Procedure netContentLoadVersion, Line 204 There is already an object named 'netContentLoadVersion' in the database. Altering [dbo].[editCreateContentVersion]... Altering [dbo].[netContentEnsureVersions]... Altering [dbo].[editDeletePageVersion]... Altering [dbo].[editContentVersionList]... Altering [dbo].[netContentTrimVersions]... Altering [dbo].[editPublishContentVersion]... Refreshing [dbo].[editDeletePageCheckInternal]... Refreshing [dbo].[netConvertPropertyForPageType]... Refreshing [dbo].[netFrameDelete]... Refreshing [dbo].[netPageListByLanguage]... Refreshing [dbo].[netPagesChangedAfter]... Refreshing [dbo].[netPageTypeGetUsage]... Refreshing [dbo].[netPropertySearch]... Refreshing [dbo].[netPropertySearchCategory]... Refreshing [dbo].[netPropertySearchNull]... Refreshing [dbo].[netPropertySearchString]... Refreshing [dbo].[netPropertySearchValue]... Refreshing [dbo].[netQuickSearchByExternalUrl]... Refreshing [dbo].[netQuickSearchByPath]... Refreshing [dbo].[netURLSegmentListPages]... Refreshing [dbo].[netURLSegmentSet]... Refreshing [dbo].[editDeleteChildsCheck]... Refreshing [dbo].[editDeletePageCheck]... Refreshing [dbo].[editDeleteChilds]... Refreshing [dbo].[editDeletePage]... Refreshing [dbo].[netContentChildrenReferences]... Refreshing [dbo].[netContentListOwnedAssetFolders]... Refreshing [dbo].[netContentMatchSegment]... Refreshing [dbo].[netContentMove]... Refreshing [dbo].[netContentRootList]... Refreshing [dbo].[netContentTypeDelete]... Refreshing [dbo].[netPropertyDefinitionGetUsage]... Refreshing [dbo].[netPropertySearchCategoryMeta]... Refreshing [dbo].[netSoftLinkList]... Refreshing [dbo].[admDatabaseStatistics]... Refreshing [dbo].[netConvertPageType]... Refreshing [dbo].[netCreatePath]... Refreshing [dbo].[netDynamicPropertiesLoad]... Refreshing [dbo].[netPageCountDescendants]... Refreshing [dbo].[netPageDefinitionDynamicCheck]... Refreshing [dbo].[netPageDefinitionSave]... Refreshing [dbo].[netPageListAll]... Refreshing [dbo].[netPageListExternalFolderID]... Refreshing [dbo].[netPageMaxFolderId]... Refreshing [dbo].[netPagePath]... Refreshing [dbo].[netPageTypeCheckUsage]... Refreshing [dbo].[netPersonalActivityList]... Refreshing [dbo].[netQuickSearchByFolderID]... Refreshing [dbo].[netQuickSearchListFolderID]... Refreshing [dbo].[netReportReadyToPublish]... Refreshing [dbo].[netSubscriptionListRoots]... Refreshing [dbo].[netBlockTypeGetUsage]... Refreshing [dbo].[netContentListBlobUri]... Refreshing [dbo].[netPropertyDefinitionCheckUsage]... Refreshing [dbo].[netBlockTypeCheckUsage]... Refreshing [dbo].[editDeletePageVersionInternal]...