TIBCO Spotfire Server goes unresponsive intermittently after using Amazon Redshift Driver

TIBCO Spotfire Server goes unresponsive intermittently after using Amazon Redshift Driver

TIBCO Spotfire Server version 10.3 or higher may become unresponsive when the JDBC Amazon Redshift Driver that comes with the installation is used for data access, and the following errors are seen:

In the Catalina.log

SEVERE [https-jsse-nio-9443-exec-2] org.apache.coyote.AbstractProtocol$ConnectionHandler.process Failed to complete processing of a request java.lang.OutOfMemoryError: Java heap space 
INFO [https-jsse-nio-9443-exec-2] org.apache.catalina.connector.CoyoteAdapter.checkRecycled Encountered a non-recycled request and recycled it forcedly. org.apache.catalina.connector.CoyoteAdapter$RecycleRequiredException 
at org.apache.catalina.connector.CoyoteAdapter.checkRecycled(CoyoteAdapter.java:525)
at org.apache.coyote.http11.Http11Processor.recycle(Http11Processor.java:1323) 
at org.apache.coyote.AbstractProtocol$ConnectionHandler.release(AbstractProtocol.java:1047) 
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:1015) 
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) 
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) 
at java.lang.Thread.run(Thread.java:748)

In the server.log:

ERROR 2019-08-02T15:32:29,776+0000 [*pool-14-thread-18, SPOTFIRESYSTEM\scheduledupdates, #29, #90139*] ws.dat.Job$GetDataTask: Exception in com.spotfire.ws.dat.Job$GetDataTask.run
ERROR 2019-08-02T15:32:29,776+0000 [*pool-14-thread-18, SPOTFIRESYSTEM\scheduledupdates, #29, #90139*] ws.dat.Job$GetDataTask: Exception in com.spotfire.ws.dat.Job$GetDataTask.runjava.lang.OutOfMemoryError: Java heap space... 
ERROR 2019-08-02T15:36:17,016+0000 [] : Critical system error detected. Will be handled accordingly to configured handler [hnd=StopNodeOrHaltFailureHandler [tryStop=false, timeout=0, super=AbstractFailureHandler [ignoredFailureTypes=[SYSTEM_WORKER_BLOCKED]]], failureCtx=FailureContext [type=SYSTEM_WORKER_TERMINATION, err=java.lang.IllegalStateException: Thread grid-nio-worker-tcp-comm-0 is terminated unexpectedly]]java.lang.IllegalStateException: Thread grid-nio-worker-tcp-comm-0 is terminated unexpectedly at org.apache.ignite.internal.util.nio.GridNioServer$AbstractNioClientWorker.body(GridNioServer.java:1827) ~[ignite-core.jar:2.7.0] 
at org.apache.ignite.internal.util.worker.GridWorker.run(GridWorker.java:120) ~[ignite-core.jar:2.7.0] 
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_212]WARN 2019-08-02T15:36:48,590+0000 [] processors.failure.FailureProcessor: No deadlocked threads detected.

  This issue is caused by Amazon Redshift driver that comes with TIBCO Spotfire Server installation bundle. Please follow these steps to resolve this issue:

1. Download the latest Amazon Redshift driver from: https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver
2. Shutdown TIBCO Spotfire Server service
3. On the TIBCO Spotfire Server machine, replace the file redshift-jdbc42-no-awssdk.jar in folder <TIBCO Spotfire Server installation directory>\tomcat\webapps\spotfire\WEB-INF\lib\ with the jar-file downloaded in step 1.
4. Restart TIBCO Spotfire Server service

External: Download the Amazon Redshift JDBC Driver.

• https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver