Changes between Version 3 and Version 4 of LEGACY - Query Tool and Analysis Types

Timestamp:

10/14/11 11:13:14 (13 years ago)

Author:

jeff.lusted

Comment:

--

LEGACY - Query Tool and Analysis Types

@@ -19 +19 @@
 
 '''NB:''' In the 1.5 data distribution for !SqlServer, there does seem to be an error, as Age does not appear within the ontology tree, even though there are inserts for Age into the ontology. Why is still unknown, but likely to be a trivial SQL discrepancy.
+
+Found it! In the job log, amongst the ontology inserts, this (and others occur):
+{{{
+[sql] Failed to execute:  INSERT INTO I2B2(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, UPDATE_DATE, DOWNLOAD_DATE, IMPORT_DATE, SOURCESYSTEM_CD, VALUETYPE_CD) 
+VALUES(2, '\i2b2\Demographics\Age\', 'Age', 'N', 'FA', NULL, NULL, NULL, 'concept_cd', 'concept_dimension', 'concept_path', 'T', 'LIKE', '\i2b2\Demographics\Age\', NULL, 'Demographics \ Age', NULL, NULL, NULL, 'DEM2FACT CONVERT', NULL)
+[sql] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'UPDATE_DATE', table 'i2b2metadata.dbo.I2B2'; column does not allow nulls. INSERT fails.
+}}}