SQLException: Maximum number of open connections reached after 20 retries - In Marketing Web Survey Daemon Running A Survey (Doc ID 1917939.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Siebel Campaign Management - Version 8.2.2 SIA[22320] and later
Information in this document applies to any platform.

Symptoms

On :  8.2.2 SIA[22320] version, Siebel Marketing

When attempting to create Marketing surveys with 16 sequences averaging 8 questions and 10 answers apiece, the database hangs after several successful cycles with the following errors in the responseprocessor.log:

ERROR
-----------------------

responseprocessor.log

Connection failure processing file dataq.0000000004
...
Caused by: java.sql.SQLException: Maximum number of open connections reached after 20 retries.
 

Caused by: java.sql.SQLException: Maximum number of open connections reached after 20 retries.
at com.medpool.communicator.connection.DBConnectionPool.getConnection(DBConnectionPool.java:427)
at com.medpool.communicator.connection.DBConnectionPoolManager.getConnection(DBConnectionPoolManager.java:79)
at oracle.apps.sem.wsd.response.ResponseDataProcessor.process(ResponseDataProcessor.java:132)
... 2 more


ERROR
----------------------
websurveys.log:

[SurveyResponseDeleterDaemon] ERROR com.medpool.communicator.runtime.services.DBAccess - Error thrown in getConnection
java.sql.SQLException: Maximum number of open connections reached after 20 retries.

STEPS
-----------------------
Create a Marketing Survey

Submit Survey Mutiple times- say 10 times


BUSINESS IMPACT
-----------------------
The issue has the following business impact:

Due to this issue, survey creation and processing fails in Preproduction and Production.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms