November Happy Hour will be moved to Thursday December 5th.
AI OnAI Off
Upgrade to Episerver CMS 11
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
GO11.2.0.sql will update it anyway so you don't have to worry about correctness
Feb 05, 2019 10:17
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
Feb 05, 2019 10:51
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.
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