search cancel

JasperReports not showing same data as in Spectrum in some instances


Article ID: 254472


Updated On:


DX NetOps CA Spectrum


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 7.9.x


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:

  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


    With names:

    (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