JasperReports not showing same data as in Spectrum in some instances

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

In some JasperServer reports, sometimes data appear different to what is shown in Spectrum. How can this be checked?

Environment

DX NetOps Spectrum Release : 21.2 or later
JasperServer 7.9.x

Cause

JasperServer retries all data from the Spectrum Report Manager (SRM) MySQL DB located on the Spectrum OneClick Server. MySQL debugging can therefore assist in identifying any data issues in the DB.

Resolution

To turn on the MySQL debug logging, do the following:

1. On OneClick/SRM server, goto bash -login and:
   
   

   cd $SPECROOT/mysql/bin
   
   

2. Login to MySQL:
   
   

   ./mysql --defaults-file=../my-spectrum.cnf –uroot –p<PASSWORD> reporting
   
   

3. To enable mysql log, from mysql prompt, run:
   
   

   SET global general_log = on
   
   

4. With this logging configuration set, a file will be created under
   

   
   $SPECROOT/mysql/data

   
   With names:
   

   
   <ocservername>.txt (windows) or <ocservername>.log (Linux) 
   
   

5. Replicate the issue by running the report again and then open a support ticket, attaching the above files for analysis