My Oracle Support Banner

Constructive Changes Are Not Working With Upgrade Install Mode. (Doc ID 2419815.1)

Last updated on JULY 05, 2018

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.7 and later
Information in this document applies to any platform.

Symptoms

On : 2.4.7 version, Data Model

When attempting to upgrade install a table with precision changes
the following error occurs in the install log.

ERROR
-----------------------
Set install status to $INSTSTATUSES$UPGPREPARED
Set install status to $INSTSTATUSES$UPGDEPLACTIVE
Starting UPGDEPL_ACTIVE.
Deploying CDR_W2D4_A1F29_$UPGRADE_2
Unit Name=CDR_W2D4_A1F29_$UPGRADE_2
An error prevents the Upgrade script from executing successfully. Please review upgrade log file /u01/app/oracle/product/11.2.0/dbh_dw3/owb/log/reorg.log. Generated upgrade script is /u01/app/oracle/product/11.2.0/dbh_dw3/owb/log/reorg.sql.

If applicable, original data can be restored from recovery table (typically postfixed '$$OCMrecovery'). Remove the recovery table afterward.

ORA-01440: column to be modified must be empty to decrease precision or scale

Execution failed


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Login to DMW with valid Credentials.
2. Enter Study as “E-R-P22” and click Enter
3. Select the Study and navigate to Study Configuration Page
4. Select the Datamodel “DHA201”
5.Verify that the data is already loaded for the data model “DHA201” under “LISTINGS “ tab.
6. Navigate back to Study Configuration Page
7. Select the Datamodel “DHA201”
8. Click on “Checkout” Icon.
9. Verify that TABLE1 is already present with 5 columns in Columns Section.
10. Select the “COL4” and click on Edit Icon.
11. Update the Precision value from 0 to 5 in “Modify Clinical Data Model” window
12. Click OK.
13. Verify that the updated value is reflected for respective column in Column Section
14. Click on “Install Model” Icon.
15. Click “Install Model” in confirmation box.
16. Verify that the Install Job in Progress Message is displayed.
17. Verify that Installation is failed with Install Job Status as “Failure”

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Impacting UAT phase

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!


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