DB Load error: 'U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR ', '42S02', 'Invalid object name 'MQ1CP001_'.'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

 

The upgrade with DBLoad from 12.3 to 21.0.0 aborts when the AE system database uses an alternative MSSQL schema.

=============================================================================

20220210/134457.126 - U00038042 Action required! Check index NK_AH_IDNR_bearb if it matches the definition in uc_ddl.sql
20220210/134457.282 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 148a84e0  DB-HDBC: 148b29a0
20220210/134457.282 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
20220210/134457.282 - U00003592 UCUDB - Status: '42S02' Native error: '208' Msg: 'Invalid object name 'MQ1CP001_'.'
20220210/134457.282 - U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: 'select * from MQ1CP001_ with (tablockx, holdlock)'
20220210/134457.282 - U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR   ', '42S02', 'Invalid object name 'MQ1CP001_'.'
20220210/134457.282 - U00038150 A database error occurred:  '', '', '', ''.
20220210/134457.282 - U00038068 ABORTING due to error. 

=============================================================================

The main AE database contains tables with name MQ1CP001_UCORIG.

 

Environment

Release : 21.0.0 Component : UTILITIES

Cause

This is a bug in the 21.0 DBLoad Utility

The main database contains tables called MQ1CP*_UCORIG which are detected by the utility during the upgrade.

Resolution

This has been fixed with the release of 12.3.9 and 21.0.3

Two workaround exist to perform the database upgrade successfully:

--  Removing all tables MQ*CP*_UCORIG from the main AE database again and run the load again.

--  Edit the DBLoad upgrade script UC_UPD.txt from the version 21, remove the lines "MIGRATE_TO_SEQUENCE" and run the Reload again.