cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Windchill Method Servers keep restarting.....

Highlighted
Participant

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 5

JDK 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)

4 REPLIES 4
Highlighted

Windchill Method Servers keep restarting.....

Mind sharing more of your log file?

Wondering if your Oracle version is causing this.


Sent from my Verizon Wireless BlackBerry
Highlighted

Windchill Method Servers keep restarting.....

I have seen this problem in couple of months ago in our production system. Please add 17410 in this line in the "site.xconf". It should work just fine.

<property name="wt.pom.recoverableConnectionCodes" overridable="true"&lt;br"/> targetFile="db/db.properties"
value="28,1012,17002,17008,3113,3114,12571,17410,17401"/>

Thanks,
Preeti
Highlighted

RE: Windchill Method Servers keep restarting.....

Hello,



We just discovered that the JDBC version bundled with Windchill 9.1 is not supported by Oracle 11G.


TS has just published a how to update the driver :


https://www.ptc.com/appserver/cs/view/solution.jsp?n=kA1A00000000J3jKAE



Morgan

Highlighted

RE: Windchill Method Servers keep restarting.....

I forgot to say that we were facing ORA-17410 errors, and according to ORacle/Metalink that's because of the not supported driver.



Morgan

Announcements
LiveWorx Call For Papers Happening Now!