OBIEE 11g - 11g XML data Incompatibility

We have observed an annoying warning  "11g xml data incompatibility" in our production environment.

There are 2 possible solutions for this, depending on the upgrade scenario:

Upgrading from 10g to 11g (11.1.1.3.0) or 11.1.1.3.0 to 11.1.1.5

The Oracle Bug - Bug 12911878 and the associated Note the below solution should resolve the issue.

When updating your OBIEE software from 11.1.1.3.0 to 11.1.1.6.0 you must manually update your Oracle BI Presentation Catalogs.

Instructions are provided below:

• Shutdown OBI Presentation Services using EM.
• Back up the Catalog and instanceconfig.xml files. The instanceconfig.xml file is located in the directory - ORACLE_INSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1
• Amend the instanceconfig.xml file to make the below change:
• Change the option to true.
• Start BI Presentation Services using opmnctl as -

ORACLE_INSTANCE/bin/opmnctl startproc ias-component=coreapplication_obips1.

Revert the change done to instanceconfig.xml file, to change the value for option to false.

Restart the Presentation Services from FMW EM.

 

Upgrading from 11.1.1.5.* to 11.1.1.6.*

In this scenario, which is what we have been in,  the above suggested solution did not work.  More digging into Oracle support site came up with a different note (Note ID: 1448893.1)and a different solution for this:

  When moving from 11.1.1.5.0 to 11.1.1.6.0, it is not required technically to upgrade the catalog; however as a best practice  and for performance reasons one should:

• Open the Repository in the 11.1.1.6 Administration Tool, run a consistency check (in case there are new consistency checks) and save the repository. As always, have a backup(s).
• Upgrade the Catalog manually using the following two options
1. Use the new 11.1.1.6.0 feature: Scan and Update Catalog Objects That Require Update.
2. If solution 1 does not reolve the ussue, then follow the full upgrade steps below. Use the steps in the Patching Guide (similar to the steps moving from 11.1.1.3.0
   See: Oracle Fusion Middleware Patching Guide 11g Release 1 (11.1.1.6.0) -- Part Number E16793-17.

To implement the 1st solution perform the below:

• Login to OBIEE Presentation Services with the login that has Administrative privileges.
• Click "Administration"
• Click "Scan and Update Catalog Objects That Require Updates" link.
• Click "Update Catalog Objects" to begin the update process.

The update process starts and and lists the number of objects that were updated and number of objects that did not required updating. 

Click on the links to see which objects were updated.