Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
51
Views
1
Comments
User_98QEC
User_98QEC Rank 3 - Community Apprentice
edited Aug 13, 2024 5:18PM in Oracle Analytics Cloud and Server

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:

DEV_RCU_FirstScreen.jpg

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

pastedImage_1.png

and

pastedImage_2.png

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?

Answers

  • User_98QEC
    User_98QEC Rank 3 - Community Apprentice

    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;