000030143 - Data Collections and AFX Connectors from/to SQL Server endpoints fail when using the jTDS driver in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Apr 9, 2020
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000030143
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle 
RSA Version/Condition: 6.x, 7.x
 
IssueData collections that collect from SQL Server endpoints and AFX connectors that provision to SQL Server endpoints fail in RSA Identity Governance & Lifecycle when using the jTDS JDBC driver.
 

SYMPTOMS:



Data Collection

 

When a SQL Server data collection fails, a test of the same collector fails with the following error in the user interface:


Collector test failed:

com.aveksa.server.runtime.ServerException: Test request failed with response: com.aveksa.server.runtime.ServerException: com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by java.sql.SQLException: No suitable driver found for jdbc:sqlserver://node,domain.com:1433;databaseName=somedatabase



AFX Connector

 

When a SQL Server AFX connector fails, the mule_ee.log file ($AFX_HOME/esb/logs/mule_ee.log) has the following error:

 


Exception followed by:
Caused by: java.lang.UnsupportedClassVersionError: net/sourceforge/jtds/jdbc/Driver :
Unsupported major.minor version 51.0


 
CauseThese error messages indicate an incompatibility between the jTDS JDBC driver and the version of Java being used by RSA Identity Governance & Lifecycle.

For example, the jTDS 1.3.1 driver is compatible with Java 6 but not Java 7.
 
ResolutionFor RSA Identity Governance & Lifecycle versions 7.x which use Java 7+, install the jTDS 1.3.x driver.
 

For RSA Identity Governance & Lifecycle versions 6.9.1 and below which use Java 6, install the jTDS 1.2.x driver.


Place the new driver in the lib folder and remove the existing driver. Execute these commands as the oracle user.

 


cp <jTDS 1.2.x driver> $AVEKSA_HOME/jboss-4.2.2.GA/server/default/lib/<jTDS 1.2.x driver>
rm <existing SQL Server driver>
afx stop
acm restart
afx start


 

Attachments

    Outcomes