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

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

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

anetake
1-Newbie

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

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 1

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.

Top Tags