Monday, June 3, 2013

Catalog object schema validation failed

Catalog object schema validation failed


After Applying patch for OBI 11.1.1.6.0 to 11.1.1.6.7, Many reports in my dashboard didn't show up. I couldn't even view them. It was throwing  "Catalog object schema validation failed"

Seems it to be some bad xml issue.

Solution:

 Go to the corresponding folder

 D:\OBIHome\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite\root\shared\Dashboard1\_portal

2)  Edit the troublesome file in an editor. 

3) Check for the XML tag value

<saw:dataLabels abbreviation="default" display="default" label="default" valueAs="default" waterfallValueAs="diffprevbar">

Remove the waterfallValueAs attribute from the XML:

<saw:dataLabels abbreviation="default" display="default" label="default" valueAs="default">

You have to repeat this process for all the improper reports. 

OBIEE Patching




Patching OBIEE


Recently I patched OBI version 11.1.1.60 to 11.1.1.6.7. There are many blogs about patching. I liked the one from "peak Indicators" 


Check out the process to Patch in the link here