Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCCE-LOGGER DB Historical Tables has NO data

I am running UCCE 8.0.3(Duplex) setup in my Lab as:
Rogger Side A
Rogger Side B
AW/HDS/DDS
PG Side A
PG Side B

Problem Description: Logger database Historical tables has NO data at all i.e. tables like Agent_Half_Hour, Agent_SkillGroup_Half_Hour, Call_Type_Half_Hour, Skill_Group_Half_Hour etc are empty. Due to this, HDS has no data as well and CUIC reports cannot show any data in Historical reports.

Is there any UCCE config i am missing which is causing this issue? Any help/pointers will be very much appreciated.

Thanks & Regards

Dinesh

8 REPLIES

UCCE-LOGGER DB Historical Tables has NO data

Hi.

That's normal. Information in historical tables on Loggers are being pushed on the AW/HDS/DDS server (if there's one).

In case the Logger(s) lose connection to the AW/HDS/DDS, the data is cached on Loggers but whenever the connection comes back, the information is flushed to AW/HDS/DDS again.

G.

New Member

UCCE-LOGGER DB Historical Tables has NO data

Hi Gergely,

                     Thanks for your response. But the problem is, No historical data exists in HDS as well.

Call types, Skill groups, Agents etc are configured in the system and some test call flows are done using the setup/config for last 20 days. But the data in HDS is also missing. HDS shows zero records for the tables that i mentioned earlier in this thread.

Not sure what's the cause of this issue. Pls let me know your comments.

Thanks & Regards

Dinesh

UCCE-LOGGER DB Historical Tables has NO data

Oh, I am sorry, now I can see this was in your original post as well.

From the top of my mind: did you take a look at the _Interval tables?

G.

New Member

UCCE-LOGGER DB Historical Tables has NO data

Yes, _Interval tables has data.

UCCE-LOGGER DB Historical Tables has NO data

Hi, yes, this is something I completely forgot (all our systems have been upgraded to 8.x a long time ago).

_Half_Hour tables will be no longer populated. Use _Interval tables instead.

Even the doc (I mean Database Schema Guide) says (for 8.0x):

Note: The Skill_Group_Interval Table will be populate with 30/15 minute reporting data,

depending on the Historical Reporting Interval setting for the PG. The Skill_Group_Half_Hour

Table will not be populated with this data.

G.

Green

Re: UCCE-LOGGER DB Historical Tables has NO data

Good reminder. Thanks.

Original poster - run ICMDBA and look at Space Used summary and see what historical tables DO have data then check with SQL queries.

Regards,

Geoff

UCCE-LOGGER DB Historical Tables has NO data

This is one of the many little reasons why you should never query the tables directly. As a best practice query the Views in the awdb. I.e. always query against _awdb, never _hds. And query the View Agent_Interval or even Agent_Half_Hour rather than t_Agent_Half_Hour.

Cheers,

Kris

New Member

Re: UCCE-LOGGER DB Historical Tables has NO data

Thanks everyone for your input on this

1739
Views
5
Helpful
8
Replies
CreatePlease login to create content