Getting error while executing JasperSoft reports

[Ashok Kumar Modi]

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

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

[Suman Pramanik]

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
------------------------------

[Ashok Kumar Modi]

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

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