No data in Spectrum Overview report
Article ID: 221365
Updated On:
Products
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"
Environment
Release : 20.2, 21.2
Component : Jaspersoft for CA Spectrum
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
Resolution
Step 1:
Export the certificate from Oneclick server
Login to oneclick server
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
Feedback
