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

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 0.25h
                0.25h

                  Git Source Code