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.