no data in CUIC 9.x reports

Version 1
    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