ODI 11g Smart Export Fails with Error "ODI-10207: Uncategorized exception during transaction system usage" (Doc ID 1530129.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

When attempting to do a Smart Export with Oracle Data Integrator (ODI) 11g, the operation fails while calculating the dependencies, and the following message is signalled:

oracle.odi.core.persistence.transaction.TransactionSystemException: ODI-10207: Uncategorized exception during transaction system usage
Internal Exception: java.sql.SQLException: Protocol violation
Error Code: 17401
    at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.translateSpringTransactionException(TransactionManagerSpringAdapter.java:273)
    at oracle.odi.core.persistence.transaction.support.TransactionManagerSpringAdapter.rollback(TransactionManagerSpringAdapter.java:88)
    at oracle.odi.core.persistence.transaction.support.TransactionTemplate.rollbackOnException(TransactionTemplate.java:67)
    at oracle.odi.core.persistence.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:109)
    at com.sunopsis.dwg.smartie.SmartExportUtils.getDependencies(SmartExportUtils.java:2054)
    at com.sunopsis.dwg.smartie.SmartExportUtils.findUIDependencies(SmartExportUtils.java:3141)
    at oracle.odi.impexp.smartie.impl.DependencyServiceImpl.getDependencies(DependencyServiceImpl.java:141)
    at oracle.odi.ui.smartie.exp.ExportSmartDialog$3.doInBackground(ExportSmartDialog.java:1640)
    at oracle.odi.ui.smartie.exp.ExportSmartDialog$3.doInBackground(ExportSmartDialog.java:1)
    at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
    at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655)
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Protocol violation
Error Code: 17401
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.processExceptionForCommError(DatabaseAccessor.java:1494)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicRollbackTransaction(DatabaseAccessor.java:1584)
    at org.eclipse.persistence.internal.databaseaccess.DatasourceAccessor.rollbackTransaction(DatasourceAccessor.java:672)
    at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.rollbackTransaction(DatabaseAccessor.java:1569)
    at org.eclipse.persistence.internal.sessions.AbstractSession.basicRollbackTransaction(AbstractSession.java:588)
    at...

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