Inventory pack for servers running on SQL creates warning messages in the NS logs: Data was ignored when loading data for column [Size Allocated] into class: 'Database'
Last Updated January 24, 2018
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 to Subscribe