When I have tried to import LOINC content using the "Subscription Import Wizard" I have errors. I have posted a piece of the log file just in case you could help me.


2014-03-05 12:31:14.226 INFO apelon.data.db [Thread-5] com.apelon.dts.db.admin.ResumeController.getLastTableImported() - #### Found last table import [DTS_CONCEPT_PROPERTY_ARCH] for version [2.42.12AB] and update type [full]
2014-03-05 12:31:14.230 INFO apelon.data.db [Thread-5] com.apelon.dts.db.admin.ResumeController.isThisTableFullyImported() - #### Table [DTS_CONCEPT_PROPERTY_ARCH, importCategory=full] isTableFullyImported =false for version [2.42.12AB] and update type [full]
2014-03-05 12:31:14.231 INFO apelon.data.db [Thread-5] com.apelon.dts.db.admin.ResumeController.getLastImportLineNumber() - #### Found last import line [1192500] for version [2.42.12AB] and update type [full]
2014-03-05 12:31:14.955 INFO apelon.data.db [Thread-5] com.apelon.dts.db.admin.DTSBaseTable.getRevisionNotRetiredDate() - Found version [NOT_RETIRED] with revision_date 2050-1-1 12:0:0. 0
2014-03-05 12:31:16.096 ERROR apelon.data.db [Thread-5] com.apelon.dts.db.admin.data.handler.TableImporter.logBatchUpdateError() - Error occured (BatchUpdateException) while importing file C:\Program Files\Apelon DTS 4.0\bin\data\5102\DTS_CONCEPT_PROPERTY_ARCH.full\
java.sql.BatchUpdateException: ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor
ORA-06512: en "DTS4.DTS_CON_PROP_ARCH_BITRG", línea 3
ORA-04088: error durante la ejecución del disparador 'DTS4.DTS_CON_PROP_ARCH_BITRG'

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9409)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)
at com.apelon.dts.db.admin.data.handler.TableImporter.executeBatch(TableImporter.java:530)
at com.apelon.dts.db.admin.data.handler.TableImporter.importTable(TableImporter.java:484)
at com.apelon.dts.db.admin.DTSBaseTable.processTableImport(DTSBaseTable.java:2324)
at com.apelon.dts.db.admin.DTSBaseTable.processFullImport(DTSBaseTable.java:1852)
at com.apelon.dts.db.admin.DTSBaseTable.processImport(DTSBaseTable.java:1831)
at com.apelon.dts.db.admin.DTSBaseTable.importTable(DTSBaseTable.java:3093)
at com.apelon.dts.db.admin.DTSBaseTable.importData(DTSBaseTable.java:3051)
at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:604)
at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:544)
at com.apelon.dts.db.admin.DbContentMgr.run(DbContentMgr.java:396)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.importNamespace(KBImportTask.java:411)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.<init>(KBImportTask.java:174)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$1.construct(KBImportTask.java:126)
at com.apelon.apps.dts.kbimport.gui.progressbar.SwingWorker$2.run(SwingWorker.java:168)
at java.lang.Thread.run(Unknown Source)
2014-03-05 12:31:16.110 INFO apelon.data.db [Thread-5] com.apelon.dts.db.admin.data.handler.TableImporter.rollbackTransaction() - Rollback on last transaction as exception handled.
2014-03-05 12:31:16.110 ERROR apelon.data.db [Thread-5] com.apelon.dts.db.admin.DTSBaseTable.importData() - BaseTable: import
java.sql.BatchUpdateException: ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor
ORA-06512: en "DTS4.DTS_CON_PROP_ARCH_BITRG", línea 3
ORA-04088: error durante la ejecución del disparador 'DTS4.DTS_CON_PROP_ARCH_BITRG'

at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:629)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9409)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:211)
at com.apelon.dts.db.admin.data.handler.TableImporter.executeBatch(TableImporter.java:530)
at com.apelon.dts.db.admin.data.handler.TableImporter.importTable(TableImporter.java:484)
at com.apelon.dts.db.admin.DTSBaseTable.processTableImport(DTSBaseTable.java:2324)
at com.apelon.dts.db.admin.DTSBaseTable.processFullImport(DTSBaseTable.java:1852)
at com.apelon.dts.db.admin.DTSBaseTable.processImport(DTSBaseTable.java:1831)
at com.apelon.dts.db.admin.DTSBaseTable.importTable(DTSBaseTable.java:3093)
at com.apelon.dts.db.admin.DTSBaseTable.importData(DTSBaseTable.java:3051)
at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:604)
at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:544)
at com.apelon.dts.db.admin.DbContentMgr.run(DbContentMgr.java:396)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.importNamespace(KBImportTask.java:411)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.<init>(KBImportTask.java:174)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$1.construct(KBImportTask.java:126)
at com.apelon.apps.dts.kbimport.gui.progressbar.SwingWorker$2.run(SwingWorker.java:168)
at java.lang.Thread.run(Unknown Source)
2014-03-05 12:31:16.110 ERROR apelon.app [Thread-5] com.apelon.dts.db.admin.DbContentMgr.run() - Exception running DbContentMgr
java.sql.SQLException: unable import data: ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor
ORA-06512: en "DTS4.DTS_CON_PROP_ARCH_BITRG", línea 3
ORA-04088: error durante la ejecución del disparador 'DTS4.DTS_CON_PROP_ARCH_BITRG'

at com.apelon.dts.db.admin.DTSBaseTable.importData(DTSBaseTable.java:3062)
at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:604)
at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:544)
at com.apelon.dts.db.admin.DbContentMgr.run(DbContentMgr.java:396)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.importNamespace(KBImportTask.java:411)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.<init>(KBImportTask.java:174)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$1.construct(KBImportTask.java:126)
at com.apelon.apps.dts.kbimport.gui.progressbar.SwingWorker$2.run(SwingWorker.java:168)
at java.lang.Thread.run(Unknown Source)
2014-03-05 12:31:16.112 ERROR apelon.data.db [Thread-5] com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.<init>() - unable import data: ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor
ORA-06512: en "DTS4.DTS_CON_PROP_ARCH_BITRG", línea 3
ORA-04088: error durante la ejecución del disparador 'DTS4.DTS_CON_PROP_ARCH_BITRG'

java.sql.SQLException: unable import data: ORA-06502: PL/SQL: error : buffer de cadenas de caracteres demasiado pequeño numérico o de valor
ORA-06512: en "DTS4.DTS_CON_PROP_ARCH_BITRG", línea 3
ORA-04088: error durante la ejecución del disparador 'DTS4.DTS_CON_PROP_ARCH_BITRG'

at com.apelon.dts.db.admin.DTSBaseTable.importData(DTSBaseTable.java:3062)
at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:604)
at com.apelon.dts.db.admin.DbContentMgr.importTables(DbContentMgr.java:544)
at com.apelon.dts.db.admin.DbContentMgr.run(DbContentMgr.java:396)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.importNamespace(KBImportTask.java:411)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$ActualTask.<init>(KBImportTask.java:174)
at com.apelon.apps.dts.kbimport.gui.progressbar.KBImportTask$1.construct(KBImportTask.java:126)
at com.apelon.apps.dts.kbimport.gui.progressbar.SwingWorker$2.run(SwingWorker.java:168)
at java.lang.Thread.run(Unknown Source)
2014-03-05 12:31:21.473 INFO apelon.app [AWT-EventQueue-0] com.apelon.apps.dts.kbimport.gui.FinishWizardPanel.finish() - Successfully closed the database connection.


Thanks

Its hard to tell exactly what the problem is, but we believe it may be due to your Oracle configuration. Here are some suggestions:
1. Oracle needs to be set up for UTF-8 data.
2. It appears you are using Oracle Express – we know there are database size limitations with this package which could affect your ability to load LOINC, especially if you have loaded other Namespaces.

So ¿Do you suggest me to use other DBMS or tu tune my Oracle instance?

By the way I've heard that this version of Apelon DTS is not stable ¿Do you recommend me to use Apelon DTS 3.5 instead?


Thanks in advance

In addition this is my Oracle instance charset:

SQL> SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

VALUE$
-------------------------------------------------------------------------

AL32UTF8

We've done additional testing in-house on your issue and have not been able to reproduce on standard platforms, so I don't think tuning would help. Oracle Express Edition is not a supported platform, so we would suggest you try to use one of the supported DBMS versions. This would apply whether you stay with 4.0 or go to 3.5.2.

Not quite sure what you mean by "unstable" but we have many clients testing and evaluating DTS 4.0 and a number are running in production. We have had a few "growing pains" with web services support, but these have been resolved. See the FAQ and other Forum entries for additional information.

Please do keep us up-to-date with your progress.

I think that my problem could be related to tablespaces size. ¿What is the minimun size for Oracle tablespaces?

Now this is my configuration:

The required size is dependent on the amount of data you will be loading, but for LOINC alone, allocate at least 2.5GB to the DTS Oracle tablespace.

I tried with Orecle SE 11g and it worked!! Thanks!!

Excellent! Glad you're back on track.