Error: Event viewer error 4100 - Database Exception

Version 3

    Verified Product Versions

    Endpoint Manager 2016.x

    Issue

    When a device that is discovered through UDD/XDD sends in its first inventory scan to the core server, the following message is seen in the Windows Event Viewer:

     

    AGLS_Error.png

     

    The message states:

     

    LANDESK Inventory Server Error 4100 Database Exception:xxxx.SCN, LDInv.dll

    -2147217913

    Conversion failed when converting date and/or time from character string.

     

    UPDATE COMPUTER SET AGLS_status = ?, AGLS_LastAttempted = ? WHERE Computer_Idn = ?, Thread ID: 14268。

    Cause

    The root cause of the issue is that the SCN file is attempting to add a 'null' value to the AGLS_status and AGLS_LastAttempted columns in the computer table where their data type does not allow for null values.

     

    Impact

    While the error may seem troublesome, it is purely cosmetic and does not affect the processing of the scan files and as such can be safely ignored.

     

    Resolution

    The database values have been updated within the 2017.3 release of Ivanti Endpoint Manager and these messages will no longer be seen within the Windows Event Viewer on the core server. It is recommended that you upgrade to this version to resolve this issue.