Article - CS274813
When using Oracle, loading fails with "SQLRecoverableException::IO" Error in Windchill Bulk Migrator
Modified: 31-Aug-2020
Applies To
- Windchill Bulk Migrator 11.0 to 11.1
- Oracle Database 12c, 12cR2, 19c
Description
- When using Oracle, loading fails with SQLRecoverableException::IO error
java.sql.SQLRecoverableException: IO Error: Got minus one from a read call, connect lapse 31 ms., Authentication lapse 0 ms.
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:794)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.ptc.windchill.migration.wbm.util.JDBCUtil.getJdbcConnection(JDBCUtil.java:273)
at com.ptc.windchill.migration.wbm.util.JDBCUtil.getConnection(JDBCUtil.java:160)
at com.ptc.windchill.migration.wbm.util.JDBCUtil.getStagingConnection(JDBCUtil.java:171)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.propagateWCIdsToRefTypeIBAs(CIIBARawDataHandler.java:318)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.consolidateRefTypeIBAs(CIIBARawDataHandler.java:256)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.traverseIBAResultSet(CIIBARawDataHandler.java:173)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.processIBAWormResultSet(CIIBARawDataHandler.java:100)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.processIBAs(CIIBARawDataHandler.java:85)
at com.ptc.wbm.ci.raw.CIOTRawDataHandler.plugIBAsToTxn(CIOTRawDataHandler.java:461)
at com.ptc.wbm.ci.raw.CIOTRawDataHandler.submitTransaction(CIOTRawDataHandler.java:406)
at com.ptc.wbm.ci.raw.CIOTRawDataHandler.processWormResultSet(CIOTRawDataHandler.java:295)
at com.ptc.wbm.ci.raw.CIOTRawDataHandler.processRawData(CIOTRawDataHandler.java:112)
at com.ptc.wbm.ci.core.CIOTHandler.run(CIOTHandler.java:130)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.IOException: Got minus one from a read call, connect lapse 31 ms., Authentication lapse 0 ms.
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:790)
... 19 more
Caused by: java.io.IOException: Got minus one from a read call, connect lapse 31 ms.
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:138)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:317)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518)
... 19 more
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.NIOHeader.readHeaderBuffer(NIOHeader.java:100)
at oracle.net.ns.NIOPacket.readNIOPacket(NIOPacket.java:252)
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:118)
... 22 more
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:794)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at com.ptc.windchill.migration.wbm.util.JDBCUtil.getJdbcConnection(JDBCUtil.java:273)
at com.ptc.windchill.migration.wbm.util.JDBCUtil.getConnection(JDBCUtil.java:160)
at com.ptc.windchill.migration.wbm.util.JDBCUtil.getStagingConnection(JDBCUtil.java:171)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.propagateWCIdsToRefTypeIBAs(CIIBARawDataHandler.java:318)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.consolidateRefTypeIBAs(CIIBARawDataHandler.java:256)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.traverseIBAResultSet(CIIBARawDataHandler.java:173)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.processIBAWormResultSet(CIIBARawDataHandler.java:100)
at com.ptc.wbm.ci.raw.CIIBARawDataHandler.processIBAs(CIIBARawDataHandler.java:85)
at com.ptc.wbm.ci.raw.CIOTRawDataHandler.plugIBAsToTxn(CIOTRawDataHandler.java:461)
at com.ptc.wbm.ci.raw.CIOTRawDataHandler.submitTransaction(CIOTRawDataHandler.java:406)
at com.ptc.wbm.ci.raw.CIOTRawDataHandler.processWormResultSet(CIOTRawDataHandler.java:295)
at com.ptc.wbm.ci.raw.CIOTRawDataHandler.processRawData(CIOTRawDataHandler.java:112)
at com.ptc.wbm.ci.core.CIOTHandler.run(CIOTHandler.java:130)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.IOException: Got minus one from a read call, connect lapse 31 ms., Authentication lapse 0 ms.
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:790)
... 19 more
Caused by: java.io.IOException: Got minus one from a read call, connect lapse 31 ms.
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:138)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:317)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518)
... 19 more
Caused by: oracle.net.ns.NetException: Got minus one from a read call
at oracle.net.ns.NIOHeader.readHeaderBuffer(NIOHeader.java:100)
at oracle.net.ns.NIOPacket.readNIOPacket(NIOPacket.java:252)
at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:118)
... 22 more
This is a printer-friendly version of Article 274813 and may be out of date. For the latest version click CS274813