What do I do with an "SRM has not finished starting" error using JasperSOFT with Spectrum?

Document ID : KB000008569
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

Our Spectrum Report Manager (SRM) no longer works.  We see an error on the OneClick web pages related to JasperSoft e.g. "Jasper Console" or "Jasper Integration" etc, saying 

"SRM has not finished starting".

 

The tomcat log from the SRM Oneclick server, shows various connection errors, as below.  

Restarting the Spectrum Tomcat service, shows no errors or exceptions, in the new tomcat log.

However, we still have the same SRM problem and see the same error on the Web page.

  

java.sql.SQLException: SQL connection lost

at com.aprisma.util.mysql.Database.reconnect(Database.java:509)

at com.aprisma.util.mysql.Database.reconnect(Database.java:485)

at com.aprisma.spectrum.app.slm.web.stat.SLMDbRead.getPreparedStatement(SLMDbRead.java:1522)

at com.aprisma.spectrum.app.slm.web.stat.SLMDbRead.monitorOutageExists(SLMDbRead.java:4964)

at com.aprisma.spectrum.app.slm.web.stat.SLMDbReadWrite.addMonitorOutage(SLMDbReadWrite.java:5204)

at com.aprisma.spectrum.app.slm.web.stat.SLMServiceAvailabilityHandler.insertMonitorOutage(SLMServiceAvailabilityHandler.java:3971)

at com.aprisma.spectrum.app.slm.web.stat.SLMServiceAvailabilityHandler.handleRootCauseEvent(SLMServiceAvailabilityHandler.java:2570)

at com.aprisma.spectrum.app.slm.web.stat.SLMServiceAvailabilityHandler.handleEvent(SLMServiceAvailabilityHandler.java:576)

at com.aprisma.spectrum.app.event.web.model.AbstractAvailabilityHandler.handleRecordEvent(AbstractAvailabilityHandler.java:528)

at com.aprisma.spectrum.app.event.web.model.AbstractAvailabilityHandler.handleRealTimeEventList(AbstractAvailabilityHandler.java:492)

at com.aprisma.spectrum.app.event.web.model.AbstractAvailabilityHandler.dataUpdated(AbstractAvailabilityHandler.java:440)

at com.aprisma.spectrum.app.event.web.model.BackEndEventDataModel.fireDataListeners(BackEndEventDataModel.java:726)

 

 

Stopping the SDN Integration Manager

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

 

 

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

at sun.reflect.GeneratedConstructorAccessor340.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1122)

at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)

at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2181)

... 23 more

Caused by: java.net.ConnectException: Connection refused: connect

at java.net.DualStackPlainSocketImpl.connect0(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)

at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:589)

 

Environment:
This may happen on any version of the integration.In this example we are using:Spectrum 10.2.1Jasper 6.3
Resolution:

When a connection error exists between Spectrum Report Manager and mySQL or JasperSoft, it is required to restart all 3 services involved to initialize the connection properly.:

SPECTRUM Tomcat,

SPECTRUM MYSQL Database Server,

CA Business Intelligence Tomcat.