Grid Control 10g and 11g - OMS Upload into Repository Fails with ORA-14400 and Many xml Files are Moved to /recv/errors Directory

(Doc ID 303359.1)

Last updated on AUGUST 19, 2015

Applies to:

Enterprise Manager Base Platform - Version 10.1.0.4 to 11.1.0.1.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 23-may-2012***
Checked for relevance on 28-Oct-2013

Symptoms

The <OMS_HOME>/sysman/recv/errors directory is getting filled with many rejected xml files. The <OMS_HOME>/sysman/log/emoms.trc is filled with the following errors:

<timestamp>,<#> [XMLLoader0 <hexnumber>.xml] ERROR eml.XMLLoader markFileAsError.826 - Failed to load <hexnumber>.xml even after 2 attempts; moving to errors directory.
Error:java.sql.SQLException: ORA-14400: inserted partition key does not map to any partition


Checking the <AGENT_HOME>/sysman/log/emagent.trc file on one of the Agent machine shows:

<timestamp> Thread-136 ERROR upload: Failed to upload file A0000001.xml, ret = -2
<timestamp> Thread-136 WARN upload: FxferSend: received http error in header from repository: http://omsmachine.domain:4889/em/upload/
ERROR-400|ORA-14400: inserted partition key does not map to any partition

ORA-06512: at "SYSMAN.TARGETS_AVAILABILITY_DEFAULT", line 85

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms