No data in Spectrum Overview report
search cancel

No data in Spectrum Overview report


Article ID: 221365


Updated On:


CA Spectrum DX NetOps


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"



Release : 20.2, 21.2

Component : Jaspersoft for CA Spectrum


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: PKIX path building failed:

unable to find valid certification path to requested target


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




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