cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
83
Views
0
Helpful
0
Comments
cdnadmin
Community Member
This document was generated from CDN thread

Created by: deniz caglar on 13-07-2009 03:25:28 PM
Hi,
I have a problem about cvp reporting. I have an application in call studio. And i create some reports using some sql's against cvp reporting server.I write a simple sql like:
 
select *   from VXMLElement where elementname = "Audio_129"
 
Some of fields like exitdatetime, numberofinteraction,resultid, exit state are empty. I am attaching the results of the sql.
But in activitylog in \\vxmlserver\c$\Cisco\CVP\VXMLServer\applications\MYAPPLICATION\logs\ActivityLog i can see that flow achieved to pass this element successfully, as you can see below:
 
10.231.16.145.1247497686526.163.IVR_AloGaranti_Deniz,07/13/2009 18:08:54.481,Audio_129,enter,
10.231.16.145.1247497686526.163.IVR_AloGaranti_Deniz,07/13/2009 18:08:54.481,Audio_129,custom,xxx,xxx
10.231.16.145.1247497686526.163.IVR_AloGaranti_Deniz,07/13/2009 18:08:54.489,Audio_129,interaction,audio_group,initial_audio_group
10.231.16.145.1247497686526.163.IVR_AloGaranti_Deniz,07/13/2009 18:08:54.653,Audio_129,exit,done

So, why can not i take these fields in my report ?
 
Thanks,
 
Deniz



Subject: RE: cvp reporting problem
Replied by: Eric Tanney on 15-07-2009 05:14:49 PM
Does this happen for every element type in your table, or only specific to "AUDIO_129"?

Subject: RE: cvp reporting problem
Replied by: deniz caglar on 16-07-2009 06:45:05 AM
It changes, i made a new sql giving different elementtypes to see if they also have the problem, i saw that not only a spesific audio element, but a desicion, menu, custom vs elements have this problem. I am attaching a new file that shows different elements have this problem (ElementProblem2). 
For example: 
One element called Decision_PaymentType is a decision element that i decide an action looking to a session variable. This element has three exit states: Card, Account and Technical Error. In my sql, only the Card exitstates are available. I made a sample call that i provide this decision element to exit with Account exitstate and i saw in the activity log that exit state is Account as shown below, but in the reporting server its resultid and exitstate columns are empty. I am also attaching the sql results of this element(Decision_PaymentType_Element.xls). You can look at the last raw at 07/16/2009 09:30 which is the same call of the activity log below. 
... 
10.231.16.145.1247725812573.106.IVR_AloGaranti_Deniz,07/16/2009 09:30:49.590,Audio_TxnReadAccont,exit,done
10.231.16.145.1247725812573.106.IVR_AloGaranti_Deniz,07/16/2009 09:30:49.590,Decision_ReturnCaller,enter,
10.231.16.145.1247725812573.106.IVR_AloGaranti_Deniz,07/16/2009 09:30:49.590,Decision_ReturnCaller,exit,MobileTopUp
10.231.16.145.1247725812573.106.IVR_AloGaranti_Deniz,07/16/2009 09:30:49.590,Decision_PaymentType,enter,
10.231.16.145.1247725812573.106.IVR_AloGaranti_Deniz,07/16/2009 09:30:49.590,Decision_PaymentType,exit,Account

10.231.16.145.1247725812573.106.IVR_AloGaranti_Deniz,07/16/2009 09:30:49.590,SetAccountInfoForMobilePayment_01,enter,
...
 
Thanks.
 
 
 

Subject: RE: cvp reporting problem
Replied by: Manoj Anantha on 05-08-2009 02:20:35 PM
I experienced similar issue and fixed it. What i had done was in one of my custom element I was storing a hugh object (web service object) into a session variable. When removed this issue was fixed.
 
If you have any custom element where you are setting a session variable other then String this is bound to happen.
 
Please let me know if you have any custom element? if yes post the code.
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:

Quick Links