ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
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
Updated On:
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.
Until then any, 'NULL' values in the Size Allocated column can safely be interpreted as zero.
Feedback
Yes
No
Powered by
