[CORE-167] Metadata data install error - i2b2 JIRA

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Fixed
Affects Version/s: 1.7.04
Fix Version/s: 1.7.05
Component/s: Data
Labels:
None

Rank:
0|i001qf:

i2b2 Sponsored Project/s:

i2b2 Core

Affects Database/s:

All databases

Developer Notes:
I few lines in both sqlserver and oracle were missing an 'NULL' in insert resulting in 'not enought values' errors.

Description

[root@i2b2 Metadata]# ant -f data_build.xml db_metadata_load_data
Buildfile: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/data_build.xml

init:

db_metadata_load_data:
     [echo] Loading metadata -- may take a while; over 10 min
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/schemes_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/table_access_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/birn_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/custom_meta_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_demographics_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_diagnoses_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_expressions_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_labtests_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_medications_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_modifiers_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_procedures_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_providers_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_reports_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/i2b2_metadata_visitDetails_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/icd10_icd9_diagnoses_insert_data.sql
      [sql] Executing resource: /opt/edu.harvard.i2b2.data/Release_1-7/NewInstall/Metadata/demo/scripts/oracle/icd10_icd9_modifiers_insert_data.sql
      [sql] Failed to execute: INSERT INTO ICD10_ICD9(C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_TOTALNUM, C_BASECODE, C_METADATAXML, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_COMMENT, C_TOOLTIP, M_APPLIED_PATH, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, VALUETYPE_CD, M_EXCLUSION_CD, C_PATH, C_SYMBOL) VALUES(1, '\Secondary Diagnosis\', 'Secondary Diagnosis', 'N', 'RA ', NULL, '2', NULL, 'MODIFIER_CD', 'MODIFIER_DIMENSION', 'MODIFIER_PATH', 'T', 'LIKE', '\Secondary Diagnosis\', NULL, 'Secondary Diagnosis', '\Diagnoses\(C00-D49) Neop~k3n8\%', TO_DATE('2014-05-05', 'YYYY-MM-DD'), NULL, NULL, NULL, NULL, NULL, NULL)
      [sql] java.sql.SQLException: ORA-00947: not enough values
      [sql] Failed to execute: INSERT INTO ICD10_ICD9(C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_TOTALNUM, C_BASECODE, C_METADATAXML, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_COMMENT, C_TOOLTIP, M_APPLIED_PATH, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, VALUETYPE_CD, M_EXCLUSION_CD, C_PATH, C_SYMBOL) VALUES(1, '\Secondary Diagnosis\', 'Secondary Diagnosis', 'N', 'RA ', NULL, '2', NULL, 'MODIFIER_CD', 'MODIFIER_DIMENSION', 'MODIFIER_PATH', 'T', 'LIKE', '\Secondary Diagnosis\', NULL, 'Secondary Diagnosis', '\Diagnoses\(E00-E89) Endo~c157\%', TO_DATE('2014-05-05', 'YYYY-MM-DD'), NULL, NULL, NULL, NULL, NULL, NULL)
      [sql] java.sql.SQLException: ORA-00947: not enough values
      [sql] Failed to execute: INSERT INTO ICD10_ICD9(C_HLEVEL, C_FULLNAME, C_NAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_TOTALNUM, C_BASECODE, C_METADATAXML, C_FACTTABLECOLUMN, C_TABLENAME, C_COLUMNNAME, C_COLUMNDATATYPE, C_OPERATOR, C_DIMCODE, C_COMMENT, C_TOOLTIP, M_APPLIED_PATH, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, VALUETYPE_CD, M_EXCLUSION_CD, C_PATH, C_SYMBOL) VALUES(1, '\Admit Diagnosis\', 'Admit Diagnosis', 'N', 'RA ', NULL, '0', NULL, 'MODIFIER_CD', 'MODIFIER_DIMENSION', 'MODIFIER_PATH', 'T', 'LIKE', '\Admit Diagnosis\', NULL, 'Admit Diagnosis', '\Diagnoses\(E00-E89) Endo~c157\%', TO_DATE('2014-05-05', 'YYYY-MM-DD'), NULL, NULL, NULL, NULL, NULL, NULL)
      [sql] java.sql.SQLException: ORA-00947: not enough values
      [sql] 272914 of 272917 SQL statements executed successfully

Attachments

Activity

People

Assignee:

Janice Donahoe

Reporter:

Jeff Cox

Participant/s:

Janice Donahoe, Jeff Cox

Votes:

0 Vote for this issue

Watchers:

2 Start watching this issue

Dates

Created:

20/Mar/15 10:28 AM

Updated:

12/May/15 10:51 AM

Resolved:

30/Mar/15 11:02 AM

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

0.25h