OBIEE upgrade to 12.2.1.4. Problem with Readiness Check for one of the schemas — Oracle Analytics

Oracle Analytics Cloud and Server

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

OBIEE upgrade to 12.2.1.4. Problem with Readiness Check for one of the schemas

Received Response
61
Views
4
Comments
aPsikus
aPsikus Rank 6 - Analytics Lead

Hi,

I'm trying to upgrade OBIEE 12.2.1.2 to 12.2.1.4.

I have installed FM in new Milddleware/Oracle_Home.

I have installed new OBIEE in the same location.

Next step is to run Upgrade Assistant in readiness check mode.

You need to provide path to the older version and provide details about all used schemas (DB user name and password).

I have successfully provided details for WLS and OPSS schemas.

There is error for IAU schema.

As I have checked in Toad, I can login to DB using credentials for IAU user. There are several tables, but looks like all of them are empty.

Error which I'm receiving is:

readiness_check-IAU_schema_error.jpg

Any suggestion how to solve this?

Difference for other schemas is that schema user was not entered by default and list is empty.

I can't skip this step. I know it's only Readiness Check, but I guess that in upgrade process it will also return error.

I have created SR, but for several days without answer from Oracle

Please send help!

Answers

  • cyborg007
    cyborg007 Rank 1 - Community Starter

    Can you please check the output of the below query:

    select * from system.schema_version_registry

    where comp_id= 'IAU';

    schema_version_registry is the table where Oracle Fusion Middleware maintains RCU schema information. If records are missing from the table, then it causes issues while upgrading.

  • aPsikus
    aPsikus Rank 6 - Analytics Lead

    system.schema_version_registry

    table or view doesn't exist

  • cyborg007
    cyborg007 Rank 1 - Community Starter

    This table is read by the upgrade process. Without it, the upgrade will not know the underlying RCU schemas. See, if it is present in any other environments. If yes, we can figure out to create a copy here.

    Regards,

    Vivek

  • Rajesh Dhanapal
    Rajesh Dhanapal Rank 4 - Community Specialist

    Which DB user account are you using? Are you using the non-sys dba account e.g. FWM as specified in Oracle documentation? If so, please check whether there is data vault for this newly created db account with DBA's. That might help to solve the issue.