Exalytics and OBIEE: Config.sh Fails with Errors When Trying to Extend Domain to Deploy JBIPS: ORA-00942: table or view does not exist, CFGFWK-60850: Test Failed! (Doc ID 2099440.1)

Last updated on JANUARY 26, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150714 and later
Oracle Exalytics Software - Version 1.0.0.3.0 and later
Information in this document applies to any platform.

Symptoms

Upgraded two node OBIEE cluster on Exalytics from version 11.1.1.6.12 to version 11.1.1.7.15020.  After installation, ran the config.sh script to extend existing WLS domain and to configure the JBIPS component as described in the FMW Patching Guide under Section 5.12.5 Enabling JBIPS Features.

The FMW Configuration wizard finds the existing domain (EXALYTICS_MWHOME -> user_projects -> domains -> bifoundation_domain), but fails during the "test JDBC Component Schema".


The EPM and BIP Schema checks succeed, but the OWSM MDS Schema fails:

If the JDBC Component Schema checks are skipped and you continue through the configuration wizard, it gets to the end and then fails with message:

CFGFWK-60319: The "JMS" configuration in your domain is invalid. Try to resolve the issue by clicking Cancel and returning to this section in the wizard.
If you cannot resolve the issue, either click Cancel and exit in the wizard, or click OK to continue.
If continuing, you may want to start the server in the domain and review the messages to identify the invalid configuration.

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