LRM: Metadata Resave Is Not Working (Doc ID 2802759.1)

Last updated on MAY 22, 2023

Applies to:

Symptoms

While re-saving the metadata it is failed as once we click on the save button nothing will be displaying and screen hangs, and we can see the following is exception in the UMM Service log

[UMMLOG] Apr 22,21 13:02:00 : [METADATASERVICEPROVIDER]*****LOCALE*****en_US
[UMMLOG] Apr 22,21 13:02:00 : [METADATASERVICEPROVIDER]Request for Maintain
[UMMLOG] Apr 22,21 13:02:00 : [METADATAMAINTAINER]Service type::3
[UMMLOG] Apr 22,21 13:02:00 : [METADATAMAINTAINER]Locale:en_US
[UMMLOG] Apr 22,21 13:02:00 : [METADATAMAINTAINER]Inside validation of locale
[UMMLOG] Apr 22,21 13:02:00 : [METADATAMAINTAINER]locale : en_US service_type:3
[UMMLOG] Apr 22,21 13:02:00 : [METADATACACHEMANAGER]Get Metadata : Infodom = OFSEPM, Code = HLRM0482, Version = 0, Type = 3, Locale = en_US
[UMMLOG] Apr 22,21 13:02:00 : [METADATAMANAGER]Get Metadata Code And Desc For Infodom : Infodom = OFSEPM, UserName : KPMG_TEST Version = -1, Type = 3
[UMMLOG] Apr 22,21 13:02:00 : [METADATAMANAGER]Query did not return any record
[UMMLOG] Apr 22,21 13:02:00 : [METADATAMANAGER]Update operation :Is Metadata Description Duplicate : Infodom = OFSEPM, Desc = LRM - LRM Product, strCode = HLRM0482
[UMMLOG] Apr 22,21 13:02:00 : [HIERARCHYMAINTAINER]getting mapped dimension list for the hierarchy HLRM0482
[UMMLOG] Apr 22,21 13:02:00 : [HIERARCHYMAINTAINER]Saving Un-Authorized PRS file of Hierarchy
[UMMLOG] Apr 22,21 13:02:00 : [FILESAVER]Success in saving file /app/ofsa8/ftpshare//OFSEPM/erwin/fipxml/Hierarchy/UnAuth/HLRM0482.prs
[UMMLOG] Apr 22,21 13:02:00 : [NEWBIHIERMANAGER]Parse query in info environment, sQLstmnt = select CASE WHEN DIM_Product.f_latest_record_indicator ='Y' THEN DIM_PRODUCT.v_prod_code END , CASE WHEN DIM_Product.f_latest_record_indicator ='Y' THEN DIM_Product.v_prod_desc END from DIM_PRODUCT DIM_PRODUCT where 1=2 ,userId = KPMG_TEST

Changes

Cause

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