DBload upgrade to 21.0.4 or superior fails due to missing create trigger grant
search cancel

DBload upgrade to 21.0.4 or superior fails due to missing create trigger grant

book

Article ID: 250492

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

When trying to upgrade the AE Database Oracle to version 21.0.4 or superior with DBload, the scripts fails due to missing trigger privileges. 

U00038042 CREATE OR REPLACE trigger TR_AH_TIMESTAMP2_4
...
U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-01031: insufficient privileges'

Environment

Release : 21.0.4 and superior

Component : AUTOMATION ENGINE

Database: Oracle

Cause

Newly required permission on 21.0.4 or superior for Oracle Databases

Resolution

Add the necessary "grant create trigger" to the Automic DB user before attempting to upgrade to 21.0.4 or superior.

This is now documented here and here

The script check_privileges.sql has also been upgraded to check this permission on 21.0.4 and superior so the command dbload checks this permission before attempting the procedure.