Forum Discussion

nitinbhansali's avatar
nitinbhansali
New Contributor
5 years ago

SQL Server connection time out

SnapLogic_SQL_server_timeout_errors.docx (120.0 KB)
Hello All,

I am getting intermittent SQL Server connection error as below
Failed to retrieve a database connection. Also uploaded the document ( basically screenshots)
I would appreciate it your help or any pointer to resolve the issue will be of great help.

snippet as below : -
Resolution:

Address the reported issue.

Reason:

HikariPool_SQLSERVER2008_jdbc_sqlserver_//proderp.arrivagroup.net_5075_b7ba13ef-304c-4d18-b770-faaabd47e81b - Connection is not available, request timed out after 1000ms.

Hide Details…

SnapCompletionService
com.snaplogic.snap.api.SnapDataException: Failed to retrieve a database connection. at com.snaplogic.snap.api.sql.JdbcDataSourceRegistryImpl.getConnection(JdbcDataSourceRegistryImpl.java:273) at com.snaplogic.snap.api.sql.JdbcDataSourceRegistryImpl.retryGetConnection(JdbcDataSourceRegistryImpl.java:324) at com.snaplogic.snap.api.sql.JdbcDataSourceRegistryImpl.getConnection(JdbcDataSourceRegistryImpl.java:266) at com.snaplogic.snap.api.sql.JdbcDataSourceRegistryImpl.retryGetConnection(JdbcDataSourceRegistryImpl.java:324) at com.snaplogic.snap.api.sql.JdbcDataSourceRegistryImpl.getConnection(JdbcDataSourceRegistryImpl.java:266) at com.snaplogic.snap.api.sql.JdbcDataSourceRegistryImpl.retryGetConnection(JdbcDataSourceRegistryImpl.java:324) at com.snaplogic.snap.api.sql.JdbcDataSourceRegistryImpl.getConnection(JdbcDataSourceRegistryImpl.java:266) at com.snaplogic.snap.api.sql.accounts.BaseDa

Thanks & Regards
Nitin.

3 Replies

  • alchemiz's avatar
    alchemiz
    Contributor III
    5 years ago

    Hi Nitin,

    In the SQL server account, have you tried increasing the Max pool size ?

  • nitinbhansali's avatar
    nitinbhansali
    New Contributor
    5 years ago

    Hi Mike,

    Thanks for your prompt response … much appreciated. My initial findings were the same. unfortunately It is a production system and wanted some definitive answer from the SanpLogic , hence raised the support call as well as on this forum topic … Another issue, I might think of it is server resource will cope with these increased Max pool size .

    They have suggested to increase timeout from 1000Ms to 10000Ms and count from 60 to 200.
    Cheers

  • Supratim's avatar
    Supratim
    Contributor III
    5 years ago

    @nitinbhansali you can validate the client jar exact version from server for good performance. We have faced similar issue, using oracle thin client it was resolved.