Article - CS423579

UpgradeManager fails at "Upgrade Database Schema" with "java.sql.SQLRecoverableException: Closed Connection"

Modified: 26-Jul-2024   


Applies To

  • Windchill PDMLink 12.1

Description

  • UpgradeManager fails at  Upgrade Database Schema task 
  • error in Upgrade.log:
Caused by: java.sql.SQLRecoverableException: Closed Connection

               at oracle.jdbc.driver.PhysicalConnection.prepareStatementInternal(PhysicalConnection.java:4086) ~[wc3rdpartylibs.jar:?]

               at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:4052) ~[wc3rdpartylibs.jar:?]

               at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3958) ~[wc3rdpartylibs.jar:?]

               at com.ptc.windchill.upgrade.dbservices.OracleDBHelper.getTableIndexNames(OracleDBHelper.java:214) ~[wnc.jar:?]

               ... 19 more
  • Error in the alert.log:
TNS-12599: TNS:cryptographic checksum mismatch

    ns secondary err code: 12656

    nt main err code: 0

    nt secondary err code: 0

    nt OS err code: 0

 
This is a printer-friendly version of Article 423579 and may be out of date. For the latest version click CS423579