Clarity

 View Only

  • 1.  Getting error while executing JasperSoft reports

    Posted 23 days ago
    Edited by Ashok Kumar Modi 23 days ago

    Hello All,

    Here is little back story of the error:

    Customer has done a fresh installation of JasperSoft Server. 

    Integration of JasperSoft with Clarity is successful. We can see status of JasperSoft as "Available" in CSA.

    All the JasperSoft post installation tasks are done.

    Customer is able to login to JasperSoft as "superuser".

    Problem:

    When they are trying to execute a report from Advanced Reporting, they get below error message:

    Customer did following to rectify above error:

    Generated a new keystore using admin command and copied it to required tomcat directory of JasperSoft server. Tomcat service restarted.

    Ran following commands:

    admin update jasperParameters : This command completed successfully.

    admin jaspersoft syncPPMContext -userName superuser -password <Super User's Password> : This command failed with below error:

    Custom Class Alias found for timeadmin.timesheetValidator: com.abt.service.TimesheetValidatorService
    Syncing PPM context to jaspersoft..
    16:34:51.938 [main] ERROR com.ca.jasper.restAdapter.JasperRestAdapter - Login failed: 500 -
    Could not login to https://<JasperSoft Server Host Name>:8443/reportservice with username superuser
    Failed to process the jasper command. : Could not login to https://<JasperSoft Server Host Name>:8443/reportservice with username superuser
    Error occurred: com.niku.union.reporting.jaspersoft.exception.JasperDomainException: Could not login to https://<JasperSoft Server Host Name>:8443/reportservice with username superuser
    Check admin.log or use -verbose for more information.

    Here is what we get from admin.log:

    Jul 29, 2025, 4:34:51 PM Error executing command: jaspersoft syncPPMContext -userName ****** -password ******
    com.niku.union.reporting.jaspersoft.exception.JasperDomainException: Could not login to https://<JasperSoft Server Host Name>:8443/reportservice with username superuser
      at com.niku.reporting.jasper.ClarityJasperAdmin.login(ClarityJasperAdmin.java:267)
      at com.niku.reporting.jasper.importexport.JasperSyncPPMCommand.execute(JasperSyncPPMCommand.java:49)
      at com.niku.reporting.jasper.ClarityJasperAdmin.processCommand(ClarityJasperAdmin.java:3565)
      at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:398)
      at com.niku.nsa.service.AdminManager.execute(AdminManager.java:204)
      at com.niku.nsa.service.Admin.main(Admin.java:78)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
      at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.base/java.lang.reflect.Method.invoke(Method.java:569)
      at com.werken.forehead.Forehead.run(Forehead.java:551)
      at com.werken.forehead.Forehead.main(Forehead.java:581)

    Any suggestions or pointers to explore to resolve the error?

    Regards

    -Ashok



    -------------------------------------------



  • 2.  RE: Getting error while executing JasperSoft reports

    Broadcom Employee
    Posted 22 days ago

    Looking at the problem it seems the bean connection is unable to connect to clarity, so we need to check Clarity connection if its encrypted. Make sure the bin directory doesn't have custom libraries. 



    ------------------------------
    Thanks & Regards
    Suman Pramanik
    ------------------------------



  • 3.  RE: Getting error while executing JasperSoft reports

    Posted 21 days ago

    Thanks for reverting, Suman.

    By "we need to check Clarity connection if its encrypted" do you mean Clarity + JaspertSoft authentication using integration keys? Or trustServerCertificate parameter in the JDBC URL for Clarity and DWH databases in Clarity's properties.xml? By default it is set to "true" but when it is set to "false" client has to validate Server's SSL\TLS certificate. Please share if you are referring to this?

    By "bin directory doesn't have custom libraries." you mean bin directory of Clarity or JasperSoft? And I assume by "Custom library" you meant any non out of the box library? Right?

    Thanks in advance

    -Ashok

    -------------------------------------------



  • 4.  RE: Getting error while executing JasperSoft reports

    Broadcom Employee
    Posted 21 days ago

    That's correct and also compare the Clarity_home\lib matches with OOTB and no custom libraries are stored in Clarity_home\lib directory



    ------------------------------
    Thanks & Regards
    Suman Pramanik
    ------------------------------



  • 5.  RE: Getting error while executing JasperSoft reports

    Posted 21 days ago

    Couple common troubleshooting items:

    • If jasper's is running on HTTPS using a self signed cert, ensure its trusted by Clarity's cacerts
    • regenerate the certificates for the trust between the apps
    • place them in the jasper folder and restart the app
    • Then run the 2 commands you are trying to run
    -------------------------------------------