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!
Last updated on JANUARY 26, 2016
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.150714 and later
Oracle Exalytics Software - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Upgraded two node OBIEE cluster on Exalytics from version 22.214.171.124.12 to version 126.96.36.199.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.
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