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'
Component: CA Automic Workload Automation
Release : 21.x
Environmental issue
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.