I'm receiving hundreds of the errors (very bottom) in my NS log. I have located Altiris KB28720 that addresses this error. The cause is apparently a NULL value in the Inv_AeX_AC_tcpip subnet column. Their resolution is to run a these scripts.



This to locate them.



SELECT vc.name, ip.*

FROM Inv_Aex_ac_tcpip ip

JOIN vcomputer vc on vc.guid = ip._resourceguid

WHERE ip.subnet IS NULL



This to update the subnet



UPDATE inv_aex_ac_tcpip

SET subnet = '255.0.0.0'

WHERE subnet is null



Sounds like a simple fix. However, I'm concerned why the subnet column is not being populated. As this should be populated from a basic inventory. That, and there are around 400 of my total 1200 nodes with this issue, leading me to believe something is a little off. I think this also may have caused the issues I had a couple days ago with my package servers.



Can anyone offer any suggestions on this before I just pop in subnets for these clients? Plus, they're on different subnets.





Log File Name: D:\Program Files\Altiris\Notification Server\Logs\a40.log

Priority: 1

Date: 1/30/2009 8:11:27 AM

Tick Count: 140506250

Host Name: NS

Process: w3wp.exe (7504)

Thread ID: 1584

Module: AltirisNativeHelper.dll

Source: Altiris.ClientTask.Web.GetClientTaskServers.Page_Load

Description: An exception occurred while attempting to get Client Task Server list ( Unhandled exception. Type=System.Data.SqlTypes.SqlNullValueException Msg=Data is Null. This method or property cannot be called on Null values. Src=System.Data

StackTrace=

at System.Data.SqlTypes.SqlString.get_Value()

at System.Data.SqlClient.SqlDataReader.GetString(Int32 i)

at Altiris.ClientTask.Web.GetClientTaskServers.LocateServersBasedOnSubnet(Guid resourceGuid)

at Altiris.ClientTask.Web.GetClientTaskServers.Page_Load(Object sender, EventArgs e) )