Hi,
We are having an issue with our Email softphone when multiple agents logged in and receiving mails, Contact server is throwing errors saying not enough connections to process the request. We are using Platform SDK 7.6 and connecting the way mentioned in the Genesys Documentation. But somehow it is not closing the connections after processing the requests. We have experimented with Interaction Workspace and it actually closing the connection.
Has anyone had this issue with SDK and any suggestions on how we can tell the Contact server to close the connections after processing a request?
We do close UcsServer connection when an agent log of and shutdown the softphone, but the problem we are facing is the contact server is not closing the opened SQL connections after a request made. It keeps it open and connections are running out and throwing the following error.
I attached the Code snippet which connects to UCS and the UCS error details shown below:
[color=purple]10:19:05.243 Trc 21124 [SvcSrvW-10] <22> Request (queued for 0 ms): Id=22|Type=Request|Service=OMInteractions|Method=G etInteractionsForContact.
10:19:05.243 Trc 21000 [SvcSrvW-10] <22 pc42421.axa-ap.intraxa:1406> Service 'OMInteractions' method 'GetInteractionsForContact' started.
10:19:05.243 Trc 21283 [SvcSrvW-10] <22 pc42421.axa-ap.intraxa:1406> Request:
Type=Request
Service=OMInteractions
Method=GetInteractionsForContact
Parameters=
[
TenantId=101
ContactId="00002a72N07001V6"
SearchCriteria=
[
EQUAL=
[
AttrValue="email"
AttrName="MediaTypeId"
]
]
]
UserData=
[
].
10:19:05.243 Dbg 29999 [SvcSrvW-10] <22> [Main DS] Acquiring new connection from pool (queue size: 4 current total nb of connections: 40 , free connections: 0 , used connections: 40 )
10:19:06.962 Trc 29998 [MemoryMon] 41 active thread(s) - memory usage : using 942,990,040 out of 1,046,937,600 (90.07%) (max=1,046,937,600)
10:19:06.962 Trc 29998 [DSFlowMon] default datasource request flow rate : 0.00 ops/sec - average connection wait : 0.00 ms/cnx
10:19:07.853 Trc 21284 [SvcSrvW-6] <92> JDBC: java.sql.SQLException: [SvcSrvW-6] Timeout: Pool empty. Unable to fetch a connection in 10 seconds, none available[40 in use].
10:19:07.853 Trc 21284 [SvcSrvW-6] <92> JDBC: at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowC onnection(ConnectionPool.java:592)
10:19:07.853 Trc 21284 [SvcSrvW-6] <92> JDBC: at org.apache.tomcat.jdbc.pool.ConnectionPool.getConn ection(ConnectionPool.java:166)
10:19:07.853 Trc 21284 [SvcSrvW-6] <92> JDBC: at com.genesyslab.util.sql.jdbc4.oracle.OracleDataSou rce.getConnection(OracleDataSource.java:235)
10:19:07.853 Trc 21284 [SvcSrvW-6] <92> JDBC: at com.genesyslab.icc.contactserver.ContactServerEngi ne.getTransaction(ContactServerEngine.java:1630)
10:19:07.853 Trc 21284 [SvcSrvW-6] <92> JDBC: at com.genesyslab.icc.contactserver.ContactServerEngi ne.getTransaction(ContactServerEngine.java:1616)
10:19:07.853 Trc 21284 [SvcSrvW-6] <92> JDBC: at com.genesyslab.icc.contactserver.service.NETIntera ctionServiceLogic.updateInteraction(NETInteraction ServiceLogic.java:1416)
[/color]
Jaison
