In some JasperServer reports, sometimes data appear different to what is shown in Spectrum. How can this be checked?
DX NetOps Spectrum Release : 21.2 or later
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.
To turn on the MySQL debug logging, do the following:
./mysql --defaults-file=../my-spectrum.cnf –uroot –p<PASSWORD> reporting
SET global general_log = on
<ocservername>.txt (windows) or <ocservername>.log (Linux)