Upgrade to Episerver CMS 11

Jon Haakon Ariansen

Vote:

Hi,

I'm doing an upgrade on Episerver CMS version 10.3.2.

When I run Update-EPiDatabase in "Package Manager Console" all packages from 7.8.0.sql to 11.0.0.sql runs however when

11.2.0.sql is beeing processed epideploy.exe breaks with the error:

EPiDeploy was stopped due to an exception, more details:

System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.netProjectItemDelete'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.Td
sParser.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.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:59b1bd10-70dd-4337-b43f-d70206bae42e
Error Number:208,State:6,Class:16

How come dbo.netProjectItemDelete is missing?

How do I fix this?

In advance thanks for your help!

Kind regards,

Jon Haakon Ariansen

#201072

Feb 04, 2019 17:06

Quan Mai

Vote:

There might be a problem with your database, because netProjectItemDelete should have been created in 7.10.0.sql. You can run this manually to create it

PRINT N'Creating [dbo].[netProjectItemDelete]...';


GO
CREATE PROCEDURE [dbo].[netProjectItemDelete]
	@ProjectItemIDs dbo.IDTable READONLY
AS
BEGIN
	SET NOCOUNT ON

	MERGE tblProjectItem AS Target
	USING @ProjectItemIDs AS Source
    ON (Target.pkID = Source.ID)
    WHEN MATCHED THEN 
		DELETE
	OUTPUT DELETED.pkID, DELETED.fkProjectID, DELETED.ContentLinkID, DELETED.ContentLinkWorkID, DELETED.ContentLinkProvider, DELETED.Language, DELETED.Category;
END
GO

11.2.0.sql will update it anyway so you don't have to worry about correctness

#201081

Feb 05, 2019 10:17

Jon Haakon Ariansen

Vote:

Hi Quan!

Thank you so much for your feedback!

I will try it out and give you feedback when I know how it goes!

I am most greatfull, thanks!

Kind regards,

Jon Haakon

#201082

Feb 05, 2019 10:51