Data mismatch in call_type_half_hour

[c.fotia]

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.

[vkapoor5]

Try this Bug - CSCma25888

Workaround:

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

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

[MSSQLSERVER_DATETIME]

PBDateFmt='\'yyyy-mm-dd\''

PBTimeFmt='\'hh:mm:ss\''

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

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

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

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

[MSSQLSERVER_DATETIME]

PBDateFmt='\'yyyy-dd-mm\''

PBTimeFmt='\'hh:mm:ss\''

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

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

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