[CORE-167] Metadata data install error Created: 20/Mar/15 Updated: 12/May/15 Resolved: 30/Mar/15 |
|
| Status: | Closed |
| Project: | i2b2 Core Software |
| Component/s: | Data |
| Affects Version/s: | 1.7.04 |
| Fix Version/s: | 1.7.05 |
| Type: | Bug | Priority: | Major |
| Reporter: | Jeff Cox | Assignee: | Janice Donahoe |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | 0d | ||
| Time Spent: | 0.25h | ||
| Original Estimate: | Not Specified | ||
| 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. |
| Participant/s: |
| 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 |
| Comments |
| Comment by Janice Donahoe [ 12/May/15 ] |
| Version 1.7.05 of the i2b2 Software has been released and is available for download on the i2b2 website (http://www.i2b2.org/software). |