Creating the AE tables using DBLoad fails: "uc_table" does not exist'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Executing the DBLoad script to create the AE tables is failing with the following error message in the DB Load log:

U00003592 UCUDB - Status: '42P01' Native error: '6844177' Msg: 'relation "uc_table" does not exist'
U00003594 UCUDB Ret: '3590' opcode: 'SLUC' SQL Stmnt: 'select Table_Children from uc_table where Table_Name = 'EH''
U00003590 UCUDB - DB error: 'select Table_Children from uc_table where Table_Name = 'EH'', 'ERROR   ', '42P01', 'relation "uc_table" does not exist'

Environment

Component: CA Automic Workload Automation

Release : 21.x

Cause

Environmental issue

Resolution

Based on the error message, the tablespace ae_data does not exist or it is possible that the user defined in the  ucybdbld.ini file does not have proper rights on the target database.

===============================================================================
20230320/145642.865 - U00003590 UCUDB - DB error: 'ERROR:  tablespace "ae_data" does not exist', '', '', ''
20230320/145642.865 - U00003592 UCUDB - Status: '42704' Native error: '6820852' Msg: 'tablespace "ae_data" does not exist'
20230320/145642.865 - U00003594 UCUDB Ret: '6' opcode: 'EXEC' SQL Stmnt: 
===============================================================================

Please do the following:

-Make sure the  user defined in the ucybdbld.ini file has proper rights on the target DB

-Make sure that the tablespaces ae_data and ae_index have been created as explained in the documentation below.

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0.5/Automic%20Automation%20Guides/Content/Installation_Common/PreparationSteps/PrepareAEDB_PostgreSQL.htm