unable to drop ILM Partition after upgrading to Automic V12.3.1

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

User is unable to drop ILM partitions.

We may receive this error when attempting to drop a partition:

 

20200123/121846.733 - U00005353 ILM: Processing after system stop was called with option 'DY17' .

20200123/121846.733 - U00005310 The standard user will be used for ILM processing because no login object has been specified.

20200123/121846.866 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 116403910  DB-HDBC: 11644d630

20200123/121846.866 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'

20200123/121846.866 - U00003592 UCUDB - Status: '' Native error: '942' Msg: 'ORA-00942: table or view does not exist'

 

Cause

Access issue

Environment

Release : 12.3.1

Component : AUTOMATION ENGINE

Resolution

Please run the below Grant statement on your database.

GRANT select on dba_objects to <schema owner>;

This will resolve the issue