cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
510
Views
0
Helpful
1
Replies

Data mismatch in call_type_half_hour

c.fotia
Level 1
Level 1

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.

1 Reply 1

vkapoor5
Level 5
Level 5

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

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: