My Oracle Support Banner

NMS PURGE_HISTORY_TABLES_JOB Failing (Doc ID 2530797.1)

Last updated on MAY 12, 2021

Applies to:

Oracle Utilities Network Management System - Version 2.3.0.1.0 and later
Oracle Network Management for Utilities - DMS - Version 2.3.0.1.0 and later
Information in this document applies to any platform.

Symptoms


The NMS 'PURGE_HISTORY_TABLES_JOB' is failing while the scada_analog_history table is growing large (for example above 700 million rows).


Error:
10/7/2018 1:00:02.705469 AM -07:00 RUN FAILED ORA-20002: NMS_CES
ORA-06512: at line 34
  ORA-20002: NMS_CES
ORA-06512: at line 34
  
9/30/2018 1:00:02.360148 AM -07:00 RUN FAILED ORA-20002: NMS_CES
ORA-06512: at line 34
  ORA-20002: NMS_CES
ORA-06512: at line 34
  
9/23/2018 1:00:02.023650 AM -07:00 RUN FAILED ORA-20002: NMS_CES
ORA-06512: at line 34
  ORA-20002: NMS_CES
ORA-06512: at line 34
  
9/16/2018 1:00:01.771671 AM -07:00 RUN FAILED ORA-20002: NMS_CES
ORA-06512: at line 34
  ORA-20002: NMS_CES
ORA-06512: at line 34
 

For additional information on the purge history job see: <Document 2482167.1> What Happened to the Script "product_dms_purge_history.ces" in 2.3.0.1?

For other data purging related KM Document references see:

<Document 1385163.1> Improving Model Build Performance with mb_purge.ces and Managing Index Statistics

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Fix Description
 Migration
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.