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