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)
...
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 |