Article - CS342020

PSI fails with "java.sql.SQLRecoverableException: IO Error" in Windchill PDMLink

Modified: 01-Apr-2021   


Applies To

  • Windchill PDMLink 12.0
  • Oracle 19c

Description

  • PTC Solution Installer validation fails when defining Oracle 19c DB settings
    • Connecting works when using SQL Developer 19 but fails when using SQL Developer 20
  • <PSI>/installer/logs/PTCSOLNINSTALLER_PtcInstall.log:
DEBUG  2021-03-15 18:21:05 - java.sql.SQLRecoverableException: IO Error: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond, Authentication lapse 0 ms. 
DEBUG  2021-03-15 18:21:05 - at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:882) 
DEBUG  2021-03-15 18:21:05 - at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793) 
DEBUG  2021-03-15 18:21:05 - at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57) 
DEBUG  2021-03-15 18:21:05 - at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747) 
DEBUG  2021-03-15 18:21:05 - at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562) 
DEBUG  2021-03-15 18:21:05 - at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677) 
DEBUG  2021-03-15 18:21:05 - at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
This is a printer-friendly version of Article 342020 and may be out of date. For the latest version click CS342020