Jump to content
Welcome to our new Citrix community!
  • 0

SQL Error Updating Monitoring Database 7.18 to 1906


Kyle Mansell1709155123

Question

Hi All,

 

We have tried to update our Delivery Controller from 7.18 to 1906 and are having issues when running the Database upgrade

 

We get to a point where the SQL script tries to update a stored procedure called [MonitorData].[UpdateSmartAlertTarget] whcih doesnt exist in the database.

 

Do i have to do an intermediary update before 1906? and can anyone send me the database upgrade scripts that create this SP?

 

Cheers

 

Kyle

Link to comment

1 answer to this question

Recommended Posts

  • 0

So, managed to get to the bottom of this,

 

For anyone else that has the same problem it comes down to a missing Stored Procedure on the Monitoring Database,

 

In this case connect to the sql server, create a new query and target your monitoring Database, then create a blank stored procedure using the below:

 

-- ================================================
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
CREATE PROCEDURE MonitorData.UpdateSmartAlertTarget 

AS
BEGIN
    SET NOCOUNT ON;

END
GO

 

Once you have doen this you will be able to run the Database upgrade scripts
 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...