no data in CUIC 9.x reports

Document created by cdnadmin on Jan 25, 2014
Version 1Show Document
  • View in full screen mode
This document was generated from CDN thread

Created by: Senthil Kumar Natarajan on 26-05-2013 10:41:52 AM
This is a new install of PCCE 9.x with CUIC 9.x. I see no data in any reports. 
However if i copy the SQL query of that report and run it directly off that instance_SideA DB (instead of the instance_awdb), i get reporting data.
Until 8.x, i was told, that i should be pointing to awdb, becasue it has the views needed for query. Has this been changed in 9.x?
TIA.
-Senthil

Subject: Re: New Message from Omar Abulaban in Contact Center Reporting (CCR) - Cont
Replied by: Omar Abulaban on 26-05-2013 11:29:44 AM
As per my understanding of the guide:
- AWDB is still the way to go
- Make sure your DB user has correct configuration
a) Check the databases associated with Side A and AWdb.
b) Choose each database and associate it with the db_datareader and public
roles, and click OK.
- Make sure the PG is configured for reporting (from configuration manager,
pg explorer)

hopefully this would help

On Sun, May 26, 2013 at 6:19 PM, Cisco Developer Community Forums <
cdicuser@developer.cisco.com> wrote:

> Omar Abulaban has created a new message in the forum "Contact Center
> Reporting": --------------------------------------------------------------
> version 9 is the same. However, your installation is PCCE, and that might
> be the difference. please check documentation again
> On May 26, 2013 5:43 PM, "Cisco Developer Community Forums" <
> cdicuser@developer.cisco.com> wrote:
>
> > Senthil Kumar Natarajan has created a new message in the forum "Contact
> > Center Reporting":
> > -------------------------------------------------------------- This is a
> > new install of PCCE 9.x with CUIC 9.x. I see no data in any reports.
> > However if i copy the SQL query of that report and run it directly off
> > that instance_SideA DB (instead of the instance_awdb), i get reporting
> data.
> > Until 8.x, i was told, that i should be pointing to awdb, becasue it has
> > the views needed for query. Has this been changed in 9.x?
> > TIA.
> > -Senthil
> > --
> > To respond to this post, please click the following link:
> >
> http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/15603679orsimply reply to this email.
> --
> To respond to this post, please click the following link:
> http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/15606123or simply reply to this email.

Subject: Re: New Message from Senthil Kumar Natarajan in Contact Center Reporting (C
Replied by: Omar Abulaban on 26-05-2013 11:19:23 AM
version 9 is the same. However, your installation is PCCE, and that might
be the difference. please check documentation again
On May 26, 2013 5:43 PM, "Cisco Developer Community Forums" <
cdicuser@developer.cisco.com> wrote:

> Senthil Kumar Natarajan has created a new message in the forum "Contact
> Center Reporting":
> -------------------------------------------------------------- This is a
> new install of PCCE 9.x with CUIC 9.x. I see no data in any reports.
> However if i copy the SQL query of that report and run it directly off
> that instance_SideA DB (instead of the instance_awdb), i get reporting data.
> Until 8.x, i was told, that i should be pointing to awdb, becasue it has
> the views needed for query. Has this been changed in 9.x?
> TIA.
> -Senthil
> --
> To respond to this post, please click the following link:
> http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/15603679or simply reply to this email.

Subject: RE: no data in CUIC 9.x reports
Replied by: Senthil Kumar Natarajan on 05-06-2013 08:54:55 AM
Due to PCCE, there is no seperate hds like for traditional UCCE. in PCCE deployment, logger aka dataserver holds the historical data (unless you install a seperate server for hds info). So in my case, i just need to point to the historical db to logger db <inst_SideA).

It is mentioned in the CUIC deployment for PCCE, which I overlooked.

HTH others.
-Senthil

Attachments

    Outcomes