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

Article Id: 144529

Status: Published

Updated On: 06-02-2020 00:12

Products:

CA Automic Workload Automation - Automation Engine , CA Automic One Automation , CA Automic Operations Manager , CA Automic Oracle

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