The upgrade process with Oracle Fusion Middleware Upgrade Assistant (ua.bat) type 'All Schemas Used By a Domain' fails with the following message: Oracle Business Intelligence Schema doUpgrade Failed, due: java.lang.RuntimeException: Total 1 schema plugins failed: (1) Schema plugin: com.oracle.bi.contentstorage.plugins.schema.ContentStorageSchemaPlugin failed: Validate failed: Migration checksum mismatch for migration 1.0.0.0.4 -> Applied to database : 2114654566 -> Resolved locally : -946993454 UPGCMP-06005: BIPLATFORM database schema update failed. Cause: Specified BIPLATFORM database schema update failed. Action: Check the log file and if necessary restore the database from backup. UPGCMP-06005: BIPLATFORM database schema update failed. Cause: Specified BIPLATFORM database schema update failed. Action: Check the log file and if necessary restore the database from backup. doUpgrade Failed Overview of environment * OAS Server OS: Windows Server 2019 Standard Edition Oracle Analytics Server 7.0.0 (OAS 2023) Applied WLS/FMW/OAS patches to OAS 2023: April 2024 Applied WLS/FMW/OAS patches to OAS 2024: April 2024 including patch 35515979 $ORACLE_HOME D:\analytics\product\oas_home $DOMAIN_HOME D:\analytics\config\domains\oas_domain * Database Server (different Machine from OAS Server) for Repository OS: Windows Server 2019 Standard Edition DBMS: MS SQL Server 2019 Enterprise Edition Process for upgrade According to Guide https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/upgrade-process.html the following steps were planed: * Apply latest patches to Oracle Analytics Server 7.0.0 (OAS 2023) installation * Shut down OAS services (leave database instance running) * Create Backup directory: mkdir D:\analytics\config\backup * Backup contents of $ORACLE_HOME as Zip-archive to D:\analytics\config\backup * Backup contents of $DOMAIN_HOME as Zip-archive to D:\analytics\config\backup * Move existing $ORACLE_HOME directory to temporary directory: move D:\analytics\product\oas_home D:\analytics\product\oas_home.2023 * Create new empty $ORACLE_HOME directory: mkdir D:\analytics\product\oas_home * Install Oracle Fusion Middleware 12.2.1.4.0 to D:\analytics\product\oas_home into new empty $ORACLE_HOME directory * Install Oracle Analytics Server 7.6.0 (OAS 2024) to D:\analytics\product\oas_home into new empty $ORACLE_HOME directory * Apply OPatch/WLS/FMW/OAS April 2024 patches (including patch 35515979) into new empty $ORACLE_HOME directory * Perform Readiness check with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat -readiness * Back up mapViewerConfig.xml: copy D:\analytics\config\domains\oas_domain\config\fmwconfig\mapviewer\conf\mapViewerConfig.xml D:\analytics\config\backup * Upgrade All Schemas Used By a Domain with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat * Reconfigure the existing domain with the Reconfiguration Wizard: ORACLE_HOME\oracle_common\commom\bin\reconfig.cmd * Upgrade All Configurations Used By a Domain with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat * Restore mapViewerConfig.xml: copy D:\analytics\config\backup\ mapViewerConfig.xml D:\analytics\config\domains\oas_domain\config\fmwconfig\mapviewer\conf\ /y * Restart all OAS services * Verify upgrade and delete old %ORACLE_HOME%: erase \analytics\product\oas_home.2023 /f /s /q Upgrade Notes * The Oracle Fusion Middleware Upgrade Assistant Readiness check indicated no errors (see attached logs) * The upgrade fails at step 13 from the above list 'Upgrade All Schemas Used By a Domain with Oracle Fusion Middleware Upgrade Assistant' (see attached logs) logfiles.zip * According to https://docs.oracle.com/en/middleware/bi/analytics-server/known-issues-oas/toc.htm additional patch 25297159 is required in order to succeed. However this patch doesn't exist. According to https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/upgrading-latest-release-oracle-analytics-server.html#GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D additional patch 35515979 is required - this patch exists und was applied to the new $ORACLE_HOME% with OAS 2024 installed prior to the upgrade. * Although certificates and SSL listeners for accessing OAS were configured no internal SSL was enabled (standard listeners were also still active) Alternatives tried (without success): * Trying an upgrade from Oracle Analytics Server 7.0.0 with January 2024 patches * Trying an upgrade from Oracle Analytics Server 7.0.0 with April 2024 patches * Trying an upgrade to Oracle Analytics Server 7.6.0 without any patches * Trying an upgrade to Oracle Analytics Server 7.6.0 with April 2024 patches * Trying an upgrade to Oracle Analytics Server 7.6.0 with April 2024 patches (including patch 35515979) Question Is there a required step missing? Or a specific patch? Or is this just a bug?

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OAS 2023 upgrade to OAS 2024 fails during upgrade 'All Schemas Used By a Domain'

Sascha L.

The upgrade process with Oracle Fusion Middleware Upgrade Assistant (ua.bat) type 'All Schemas Used By a Domain' fails with the following message:

Oracle Business Intelligence Schema
doUpgrade Failed, due: java.lang.RuntimeException: Total 1 schema plugins failed: (1) Schema plugin: com.oracle.bi.contentstorage.plugins.schema.ContentStorageSchemaPlugin failed: Validate failed: Migration checksum mismatch for migration 1.0.0.0.4 -> Applied to database : 2114654566 -> Resolved locally : -946993454
UPGCMP-06005: BIPLATFORM database schema update failed.
Cause: Specified BIPLATFORM database schema update failed.
Action: Check the log file and if necessary restore the database from backup.
UPGCMP-06005: BIPLATFORM database schema update failed.
Cause: Specified BIPLATFORM database schema update failed.
Action: Check the log file and if necessary restore the database from backup.
doUpgrade Failed

Overview of environment

OAS Server
OS: Windows Server 2019 Standard Edition
Oracle Analytics Server 7.0.0 (OAS 2023)
Applied WLS/FMW/OAS patches to OAS 2023: April 2024
Applied WLS/FMW/OAS patches to OAS 2024: April 2024 including patch 35515979
$ORACLE_HOME D:\analytics\product\oas_home
$DOMAIN_HOME D:\analytics\config\domains\oas_domain
Database Server (different Machine from OAS Server) for Repository
OS: Windows Server 2019 Standard Edition
DBMS: MS SQL Server 2019 Enterprise Edition

Process for upgrade
According to Guide https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/upgrade-process.html the following steps were planed:

Apply latest patches to Oracle Analytics Server 7.0.0 (OAS 2023) installation
Shut down OAS services (leave database instance running)
Create Backup directory: mkdir D:\analytics\config\backup
Backup contents of $ORACLE_HOME as Zip-archive to D:\analytics\config\backup
Backup contents of $DOMAIN_HOME as Zip-archive to D:\analytics\config\backup
Move existing $ORACLE_HOME directory to temporary directory: move D:\analytics\product\oas_home D:\analytics\product\oas_home.2023
Create new empty $ORACLE_HOME directory: mkdir D:\analytics\product\oas_home
Install Oracle Fusion Middleware 12.2.1.4.0 to D:\analytics\product\oas_home into new empty $ORACLE_HOME directory
Install Oracle Analytics Server 7.6.0 (OAS 2024) to D:\analytics\product\oas_home into new empty $ORACLE_HOME directory
Apply OPatch/WLS/FMW/OAS April 2024 patches (including patch 35515979) into new empty $ORACLE_HOME directory
Perform Readiness check with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat -readiness
Back up mapViewerConfig.xml: copy D:\analytics\config\domains\oas_domain\config\fmwconfig\mapviewer\conf\mapViewerConfig.xml D:\analytics\config\backup
Upgrade All Schemas Used By a Domain with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat
Reconfigure the existing domain with the Reconfiguration Wizard: ORACLE_HOME\oracle_common\commom\bin\reconfig.cmd
Upgrade All Configurations Used By a Domain with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat
Restore mapViewerConfig.xml: copy D:\analytics\config\backup\ mapViewerConfig.xml D:\analytics\config\domains\oas_domain\config\fmwconfig\mapviewer\conf\ /y
Restart all OAS services
Verify upgrade and delete old %ORACLE_HOME%: erase \analytics\product\oas_home.2023 /f /s /q

Upgrade Notes

The Oracle Fusion Middleware Upgrade Assistant Readiness check indicated no errors (see attached logs)
The upgrade fails at step 13 from the above list 'Upgrade All Schemas Used By a Domain with Oracle Fusion Middleware Upgrade Assistant' (see attached logs)
logfiles.zip
According to https://docs.oracle.com/en/middleware/bi/analytics-server/known-issues-oas/toc.htm additional patch 25297159 is required in order to succeed. However this patch doesn't exist. According to https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/upgrading-latest-release-oracle-analytics-server.html#GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D additional patch 35515979 is required - this patch exists und was applied to the new $ORACLE_HOME% with OAS 2024 installed prior to the upgrade.
Although certificates and SSL listeners for accessing OAS were configured no internal SSL was enabled (standard listeners were also still active)

Alternatives tried (without success):

Trying an upgrade from Oracle Analytics Server 7.0.0 with January 2024 patches
Trying an upgrade from Oracle Analytics Server 7.0.0 with April 2024 patches
Trying an upgrade to Oracle Analytics Server 7.6.0 without any patches
Trying an upgrade to Oracle Analytics Server 7.6.0 with April 2024 patches
Trying an upgrade to Oracle Analytics Server 7.6.0 with April 2024 patches (including patch 35515979)

Question

Is there a required step missing? Or a specific patch? Or is this just a bug?

Find more posts tagged with

Upgrade

OAS

Accepted answers

Steve F-2

Hi @Sascha L. ,

I understand you are working on an internal reproduction via the Service Request.

According to https://docs.oracle.com/en/middleware/bi/analytics-server/known-issues-oas/toc.htm additional patch 25297159 is required in order to succeed. However this patch doesn't exist.

I just wanted to let you and future readers know that we have filed a documentation update for this. Patch 35515979 is the correct patch.

All comments

Sascha L.

Also opened Technical Service Request SR 3-37241855861 for this issue.

[Deleted User]

Hi Sascha,

I suggest you pursue the SR. Oracle Support is a service you pay for with your licenses. This is is a public and free community forum.

Especially errors like yours aren't really things that the community can resolve.

Unless someone has your precise setup with an all-Windows config you'll probably not get anyone who can reproduce it and even then it's 50/50 because it's an upgrade and not a fresh install.

I'll ask the question that's probably burning on the fingers of several forum users but not typed out: What forces you to stay on-premises?

Steve F-2

Hi @Sascha L. ,

I understand you are working on an internal reproduction via the Service Request.

According to https://docs.oracle.com/en/middleware/bi/analytics-server/known-issues-oas/toc.htm additional patch 25297159 is required in order to succeed. However this patch doesn't exist.

I just wanted to let you and future readers know that we have filed a documentation update for this. Patch 35515979 is the correct patch.

Karthik-Oracle

The issue happening in OAS 2023 to OAS 2024 upgrade ..

and the patch 35515979 suggested, is saying BIAPPS UPGRADE OAS6.4 WITH OCT CPU TO OAS7 FAILS AT RECONFIG…

—

as per I have found OAS 2023 is 7.0 right & OAS 2024 is 7.6?

is it may be same old patch necessary here also, or a typo in naming the patch?

Karthik-Oracle

And when I tried to apply this patch, it's superset patch 36946553 is already a necessary patch indicated in FMW quarterly patches list..

Steve F-2

@Karthik-Oracle
This is an old thread with an accepted answer.
Patch 36946553 was from OCT 2024, and yes, it has been superseded by the JAN 2025 patches

Also, as FYI OAS 2025 was released last week.

Karthik-Oracle

@SteveF-Oracle

we are upgrading now from OAS 2023 , shall I directly jump to OAS 2025 ?

why I am asking suggestion is, dealing with BIP/OAS is a difficult one, so just our target is to save as much time possible on OAS maintenance..

We have lot of environments running this setup.

So what will you suggest shall I proceed upgrading to 2024, or is it best to upgrade in to the just released 2025 version ?