|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle |
RSA Version/Condition: 6.x, 7.x
|Issue||Data 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.|
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:
When a SQL Server AFX connector fails, the mule_ee.log file ($AFX_HOME/esb/logs/mule_ee.log) has the following error:
|Cause||These 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.
|Resolution||For RSA Identity Governance & Lifecycle versions 7.x which use Java 7+, install the jTDS 1.3.x driver.|
Place the new driver in the lib folder and remove the existing driver. Execute these commands as the oracle user.