EM: REFRESH_FROM_MY_ORACLE_SUPPORT_JOB Fails for Integrity Constraint from Data in aru_product_releases.xml on 27-JAN-2014 (Doc ID 1621166.1)

Last updated on MARCH 14, 2014

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Job Refresh from MOS fails:

I'm trying to get Oracle Enterprise Manager Cloud Control 12c Release 3 (12.1.0.3.0) to run the REFRESH_FROM_MY_ORACLE_SUPPORT_JOB (RFMOS job).
Output shows the following error (also tried it in offline mode, with the same result):


The OMS is in online mode. Downloading the latest catalog data from My Oracle Support.
Checking My Oracle Support authorization.
Patch Search URL: https://updates.oracle.com
User Name: dba@cbr.nl
Password: ******

Proxy Server details:
----------------------
Host : proxy.cbr.nl
Port : 8,080



Catalog Data Details
---------------------------

aru_products.xml : Parsing...Done : Loading...Done
Parse Time (ms) : 4053
Load Time (ms) : 5455

aru_releases.xml : Parsing...Done : Loading...Done
Parse Time (ms) : 2244
Load Time (ms) : 3269

aru_platforms.xml : Parsing...Done : Loading...Done
Parse Time (ms) : 465
Load Time (ms) : 34

aru_languages.xml : Parsing...Done : Loading...Done
Parse Time (ms) : 455
Load Time (ms) : 22

aru_product_groups.xml : Parsing...Done : Loading...Done
Parse Time (ms) : 1601
Load Time (ms) : 1489

aru_product_releases.xml : Parsing...Done : Loading...
 
 - Error eedcc93e-b003-4a58-a2e4-a674ed05eb08: An integrity constraint, that is, a foreign key, a primary key, or a unique key has been violated.
Cause: the release id '600000000010102' is not found in the parent release table
 - An error has occurred. The session is being rolled back.

---------------------------------------------------
[MOS_RFMPlugIn] START
---------------------------------------------------

...... (because of characterlimits removed, will upload the entire output)

---------------------------------------------------
[MOS_RFMPlugIn] END
---------------------------------------------------

This job failed. For more information, check the logs.


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