Error: Event viewer error 4100 - Database Exception

Version 3

    Verified Product Versions

    Endpoint Manager 2016.x


    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:




    The message states:


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


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


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


    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.



    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.



    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.