ODI 11g Smart Export Fails with Error "ODI-10207: Uncategorized exception during transaction system usage"
(Doc ID 1530129.1)
Last updated on SEPTEMBER 10, 2021
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...
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |