Imported data in a column shows an incorrect value

Issue:

In Analytics Plus version 4100, when a data is imported into Analytics Plus(especially from MSSQL server), a few column values are not identified properly. The query used to pull the details works fine on MSSQL server and returns proper results.

eg:

MSSQL otuput:

Cause:

The column was not identified as a valid data type so it is moved to 'unknown'

Solution:

The column identified as a unknown data type should be converted to string datatype. Here are the steps involved

Download the attached file(1MSSQL.jar) and place it under <AnalyticsPlus home>\lib

Restart the Analytics Plus service

Note: If you are using the other versions of Analytics Plus and experiencing the same issue, please write to analyticsplus-support@manageengine.com for further assistance.