The issue occurs when server pack for inventory runs on SQL servers and they return a NULL value in the ‘Size Allocated’ column of the database dataclass. This is a legitimate value to return from the server, but this value is not handled very well in our current code.
This can be seen in the Notification Server (NS) log files:
Data was ignored when loading data for column [Size Allocated] into class: 'Database' (38473c2c-2605-45dc-977b-bab0fe1a0e64)
Failed to parse Int64, column [Size Allocated], value [NaN], target: dbo.[Inv_Database] [System.FormatException @ Altiris.NS]
Instead of sending an integer (numerals only) as the dataclass expects – the null value in this case returns the string ‘NaN’.
This will be correctly handled as zero in the ITMS 8.5 release due in Q2/2018.
Until then any, 'NULL' values in the Size Allocated column can safely be interpreted as zero.
Subscribing will provide email updates when this Article is updated. Login is required.