Upgrade from 21.0.0 blocked with errors | Cannot use DROP SYNONYM

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

During the loading of the initial data with DBload as part of an upgrade operation from Version 21.0.0 to Version 21.0.2, the following comes up:

 

DBLoad log file:

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

Version and status of database: '21.0'/'READY'.  
Version and content of data file: '21.0'/'UPGRADE'.  
Version of database objects: '21.0.0+build.54' 
Loading in mode 'UPGRADE'.
20220223/130918.533 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: a11509a0  DB-HDBC: a11510d0
20220223/130918.533 - U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
20220223/130918.533 - U00003592 UCUDB - Status: '42000' Native error: '3705' Msg: 'Cannot use DROP SYNONYM with 'MQSRV' because 'MQSRV' is a table. Use DROP TABLE.'
20220223/130918.533 - U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: 'DROP SYNONYM MQSRV'
20220223/130918.533 - U00003590 UCUDB - DB error: 'SQLExecDirect', 'ERROR   ', '42000', 'Cannot use DROP SYNONYM with 'MQSRV' because 'MQSRV' is a table. Use DROP TABLE.'
20220223/130918.533 - U00038068 ABORTING due to error. 

The loading process was terminated abnormally. The Database might be in an inconsistent condition. Please contact Automic Support.

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

Environment

Release : 21.0.2 Component : Utilities

Cause

This error is due that to misconfiguration in the DBLOAD configuration.

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

 [MQDB]

.......

sqlDriverConnect=ODBCVAR=SNNNNNRN,DSN=AE_Automic;UID=dbo_ae;PWD=???

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

The MQDB section in the configuration contains a connection string for a unexisting separate MSSQL database dedicated to the MQ tables.

MQ Tables stored in such a external database are reference as synonyms in the AE database. DBLoad is unable to find any synonyms, this is the reason of the aborting.

Resolution

Comment or remove the SQLdriverconnect line in the MQDB section of the DBLoad INI file. This will fix the problem.

Additional Information

The MQDB section is only used if the MQ tables are stored in the a separate database.

https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Admin/inifiles/admin_ini_utility_db_load.htm?Highlight=MQDB