My Oracle Support Banner

DB Upgrade Issue LAM_PATIENT.STUDY_PATIENT_ID (Doc ID 1546249.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 7.0.1 and later
Information in this document applies to any platform.

Goal

Column LAM_PATIENT.STUDY_PATIENT_ID has a length of 20 in V 5.0.5 and in V 7.0.2 as well.

Migration script path:
\Previous Database Upgrades\Database_released_code_701_from_5052\Database_released_code_51\DBInstaller\Upgrades\UPGRADE_TO_51\SQL

Argus_51_schema_change_B2C.sql:
ALTER TABLE &USER..LAM_PATIENT MODIFY (STUDY_PATIENT_ID VARCHAR2(10 CHAR));

Since we have more than 10 char in this field the statement above fails.

The first statement seems to be redundant. The second statement should be corrected to:
ALTER TABLE &USER..LAM_PATIENT MODIFY (STUDY_PATIENT_ID VARCHAR2(20 CHAR));

Please confirm if this is an issue with the DB upgrade scripts.
 

Solution

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
Goal
Solution


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