ucybdbld to 21.0.4 or higher ORA-01031: Insufficient permissions to create trigger

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic One Automation

Issue/Introduction

During the upgrade to 21.0.4 or superior, while launching the DB Load tool (ucybdbld) to upgrade the database with UC_UPD.TXT, the procedure fails with an error similar to the following  one for Oracle Database: 

ORA-01031: insufficient privileges

This error is returned when the following is attempted:

CREATE OR REPLACE trigger TR_AH_TIMESTAMP2_4
  AFTER INSERT OR UPDATE OF AH_TimeStamp2, AH_TimeStamp4 ON AH
  FOR EACH ROW
  ...

Environment

Release : 21.0.4 and superior

Component : AUTOMATION ENGINE

Cause

Change in the DB structure added in 21.0.4 and superior versions required for the Automic Automation integration with Automic Automation Intelligence (AAI)

Resolution

Workaround:

Please grant the privilege to create or replace triggers to the user defined in ucsrv.ini to connect to the database BEFORE attempting the dbload procedure to upgrade/install the Automation Engine 21.0.4 or superior.

Solution:

Update to a fix version listed below or a newer version if available.

Fix version:
Component(s): Automation Engine

Automation.Engine 21.0.4 HF1 - Available
Automation.Engine 21.0.5  - Available

Additional Information

As part of the solution, the documentation will also be updated with this newly required permission and the script that checks the required privileges will also check this permission from 21.0.4 HF1 and superior.