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

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

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

UCCX - Inconsistent data on the Database

Hello Team,

I have found some values on the database that are not consistent with the DBSchema for UCCX 8.0.

For example. I found on a production system several entries where several sessionid do not have a connection between

ContactServiceQueue and ContactCallDetail, altough the targetype on the entrie referer that tha call originated on the Queue. For example.

select * from

    ContactQueueDetail] ab

    join contactcalldetail xb on ab.sessionid = xb.sessionid

where ab.targetid > 7

and ab.targettype = 0

The result of this query will show around 5.000 entries that vary on time. Also in my database the csqrecordid as the maximum value of 7.

Has anyone found any similar issue.

Cisco Employee

UCCX - Inconsistent data on the Database

HI Jose,

There are several ways in which the session -ids are generated in the CRA_DB

-Is this for reporting purposes and if so what reports are being tested to get the output.

I can send you the programming guide for Historical reports if this is indeed for checking the DB values against the reports



New Member

UCCX - Inconsistent data on the Database

Hello Prashanth,

Thanks for your help. Yes this is for reporting purproses, but i will be interested in understand why i have here entries that are not related check this example:

select * from ContactQueueDetail cqd

where cqd.targettype = 0

and cqd.targetID

not in (select recordId from ContactServiceQueue);

Here according to Cisco Unified CCX Database Schema Guide, Release 8.0(1), the value cdq.targetype defines if the call enters by Queue or Agent. If cdq.targetype=0, then cqd.targetID must be in ContactServiceQueue.

If i execute this command i will get about 90000 entries.

Can you tell me why is this happening?



Cisco Employee

UCCX - Inconsistent data on the Database

Hello Jose,

I am attaching the programming guide for HRC documents, let me know if this helps

This will explain the differences in how the counts are obtained