Configuration Failure with TRANSFORMBAREXCEPTION

The Oracle Analytics Server configuration might fail with a TRANSFORMBAREEXCEPTION error, if any objects in the catalog are older than Release 11.1.1.9. You can confirm the need to update the catalog items by viewing the metrics in Oracle Enterprise Manager Fusion Middleware Control. In the Catalog folder, find a metric called Reads Needing Upgrade with the description "The number of objects read that required upgrading." If the number is large, then you can resolve this issue by updating objects in the catalog using the Administration page in Presentation Services.

To update the catalog:

1. Sign in to Oracle Analytics Server with administration credentials.
2. In the global header, click Administration.
3. Click the Scan and Update Catalog Objects That Require Updates link.
4. Click Update Catalog Objects to begin the update process.
   Click the other links on the page to see which objects were updated and which were not. You can view the log files for details on objects that were not updated.

Restart Oracle BI Presentation Services using Oracle Enterprise Manager Fusion Middleware Control.

Updating Oracle BI Presentation Services Catalog

When migrating from Oracle Business Intelligence, you must manually update your Oracle BI Presentation Services Catalog.

To update the Oracle BI Presentation Services Catalog:

1. Shut down Oracle BI Presentation Services using Oracle Enterprise Manager Fusion Middleware Control.
   See Using Fusion Middleware Control to Start and Stop BI System Component Processes in Administering Oracle Analytics Server.
2. Back up your existing Oracle BI Presentation Services Catalog by using the 7-Zip utility to create a compressed file.
3. Create a backup copy of the instanceconfig.xml file present at these locations:
   • (Linux) BI_DOMAIN_HOME/config/OracleBIPresentationServicesComponent/coreapplication_obipsn
   • (Windows) BI_DOMAIN_HOME\config\OracleBIPresentationServicesComponent\coreapplication_obipsn
4. Change the UpgradeAndExit option to true in the instanceconfig.xml file.
   Find the following code:

   <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
      <ps:UpgradeAndExit>false</ps:UpgradeAndExit>
   </ps:Catalog>

   Change it to the following:

   <ps:Catalog xmlns:ps="oracle.bi.presentation.services/config/v1.1">
      <ps:UpgradeAndExit>true</ps:UpgradeAndExit>
   </ps:Catalog>

5. Start Oracle BI Presentation Services using the following OPMN command to update the Oracle BI Presentation Services Catalog:
   opmnctl startproc ias-component=coreapplication_obipsn
   Where, n is the instance.
   For example:
   (Linux) cd ORACLE_INSTANCE/bin
   (Linux) ./opmnctl startproc ias-component=coreapplication_obips1
   (Windows) cd ORACLE_INSTANCE\bin
   (Windows) opmnctl startproc ias-component=coreapplication_obips1
6. After the catalog is updated, edit the instanceconfig.xml file again and change the UpgradeAndExit option back to false.
7. Restart Oracle BI Presentation Services using Oracle Enterprise Manager Fusion Middleware Control.