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

Attachments:

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.
 
 
 

Attachments: