My Oracle Support Banner

Upgrade Script to Edition Existing Schemas is Failing for Schemas Including Custom Objects (Doc ID 2816785.1)

Last updated on FEBRUARY 21, 2023

Applies to:

Oracle Health Sciences Data Management Workbench - Version 3.1.0 to 3.1.0 [Release 3.1.0]
Oracle Life Sciences Data Hub - Version 3.1.0 to 3.1.0 [Release 3.1.0]
Information in this document applies to any platform.

Symptoms

On Oracle Life Sciences Data Hub (LSH) 3.1.0 version,

ACTUAL BEHAVIOR
---------------
While upgrading LSH from version 3.0 to 3.1, few schema failed to upgrade during the script dmeupg31runprgs.sql execution.

EXPECTED BEHAVIOR
-----------------------
It would be expected that the schema upgrade to be completed successfully.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Perform the upgrade steps from LSH 3.0 to 3.1.
2. As part of the steps in "Run the Upgrade Script to Edition Existing Schemas" section from LSH 3.1 Installation Guide document, execute the script dmeupg31runprgs.sql
3. Monitor the upgrade process using the following query:

    The query is returning a value higher than zero for the 'failed_schema_Count'.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.