Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Cisco Community
- Technology and Support
- DevNet Hub
- DevNet Collaboration
- Collaboration Knowledge Base
- Some calls like 80% are connected with database and 20% bypass the databas
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
50
Views
0
Helpful
0
Comments
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
on 01-24-2014 01:58 AM
This document was generated from CDN thread
Created by: Zaki Qureshi on 02-08-2010 01:35:42 AM
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Hemal Mehta on 02-08-2010 02:35:16 PM
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Zaki Qureshi on 02-08-2010 04:15:55 PM
Thanks for your reply. But here i have to mention one more thing is that we just take it wire shark traces and as we observe that the request take only 0.5 sec to complete round trip from database to cvp and back to CVP. Kindly advice on this my question is here that calls successfully reach database but some call goes directly transfer to agent without any options.
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Hemal Mehta on 02-08-2010 04:21:16 PM
Are you running CVP standalone or do you have an enterprise system. Yes, calls going to agent is typical behavior when there is problem at backend or one of the services times out. Is it taking 0.5 secs for calls to come back even in cases where call is going to agent?
You have to provide more details about your setup and what other components you have before I can provide any further help.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Monday, August 02, 2010 11:15 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Thanks for your reply. But here i have to mention one more thing is that we just take it wire shark traces and as we observe that the request take only 0.5 sec to complete round trip from database to cvp and back to CVP. Kindly advice on this my question is here that calls successfully reach database but some call goes directly transfer to agent without any options.
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
or simply reply to this email.
Subject: Re: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Janine Graves on 02-08-2010 04:21:16 PM
Zaki,
Is the database interaction being done through a Studio/Vxml Server
application? If so, did you write the database interaction yourselves,
or are you using the Database element? If you wrote it yourselves, are
you logging into the database with each phone call (usually slow), or
using Tomcat JNDI to log in and remain connected to the DB?
If the app is written using Studio, you might try is changing the
VoiceXML Property named "fetchtimeout" to "10s" (this can be done in the
Root Document of the Stuido project, omit the quotes), because perhaps
the VoiceXML Gateway is timing out waiting for the application to
complete its database transaction.
Janine
On 8/2/2010 12:15 PM, Cisco Developer Community Forums wrote:
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Thanks for your reply. But here i have to mention one more thing is
> that we just take it wire shark traces and as we observe that the
> request take only 0.5 sec to complete round trip from database to cvp
> and back to CVP. Kindly advice on this my question is here that calls
> successfully reach database but some call goes directly transfer to
> agent without any options.
> Â
> Â
> Will need more details. If you are not getting a response from
> database and timing out then how are you catching/handling that event
> in the IVR code?
> Based on what you have written, if the call goes through IVR and hits
> the database and does not come back then it is timeout issue. There
> could be no things causing it. Please provide more details.
> Hemal
> ________________________________
> From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
> Sent: Sunday, August 01, 2010 8:35 PM
> To: cdicuser@developer.cisco.com
> Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP)
> - New Feature Discussion: Some calls like 80% are connected with
> database and 20% bypass the databas
>
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Hi,
>
> We have issue with database connectivity most of the calls are
> successfull and getting the IVR compeletly but some calls Bypass the
> IVR its mean they didnt get the response from Database.
>
> This issue happen Site A which is connected through WAN.
>
> Let me add here that we have central Database which is connected to
> Side B its mean Side B is connected Locally and there is no issue.
>
> The problem occurs only in PEAK Hours
>
> Looking for your support
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
>
> or simply reply to this email.
>
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
>
> or simply reply to this email.
--
Janine Graves
781-990-1040
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Zaki Qureshi on 03-08-2010 04:01:37 PM
Hi,
Yes its enterprise System. Can you help me on this to identify the issue that where is the issue Exactly even in Backend or services timeout.
--CVP version is 4.1
--Database Oracle 10g
Looking for you support.
Subject: RE: Re: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New
Replied by: Zaki Qureshi on 03-08-2010 04:17:17 PM
Thanks Janine
Database Interaction by ourselves yes we are logging into the database for each call as we are using JDBC connection. By the way most of the calls are working fine but some calls directly divert to agent without getting any menus. Let me check with team for "Fetchtimeout" changing the values but my question is here that why the other calls are working fine.
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Zaki Qureshi on 03-08-2010 04:46:58 PM
Can you please tell me that how i can put debug on our code we are Using JDBC connection between our database.
Please tell me one more thing that what is the default value of fetchtimeout and what should have.
Thanks
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Hemal Mehta on 03-08-2010 04:25:16 PM
Ok, first of all check your fetchtimeout property value. What is the value of this? This is generally set at global level and it is a voicexml property variable. If it set too low, you might want to increase this and see what happens.
Also check if you are overriding this somewhere in the code, if so that value will prevail.
Are you using your own database code or using studio element. You should be able to easily put debugs in ur code which show you if the request is timing out or not and then the call is going to an agent.
Based on that you can isolate where the problem is. If the call is indeed timing out with the database request, then you would need to examine a no of things:
a. No of database connections allowed. Since it is happening in peak period, u have tyo make sure that these are not being exceeded than max allowed
b. Network issues
c. Code which makes the database call
First step is to isolate the issue and then tackle it accordingly.
Hemal mehta
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Tuesday, August 03, 2010 11:01 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
Yes its enterprise System. Can you help me on this to identify the issue that where is the issue Exactly even in Backend or services timeout.
--CVP version is 4.1
--Database Oracle 10g
Looking for you support.
Are you running CVP standalone or do you have an enterprise system. Yes, calls going to agent is typical behavior when there is problem at backend or one of the services times out. Is it taking 0.5 secs for calls to come back even in cases where call is going to agent?
You have to provide more details about your setup and what other components you have before I can provide any further help.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Monday, August 02, 2010 11:15 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Thanks for your reply. But here i have to mention one more thing is that we just take it wire shark traces and as we observe that the request take only 0.5 sec to complete round trip from database to cvp and back to CVP. Kindly advice on this my question is here that calls successfully reach database but some call goes directly transfer to agent without any options.
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2403245>
or simply reply to this email.
Subject: Re: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Janine Graves on 03-08-2010 05:43:16 PM
For the calls that are diverting directly to an agent, can you tell from
the Activity Logs whether the call gets as far as your database element?
If so, look at the time stamps and see the duration between the start of
the database interaction and the start of the transfer to an agent.
On 8/3/2010 12:17 PM, Cisco Developer Community Forums wrote:
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Thanks Janine
> Â
> Database Interaction by ourselves yes we are logging into the database
> for each call as we are using JDBC connection. By the way most of the
> calls are working fine but some calls directly divert to agent without
> getting any menus. Let me check with team for "Fetchtimeout"Â
> changing the values but my question is here that why the other calls
> are working fine.
> Â
> Zaki,
>
> Is the database interaction being done through a Studio/Vxml Server
> application? If so, did you write the database interaction yourselves,
> or are you using the Database element? If you wrote it yourselves, are
> you logging into the database with each phone call (usually slow), or
> using Tomcat JNDI to log in and remain connected to the DB?
>
> If the app is written using Studio, you might try is changing the
> VoiceXML Property named "fetchtimeout" to "10s" (this can be done in the
> Root Document of the Stuido project, omit the quotes), because perhaps
> the VoiceXML Gateway is timing out waiting for the application to
> complete its database transaction.
>
> Janine
>
>
>
> On 8/2/2010 12:15 PM, Cisco Developer Community Forums wrote:
> > Zaki Qureshi has created a new message in the forum "New Feature
> > Discussion":
> >
> > --------------------------------------------------------------
> > Thanks for your reply. But here i have to mention one more thing is
> > that we just take itÿ wire sharkÿ traces and as we observe that the
> > request take only 0.5 sec to complete round trip from database to cvp
> > and back to CVP. Kindly advice on this my question is here that calls
> > successfully reach database but some call goes directly transfer to
> > agent without any options.
> > ÿ
> > ÿ
> > Will need more details. If you are not getting a response from
> > database and timing out then how are you catching/handling that event
> > in the IVR code?
> > Based on what you have written, if the call goes through IVR and hits
> > the database and does not come back then it is timeout issue. There
> > could be no things causing it. Please provide more details.
> > Hemal
> > ________________________________
> > From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
> > Sent: Sunday, August 01, 2010 8:35 PM
> > To: cdicuser@developer.cisco.com
> > Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP)
> > - New Feature Discussion: Some calls like 80% are connected with
> > database and 20% bypass the databas
> >
> > Zaki Qureshi has created a new message in the forum "New Feature
> > Discussion":
> >
> > --------------------------------------------------------------
> > Hi,
> >
> > We have issue with database connectivity most of the calls are
> > successfull and getting the IVR compeletly but some calls Bypass the
> > IVR its mean they didnt get the response from Database.
> >
> > This issue happen Site A which is connected through WAN.
> >
> > Let me add here that we have central Database which is connected to
> > Side B its mean Side B is connected Locally and there is no issue.
> >
> > The problem occurs only in PEAK Hours
> >
> > Looking for your support
> > --
> > To respond to this post, please click the following link:
> >
> >
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
> >
> > or simply reply to this email.
> >
> > --
> > To respond to this post, please click the following link:
> >
> >
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
> >
> > or simply reply to this email.
>
> --
> Janine Graves
> 781-990-1040
>
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2403264>
>
> or simply reply to this email.
--
Janine Graves
781-990-1040
Subject: RE: Re: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New
Replied by: Manoj Anantha on 26-10-2010 05:17:35 AM
I think you would be using a custom action element to fetch data from DB using JDBC. So you can log all the activities as a part of activity log itself.
ActionData.addToLog("MyClassName","Starting DB connection");
//JDBC connections codes
ActionData.addToLog("MyClassName","Connection extablished");
.
.
.
Since you are using JDBC. For every call a new connection is been establised. Check if you have licensed enough database connections in Oracle and that you close the connection after the fetching the data.
Here you can take advantage of JNDI, which would open a connection pool and all the call would use the same connection to fetch the data.
Manoj Anantha
Created by: Zaki Qureshi on 02-08-2010 01:35:42 AM
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Hemal Mehta on 02-08-2010 02:35:16 PM
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Zaki Qureshi on 02-08-2010 04:15:55 PM
Thanks for your reply. But here i have to mention one more thing is that we just take it wire shark traces and as we observe that the request take only 0.5 sec to complete round trip from database to cvp and back to CVP. Kindly advice on this my question is here that calls successfully reach database but some call goes directly transfer to agent without any options.
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Hemal Mehta on 02-08-2010 04:21:16 PM
Are you running CVP standalone or do you have an enterprise system. Yes, calls going to agent is typical behavior when there is problem at backend or one of the services times out. Is it taking 0.5 secs for calls to come back even in cases where call is going to agent?
You have to provide more details about your setup and what other components you have before I can provide any further help.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Monday, August 02, 2010 11:15 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Thanks for your reply. But here i have to mention one more thing is that we just take it wire shark traces and as we observe that the request take only 0.5 sec to complete round trip from database to cvp and back to CVP. Kindly advice on this my question is here that calls successfully reach database but some call goes directly transfer to agent without any options.
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
or simply reply to this email.
Subject: Re: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Janine Graves on 02-08-2010 04:21:16 PM
Zaki,
Is the database interaction being done through a Studio/Vxml Server
application? If so, did you write the database interaction yourselves,
or are you using the Database element? If you wrote it yourselves, are
you logging into the database with each phone call (usually slow), or
using Tomcat JNDI to log in and remain connected to the DB?
If the app is written using Studio, you might try is changing the
VoiceXML Property named "fetchtimeout" to "10s" (this can be done in the
Root Document of the Stuido project, omit the quotes), because perhaps
the VoiceXML Gateway is timing out waiting for the application to
complete its database transaction.
Janine
On 8/2/2010 12:15 PM, Cisco Developer Community Forums wrote:
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Thanks for your reply. But here i have to mention one more thing is
> that we just take it wire shark traces and as we observe that the
> request take only 0.5 sec to complete round trip from database to cvp
> and back to CVP. Kindly advice on this my question is here that calls
> successfully reach database but some call goes directly transfer to
> agent without any options.
> Â
> Â
> Will need more details. If you are not getting a response from
> database and timing out then how are you catching/handling that event
> in the IVR code?
> Based on what you have written, if the call goes through IVR and hits
> the database and does not come back then it is timeout issue. There
> could be no things causing it. Please provide more details.
> Hemal
> ________________________________
> From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
> Sent: Sunday, August 01, 2010 8:35 PM
> To: cdicuser@developer.cisco.com
> Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP)
> - New Feature Discussion: Some calls like 80% are connected with
> database and 20% bypass the databas
>
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Hi,
>
> We have issue with database connectivity most of the calls are
> successfull and getting the IVR compeletly but some calls Bypass the
> IVR its mean they didnt get the response from Database.
>
> This issue happen Site A which is connected through WAN.
>
> Let me add here that we have central Database which is connected to
> Side B its mean Side B is connected Locally and there is no issue.
>
> The problem occurs only in PEAK Hours
>
> Looking for your support
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
>
> or simply reply to this email.
>
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
>
> or simply reply to this email.
--
Janine Graves
781-990-1040
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Zaki Qureshi on 03-08-2010 04:01:37 PM
Hi,
Yes its enterprise System. Can you help me on this to identify the issue that where is the issue Exactly even in Backend or services timeout.
--CVP version is 4.1
--Database Oracle 10g
Looking for you support.
Are you running CVP standalone or do you have an enterprise system. Yes, calls going to agent is typical behavior when there is problem at backend or one of the services times out. Is it taking 0.5 secs for calls to come back even in cases where call is going to agent?
You have to provide more details about your setup and what other components you have before I can provide any further help.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Monday, August 02, 2010 11:15 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Thanks for your reply. But here i have to mention one more thing is that we just take it wire shark traces and as we observe that the request take only 0.5 sec to complete round trip from database to cvp and back to CVP. Kindly advice on this my question is here that calls successfully reach database but some call goes directly transfer to agent without any options.
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
or simply reply to this email.
Subject: RE: Re: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New
Replied by: Zaki Qureshi on 03-08-2010 04:17:17 PM
Thanks Janine
Database Interaction by ourselves yes we are logging into the database for each call as we are using JDBC connection. By the way most of the calls are working fine but some calls directly divert to agent without getting any menus. Let me check with team for "Fetchtimeout" changing the values but my question is here that why the other calls are working fine.
Zaki,
Is the database interaction being done through a Studio/Vxml Server
application? If so, did you write the database interaction yourselves,
or are you using the Database element? If you wrote it yourselves, are
you logging into the database with each phone call (usually slow), or
using Tomcat JNDI to log in and remain connected to the DB?
If the app is written using Studio, you might try is changing the
VoiceXML Property named "fetchtimeout" to "10s" (this can be done in the
Root Document of the Stuido project, omit the quotes), because perhaps
the VoiceXML Gateway is timing out waiting for the application to
complete its database transaction.
Janine
On 8/2/2010 12:15 PM, Cisco Developer Community Forums wrote:
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Thanks for your reply. But here i have to mention one more thing is
> that we just take it wire shark traces and as we observe that the
> request take only 0.5 sec to complete round trip from database to cvp
> and back to CVP. Kindly advice on this my question is here that calls
> successfully reach database but some call goes directly transfer to
> agent without any options.
> Â
> Â
> Will need more details. If you are not getting a response from
> database and timing out then how are you catching/handling that event
> in the IVR code?
> Based on what you have written, if the call goes through IVR and hits
> the database and does not come back then it is timeout issue. There
> could be no things causing it. Please provide more details.
> Hemal
> ________________________________
> From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
> Sent: Sunday, August 01, 2010 8:35 PM
> To: cdicuser@developer.cisco.com
> Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP)
> - New Feature Discussion: Some calls like 80% are connected with
> database and 20% bypass the databas
>
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Hi,
>
> We have issue with database connectivity most of the calls are
> successfull and getting the IVR compeletly but some calls Bypass the
> IVR its mean they didnt get the response from Database.
>
> This issue happen Site A which is connected through WAN.
>
> Let me add here that we have central Database which is connected to
> Side B its mean Side B is connected Locally and there is no issue.
>
> The problem occurs only in PEAK Hours
>
> Looking for your support
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
>
> or simply reply to this email.
>
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
>
> or simply reply to this email.
--
Janine Graves
781-990-1040
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Zaki Qureshi on 03-08-2010 04:46:58 PM
Can you please tell me that how i can put debug on our code we are Using JDBC connection between our database.
Please tell me one more thing that what is the default value of fetchtimeout and what should have.
Thanks
Ok, first of all check your fetchtimeout property value. What is the value of this? This is generally set at global level and it is a voicexml property variable. If it set too low, you might want to increase this and see what happens.
Also check if you are overriding this somewhere in the code, if so that value will prevail.
Are you using your own database code or using studio element. You should be able to easily put debugs in ur code which show you if the request is timing out or not and then the call is going to an agent.
Based on that you can isolate where the problem is. If the call is indeed timing out with the database request, then you would need to examine a no of things:
a. No of database connections allowed. Since it is happening in peak period, u have tyo make sure that these are not being exceeded than max allowed
b. Network issues
c. Code which makes the database call
First step is to isolate the issue and then tackle it accordingly.
Hemal mehta
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Tuesday, August 03, 2010 11:01 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
Yes its enterprise System. Can you help me on this to identify the issue that where is the issue Exactly even in Backend or services timeout.
--CVP version is 4.1
--Database Oracle 10g
Looking for you support.
Are you running CVP standalone or do you have an enterprise system. Yes, calls going to agent is typical behavior when there is problem at backend or one of the services times out. Is it taking 0.5 secs for calls to come back even in cases where call is going to agent?
You have to provide more details about your setup and what other components you have before I can provide any further help.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Monday, August 02, 2010 11:15 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Thanks for your reply. But here i have to mention one more thing is that we just take it wire shark traces and as we observe that the request take only 0.5 sec to complete round trip from database to cvp and back to CVP. Kindly advice on this my question is here that calls successfully reach database but some call goes directly transfer to agent without any options.
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2403245>
or simply reply to this email.
Subject: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Hemal Mehta on 03-08-2010 04:25:16 PM
Ok, first of all check your fetchtimeout property value. What is the value of this? This is generally set at global level and it is a voicexml property variable. If it set too low, you might want to increase this and see what happens.
Also check if you are overriding this somewhere in the code, if so that value will prevail.
Are you using your own database code or using studio element. You should be able to easily put debugs in ur code which show you if the request is timing out or not and then the call is going to an agent.
Based on that you can isolate where the problem is. If the call is indeed timing out with the database request, then you would need to examine a no of things:
a. No of database connections allowed. Since it is happening in peak period, u have tyo make sure that these are not being exceeded than max allowed
b. Network issues
c. Code which makes the database call
First step is to isolate the issue and then tackle it accordingly.
Hemal mehta
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Tuesday, August 03, 2010 11:01 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
Yes its enterprise System. Can you help me on this to identify the issue that where is the issue Exactly even in Backend or services timeout.
--CVP version is 4.1
--Database Oracle 10g
Looking for you support.
Are you running CVP standalone or do you have an enterprise system. Yes, calls going to agent is typical behavior when there is problem at backend or one of the services times out. Is it taking 0.5 secs for calls to come back even in cases where call is going to agent?
You have to provide more details about your setup and what other components you have before I can provide any further help.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Monday, August 02, 2010 11:15 AM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: RE: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Thanks for your reply. But here i have to mention one more thing is that we just take it wire shark traces and as we observe that the request take only 0.5 sec to complete round trip from database to cvp and back to CVP. Kindly advice on this my question is here that calls successfully reach database but some call goes directly transfer to agent without any options.
Will need more details. If you are not getting a response from database and timing out then how are you catching/handling that event in the IVR code?
Based on what you have written, if the call goes through IVR and hits the database and does not come back then it is timeout issue. There could be no things causing it. Please provide more details.
Hemal
________________________________
From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
Sent: Sunday, August 01, 2010 8:35 PM
To: cdicuser@developer.cisco.com
Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feature Discussion: Some calls like 80% are connected with database and 20% bypass the databas
Zaki Qureshi has created a new message in the forum "New Feature Discussion":
--------------------------------------------------------------
Hi,
We have issue with database connectivity most of the calls are successfull and getting the IVR compeletly but some calls Bypass the IVR its mean they didnt get the response from Database.
This issue happen Site A which is connected through WAN.
Let me add here that we have central Database which is connected to Side B its mean Side B is connected Locally and there is no issue.
The problem occurs only in PEAK Hours
Looking for your support
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
or simply reply to this email.
--
To respond to this post, please click the following link:
<http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2403245>
or simply reply to this email.
Subject: Re: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New Feat
Replied by: Janine Graves on 03-08-2010 05:43:16 PM
For the calls that are diverting directly to an agent, can you tell from
the Activity Logs whether the call gets as far as your database element?
If so, look at the time stamps and see the duration between the start of
the database interaction and the start of the transfer to an agent.
On 8/3/2010 12:17 PM, Cisco Developer Community Forums wrote:
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Thanks Janine
> Â
> Database Interaction by ourselves yes we are logging into the database
> for each call as we are using JDBC connection. By the way most of the
> calls are working fine but some calls directly divert to agent without
> getting any menus. Let me check with team for "Fetchtimeout"Â
> changing the values but my question is here that why the other calls
> are working fine.
> Â
> Zaki,
>
> Is the database interaction being done through a Studio/Vxml Server
> application? If so, did you write the database interaction yourselves,
> or are you using the Database element? If you wrote it yourselves, are
> you logging into the database with each phone call (usually slow), or
> using Tomcat JNDI to log in and remain connected to the DB?
>
> If the app is written using Studio, you might try is changing the
> VoiceXML Property named "fetchtimeout" to "10s" (this can be done in the
> Root Document of the Stuido project, omit the quotes), because perhaps
> the VoiceXML Gateway is timing out waiting for the application to
> complete its database transaction.
>
> Janine
>
>
>
> On 8/2/2010 12:15 PM, Cisco Developer Community Forums wrote:
> > Zaki Qureshi has created a new message in the forum "New Feature
> > Discussion":
> >
> > --------------------------------------------------------------
> > Thanks for your reply. But here i have to mention one more thing is
> > that we just take itÿ wire sharkÿ traces and as we observe that the
> > request take only 0.5 sec to complete round trip from database to cvp
> > and back to CVP. Kindly advice on this my question is here that calls
> > successfully reach database but some call goes directly transfer to
> > agent without any options.
> > ÿ
> > ÿ
> > Will need more details. If you are not getting a response from
> > database and timing out then how are you catching/handling that event
> > in the IVR code?
> > Based on what you have written, if the call goes through IVR and hits
> > the database and does not come back then it is timeout issue. There
> > could be no things causing it. Please provide more details.
> > Hemal
> > ________________________________
> > From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
> > Sent: Sunday, August 01, 2010 8:35 PM
> > To: cdicuser@developer.cisco.com
> > Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP)
> > - New Feature Discussion: Some calls like 80% are connected with
> > database and 20% bypass the databas
> >
> > Zaki Qureshi has created a new message in the forum "New Feature
> > Discussion":
> >
> > --------------------------------------------------------------
> > Hi,
> >
> > We have issue with database connectivity most of the calls are
> > successfull and getting the IVR compeletly but some calls Bypass the
> > IVR its mean they didnt get the response from Database.
> >
> > This issue happen Site A which is connected through WAN.
> >
> > Let me add here that we have central Database which is connected to
> > Side B its mean Side B is connected Locally and there is no issue.
> >
> > The problem occurs only in PEAK Hours
> >
> > Looking for your support
> > --
> > To respond to this post, please click the following link:
> >
> >
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
> >
> > or simply reply to this email.
> >
> > --
> > To respond to this post, please click the following link:
> >
> >
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
> >
> > or simply reply to this email.
>
> --
> Janine Graves
> 781-990-1040
>
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2403264>
>
> or simply reply to this email.
--
Janine Graves
781-990-1040
Subject: RE: Re: New Message from Zaki Qureshi in Customer Voice Portal (CVP) - New
Replied by: Manoj Anantha on 26-10-2010 05:17:35 AM
I think you would be using a custom action element to fetch data from DB using JDBC. So you can log all the activities as a part of activity log itself.
ActionData.addToLog("MyClassName","Starting DB connection");
//JDBC connections codes
ActionData.addToLog("MyClassName","Connection extablished");
.
.
.
Since you are using JDBC. For every call a new connection is been establised. Check if you have licensed enough database connections in Oracle and that you close the connection after the fetching the data.
Here you can take advantage of JNDI, which would open a connection pool and all the call would use the same connection to fetch the data.
Manoj Anantha
For the calls that are diverting directly to an agent, can you tell from
the Activity Logs whether the call gets as far as your database element?
If so, look at the time stamps and see the duration between the start of
the database interaction and the start of the transfer to an agent.
On 8/3/2010 12:17 PM, Cisco Developer Community Forums wrote:
> Zaki Qureshi has created a new message in the forum "New Feature
> Discussion":
>
> --------------------------------------------------------------
> Thanks Janine
> Â
> Database Interaction by ourselves yes we are logging into the database
> for each call as we are using JDBC connection. By the way most of the
> calls are working fine but some calls directly divert to agent without
> getting any menus. Let me check with team for "Fetchtimeout"Â
> changing the values but my question is here that why the other calls
> are working fine.
> Â
> Zaki,
>
> Is the database interaction being done through a Studio/Vxml Server
> application? If so, did you write the database interaction yourselves,
> or are you using the Database element? If you wrote it yourselves, are
> you logging into the database with each phone call (usually slow), or
> using Tomcat JNDI to log in and remain connected to the DB?
>
> If the app is written using Studio, you might try is changing the
> VoiceXML Property named "fetchtimeout" to "10s" (this can be done in the
> Root Document of the Stuido project, omit the quotes), because perhaps
> the VoiceXML Gateway is timing out waiting for the application to
> complete its database transaction.
>
> Janine
>
>
>
> On 8/2/2010 12:15 PM, Cisco Developer Community Forums wrote:
> > Zaki Qureshi has created a new message in the forum "New Feature
> > Discussion":
> >
> > --------------------------------------------------------------
> > Thanks for your reply. But here i have to mention one more thing is
> > that we just take itÿ wire sharkÿ traces and as we observe that the
> > request take only 0.5 sec to complete round trip from database to cvp
> > and back to CVP. Kindly advice on this my question is here that calls
> > successfully reach database but some call goes directly transfer to
> > agent without any options.
> > ÿ
> > ÿ
> > Will need more details. If you are not getting a response from
> > database and timing out then how are you catching/handling that event
> > in the IVR code?
> > Based on what you have written, if the call goes through IVR and hits
> > the database and does not come back then it is timeout issue. There
> > could be no things causing it. Please provide more details.
> > Hemal
> > ________________________________
> > From: Cisco Developer Community Forums [cdicuser@developer.cisco.com]
> > Sent: Sunday, August 01, 2010 8:35 PM
> > To: cdicuser@developer.cisco.com
> > Subject: New Message from Zaki Qureshi in Customer Voice Portal (CVP)
> > - New Feature Discussion: Some calls like 80% are connected with
> > database and 20% bypass the databas
> >
> > Zaki Qureshi has created a new message in the forum "New Feature
> > Discussion":
> >
> > --------------------------------------------------------------
> > Hi,
> >
> > We have issue with database connectivity most of the calls are
> > successfull and getting the IVR compeletly but some calls Bypass the
> > IVR its mean they didnt get the response from Database.
> >
> > This issue happen Site A which is connected through WAN.
> >
> > Let me add here that we have central Database which is connected to
> > Side B its mean Side B is connected Locally and there is no issue.
> >
> > The problem occurs only in PEAK Hours
> >
> > Looking for your support
> > --
> > To respond to this post, please click the following link:
> >
> >
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2399194>
> >
> > or simply reply to this email.
> >
> > --
> > To respond to this post, please click the following link:
> >
> >
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2401313>
> >
> > or simply reply to this email.
>
> --
> Janine Graves
> 781-990-1040
>
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/cvp/forums/-/message_boards/message/2403264>
>
> or simply reply to this email.
--
Janine Graves
781-990-1040
Labels:
Getting Started
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
Customers Also Viewed These Support Documents