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
...
Release : 21.0.4 and superior
Component : AUTOMATION ENGINE
Change in the DB structure added in 21.0.4 and superior versions required for the Automic Automation integration with Automic Automation Intelligence (AAI)
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.
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
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.