search cancel

JasperReports not showing same data as in Spectrum in some instances

book

Article ID: 254472

calendar_today

Updated On:

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