U00003592 UCUDB - Status: '42000' Native error: '156' Msg: 'Incorrect syntax near the keyword 'if'.'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

An issue was found durig the upgrade from 12.2 to V21.0:

 

20220513/142414.614 - U00038082 INSERT INTO UC_SVALU SELECT DISTINCT SVALF_FullVName, 1 FROM UC_SVALF WHERE NOT EXISTS (SELECT 1 FROM UC_SVALU WHERE SVALU_SVALF_FVName=SVALF_FullVName) AND NOT SVALF_FullVName IS NULL
20220513/142414.684 - U00038082 delete from ofs where ofs_link = 1 and ofs_oh_idnr_o < 100000 and ofs_oh_idnr_o not in (select ofs_oh_idnr_o from ofs where ofs_link = 0)
20220513/142414.724 - U00038294 Password hashing initiated.
20220513/142414.774 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 124a3f0  DB-HDBC: 17d88cf0
20220513/142414.774 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
20220513/142414.774 - U00003592 UCUDB - Status: '42000' Native error: '156' Msg: 'Incorrect syntax near the keyword 'if'.'
20220513/142414.774 - U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: 'alter table MQ1AUT drop constraint if exists PK_MQ1AUT'
20220513/142414.774 - U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR   ', '42000', 'Incorrect syntax near the keyword 'if'.'
20220513/142414.779 - U00038150 A database error occurred:  '', '', '', ''.
20220513/142414.779 - U00038068 ABORTING due to error. 

 

Environment

Release : 21.0.2

Component : AUTOMATION ENGINE

Cause

Software Bug

Resolution

The issue has been fixed by the engineering department and made available via V21.0.3.

This fix does require an update of AE Server, Initialdata and AWI components.