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 OCTOBER 07, 2024

Applies to:

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.