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'

Article Id: 170632

Status: Published

Updated On: 24-01-2018 03:52

Legacy Id: TECH248386

Products:

Inventory Pack for Servers

Issue/Introduction:

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]

Cause:

Instead of sending an integer (numerals only) as the dataclass expects – the null value in this case returns the string ‘NaN’.

Resolution:

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.