Skip to main content
Anonymous
May 9, 2014
Question

java.sql.SQLException: Failed to get connection from Windchill:

  • May 9, 2014
  • 1 reply
  • 1139 views

Many time we are receiving below connectivity exception.

java.sql.SQLException:

Failed to get connection from Windchill:

Failed to get connection in the method Query.obtainConnection() - this.connection is null.

at com.lcs.wc.db.Query.obtainConnection(Query.java:377)

at com.lcs.wc.db.Query.prepareForQuery(Query.java:113)

at com.lcs.wc.db.Query.runPreparedQuery(Query.java:226)

at com.lcs.wc.db.Query.runQuery(Query.java:194)

at com.lcs.wc.foundation.LCSQuery.runDirectQuery(LCSQuery.java:251)

Windchill/FlexPLM version

Support Support Installer

Datecode Release Number Release Id Sequence Display Label

-- -------- -------------- --------------- --------- ---------------------

M060 9.1 pdml.9.1.60.12 03 Windchill PDMLink

M060 9.1 flexplm.9.2.10.41 01 FlexPLM Solution

M060 9.1 ie.9.1.60.12 03 Info*Engine

M060 9.1 wnc.9.1.60.12 03 Windchill Services

Below actions has been taken-

1)Checked database connectivity issue and DBA said everthing is ok from there side.

2)Network team also said everthing ok from there side.

3)Linux server team also didnt found any issue from there side.

########

Will have 4 clustered servers with windchill/Flexplm application running and max db connection from each slave is---

wt.pom.maxDbConnections=5

Will this issue solve with increasing maxdb connection?

Do any one facing same issue?

Thank you in advance.

Best Regards,

Amol

1 reply

ChrisSpartz13-Aquamarine
13-Aquamarine
May 15, 2014

Take a look at CS116762. This article indicates that this error message can be caused by the property wt.pom.maxDbConnections being set too low. Try increasing the value of this property. Then, restart Windchill and see if the error still occurs.

Terms & ConditionsAccessibility statement