Windchill Method Servers keep restarting.....

[ArturPonurski]

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)

[ddemay]

Mind sharing more of your log file?

Wondering if your Oracle version is causing this.


Sent from my Verizon Wireless BlackBerry

[PreetiGupta]

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

[MorganBelais]

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

[MorganBelais]

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