DX NetOps

Expand all | Collapse all

Updateing a Global Collection in Report Manager

  • 1.  Updateing a Global Collection in Report Manager

    Posted 05-07-2018 11:36 AM

    We are using Jaspersoft Report Manager and one of while running an Availability_Group report, one of the Global Collections didn't identify all the assets that are in the actual GC.  How can I check if Report Manager is correctly communication with that GC in Spectrum?



  • 2.  Re: Updateing a Global Collection in Report Manager

    Broadcom Employee
    Posted 05-07-2018 12:46 PM

    Hi Michael,

     

    First check whether the reporting database is in sync. Run the following MySQL query:

     

    1. Open a bash shell (bash -login)

    2. Navigate to $SPECROOT/mysql/bin directory

    cd mysql/bin

    3. Launch the MySQL command prompt

    ./mysql -uroot -proot ddmdb (for Windows)

    ./mysql --defaults-file=../my-spectrum.cnf -uroot -proot ddmdb (for Linux or Solaris)

    4. Run the following MySQL query:

    SELECT * FROM landscape\G

     

    If the reporting db is in sync, run the following MySQL query to list the models that are member of a Global Collection:

    SELECT entity.entity_name, entity.create_time, entity.destroy_time, model.network_address FROM entity, entitygroup, entitygroupentity, model WHERE entity.entity_ID=entitygroupentity.entity_ID AND entitygroupentity.entity_group_ID=entitygroup.entity_group_ID AND entity.current_model_key=model.model_key AND entitygroup.entity_group_name='<Global_Collection_name>';

     

    Where <Global_Collection_name> is the problematic Global Collection's name

     

    Also check whether there are bucket files in the $SPECROOT/msyql/data/reporting/ directory.

    Also check the Tomcat's log file ($SPECROOT/tomcat/logs/sdtout.log or catalina.out).

     

    Thanks,

    Silvio



  • 3.  Re: Updateing a Global Collection in Report Manager

    Posted 06-06-2018 07:45 AM

    There's now way to simply sync the report repositories to the Global collections?