Make plans now to attend XMPP integration with CVP 2012/06/14 @ 10:00 AM at Cisco Live! in San Diego. ...Read More

 



Cisco Developer Network will be presenting a CDN Developer Track at Cisco Live! London the week of January 31, 2011.

We are presenting technical sessions which highlight Application Programming interfaces (APIs) and Software Developer Kits (SDKs) for Cisco technologies such as Unified Communications, IOS, and Access Routing Technologies ¿ including the new Cisco Cius ...Read More

 

Recently noticed that there have been repeated questions from our developer community complaining that they can't seem to get the beep to work with <record>. They have set the beep attribute to "true" alright, and the reference guide even says this is supported but why doesn't it work?
...Read More

 

August 01, 2006
Earlier today, as I was typing a comment in our internal issuing-tracking system, I hit backspace to correct a typo. WHAM! I go back to the previous page, and my long-winded comment is gone. Apparently I somehow left the context of the text area (did I tab, or spuriously click, or??), which causes backspace to act as a hotkey for "Back". The web browser was not very forgiving of my mistake.

Are your IVR applications forgiving? They should be.
...Read More

 

Mark Gibbs over at Network World has put together a spiffy little scoring system for customer service systems (including many criteria for IVR systems). How would callers score your IVR using Mark's guidelines? Place a call and find out, you may be surprised.
...Read More

 

If you're using JNDI to connect to your database through Tomcat, then it's possible you've had to deal with database connection pool leaks. Your code tests fine, it's been reviewed, but in load tests or in production your app is unable to acquire database connections, the pool is empty!

Fear not, there are some handy parameters which can be set in your application's XML configuration file (in tomcat/conf/Catalina/YOUR_IP/YOUR_APP.xml):
...Read More

 

Showing 6 results.
Items per Page 50
of 1

CVP Forum

« Back to CVP - All Versions

Reporting Server - How to send data to the Informix database

Combination View Flat View Tree View
Threads [ Previous | Next ]
Hi,
 
I created different applications in CVP Call Studio. However, only one of them is logging in the Informix Database.
FYI:
VXML Server configuration:
  - Enable reporting for this VXML server = YES
  - Enable reporting for VXML application details = YES
  - Inclusive filters: *.*.*.*
 
I redeployed my applications, restarted both the VXML Server and the Reporting Server.
 
Is there other places I need to configure to make this work and can someone help me understand why one application is working(write data in the Informix database) and not the other one.
 
Thanks in advance,
David

First things first...are you in a standalone of comprehensive environment?
 
Just so you know (if you don't already) CVP Reporting is one of the most undocumented systems out there. It leaves a lot for the designers imagination. I finally got up and running in a comprehensive environment and there are a lot of settings which have to be dead on to make it work.

When you restarted the VXML server, did wait until it was fully up to start the reporting server? When I was in this debacle, the process which worked for me was:
1. Make change in OAMP
2. Restart VXML and Call Servers (A and B side)
3. Restart OAMP
4. Reboot CVP Reporting server
 
When sending a call into the VXML application from ICM, are you concatenating the ICMInfokeys? If these aren't there, then CVP Reporting will not write that record into the Call table.  

Hi Eric,
 
I have a comprehensive environment. To facilitate the troubleshooting, I'm running on simplex right now.
I did the same booting sequence as you do.
 
Here is more details of what I'm trying to understand.
I have an application A and an application B.
 
 - Reporting Server always writes in "call" table when I call Application A.
 - Reporting Server never writes in "VXMLSession" table when I call Application A.
 
 - Reporting Server always writes in "call" table when I call Application B.
 - Reporting Server always writes in "VXMLSession" table when I call Application B.
 
Before calling each application, I'm passing the ICM routercallkey information.
 
 
Thanks!

David,

Seems like you have two seperate issues here. 1.) The VXML data not being written to the database. 2.) Not being able to add an application through the OAMP.
 
1.) Not to insult you, but just to check... you do have the "Enable reporting for VXML application details" radio button checked to yes, correct?
 
Ok good, you do. Now, in your Cisco ICM script, you have to make sure you are sending the appropriate variables neccessary for CVP Reporting. What is usually common in an ICM config is VXML[0] = concatenate("application=APPLICATION_A;","callid=",Call.user.media.id). The Call.user.media.id is what you will see in your "call" table as CALLGUID. 
 
I use VXML[4] to pass through the rest of the variables from ICM. VXML[4] = concatenate("ICMInfoKeys=",Call.RouterCallKey,"-",Call.RouterCallDay,"-",Call.RouterCallKeySequenceNumber). This puts all the data (hyphen delimited) into CVP and reporting parses it out. Meaning, there is no need to identify the session data in CVP. However, you can use whichever array you have room to put it in. But this string is required to begin writing to the succeeding tables.
 
2.) Have you tried deleting your *.*.*.* inclusive filter, save and deploy, reboot sequence, then readd? If that doesn't work (as much as it defeats the purpose of wildcards), you can try to keep the *.*.*.* inclusive filter in there and seperate it with a ; and put ApplicationA.*.*.*. This should at the very least kick start the reporting server into seeing that application. If that works, I'd let it run for a day, then remove it and see what happens.
 

Hi Rick,
 
Thanks for helping. My VXML server configuration is OK (as described in my first email). VXML data is written to the database... but only for one application.
 
I isolated the gap between the two and my error was in the ICM script. The application that is working is receiving in the ToVXML[] callID="something" and the application that is not working is receiving in the ToVXML[] call_ID="something".
 
It seems only the keyword "callid=" is required in order to populate the VXML tables. I will keep note of your other comments if I run into issues later on but so far it is working fine.
 
 
Thanks and regards,
David

Oh yeah, my mistake for not pointing that out, as well. Our initial configuration set VXML[0] to cvp_call_id. While this looks right, it's not. If it's not set as callID then nothing about it will work. It's like it doesn't exist.

Did you have a chance to remove that exclusive filter?
 
I really hope your in a lab environment doing all this. When I was working on mine it was in production. And nearly everyday I had to reboot servers, so I had to wait until the maintenance window to bring everything down...2am.

 
You do need the call id to be setup with variable name 'callid'.   While some data gets written to the reporting server even without callid, it is requied to get values on the VXMLSession and VXMLElement tables.   I believe callid value is used to link the tables together.
 
From the CVP Config guide:
 
When using the VXML Server option in the Unified CVP solution, you can correlate UnifiedCVP/Unified ICME logs with VoiceXML logs. To do this, you need to pass the Call ID to theVXML Server by URL. Building upon the URL used in the previous example, the URL wouldbe as follows:
http://12.34.567.890:7000/CVP/Server?application=Chapter1_HelloWorld&callid=XXXXX-XXXXX-XXXXXX-XXXXXX
To configure logging, do the following:
Step 1
In the Unified ICME script, use the formula editor to set ToExtVXML[1]. Set ToExtVXML[1]= concatenate("callid=",Call.user.media.id) to the contents of theUser.microapp.media_id ECC Variable.
Note: Always include "callid" when sending the call to the VXML Server using the Comprehensivecall flow model.