'Internal Exception: java.sql.SQLException: Protocol violation' Signalled When Performing a SmartExport Of a Large Project Folder In ODI 11.1.1.7.0 (Doc ID 1909012.1)

Last updated on APRIL 20, 2017

Applies to:

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

Symptoms

When attempting to perform a SmartExport of a large Project Folder from Oracle Data Integrator (ODI) version 11.1.1.7.0, the following exception 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)
  ...
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.exceptions.DatabaseException.sqlException(DatabaseException.java:333)
  ...
Caused by: java.sql.SQLException: Protocol violation
  at oracle.jdbc.driver.T4CTTIfun.readRXH(T4CTTIfun.java:640)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:362)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
  at oracle.jdbc.driver.T4C7Ocommoncall.doOROLLBACK(T4C7Ocommoncall.java:72)
  at oracle.jdbc.driver.T4CConnection.doRollback(T4CConnection.java:751)
  at oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java:5150)
  ...

Also the below exception is also observed for the same issue:

java.net.ConnectException: Connection timed out: connect
  at java.net.PlainSocketImpl.socketConnect(Native Method)
  at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
  at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
  at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
  at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
  at java.net.Socket.connect(Socket.java:529)
  at java.net.Socket.connect(Socket.java:478)
  at sun.net.NetworkClient.doConnect(NetworkClient.java:163)
  at sun.net.NetworkClient.openServer(NetworkClient.java:118)
  at sun.net.ftp.FtpClient.openServer(FtpClient.java:488)
  at sun.net.ftp.FtpClient.openServer(FtpClient.java:475)
  at sun.net.www.protocol.ftp.FtpURLConnection.connect(FtpURLConnection.java:270)
  at sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(FtpURLConnection.java:352)
  at javax.swing.JEditorPane.getStream(JEditorPane.java:811)
  at javax.swing.JEditorPane.setPage(JEditorPane.java:417)
  at com.sunopsis.graphical.component.OdiHtmlFrame.setHtmlText(OdiHtmlFrame.java:82)
  at com.sunopsis.graphical.component.OdiHtmlFrame.setXmlAndXsl(OdiHtmlFrame.java:103)
  at oracle.odi.ui.smartie.exp.ExportSmartReport.createExportReport(ExportSmartReport.java:360)
  at oracle.odi.ui.smartie.exp.ExportSmartDialog$2.doInBackground(ExportSmartDialog.java:1402)
  at oracle.odi.ui.smartie.exp.ExportSmartDialog$2.doInBackground(ExportSmartDialog.java:1)
  at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:655) at java.lang.Thread.run(Thread.java:662)

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