My Oracle Support Banner

Error "ORA-02290: check constraint" Running the Variant KB Loader for PharmGKB and PharmVar Sources (Doc ID 2624479.1)

Last updated on APRIL 08, 2021

Applies to:

Oracle Healthcare Omics - Version 3.2.2 and later
Information in this document applies to any platform.

Symptoms

Translational Research/OMICS, you receive the following error message when running the Variant KB Loader for PharmGKB and PharmVar sources:


ERROR
========
Description: ORA-02290: check constraint (ODB.W_EHA_VERSION_CKC2) violated
Trace: ORA-06512: at "ODB.ODB_UTIL", line 408
ORA-06512: at "ODB.ODB_UTIL", line 400
ORA-06512: at "ODB.ODB_REF_PHARMGX_UTIL", line 657

ORA-02290: check constraint (ODB.W_EHA_VERSION_CKC2) violated
ORA-06512: at "ODB.ODB_UTIL", line 408
ORA-01403: no data found
ORA-06512: at "ODB.ODB_UTIL", line 400



STEPS TO REPLICATE
====================
1. Run the loader Variant KB Loader for PharmGKB and PharmVar sources (ODB_REF_PHARMGX_UTIL.process_pharmgx and pass the parameters):

Command Used
  ODB_REF_PHARMGX_UTIL.process_pharmgx(
  i_data_directory => '<DATA_DIRECTORY>',
  i_annotation_src_name => '<SRC_NAME>',
  i_annotation_src_version => '<SRC_VERSION>',
  i_haplotype_transl_file_name => '<FILE_NAME>',
  i_haplotype_transl_src_name => '<SRC_NAME>',
  i_haplotype_transl_src_version => '<SRC_VERSION>',
  i_haplotype_transl_assembly => null,
  i_preprocess_dir => null,
  i_preprocess_file => null,
  i_debug => null
)

Properties
  Start Date: 2019-12-11 10:31:50
  ETL Process ID: <PROCESS_ID>
  DB User: <ODB_USER>
  OS User: <OS_USER>
  Hostname: <HOST_NAME>
  End Date: 2019-12-11 10:31:50
  Status: FAILURE

2. Results in the aforementioned error message.

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.