[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

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

Ascending order - Click to sort in descending order

Jeff Cox created issue - 20/Mar/15 10:28 AM

Janice Donahoe made changes - 23/Mar/15 11:46 AM

Field	Original Value	New Value
Component/s		Data [ 10050 ]
Assignee		Lori Phillips [ lcp5 ]
i2b2 Sponsored Project/s		i2b2 Core [ 10196 ]
Status	New [ 10000 ]	Open [ 1 ]

Permalink

Lori Phillips logged work - 23/Mar/15 1:26 PM

Time Spent:

0.25h

<No comment>

Lori Phillips made changes - 23/Mar/15 1:26 PM

Status

Open [ 1 ]

In Progress [ 3 ]

Lori Phillips made changes - 23/Mar/15 1:27 PM

Worklog Id	10100 [ 10100 ]
Remaining Estimate		0d [ 0 ]
Time Spent		0.25h [ 900 ]

Lori Phillips made changes - 23/Mar/15 1:27 PM

Developer Notes		I few lines in both sqlserver and oracle were missing an 'NULL' in insert resulting in 'not enought values' errors.
Fix Version/s		1.7.05 [ 10164 ]
Status	In Progress [ 3 ]	Ready to Test [ 10001 ]

Lori Phillips made changes - 23/Mar/15 1:28 PM

Assignee

Lori Phillips [ lcp5 ]

Janice Donahoe [ jmd86 ]

Janice Donahoe made changes - 23/Mar/15 2:47 PM

Status

Ready to Test [ 10001 ]

Testing [ 10002 ]

Janice Donahoe made changes - 23/Mar/15 2:52 PM

SVN Revision Number		5311
Status	Testing [ 10002 ]	Testing [ 10002 ]

Janice Donahoe made changes - 23/Mar/15 2:54 PM

Affects Database/s		All databases [ 10219 ]
Affects Version/s		1.7.04 [ 10160 ]

Janice Donahoe made changes - 30/Mar/15 11:02 AM

Resolution		Fixed [ 1 ]
Status	Testing [ 10002 ]	Resolved [ 5 ]

Janice Donahoe added a comment - 12/May/15 10:51 AM

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

Janice Donahoe added a comment - 12/May/15 10:51 AM 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 ).

Janice Donahoe made changes - 12/May/15 10:51 AM

Status

Resolved [ 5 ]

Closed [ 6 ]

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

i2b2 Core Software

Details

Description

Attachments

Activity

People

Dates

Time Tracking