Reporting Query Mismatch in ICM and CVP call count

[r.boloor.rao]

Hi

We have a Comprehensive call model for SelfService IVRs. I see a descrepancy in the Call count  for the reporting purpose.

ICM<-------->CVP<------->GW<--->caller

  |                 |

AWDB       ReportingDB

On the CVP reporting DB, I am using a query

------------------------------------------------------------------------

"Select count(*) from call where DNIS=xxxxxx

and callstartdate between datetime1 and datetime2

;"

-------------------------------------------------------------------------

Say it gives me a result  <Count1>

If I run a similar report against ICM AWDB route_call_detail

--------------------------------------------------------------------------

select count(*) from Route_Call_Detail

where DialedNumberString=xxxxxx

and RoutingBeganDate between Datetime1 and Datetime2

--------------------------------------------------------------------------

Say it gives me a result <Count2>

I find that Count2 always larger thant Count1. Not sure why this mismatch. any pointer on this is will be greatest help for me.

Thanks

[cndilip123]

ICM puts a record into Route_Call_Detail for every Route_Request.

Do you notice duplicate records here?

Regards,

Dilip

[jimmy jain]

if you transfer the call , ICM Will write one more entry into RCD with same routercallkey and routercallkeyday.

hence you will find the second count always more, try using distinct keywork in RCD.