Data Migration Documentation

Database Script Error Messages

The following table represents previously detected database script errors that you might encounter when running the scripts.

Liquent InSight 6.2

Upgrade Path Error Description/Resolution
6.2.9 to 6.2.10
  • drop table dbcommon.role * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table dbcommon.entity_type * ERROR at line 1: ORA-00942: table or view does not exist
Ignore
6.2 CHF 7 to 6.2.8
  • drop table dbcommon.role * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table dbcommon.entity_type * ERROR at line 1: ORA-00942: table or view does not exist
Ignore
6.2 CHF 6 to 6.2 CHF 7
  • drop table dbcommon.role * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table dbcommon.entity_type * ERROR at line 1: ORA-00942: table or view does not exist
Ignore
6.2 CHF 5 to 6.2 CHF 6
  • drop table dbcommon.role * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table dbcommon.entity_type * ERROR at line 1: ORA-00942: table or view does not exist
Ignore
6.2 CHF 4 to 6.2 CHF 5
  • drop table dbcommon.role * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table dbcommon.entity_type * ERROR at line 1: ORA-00942: table or view does not exist
Ignore
6.2 CHF 3 to 6.2 CHF 4
  • drop table assembly_totals * ORA-00942: table or view does not exist
  • drop index XAK1CONTENT * ERROR at line 1: ORA-01418: specified index does not exist
  • drop view vw_assembly_totals * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table dbcommon.role * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table dbcommon.entity_type * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table view_column_name_overrides * ERROR at line 1: ORA-00942: table or view does not exist
Ignore
6.2 CHF 2 to 6.2 CHF 3
  • drop table dbcommon.role * ERROR at line 1: ORA-00942: table or view does not exist
  • drop table dbcommon.entity_type * ERROR at line 1: ORA-00942: table or view does not exist
Ignore
6.2 CHF 1 to 6.2 CHF 2
  • dbcommon.role *ERROR at line 1:ORA-00942: table or view does not exist
  • drop table dbcommon.entity_type *ERROR at line 1:ORA-00942: table or view does not exist
Ignore
6.2 (new installation only) drop table d_date * ERROR at line 1: ORA-00942: table or view does not exist Ignore

This error does not appear during the migration from the previous Calyx RIM versions to Calyx RIM 6.2. It may be seen only if you install a new Calyx RIM 6.2 database. If you see this error, you can ignore it.

Liquent InSight 6.1

Upgrade path Error Description/Resolution
6.1 to 6.1 CHF 1
  • ******************* fix EU-3-0 EMA-eAF ******************* declare * ERROR at line 1: ORA-01403: no data found ORA-06512: at line 9
  • drop table tmp_ind_expressions  * ERROR at line 1: ORA-00942: table or view does not exist
Ignore
6.1 to 6.1 CHF 1
  • ORA-00955: name is already used by an existing object
  • ORA-02260: table can have only one primary key
  • ORA-24344: success with compilation error
  • ORA-06512: at line 115
Ignore. These errors can be ignored if the migration path contained Calyx RIM 6.0 CHF 6 or Calyx RIM 6.0 CHF 7.
6.1 to 6.1 CHF 1 to 6.1 CHF 2 ERROR at line 1: ORA-04043: object WRITE_STORAGE_REQUIREMENTS does not exist Ignore
6.1 CHF 1 to 6.1 CHF 2
  • ORA-24344: success with compilation error
  • ORA-06512: at line 115
Ignore. These errors can be ignored if the migration path contained Calyx RIM 6.0 CHF 6 or Calyx RIM 6.0 CHF 7.
6.1 CHF 2 to 6.1 CHF 3
  • ORA-01918: user 'DBCOMMON' does not exist
  • ORA-04043: object GET_DIRLIST does not exist
  • ORA-00904: "SUB_TO_ADD_MONITOR_CODE": invalid identifier
  • ORA-00904: "ORPHAN_DRUG_FLAG": invalid identifier
Ignore
6.1 CHF 2 to 6.1 CHF 3 ORA-02298: cannot validate (MGR.T_1671) - parent keys not found Ignore
6.1 CHF 2 to 6.1 CHF 3 to 6.1 CHF 4 ORA-02298: cannot validate (MGR.T_1671) - parent keys not found Ignore
6.1 CHF 2 to 6.1 CHF 3
  • ORA-00001: unique constraint (MGR.AK0BROAD_INDC_COUNTRY) violated
  • ORA-00955: name is already used by an existing object
Ignore. These errors can be ignored if the migration path contained Calyx RIM 6.0 CHF 6 or Calyx RIM 6.0 CHF 7.
6.1 CHF 3 to 6.1 CHF 4
  • ORA-00001: unique constraint (MGR.UX1REGULATORY_ACT_LEAD) violated
  • ORA-00001: unique constraint (MGR.UX1SEQ_DESCR_TYPE) violated
Ignore. These errors can be ignored if the migration path contained Calyx RIM 6.0 CHF 6 or Calyx RIM 6.0 CHF 7.
6.1 to 6.2 ORA-01418: specified index does not exist Ignore
6.1 CHF 4 to 6.2 CHF 1
  • ORA-24344: success with compilation error
  • Any errors for the PACKAGE BODY ISM.PRODUCT_FAMILY_COPY:
  • ORA-02298: cannot validate (MGR.T_1671) - parent keys not found
Ignore

Liquent InSight 6.0

Upgrade path Error Description/Resolution
6.0 to 6.0 CHF 1 ORA-01952: system privileges not granted. Ignore. This error can appear when running the master-pre.sql script. It means that the system privileges are not granted to MGR, ODS, or SEC.
6.0 CHF 1 to 6.0 CHF 2 to 6.0 CHF 3 drop table view_column_metadata            * ERROR at line 1: ORA-00942: table or view does not exist comment on column vd_conten.logical_parent_id is 'Reserved for Internal Use; Do not Use'                   * ERROR at line 1: ORA-00942: table or view does not exist Ignore
6.0 CHF 2 to 6.0 CHF 3 ******************************** build dimension views  ******************************** ORA-24344: success with compilation error  VD_PDS_LAB_HIST.R_VD_PDS_LAB_HIST6 

ORA-24344: success with compilation error  VD_PDS_LAB_HIST.R_VD_PDS_LAB_HIST1 

ORA-24344: success with compilation error  VD_PDS_LAB_HIST.R_VD_PDS_LAB_HIST3 

ORA-24344: success with compilation error  VD_PDS_LAB_HIST.R_VD_PDS_LAB_HIST2 

ORA-24344: success with compilation error  VD_PDS_LAB_HIST.R_VD_PDS_LAB_HIST4 

ORA-24344: success with compilation error  VD_PDS_LAB_HIST.R_VD_PDS_LAB_HIST5 

PL/SQL procedure successfully completed. 

Ignore
6.0 CHF 2 to 6.0 CHF 3 to 6.0 CHF 4 to 6.0 CHF 5 from dba_views v

         * ERROR at line 36:

Ignore
6.0 CHF 3 to 6.1 drop table tmp_ind_expressions                * ERROR at line 1: ORA-00942: table or view does not exist Ignore
6.0 CHF 3 to 6.1 When executing the data migration from 6.0 CHF 3 to Calyx RIM 6.1 (script DB Upgrade 60 CHF3 to 61), the following error messages appeared:
  • Line 146: Error creating indexes on table aud.GENERICLOAD ORA-00904: "DATASET_NAME": 
  • Line 363: ORA-00942: table or view does not exist 
  • Line 4344: ORA-02437: cannot validate (AUD.PKAPPLICANT_CONTACT) - primary key violated 
  • Line 4345: ORA-06512: at line 58 
  • Line 9644: ORA-00942: table or view does not exist 
  • Line 15517: Error creating indexes on table aud.GENERICLOAD ORA-00904: "DATASET_NAME":
Resolved with the Calyx RIM 6.1 CHF 1 database migration script.
6.0 CHF 7 to 6.1
  • ORA-24344: success with compilation error
  • ORA-06512: at line 115
Ignore

Liquent InSight 5.1

Upgrade path Error Description/Resolution
5.1 to 6.0 Any indexing or constraint errors regarding the following tables can be ignored:
  • Excipient
  • Active_ingredient
  • Prod_acting
  • Prodfam_acting
  • Pds_excip
  • Pds_excip_change
  • Concentration_unit_type
  • Fda_device_class_type
  • Eu_class_type
Also ignore the following error messages:
  • Warning: Package Body created with compilation errors. Errors for PACKAGE BODY ISM.PRODUCT_FAMILY_COPY: 285/26   PL/SQL: ORA-00942: table or view does not exist  
  • Revoke inherit privileges on system from dbo ERROR at line 1: ORA-00990: missing or invalid privilege revoke select any table privilege from aud ERROR at line 1: ORA-00990: missing or invalid privilege
Ignore

Example:

Error dropping constraint ACTIVE_INGREDIENT:PKACTIVE_INGREDIENT

ORA-02273: this unique/primary key is referenced by some foreign keys

Dropping index: ACTIVE_INGREDIENT:PKACTIVE_INGREDIENT Columns: ID-->

Error dropping index ACTIVE_INGREDIENT:PKACTIVE_INGREDIENT

ORA-02429: cannot drop index used for enforcement of unique/primary key

5.1 to 6.0 ORA-01543: tablespace 'IDX_IDMP' already exists Ignore
5.1 to 6.0 ORA-01543: tablespace 'DAT_IDMP' already exists Ignore
5.1 to 6.0 ORA-01543: tablespace 'IDX_DM' already exists Ignore
5.1 to 6.0 ORA-01543: tablespace 'DAT_DM' already exists Ignore
5.1 to 6.0 ORA-01918: all ORA-01918 messages Ignore
5.1 to 6.0 ORA-01919: all ORA-01919 messages Ignore
5.1 CHF 3 to 6.0 to 6.0 CHF 1 ORA-00955: name is already used by an existing object

CREATE TABLE MGR.REGULATORY_ACT_LEAD(

ERROR at line 1:

ORA-00955: name is already used by an existing object 

CREATE TABLE MGR.SEQ_DESCR_TYPE(

                 *

ORA-00001: unique constraint (MGR.UX1REGULATORY_ACT_LEAD) violated 

ORA-00001: unique constraint (MGR.UX1SEQ_DESCR_TYPE) violated

Ignore

Liquent InSight 5.0

Upgrade path Error Description/Resolution
5.0 or 5.0 CHF 6 to 5.1 ORA-01920: user name 'MIGRATION' conflicts with another user or role name The migration user already exists.
5.0 or 5.0 CHF 6 to 5.1 ora-01543: tablespace 'IDX_MIG' already exists The migration tablespace already exists.
5.0 or 5.0 CHF 6 to 5.1 ora-01543: tablespace 'DAT_MIG' already exists The migration tablespace already exists.
5.0 or 5.0 CHF 6 to 5.1 ORA-02296: cannot enable (ODS.) - null values found The data will be updated later in the migration, and the constraint on SETTINGS_PROFILE.LINK_STYLE_TYPE_ID will be added at that point.
5.0 or 5.0 CHF 6 to 5.1 ORA-02273: this unique/primary key is referenced by some foreign keys Ignore any index and constraint errors on asm_pub_settings/asm_pub_settings_profile tables.
5.0 or 5.0 CHF 6 to 5.1 ORA-02429: cannot drop index used for enforcement of unique/primary key Ignore any drop index errors on “enforcement of unique/primary key”.
5.0 or 5.0 CHF 6 to 5.1 ORA-00936: missing expression Ignore
5.0 or 5.0 CHF 6 to 5.1 ORA-04098: trigger 'ODS.UCNTNT' is invalid and failed re-validation Ignore
5.0 or 5.0 CHF 6 to 5.1 Any errors for the PACKAGE BODY ISM.PRODUCT_FAMILY_COPY: Ignore
The following are the common errors you might encounter when migrating to a subsequent version.
Table 1. Common Errors
Error Description
SP2-0310: unable to open file "define.passwords" Ignore
SP2-0310: unable to open file "define.application" Ignore
ORA-02264: name already used by an existing constraint DO NOT IGNORE. Call Technical Support