Precision Queue Interval All Fields report can only produce 14 days historical data

[wahyukurnia]

Hi All,

I have PCCE 9.0.4. It only had internal database. There is no external database for HDS.

I configured Precision Queue for incoming call agents. When I produce report using "Precision Queue Interval All Fields (PQIAF)" provided by Cisco Stock Report, I can only find 14 days historical data.  Referring to PCCE Product Specification doc, internal logger should provide 400 days historical data for PQIAF report.

When I open the report definition, PQIAF is pointing to 3 tables: Router_Queue_Interval, Skill_Group_Interval and Precision_Queue. I found the Router_Queue_Interval only stored 14 days data. Is it normal?

Have anyone found the same problem when PCCE only used internal database?

Please advise,

Heribertus

[Kartik Bhatia]

What version of CUIC?

Also if you right click - edit your report template on CUIC - what version of template is it?

I have CUIC 9.1.1 template v2 and mine runs fine.

Kartik

[wahyukurnia]

Kartik,

The template is ok.

I already checked into the table related with this report. The problem is  the Router_Queue_Interval table only stored 14 days data.

[Graham Old]

The logger database for Enterprise only holds 14 days by default. As part of the PCCE install you should have edited the retention period to 400 days. It looks like you missed changing the Router_Queue_Interval table to 400 days.

You need to edit the logger setup. See this link for setting the retention period

http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/pcce/pcce_901/installation/guide/PCCE_BK_IBC40C6F_00_installing-and-configuring-pcce/PCCE_BK_ICC40C6F_00_installing-and-configuring-pcce_chapter_0111.html#PCCE_TK_L33657A9_00

Graham

[wahyukurnia]

All,

In PCCE 9.x found a bug. Please refer to

https://tools.cisco.com/bugsearch/bug/CSCui53554

There is no web configuration menu for Router_Queue_Interval.

It can be fixed by modify registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Cisco Systems, Inc.\ICM\instxx\LoggerA\Recovery\CurrentVersion\Purge\Retain\Interval\RouterQueue

Hope this help.

Heribertus

[Omar Deen]

Are you using the <instance>_sideA database? 

[wahyukurnia]

Yes, I am pointing to sideA database since there is no HDS External

[david.kiraly]

PG Explorer --> Agent PG --> Agent Distribution Tab

Are both your AW site names defined and have real-time and historical data checked?

[wahyukurnia]

The configuration for AW are:

- Agent real time data is checked

- Agent historical data is unchecked

Please advise