OEM 13.5 Error | Refresh from My Oracle Support Job is failing

 OEM Offline Patching - Refresh From Oracle Support Error

Title:

Refresh from My Oracle Support Job is failing

Description:

For security recommendations, the oracle em catalog can be uploaded to OEM in offline mode. And while doing so, the Refresh from my oracle support executes to validate the current and required patch sets for all the monitoring agents and systems. The below error occurs due to a Bug which is fixed in OEM 13.5 RU 110 version.

OEM Offline Patching Navigation

Log file will show error as below:

The OMS is in offline mode. Using the catalog file saved in the Software Library.

Ensure that the catalog file saved in the Software Library is up to date to avoid stale updates.

Catalog Location is :<Software Library location>

[Free Memory: 274] [Total Memory: 1,706] [Max Memory: 1,706]

Catalog Data Details

---------------------------

aru_products.xml : Parsing...Done : Loading...Done

 - Error 065c9318-ad29-41c3-8602-0abdcc12baf4: An integrity constraint, that is, a foreign key, a primary key, or a unique key has been violated.

Cause: the release id '600000000226924' is not found in the parent release table

 - An error has occurred. The session is being rolled back.

Total Time Taken: 1 minute(s) and 35 seconds

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

Solution:

Please do not directly perform this is Production environment. If the issue is only happening in Prod system, it is recommended to consult Oracle Support for more environment specific solution. This was part of a bug and I got this solution from oracle Support. 

Refresh from MOS and retry

---------------------------------------------

Login as SYSMAN user in the repository database and run:

SQL> DELETE FROM mgmt_aru_patch_recom_md;

SQL> begin

mos_pa_patch_recom.delete_checksums;

commit;

end;

/

Rerun the "Refresh from My Oracle Support" job.

Reference: 

Below Bugs were fixed in 13.5 RU 110 version & higher.

BUG 34221296 : REFRESH_FROM_MY_ORACLE_SUPPORT_JOB > 'Download Patch Recommendations Metadata' s

BUG 34370999 : EM 13c: Refresh from MOS Job Fails with ORA-02291: integrity constraint Error

Hope this helps. Best Wishes!!