Failed upgrade to 7.9.1

Vote:
 

Hi - I'm trying to upgrade from 7.7.0 to 7.9.1. Ther package manager is throwing the below error. When I access the site then the cms login page can't be found any more. Does anyone know what is goign wrong.


Thanks

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
#88581
Jul 17, 2014 16:39
Vote:
 

Hi,

It seems the user in your ConnectionStrings.config either does not have permissions enough (or it could be your Windows User account that does not have the right permissions on the SQL box, if using integrated authentication).

You can extract the SQL Updates from a package by calling Export-EPiUpdates:

PM> Export-EPiUpdates 
An Export package is created C:\EPiServer\AlloyDemo\wwwroot\EPiUpdatePackage 
Exporting epiupdates into EPiUpdatePackage\EPiServer.CMS.Core.7.8.2\epiupdates


Or simply open the NuPkg file in Nuget Package Explorer or renaming it to .zip and extracting it with your favorite ZIP tool. In it, you will find the SQL scripts for the SQL schema updates.

Also, could you check the database to see whether dbo.ChangeNotificationStringTable exists in the list of tables?

#88584
Jul 17, 2014 17:08
Vote:
 

Thanks for the response - the table is tblChangeNotificationQueuedString to tblChangeNotificationQueuedString

I extracted the file and ran it and I get a whole load of errors - copied below. I've rolled back the script.

Should I raise this a a bug about this?

(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]...
#88597
Jul 18, 2014 10:58