VERIFIED SOLUTION i

Resolve EngageOne Batch error 'NoClassDefFoundError: com.microsoft.sqlserver.jdbc'

Product Feature: Batch (Accumulated)

Operating System: Linux

 

Issue

When Running EngageOne Batch the follow error is shown in the systemout.log file of WebSphere:

Error encountered java.lang.NoClassDefFoundError: com.microsoft.sqlserver.jdbc.SQLServerException

Cause

The system is unable to either find or access the sqljdbc4.jar file.

Resolution

UPDATED: September 29, 2017
To resolve this issue change permissions on the following files:
sqljdbc4.jar
tds.jar

located in the <install location>/server/batch/lib folder to 775 by running the following command

chmod 775 sqljdbc4.jar
chmod 775 tds.jar

Re-run the batch job and confirm the error is now resolved.