JDBC Enrichment policies doesn't work after SOI 4.2 upgrade

Document ID : KB000116996
Last Modified Date : 05/10/2018
Show Technical Document Details
Issue:
After upgrading SOI from 4.0 to 4.2, JDBC enrichment policies stopped working
Environment:
Windows
SOI 4.2
Cause:
SOI 4.2 replaces old SQLJDBC jar files to "sqljdbc4-4.0.jar", hence the file name & path doesn't match and enrichment fails and we could see below exceptions in logs

"eventplus.catalog - CallJDBC:Classnotfound Exception:com.microsoft.sqlserver.jdbc.SQLServerDriver." error
Resolution:
As SOI 4.2 uses latest "sqljdbc4-4.0.jar" which is available in following folders on the SOI Manager

=> \SOI\Tools\Priming Utility\lib
=> \SOI\indexer\lib

We need to adjust the Enrichment policy "Class Path" as shown in the picture
User-added image

Note: You may copy this new .jar to other folder and adjust the "Class Path"