No data in Spectrum Overview report

book

Article ID: 221365

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

We have integrated SRM server and now trying to pull reports. we are getting data for few reports but for spectrum overview we are receiving error

"An unexpected error occurred while retrieving the data. please check the user access privileges"

 

Cause

One click SSL is enabled (HTTPS)

CABI server doesn't have the oneclick server certificate loaded 

Errors in Jasperserver.log

ERROR AsyncJasperPrintAccessor,pool-6-thread-41:321 - Error during report execution
Error with request on the server:
 POST https://Oneclick:8443/spectrum/restful/alarms HTTP/1.1
Additional informations:
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException:

unable to find valid certification path to requested target

Environment

Release : 20.2

Component : Jaspersoft for CA Spectrum

Resolution

Step 1:

Export the certificate from Oneclick server

Login to oneclick server

cd $SPECROOT/Java/bin

keytool -export -alias tomcatssl -keystore $SPECROOT/custom/keystore/cacerts -file /tmp/tomcat.cer

tomcat.cer file will be created in /tmp folder

 

Step 2:

Copy the certificate from Oneclick server to Jasperserver /tmp folder

 

Step 3:

Login to CABI server

cd %CABI-HOME%/java/bin

./keytool -import -alias tomcatssl -keystore "%CABI-HOME%/java/lib/security/cacerts" -file /tmp/tomcat.cer

it will prompt you whether to store (Yes / No).

Type yes

 

Step 4:

Recycle tomcat services on Jasper Server

cd %CABI-HOME%/tomcat/bin

./shutdown.sh

./startup.sh

 

Step 5:

You can check and confirm whether the certificate is loaded into CABI cacerts by running below command

cd %CABI-HOME%/java/bin

./keytool -list -keystore /apps/nm/cabi/java/lib/security/cacerts | grep -i tomcatssl

 

Now you will be able to see the spectrum overview dashboard

 

Attachments