000030143 - IMG: SQLserver Collector or AFX provisioning errors with jTDS JDBC driver

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000030143
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9, 6.9.1
Platform: SUSE Linux
Product Description: Access Fulfill Express (AFX), IMG Collectors
IssueConnections through collectors or AFX to SQL Server fail.
Discovery for AFX: 
mule_ee.log contains:
Exception followed by:
Caused by: java.lang.UnsupportedClassVersionError: net/sourceforge/jtds/jdbc/Driver : Unsupported major.minor version 51.0
Discovery for collections: 
Error on screen says:
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
CauseCustomer downloaded the latest jTDS driver 1.3.1
This driver is compatible with Java 7, but not Java 6.

ResolutionIMG 6.9.1 and lower are using Java 6. so JTDS driver 1.2.x is needed as 1.3.x will not work.
After you have dropped the driver into /home/oracle/jboss-4.2.2.GA/server/default/lib, you will need to restart ACM and AFX if you are using AFX.