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

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

book

Article ID: KB0080605

calendar_today

Updated On:

Products Versions
Spotfire Server All Supported Versions

Description

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

----------------------   

Issue/Introduction

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

Environment

All Supported Environments

Resolution


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.
Powered by Wolken Software