Data mismatch in call_type_half_hour

Unanswered Question
Aug 3rd, 2007

Our environment include a CCM 4.1 cluster, a CRS IP-IVR server and an IPCC Enterprise 6.0 system. Counting the calls handled by Contact Center for a specific CallType (5006) I've found a data mismatch...

From call_type_half_hour table definition in DBSchema document:

"CallsHandledHalf in is the total number of calls of this call type handled

in the current half-hour.

Termination_Call_Detail records with a

CallDisposition of 6, 13, 14, 28, 29, 30, or 34 are

counted as CallHandled.

Note Valid for both IPCC and standard ACD

targets that use translation routes."

On t_termination_call_detail there are 33 calls, in t_call_type_half_hour there are 14...

In attached file can find the queries on DB and the results.

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
vkapoor5 Thu, 08/09/2007 - 06:34

Try this Bug - CSCma25888


1) Locate 'pbodb80.ini' ('pbodb70.ini' for 4.6.x) file in '

Home>\shared\PowerBuilder' directory.

2) Open the file in notepad

3) Locate following section





PBDateTimeFmt='\'yyyy-mm-dd hh:mm:ss.fff\''


4) Modify the date format appropriately. For French system it would be





PBDateTimeFmt='\'yyyy-dd-mm hh:mm:ss.fff\''


5) Restart 'Jaguar' and 'IIS ADmin' Services


This Discussion