20.4 CU2 stored procedure failing to run
search cancel

20.4 CU2 stored procedure failing to run

book

Article ID: 242301

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Running the sql query to create the stored procedure for cumulative update 2  gives this error.
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'OR'.
Msg 111, Level 15, State 1, Line 10
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

Environment

Release : 20.4 CU2

Component : UNIFIED INFRASTRUCTURE MGMT

Cause

Failed line in the sql code had the syntax
"CREATE OR ALTER PROCEDURE"
the correct syntax in the sql query should be
"CREATE PROCEDURE"

Resolution

Did a new download and rerun of the stored procedure for the cumulative update.