JDBC Enrichment policies doesn't work after SOI 4.2 upgrade

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

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

<Please see attached file for image>

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