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 MAY 19, 2021
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.150714 and later
Oracle Exalytics Software - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Upgraded two node OBIEE cluster on Exalytics from version 126.96.36.199.12 to version 188.8.131.52.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document