Windchill Method Servers keep restarting.....
Hi All,
We have cluster environment with 1 background method server on master and 3 foreground method servers on slave. For some unknown reason 3 method servers are keeping restarting (at different times) and they should be running continuously all the time I believe. Before each time they are restarting in Method Server logs we have errorCode=17410.
PTC recommendation is to add errorCode=17410 to wt.pom.recoverableConnectionCodes. This way Method Servers will not be restarting. I’m interested why we get errorCode=17410?
Error: ” No more data to read from socket” – I was told this is due to device (firewall) between database and windchill server. Interestingly enough there are no devices between them….
Our configuration:
Windchill 9.1 M50 on RHEL 5.5
Apache 2.2.14 (Unix)
Tomcat 5JDK 1.6.0_18
Database: Oracle 11g
Have any of you encountered similar situation or have any ideaswhat elsecould it be?TIA,
Art
Log:
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: ERROR : wt.pom.jdbc - *** SQLException caught ***Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: WARN : wt.pom.jdbc - SQLState: 08000
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: WARN : wt.pom.jdbc - Message: No more data to read from socket
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: WARN : wt.pom.jdbc - ErrorCode: 17410
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: WARN : wt.pom.jdbc -
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: ERROR : wt.pds - Lost Connection SQLException: errorCode=17410
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: ERROR : wt.pds - Shutting down
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: wt.pom.ConnectionLostException: A SQL error has occurred. Database system message follows:
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: Nested exception is: java.sql.SQLException: No more data to read from socket
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:133)
Mon 1/3/11 09:08:26: RMI TCP Connection(31151)-127.0.0.1: at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:134)