I am attempting to import only RxNORM and am seeing the following error. Any way to get past this? The same exception is reported even if I choose only ICD9, or SNOMED-CT, or LOINC, or a all of them together. 2014-09-22 05:20:15.343 INFO apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.importData() - ---- Importing into table DTS_NAMESPACE 2014-09-22 05:20:15.344 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.kbcontentDropConstraints() - numSourceFileLines = 1.0 2014-09-22 05:20:15.344 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.kbcontentDropConstraints() - targetTableSize = 0.0 2014-09-22 05:20:15.344 INFO apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.processTableImport() - * Working on namespace [RxNorm R], with property add=true [category=full] 2014-09-22 05:20:15.345 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Retreiving Table Header Information : 2014-09-22 05:20:15.346 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - GID with type number 2014-09-22 05:20:15.346 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - ID with type number 2014-09-22 05:20:15.346 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - CODE with type string 2014-09-22 05:20:15.346 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - NAME with type string 2014-09-22 05:20:15.346 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - NAMESPACE_ID with type number 2014-09-22 05:20:15.346 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - RELEASE_DATE with type date 2014-09-22 05:20:15.347 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Retreiving Table Header Information : 2014-09-22 05:20:15.348 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - GID with type number 2014-09-22 05:20:15.348 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - ID with type number 2014-09-22 05:20:15.348 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - CODE with type string 2014-09-22 05:20:15.348 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - NAME with type string 2014-09-22 05:20:15.348 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - NAMESPACE_ID with type number 2014-09-22 05:20:15.348 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - RELEASE_DATE with type date 2014-09-22 05:20:15.349 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.ResumeController.initStatusMgr() - ---- Initializing import status manager... 2014-09-22 05:20:15.349 DEBUG apelon.data.db [Thread-3] com.apelon.common.sql.SQL.checkTableExists() - SELECT count(*) AS value FROM information_schema.TABLES WHERE table_schema = SCHEMA() and UPPER(table_name) = UPPER('DTS_IMPORT_STATUS') 2014-09-22 05:20:15.350 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.getBaseTableName() - No base table found for DTS_NAMESPACE 2014-09-22 05:20:15.350 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.processTableImport() - importCategory=full 2014-09-22 05:20:15.350 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.processTableImport() - indexConstrDropped=false 2014-09-22 05:20:15.350 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.getImportStatement() - Using table 'DTS_NAMESPACE' import statement [insert into dts_namespace (id, name, code, referenced_by, authority_id, is_local, is_writeable, has_semantic_types , namespace_type, base_namespace_id,action) values (?,?,?,?,?,?,?,?,?,?,'S')] 2014-09-22 05:20:15.350 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.DTSBaseTable.getBaseTableImportStatement() - No base table import statement found for DTS_NAMESPACE 2014-09-22 05:20:15.351 INFO apelon.data.db [Thread-3] com.apelon.dts.db.admin.ResumeController.getLastTableImported() - #### Found last table import [DTS_NAMESPACE] for version [2008.AA.b] and update type [full] 2014-09-22 05:20:15.354 INFO apelon.data.db [Thread-3] com.apelon.dts.db.admin.ResumeController.isThisTableFullyImported() - #### Table [DTS_NAMESPACE, importCategory=full] isTableFullyImported =false for version [2008.AA.b] and update type [full] 2014-09-22 05:20:15.355 INFO apelon.data.db [Thread-3] com.apelon.dts.db.admin.ResumeController.getLastImportLineNumber() - #### Found last import line [0] for version [2008.AA.b] and update type [full] 2014-09-22 05:20:15.364 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.ImportStatusMgr.updateStatusWithTableInfo() - Updated [1] of import status table 2014-09-22 05:20:15.370 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Retreiving Table Header Information : 2014-09-22 05:20:15.370 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - ID with type number 2014-09-22 05:20:15.370 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - NAME with type string 2014-09-22 05:20:15.371 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - CODE with type string 2014-09-22 05:20:15.371 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - REFERENCED_BY with type string 2014-09-22 05:20:15.371 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - AUTHORITY_ID with type number 2014-09-22 05:20:15.371 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - IS_LOCAL with type string 2014-09-22 05:20:15.371 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - IS_WRITEABLE with type string 2014-09-22 05:20:15.371 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - HAS_SEMANTIC_TYPES with type string 2014-09-22 05:20:15.371 DEBUG apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.parseHeader() - Found header - NAMESPACE_TYPE with type string 2014-09-22 05:20:15.373 ERROR apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.logError() - Error occured (java.sql.SQLException) while importing line #[2] of file /home/ad/local/apelon/imports/data/1552/DTS_NAMESPACE.full/ java.sql.SQLException: No value specified for parameter 10 java.sql.SQLException: No value specified for parameter 10 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) at com.mysql.jdbc.PreparedStatement.checkAllParametersSet(PreparedStatement.java:2611) at com.mysql.jdbc.PreparedStatement.addBatch(PreparedStatement.java:1032) at com.apelon.dts.db.admin.data.handler.TableImporter.importRow(TableImporter.java:656) at com.apelon.dts.db.admin.data.handler.TableImporter.importTable(TableImporter.java:449) at com.apelon.dts.db.admin.DTSBaseTable.processTableImport(DTSBaseTable.java:2354) at com.apelon.dts.db.admin.DTSBaseTable.processFullImport(DTSBaseTable.java:1854) at com.apelon.dts.db.admin.DTSBaseTable.processImport(DTSBaseTable.java:1833) at com.apelon.dts.db.admin.DTSBaseTable.importTable(DTSBaseTable.java:3123) at com.apelon.dts.db.admin.DTSBaseTable.importData(DTSBaseTable.java:3081) at com.apelon.dts.db.admin.impl.dbcontentmgr.importtables.ImportTables.importTables(ImportTables.java:28) at com.apelon.dts.db.admin.impl.dbcontentmgr.importtables.ImportTables.importTables(ImportTables.java:15) at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:546) at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:566) at com.apelon.dts.db.admin.DbContentMgr.run(DbContentMgr.java:428) at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.importNamespace(KBImportTask.java:361) at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.<init>(KBImportTask.java:161) at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$1.construct(KBImportTask.java:113) at com.apelon.apps.dts.kbimport.gui.progressbar.SwingWorker$2.run(SwingWorker.java:168) at java.lang.Thread.run(Thread.java:744) 2014-09-22 05:20:15.376 INFO apelon.data.db [Thread-3] com.apelon.dts.db.admin.data.handler.TableImporter.rollbackTransaction() - Rollback on last transaction as exception handled.
|