Lately we have had our IT department send us alerts that the database that Windchill is using has too many "inactive sessions". Often more than 150. While I know that inactive session is perfectly normal state for a particular session to be in, 150 inactive sessions still sounds a too many. Our guess is that for some reason Windchill is not releasing the sessions that it establishes with the database. What can we check/tweak to stop the inactive sessions from getting piled up?
Solved! Go to Solution.
We were able to fix the issue by setting the property wt.pom.connectionCloserIdleTimeout to a value of 1800. After setting this property we notice that db sessions get ternminated after they have been waiting for more than 1800 seconds (30mins) as intended. Pile up of inactive db sesions does not happen any more.
We were able to fix the issue by setting the property wt.pom.connectionCloserIdleTimeout to a value of 1800. After setting this property we notice that db sessions get ternminated after they have been waiting for more than 1800 seconds (30mins) as intended. Pile up of inactive db sesions does not happen any more.