RCU SQL State 4200 Error Code 942 Table or View does not exist BIPLATFORM

User_98QEC

Good afternoon -

I am trying to set up OBIEE 12.2.1.4 on a UNIX server running RHEL 6.

I'm using a Oracle 12.2 container/plugin database as my repository.

I've sailed through all steps so far UNTIL I attempt the "Perform Product Load"

Now I get the following errors:

All of the schemas are successfully installed EXCEPT BIDEV_BIPLATFORM.

I've have to have my dba perform the system load and the product load as I do not have privs.

He is using the SYS acccount.

I have checked and the BIDEV_BIPLATFORM user/schema DOES exist and is entered in the system.schema_version_registry table

and

This is a single installation on the BI server, BUT I am trying to utilize the same database for both a DEV and TEST instance.

The TEST version is BITEST_BIPLATFORM.....

and the DEV instance will utilize BIDEV_BIPLATFORM.

TEST works - I installed it first, DEV does not.

Any suggestions?

User_98QEC

OK, I finally gave up and opened a Service Request and this is what they said, and they were correct. This solution fixed my problem

I suspect it is a lack of privileges for BI_PLATFORM schema. Can you discuss with your DBA and request they try to manually grant a SELECT privilege on ALL_USERS view to the BI_PLATFORM schema then try again?

Another suggestion is to perform re-installation and before rcu run, add the below lines to the create_user.sql in <ORACLE_HOME>/oracle_common/common/sql/biplatform/scripts/oracle/create_user.sql

------

GRANT EXECUTE ON SYS.DBMS_LOCK to &&1;

GRANT EXECUTE ON SYS.DBMS_OUTPUT to &&1;

GRANT SELECT ON ALL_USERS TO &&1;