OBIEE MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid.

I did a simple install of OBIEE on my windows 7 64 bit machine. After installing, i was able to login to the Console and Enterprise manager. But I was unable to login to the analytics URL using the same weblogic credentials. I was getting the below error

I checked the BI services, all the BI services were running properly, then I logged into the Enterprise manager and found the below log file

Message    MDSConfigurationException encountered in parseADFConfigurationMDS-01330: unable to load MDS configuration document   
Supplemental Detail    MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid.   
ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DEV_MDS.MDS_INTERNAL_SHREDDED"
ORA-06512: at line 1

 oracle.mds.config.MDSConfigurationException: MDS-01330: unable to load MDS configuration document   
MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "OWSM_TargetRepos" is invalid.   
ORA-04063: package body "DEV_MDS.MDS_INTERNAL_SHREDDED" has errors
ORA-06508: PL/SQL: could not find program unit being called: "DEV_MDS.MDS_INTERNAL_SHREDDED"
ORA-06512: at line 1

Solution:
Later found that I did run the below commands before running the RCU

set RCU_JDBC_TRIM_BLOCKS=TRUE

echo %RCU_JDBC_TRIM_BLOCKS%

Please stop all the services including admin server, BI services and manager server.

Drop the RCU and do a fresh install of the RCU with the same password you used before for DEV_BIPLATFORM schema.

Restart the services again. You should now be able to login to the analytics

0 comments:

Search This Blog

Powered by Blogger.