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'

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.