My Oracle Support Banner

ORA-28231 and ERROR-1200 Errors In Loading Alerts In emoms_pbs.trc (Doc ID 2638864.1)

Last updated on MAY 27, 2024

Applies to:

Enterprise Manager Base Platform - Version 13.3.0.0.0 to 13.3.0.0.0 [Release 13c]
IBM AIX on POWER Systems (64-bit)

Symptoms

EM 13.3 on AIX

emoms_pbs.trc files and emoms_pbs.log are getting flooded with ORA-28231 and ERROR-1200, as in example provided below:

 

...

2019-10-22 04:18:58,783 [GCLoader[severity] -
https://<agent host name>:3872/emd/main/] ERROR gcloader.DataLoaderlogp.251 - Exception: java.sql.SQLException: ORA-28231: no data passed to obfuscation toolkit
ORA-06512: at line 13
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI", line 109
ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT", line 291
ORA-06512: at "SYSMAN.MGMT_GLOBAL", line 237
ORA-06512: at "SYSMAN.MGMT_METRIC", line 2070
ORA-06512: at line 6

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

...

2019-10-22 04:18:58,833 [GCLoader[severity] - https://<agent host name>:3872/emd/main/] ERROR gcloader.Receiverlogp.251 - Upload failed: emdURL=<agent host name>:3872/emd/main/
trackingKey=21301.1571732338585 type=severity e=ERROR-1200|Error in loading alerts
ERROR-1200|Error in loading alerts
at
oracle.sysman.core.pbs.gcloader.DataLoader.loadAlertsImpl(DataLoader.java:1235
)
at
oracle.sysman.core.pbs.gcloader.XMLDocumentDataParser.endElement(XMLDocumentDataParser.java:431)
at
oracle.xml.parser.v2.NonValidatingParser.parseElement(NonValidatingParser.java:1643)
at
oracle.xml.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:458)
at
oracle.xml.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:404)
at oracle.xml.parser.v2.XMLParser.parse(XMLParser.java:245)

...

 

At the same time, on the agent side, we see the following exception in gcagent.log

 

...

2019-10-22 04:18:58,844 [78:BF500E2C] WARN - Internal Exception occurred from loader on file /u01/app/oracle/agent/agent_inst/sysman/emd/upload/upload/sending/uplB_P2_S1_I21301.xml
2019-10-22 04:18:58,845 [78:BF500E2C] WARN - Upload file /u01/app/oracle/agent/agent_inst/sysman/emd/upload/upload/sending/uplB_P2_S1_I
21301.xml with tracking key 21301.1571732338585 being moved to invalid file location storage due to upload error: Error in loading alerts (code=1200)
oracle.sysman.gcagent.upload.UploadStream$dequeuer$ResponseINTERNALException: Error in loading alerts (code=1200)
at
oracle.sysman.gcagent.upload.UploadStream$dequeuer.processNotificationValue(UploadStream.java:2656)
at
oracle.sysman.gcagent.upload.UploadStream$dequeuer.xferFile(UploadStream.java:1775)
at
oracle.sysman.gcagent.upload.UploadStream$dequeuer._run(UploadStream.java:2815)
at
oracle.sysman.gcagent.upload.UploadStream$dequeuer.run(UploadStream.java:2688)

at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1164)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:634)
at
oracle.sysman.gcagent.util.system.GCAThread$RunnableWrapper.run(GCAThread.java:198)
at java.lang.Thread.run(Thread.java:798)

...

 

 

Changes

 N/A

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
References


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