DX NetOps

Expand all | Collapse all

JasperSoft reports integrates successfully with Spectrum 10.3.1, but shows no reports in the repository

  • 1.  JasperSoft reports integrates successfully with Spectrum 10.3.1, but shows no reports in the repository

    Posted Apr 02, 2019 11:17 AM

    Hello,

     

    I have Successfully integrated jasper and spectrum 10.3.1, but when i try to fetch the report it gives error as no record found. some spectrum information is visible in jasper console as screenshot. have anyone face this issue please suggest. 



  • 2.  Re: JasperSoft reports integrates successfully with Spectrum 10.3.1, but shows no reports in the repository



  • 3.  Re: JasperSoft reports integrates successfully with Spectrum 10.3.1, but shows no reports in the repository

    Broadcom Employee
    Posted Apr 02, 2019 03:55 PM

    Hm the link appears to be working for me. 

     

    Document ID : KB000007814
    Last Modified Date : 02/01/2019
    Show Technical Document Details
    Issue:

    We are using the Unified JasperSoft reports, with various CA products for reporting, and so are using a common DB repository and not the mySQL that comes with Spectrum.

    It integrates successfully with Spectrum, but then shows no reports in the repository.

     

    Environment:
    CA Spectrum 10.X CABI JasperReports Server Integration for Unified Dashboards and ReportingCommon DB repository outside of Spectrum mySQL instance.
    Cause:

    In this situation, mySQL was installed manually and apart from Spectrum so did not take the mySQL config that comes with the Spectrum install.  In the OneClick/SRM tomcat log files we will find an import failed message, such as below.

    “Import State: Import failed. Reason: null id in com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource entry (don't flush the Session after an exception occurs) Errors:ErrorDescriptor{message='null', errorCode='import.failed', parameters=[null id in com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.persistent.RepoFileResource entry (don't flush the Session after an exception occurs)], errorUid='null', exception=null} Warnings:null”

     

    This points to a problem with the mySQL database configuration.

    Resolution:

    This can be resolved by changing the mySQL configuration at <mysql install directory OR a sub directory>\my.cnf (Linux) or my.ini (Windows).  Search for “max_allowed_packet”.

     

    Before change : max_allowed_packet=1M

    After Change : max_allowed_packet=16M

    Save the file and re-start the mySQL server. Once it is up, please perform the integration step, on the OC web administration page "Jasper integration" one more.  Once it completes sucessfully, log into JasperSoft and check for the reports.

    Additional Information:

    https://docops.ca.com/ca-spectrum/10-3-0/en/installing-and-upgrading/install-report-manager/cabi-jasperreports-server/install-cabi-jasperreports-server/

    JasperReports Server needs DB repository (you can use MySQL that comes with Spectrum).  JasperReports Server creates its own DB (‘jaspersoft’) in the MySQL instance.  You can install Spectrum OneClick with SRM on a separate box even before attempting to install JasperReports Server and use that as repository. If you plan to use JasperReports Server for other CA products also, then you can select a common repository. 

     

     

     

    Regards, 

    Jay V