1. Home
  2. Support
Article - CS14136

Error "Lost Connection SQLException: errorCode=17002" stops the MethodServer in Windchill PDMLink 9.1

Modified: 03-Sep-2015   


Applies To

  • Windchill PDMLink 9.1 M040 to M070

Description

  • MethodServer fails to reconnect which results in the MethodServer shutting down.
  • Many lost connection errors reported however MethodServer still up
  • Error in MethodServer log :
ERROR wt.pom.jdbc - *** SQLException caught ***
SocketThread###: WARN : wt.pom.jdbc - SQLState: null
SocketThread###: ######### [SocketThread###] WARN wt.pom.jdbc - SQLState: null
SocketThread###: WARN : wt.pom.jdbc - Message: Io exception: Socket read timed out
SocketThread###: ######### [SocketThread###] WARN wt.pom.jdbc - Message: Io exception: Socket read timed out
SocketThread###: WARN : wt.pom.jdbc - ErrorCode: 17002
SocketThread###: ######### [SocketThread###] WARN wt.pom.jdbc - ErrorCode: 17002
SocketThread###: WARN : wt.pom.jdbc -
SocketThread###: ######### [SocketThread###] WARN wt.pom.jdbc -
SocketThread###: Testing for lost connection: errorCode=17002 checkCodes=[3113, 3114, 12571, 17002, 17410, 17401, 17008, 1012]
SocketThread###: Lost Connection SQLException: errorCode=17002
SocketThread###: Testing for recoverable connection: errorCode=17002 checkCodes=[17002, 17008, 1012, 28]
SocketThread###: Attempting to reconnect...
SocketThread###: Reconnect failed: wt.pom.ConnectionException: A persistence error occurred. System message follows:
SocketThread###: (wt.pom.pomResource/0) wt.pom.PersistenceException: A persistence error occurred. System message follows:
SocketThread###: Nested exception is: java.sql.SQLException: Io exception: Socket read timed out
SocketThread###: wt.pom.ConnectionLostException: A SQL error has occurred. Database system message follows:
SocketThread###: Nested exception is: java.sql.SQLException: Io exception: Socket read timed out
SocketThread###: at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
This is a printer-friendly version of Article 14136 and may be out of date. For the latest version click CS14136