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:

1. Apply latest patches to Oracle Analytics Server 7.0.0 (OAS 2023) installation
2. Shut down OAS services (leave database instance running)
3. Create Backup directory: mkdir D:\analytics\config\backup
4. Backup contents of $ORACLE_HOME as Zip-archive to D:\analytics\config\backup
5. Backup contents of $DOMAIN_HOME as Zip-archive to D:\analytics\config\backup
6. Move existing $ORACLE_HOME directory to temporary directory: move D:\analytics\product\oas_home D:\analytics\product\oas_home.2023
7. Create new empty $ORACLE_HOME directory: mkdir D:\analytics\product\oas_home
8. Install Oracle Fusion Middleware 12.2.1.4.0 to D:\analytics\product\oas_home into new empty $ORACLE_HOME directory
9. Install Oracle Analytics Server 7.6.0 (OAS 2024) to D:\analytics\product\oas_home into new empty $ORACLE_HOME directory
10. Apply OPatch/WLS/FMW/OAS April 2024 patches (including patch 35515979) into new empty $ORACLE_HOME directory
11. Perform Readiness check with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat -readiness
12. Back up mapViewerConfig.xml: copy D:\analytics\config\domains\oas_domain\config\fmwconfig\mapviewer\conf\mapViewerConfig.xml D:\analytics\config\backup
13. Upgrade All Schemas Used By a Domain with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat
14. Reconfigure the existing domain with the Reconfiguration Wizard: ORACLE_HOME\oracle_common\commom\bin\reconfig.cmd
15. Upgrade All Configurations Used By a Domain with Oracle Fusion Middleware Upgrade Assistant: %ORACLE_HOME%\oracle_common\upgrade\bin\ua.bat
16. Restore mapViewerConfig.xml: copy D:\analytics\config\backup\ mapViewerConfig.xml D:\analytics\config\domains\oas_domain\config\fmwconfig\mapviewer\conf\ /y
17. Restart all OAS services
18. 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?

SteveF-Oracle

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.

Sascha L.

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

Christian Berg -Oracle

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?