IPCC Database integeration

Unanswered Question
May 14th, 2008
User Badges:

Hi all,

we have an ipcc 7.1.4 based Contact center. Every thing was working fine for the last one year.From the last 2 days, Oracle CRM Database team start complaining that due to thousands of sessions between odbc gateway and database, Database can be hangup or crash. Database side is running a script which kill the inactive sessions after every 10 minutes but it is failing to do so because of excessive connections.

According to the LLD document, we commit that only 10 connection will be active per odbc gateway at a time and we are using 3 side A and 3 side B odbc gateways so the number of session would not exceed 60 at the most.

Well! Through Solarwind we found that 147 tcp connections are there from our 6 odbc gateways to remote Database.

Any Idea??

Thanks in Advance,

Mudassar

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Riccardo Bua Wed, 07/02/2008 - 05:33
User Badges:
  • Cisco Employee,

Hi Mudassar,


it might be quick TCP/IP disconnects causing a new socket connection to be performed I would suggest to check with a sniffer to confirm the offending party.


Regards,


Riccardo

Actions

This Discussion