OneClick JasperSoft Integration: Error Unknown Error. Please Check the tomcat log for details

Products

• CA Spectrum

Issue/Introduction

When trying to integrate OneClick SRM with Jaspersoft the following error is seen


Error Unknown Error. Please Check the tomcat log for details



This prevents OneClick from setting up the spectrum organization, data sources, and layout within jaspersoft

Environment

Release : 20.2

Component : Jaspersoft for CA Spectrum

JasperSoft 7.1.1 installed on RHEL 7 server. 

Cause

Enabling 'SRM - Core - Report Manager' debug within OneClick and re-trying the integration provided some information
   in the OneClick tomcat log files

 

OneClick Web Page
~~> Administration ~~> debugging ~~> Web Server Debug Page (runtime)
  ~~> SRM - Core - Report Manager ~~> On
  Scroll to the bottom and Click 'Apply'

 

 

$SPECROOT/tomcat/logs/catalina.out
-------------------------------------------------------------------------

Apr 07, 2021 14:35:05.282 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - Jasper SSO is : false
Apr 07, 2021 14:35:05.285 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - Getting Jasper Server Info...
Apr 07, 2021 14:35:05.285 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - Server Info URL:http://xxxxxxxxx.xxxxxx.xxx.xxx.xxx:9080/jasperserver-pro/rest_v2/serverInfo
Apr 07, 2021 14:35:05.320 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - Jasper Server Info:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?><serverInfo><build>20190405_0833</build><dateFormatPattern>yyyy-MM-dd</dateFormatPattern><datetimeFormatPattern>yyyy-MM-dd'T'HH:mm:ss</datetimeFormatPattern><edition>PRO</edition><editionName>Enterprise</editionName><features>AUD ANA MT EXP Fusion AHD DB </features><licenseType>Commercial</licenseType><version>7.1.1</version></serverInfo>
Apr 07, 2021 14:35:05.326 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - Integrated with Jasper Server @xxxxxxxxx.xxxxxx.xxx.xxx.xxx, Enabled=true
Apr 07, 2021 14:35:05.328 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - value of isJasperMultitenancyEnabled--false
Apr 07, 2021 14:35:05.328 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - SpecRoot:/opt/spectrum
Apr 07, 2021 14:35:05.991 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - Process ended with rc=1
Apr 07, 2021 14:35:05.991 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - Standard Output: com.jaspersoft.jasperserver.jaxrs.client.core.exceptions.JSClientWebException: Found
 at com.jaspersoft.jasperserver.jaxrs.client.core.exceptions.handling.DefaultErrorHandler.handleStatusCodeError(DefaultErrorHandler.java:109)
 at com.jaspersoft.jasperserver.jaxrs.client.core.exceptions.handling.DefaultErrorHandler.handleError(DefaultErrorHandler.java:68)
 at com.jaspersoft.jasperserver.jaxrs.client.core.JasperserverRestClient.login(JasperserverRestClient.java:80)
 at com.jaspersoft.jasperserver.jaxrs.client.core.JasperserverRestClient.authenticate(JasperserverRestClient.java:50)
 at com.aprisma.spectrum.app.reporting.jasper.JasperServer.testConnection(JasperServer.java:133)
 at com.aprisma.spectrum.app.reporting.jasper.JasperIntegration.main(JasperIntegration.java:28)

Apr 07, 2021 14:35:05.991 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) -
Standard Error: Exception in thread "main" com.jaspersoft.jasperserver.jaxrs.client.core.exceptions.JSClientWebException: Found
 at com.jaspersoft.jasperserver.jaxrs.client.core.exceptions.handling.DefaultErrorHandler.handleStatusCodeError(DefaultErrorHandler.java:109)
 at com.jaspersoft.jasperserver.jaxrs.client.core.exceptions.handling.DefaultErrorHandler.handleError(DefaultErrorHandler.java:68)
 at com.jaspersoft.jasperserver.jaxrs.client.core.JasperserverRestClient.login(JasperserverRestClient.java:80)
 at com.jaspersoft.jasperserver.jaxrs.client.core.JasperserverRestClient.authenticate(JasperserverRestClient.java:50)
 at com.aprisma.spectrum.app.reporting.jasper.JasperServer.testConnection(JasperServer.java:133)
 at com.aprisma.spectrum.app.reporting.jasper.JasperIntegration.main(JasperIntegration.java:28)

Apr 07, 2021 14:35:05.991 (https-jsse-nio-8443-exec-10) (RepMgr) - (DEBUG) - Reports redeployment done. Success?=false




The only real clue from the debug was 'JasperserverRestClient.authenticate', which lead to clearing and re-entering the password in the Jaspersoft Integration page.

Resolution

 

The user password field appeared to have been incorrectly entered or there was a typo while entering it.

- verified the Jaspersoft superuser password by logging into JasperServer directly
      http://<jasperServer>:<port>/jasperserver-pro

- Cleared and re-entered the superuser password and the integration is now successful to jaspersoft.
    We were also able to now see the spectrum organization, datasources and reports within jaspersoft.