OBIEE 11g: Error: "Catalog object schema validation failed...Error Codes: AGFIXBO2:EIRWWH9E" After Upgrade (Doc ID 1247125.1)

Last updated on APRIL 30, 2015

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.3.0 [1905] to 11.1.1.3.0 [1905] [Release 11g]
Business Intelligence Server Enterprise Edition - Version 11.1.1.3.0 [1905] to 11.1.1.3.0 [1905] [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 22-Nov-2013***

Symptoms

You have used the upgrade assistant (UA) utility to upgrade the OBIEE catalog from version 10g to 11.1.1.3.0 . The upgrade completed successfully. But when you try to open any reports, you see the following error:

Catalog object schema validation failed: /shared/Business Areas/Business Areas/India/Pru FA - Asset Information Report
Error Details
Error Codes: AGFIXBO2:EIRWWH9E
Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool, saw.threadpool, saw.threads
The current xml is invalid with the following errors: Bad xml instance! <?xml version="1.0"?> <saw:report xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="200810080" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:sawx="com.siebel.analytics.web/expression/v1.1"><saw:criteria subjectArea=""Assets"" xsi:type="saw:simpleCriteria"><saw:columns><saw:column columnID="c0" columnTitle="Asset Class" xsi:type="saw:regularColumn" forceGroupBy="true"><saw:columnFormula><sawx:expr xsi:type="sawx:sqlExpression">"Asset Category Flexfield&quot;.&quot;Asset Class&quot;</sawx:expr></saw:columnFormula></saw:column><saw:column columnID="c1" columnTitle="Asset Type" xsi:type="saw:regularColumn" forceGroupBy="true"><saw:columnFormula><sawx:expr xsi:type="sawx:sqlExpression">"Asset Category Flexfield&quot;.&quot;Asset Type&quot;</sawx:expr></saw:columnFormula></saw:column><saw:column columnID="c2" columnTitle="Local Use" xsi:type="saw:regularColumn" forceGroupBy="true"><saw:columnFormula><sawx:expr xsi:type="sawx:sqlExpression">"Asset Category Flexfield&quot;.&quot;Local Use&quot;</sawx:expr></saw:columnFormula></saw:column><saw:column columnID="c3" columnTitle="Asset Number" xsi:type="saw:regularColumn" forceGroupBy="true"><saw:columnFormula><sawx:expr xsi:type="sawx:sqlExpression">"Asset Information&quot;.&quot;Asset Number&quot;</sawx:expr></saw:columnFormula></saw:c

Changes

 Upgrade from OBIEE 10g to 11.1.1.3.0.

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