Information link cache is getting expired before the cache timeout period when we configure the Validation SQL query.

Created
October 08, 2021 23:24

Date Posted: 2018-09-27
Product: TIBCO Spotfire®

Problem:

Solution:

When information link cache is configured for a certain period and validation SQL query is configured ,this validation query will be executed everytime the cached information link is loaded.

If the validation query fails to execute because it does not get a database connection to the Spotfire server the following warning will be thrown in the server.log
----------------------

WARN 2018-09-10T15:26:46,954-0700 [sp714svc1, #1, #207] api.query.InformationLinkCache: Unable to run a configured information link cache validation query - the information link will not be cached.
java.sql.SQLException: Timeout while waiting for database connection after 10 seconds

----------------------
Check if the min and max connections for the respective datasource is 1.If yes change the max connections to some number <40(Eg: 10) where connection can be acquired to execute the validation query. The default connections set in the Spotfire server configuration is 40 so that max connections set for a data source should be less than or equal to 40. The max connections in the server configuration is configurable.