SQL Server data collectors in RSA Identity Governance & Lifecycle periodically fail with connection timed out errors
Originally Published: 2019-07-25
Last Modified: 2023-09-25
Article Number
Applies To
RSA Version/Condition: 7.1.0, 7.1.1
Issue
The aveksaServer.log has the following errors. In this example, the SQL Server collector is an Account Data Collector (ADC) that uses the jTDS driver.
05/30/2019 12:54:22.231 INFO (Thread-123) [com.aveksa.client.component.communication.ChangeListHandler] Got new change item method=Run ChangeItem[ID=1559217262230, type=TestCollectionRequest, source=535, source-name=AC_Intellimatch]
05/30/2019 12:54:29.050 ERROR (ApplyChangesRegularThread-176) [SystemErr] java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:436)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.sql.DriverManager.getConnection(DriverManager.java:664)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.sql.DriverManager.getConnection(DriverManager.java:247)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.collector.accountdata.DBGenericAccountReader.getConnection(DBGenericAccountReader.java:874)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.collector.accountdata.DBGenericAccountReader.extractAccounts(DBGenericAccountReader.java:283)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.collector.accountdata.DBGenericAccountReader.collectAccounts(DBGenericAccountReader.java:204)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.collector.accountdata.DBGenericAccountReader.collectTestData(DBGenericAccountReader.java:144)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collectData(AccountDataCollector.java:358)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collect(AccountDataCollector.java:302)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collectTestData(AccountDataCollector.java:277)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.framework.DataCollectorManager.collect(DataCollectorManager.java:533)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.collector.DefaultCollectorManager.actUpon(DefaultCollectorManager.java:204)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.collector.DefaultCollectorManager.handle(DefaultCollectorManager.java:102)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.event.DefaultEventManager.handle(DefaultEventManager.java:60)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.framework.SimpleEventSource.notifyListeners(SimpleEventSource.java:67)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.communication.DefaultCommunicationManager.notifyEvent(DefaultCommunicationManager.java:377)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.communication.ChangeListHandler.applyChanges(ChangeListHandler.java:364)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.communication.ChangeListHandler.access$300(ChangeListHandler.java:58)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.communication.ChangeListHandler$ChangeApplyingRunnable.run(ChangeListHandler.java:275)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.lang.Thread.run(Thread.java:748)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] Caused by: java.net.ConnectException: Connection timed out (Connection timed out)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.PlainSocketImpl.socketConnect(Native Method)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.Socket.connect(Socket.java:589)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:251)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:331)
05/30/2019 12:54:29.055 ERROR (ApplyChangesRegularThread-176) [SystemErr] ... 20 more
05/30/2019 12:54:29.055 ERROR (ApplyChangesRegularThread-176) [com.aveksa.collector.accountdata.DBGenericAccountReader] Error while extracting the account data: com.aveksa.common.DataReadException: ERROR: Could not get accounts data: FAILED method=collectAccounts
05/30/2019 12:54:29.050 ERROR (ApplyChangesRegularThread-176) [SystemErr] java.sql.SQLException: Network error IOException: Connection timed out (Connection timed out)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:436)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.sql.DriverManager.getConnection(DriverManager.java:664)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.sql.DriverManager.getConnection(DriverManager.java:247)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.collector.accountdata.DBGenericAccountReader.getConnection(DBGenericAccountReader.java:874)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.collector.accountdata.DBGenericAccountReader.extractAccounts(DBGenericAccountReader.java:283)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.collector.accountdata.DBGenericAccountReader.collectAccounts(DBGenericAccountReader.java:204)
05/30/2019 12:54:29.051 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.collector.accountdata.DBGenericAccountReader.collectTestData(DBGenericAccountReader.java:144)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collectData(AccountDataCollector.java:358)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collect(AccountDataCollector.java:302)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collectTestData(AccountDataCollector.java:277)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.framework.DataCollectorManager.collect(DataCollectorManager.java:533)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.collector.DefaultCollectorManager.actUpon(DefaultCollectorManager.java:204)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.collector.DefaultCollectorManager.handle(DefaultCollectorManager.java:102)
05/30/2019 12:54:29.052 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.event.DefaultEventManager.handle(DefaultEventManager.java:60)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.datacollector.framework.SimpleEventSource.notifyListeners(SimpleEventSource.java:67)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.communication.DefaultCommunicationManager.notifyEvent(DefaultCommunicationManager.java:377)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.communication.ChangeListHandler.applyChanges(ChangeListHandler.java:364)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.communication.ChangeListHandler.access$300(ChangeListHandler.java:58)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at com.aveksa.client.component.communication.ChangeListHandler$ChangeApplyingRunnable.run(ChangeListHandler.java:275)
05/30/2019 12:54:29.053 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.lang.Thread.run(Thread.java:748)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] Caused by: java.net.ConnectException: Connection timed out (Connection timed out)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.PlainSocketImpl.socketConnect(Native Method)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at java.net.Socket.connect(Socket.java:589)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:251)
05/30/2019 12:54:29.054 ERROR (ApplyChangesRegularThread-176) [SystemErr] at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:331)
05/30/2019 12:54:29.055 ERROR (ApplyChangesRegularThread-176) [SystemErr] ... 20 more
05/30/2019 12:54:29.055 ERROR (ApplyChangesRegularThread-176) [com.aveksa.collector.accountdata.DBGenericAccountReader] Error while extracting the account data: com.aveksa.common.DataReadException: ERROR: Could not get accounts data: FAILED method=collectAccounts
Please refer to 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the log files for your specific deployment.
Cause
Resolution
Notes
This is a legacy Knowledge Base Article and only applies to the listed versions which are no longer actively supported.
RSA does not recommend the continued use of the public domain JTDS driver on current versions of the product. RSA recommends customers use the JDBC driver specific for their database.
Related Articles
Collector circuit breaker tripped by rejections in RSA Via Lifecycle and Governance 270Number of Views How to move the StealthAUDIT DAG database to a new server in RSA Identity Governance & Lifecycle 42Number of Views Timeout when editing a collector in RSA Governance & Lifecycle 148Number of Views RSA Via Lifecycle and Governance - How to set up an environment to run WebServices with Turkish Characters 14Number of Views RSA Identity Governance and Lifecycle MigrationReports.zip fails to install Migration Reports with ORA-04063: package body… 152Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?