"ODI-10207: Uncategorized exception during transaction system usage" Error When Importing a Datastore Using OdiImportObject Tool

(Doc ID 2335757.1)

Last updated on JUNE 11, 2018

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

When attempting to import a datastore object into Oracle Data Integrator (ODI) using the OdiImportObject tool, the below error occurs:

[odi] [ERROR] [] [oracle.odi.agent] [tid: 1] [ecid: xxxxxxxxxxxxxxxx1,0] Executing: OdiImportObject "-FILE_NAME=FILE_TO_IMPORT.xml" "-WORK_REP_NAME=ODIWORK" "-IMPORT_MODE=SYNONYM_INSERT_UPDATE" [[
java.lang.RuntimeException: oracle.odi.oditools.OdiToolException: Error while running ODI Tool OdiImportObject
  at oracle.odi.oditools.OdiAbstractToolRunner$4.doAction(OdiAbstractToolRunner.java:255)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:173)
  at oracle.odi.oditools.OdiAbstractToolRunner.executeConnectedCoreTool(OdiAbstractToolRunner.java:245)........
Caused by: oracle.odi.oditools.OdiToolException: Error while running ODI Tool OdiImportObject
  at oracle.odi.oditools.OdiAbstractToolRunner.executeTool(OdiAbstractToolRunner.java:194)
  at oracle.odi.oditools.OdiAbstractToolRunner.access$000(OdiAbstractToolRunner.java:28)
  at oracle.odi.oditools.OdiAbstractToolRunner$4.doAction(OdiAbstractToolRunner.java:253)
  ... 5 more
Caused by: oracle.odi.core.persistence.transaction.TransactionSystemException: ODI-10207: Uncategorized exception during transaction system usage.
Transaction "rolled back" because transaction was set to RollbackOnly.

  at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.translateSpringTransactionException(TransactionManagerSpringAdapter.java:286)
  at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.commit(TransactionManagerSpringAdapter.java:71)
  ...

The same data store object is imported successfully using the "Import Datastore..." option at the level of the model.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms