Updateing a Global Collection in Report Manager

[MichaelDavenport62353086]

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?

[Silvio Okamoto]

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

[MichaelDavenport62353086]

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