Support Article
ConnectionWaitTimeoutExceptions observed during makeDecision
SA-3425
Summary
ConnectionWaitTimeoutExceptions occurred during the makeDecision() call and below exception thrown
Connection not available while invoking method createOrWaitForConnection for resource jdbc/rtdsDataSource.
AsyncADSInput E com.kiq.omega.ods.core.AsyncADSInputCacheWorkManagerImpl$1 run Unable to insert inputs -
java.lang.RuntimeException: Failed to insert the inputs
at com.kiq.omega.ods.core.AsyncADSInputCacheWorkManagerImpl.persistInputs(AsyncADSInputCacheWorkManagerImpl.java:245)
at com.kiq.omega.ods.core.AsyncADSInputCacheWorkManagerImpl.access$0(AsyncADSInputCacheWorkManagerImpl.java:229)
at com.kiq.omega.ods.core.AsyncADSInputCacheWorkManagerImpl$1.run(AsyncADSInputCacheWorkManagerImpl.java:134)
Error Messages
Connection not available while invoking method createOrWaitForConnection for resource jdbc/rtdsDataSource.
AsyncADSInput E com.kiq.omega.ods.core.AsyncADSInputCacheWorkManagerImpl$1 run Unable to insert inputs -
java.lang.RuntimeException: Failed to insert the inputs
at com.kiq.omega.ods.core.AsyncADSInputCacheWorkManagerImpl.persistInputs(AsyncADSInputCacheWorkManagerImpl.java:245)
Steps to Reproduce
Invoke Real Time Decisioning Service(RTDS) makeDecision() and Adaptive Decisioning Service (ADS) updateAdaptiveModel() calls concurrently in load environment to create load on the rtdsDataSource.
Root Cause
When the user load increases, requests will be in queue and response times goes up. Because of the high volume requests and less number of connections available, inserting ads inputs will take time and update response fails.
Resolution
Max Connections parameter in the data source connection pool needs to be fine-tuned based on the user request load or rtdsDataSource WaitingThreadCount(Average number of threads that are concurrently waiting for connection)
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.