DB Upgrade Issue LAM_PATIENT.STUDY_PATIENT_ID (Doc ID 1546249.1)

Last updated on JUNE 10, 2013

Applies to:

Oracle 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

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 hundreds of Community platforms