CP and WP do not start with error message: 'relation "uc_versi" does not exist'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The WP or CP do not start with the following error message in the log.

---------------------------------------------------------------------------------------------------------------------------------------

20220425/152526.997 - U00003590 UCUDB - DB error: 'ERROR:  relation "uc_versi" does not exist LINE 1: SELECT * FROM UC_VERSI WHERE 1=0                       ^', '', '', ''

20220425/152526.997 - U00003592 UCUDB - Status: '42P01' Native error: '6844177' Msg: 'relation "uc_versi" does not exist'

20220425/152526.997 - U00003517 UCUDB: Invalid DB-STMT IND: '0' at OPC: 'CLST'
---------------------------------------------------------------------------------------------------------------------------------------

Cause

The error message means that the AE tables have not been created.

Environment

Release : 12.3.x

Component : AUTOMATION ENGINE

Resolution

Please make sure that the AE tables are created by using the Utility DB Load with the same version as the Automation Engine.