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

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


Article ID: 234567


Updated On:


CA Automic Workload Automation - Automation Engine



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.



Release : 21.0.0 Component : UTILITIES


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.


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.