000037764 - SQL Server data collectors in RSA Identity Governance & Lifecycle periodically fail with connection timed out errors

Document created by RSA Customer Support Employee on Jul 26, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037764
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: All
 
IssueSQL Server data collectors intermittently fail with connection timed out errors.

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 



Please refer to 000030327 - Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the log files for your specific deployment.
CauseThe host name in the database connection string that points to the location of the SQL Server database is mapped to more than one IP address.
ResolutionModify the host name in the database connection string to a single IP address. In the RSA Identity Governance & Lifecycle user interface go to Collectors > [collector type] > [name of the collector] > Edit > Next.

User-added image

Attachments

    Outcomes