Unable to see reports in CABI

book

Article ID: 221458

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

Unable to see the reports on cabi

Jasperserver.log shows below error

java.sql.SQLException: Could not connect to address=(host=OneClickSrvr)(port3306)(type=master) : Connection timed out (Connection timed out)

 

Cause

Unable to communicate with mysql on port 3306 because of firewall blocking the port

Environment

Release : 21.2

Component : Jaspersoft for CA Spectrum

Resolution

As per the jasperserver.log 3306 has a connection timed out error
java.sql.SQLException: Could not connect to address=(host=OneClickSrvr)(port3306)(type=master) : Connection timed out (Connection timed out)

Ensure that you enabled below ports bi directional between oneclick server and cabi server

14001-14006 (Corba)
8080 (OC Tomcat Port)
3306 (mysql)
3307 (mysql for BOXI on Linux)
8082 (Jasper Tomcat)
6400 (BOXI CMS)

 

Recycle Oneclick Tomcat and mysql services

Stopped below services
Spectrum Tomcat
Spectrum Process Daemon
(check if mysql also stopped or not, with process daemon stop mysql service should be stopped)

Started below services
Spectrum Process Daemon (Ensure spectrum mysql service also started)
Spectrum Tomcat

 

Recycle services on CABI Server

cd ${CABI-HOME}
./stopServers.sh
./startServers.sh

Attachments