unable to drop ILM Partition after upgrading to Automic V12.3.1
Article ID: 144529
Updated On:
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
GRANT select on dba_objects to <schema owner>;
This will resolve the issue
Feedback
Yes
No
Powered by
