Unable to save existing packages after editing them or unable to download or recreate patch packages. Alogs are full of warnings or errors referencing the packages and say "An invalid IP address was specified"

<event date="date/time -04:00" severity="2" hostName="SMP Servername" source="Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.ManageDistributionPoints" module="AeXSVC.exe" process="AeXSvc" pid="1528" thread="65" tickCount="81393568"><![CDATA[Unable to manage the distribution points for package: 'package name' (package GUID)
An invalid IP address was specified.
   [System.FormatException @ System]
   at System.Net.IPAddress.InternalParse(String ipString, Boolean tryParse)
   at Altiris.Resource.StandardResources.SiteSubnetRelationCache.ConvertIPStrings(IEnumerable`1 tcpipAddresses)
   at Altiris.Resource.StandardResources.SiteSubnetRelationCache.GetClosestSitesForAddresses(IEnumerable`1 tcpipAddresses)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.GetAutoAssignmentCollection(Guid packageGuid, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.SetPackageServerAssignment(Guid packageGuid, String packageName, SourceType st, String packageLocation, PkgSvrAssignmentType method, Boolean automaticallyAssignSites, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.SetPackageServerAssignment(PackageItem package, PkgSvrAssignmentType method, Boolean automaticallyAssignSites, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.ManageDistributionPoints(PackageItem pkgItem, Boolean snapshotOnly)
 
<event date="date/time -04:00" severity="1" hostName="SMP Servername" source="Altiris.NS.StandardItems.SoftwareDelivery.PackageItem.OnSave" module="w3wp.exe" process="w3wp" pid="3620" thread="379" tickCount="82355392"><![CDATA[Unable to save the Package. Reason: System.FormatException: An invalid IP address was specified.
   at System.Net.IPAddress.InternalParse(String ipString, Boolean tryParse)
   at Altiris.Resource.StandardResources.SiteSubnetRelationCache.ConvertIPStrings(IEnumerable`1 tcpipAddresses)
   at Altiris.Resource.StandardResources.SiteSubnetRelationCache.GetClosestSitesForAddresses(IEnumerable`1 tcpipAddresses)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.GetAutoAssignmentCollection(Guid packageGuid, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.SetPackageServerAssignment(Guid packageGuid, String packageName, SourceType st, String packageLocation, PkgSvrAssignmentType method, Boolean automaticallyAssignSites, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.SetPackageServerAssignment(PackageItem package, PkgSvrAssignmentType method, Boolean automaticallyAssignSites, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.PackageItem.OnSave(Boolean bExistingItem)
**CEDUrlStart** :http://entced.symantec.com/entt?product=SMP&version=7.5.3153.0&language=en&module=WXMWZGoLfGP6PLrkwtXY1LM6mCn0TofmuBVm8LTebIA=&error=-1939410647&build=**CEDUrlEnd**]]></event>
<event date="date/time -04:00" severity="1" hostName="SMP Servername" source="Resource.SaveResourceToDatabase" module="w3wp.exe" process="w3wp" pid="3620" thread="379" tickCount="82355392"><![CDATA[Item save to DB failed: “Package GUID”, (fromClone=False, user=AD\”user”)
An invalid IP address was specified.
   [System.FormatException @ System]
   at System.Net.IPAddress.InternalParse(String ipString, Boolean tryParse)
   at Altiris.Resource.StandardResources.SiteSubnetRelationCache.ConvertIPStrings(IEnumerable`1 tcpipAddresses)
   at Altiris.Resource.StandardResources.SiteSubnetRelationCache.GetClosestSitesForAddresses(IEnumerable`1 tcpipAddresses)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.GetAutoAssignmentCollection(Guid packageGuid, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.SetPackageServerAssignment(Guid packageGuid, String packageName, SourceType st, String packageLocation, PkgSvrAssignmentType method, Boolean automaticallyAssignSites, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.SWDSupport.SetPackageServerAssignment(PackageItem package, PkgSvrAssignmentType method, Boolean automaticallyAssignSites, ICollection`1 serverOrSiteGuids, ICollection`1 manuallyAssignedSites)
   at Altiris.NS.StandardItems.SoftwareDelivery.PackageItem.OnSave(Boolean bExistingItem)
   at Altiris.NS.ItemManagement.Item.Save()
 

Unable to refresh the codebase information for package: '=update' (GUID)
An invalid IP address was specified.

Error downloading software update [Bulletin][update] {GUID.EN_US} - Altiris.NS.Exceptions.AeXException: Item save failed: 'update' (GUID) ---> System.FormatException: An invalid IP address was specified.
Item save to DB failed: GUID, (fromClone=False, user=DOMAIN\user)

The spGetAutoAssignInfoForPackage stored procedure gets called and fails because there are invalid IP Addresses in the Inv_AeX_AC_TCPIP table.

In one case the problem was solved by identifying the problem packages in the a.log files and changing their Package Server Settings from "Package Servers automatically with manual prestaging" to something else (All Package Servers, Package Servers by Site, etc.)

In another case the problem was solved by confirming there were empty IP addresses for some of the package servers in the Inv_AeX_AC_TCPIP table:

select * from Inv_AeX_AC_TCPIP

Then the empty IP addresses were deleted with the following query:

delete from Inv_AeX_AC_TCPIP
where Inv_AeX_AC_TCPIP.[IP Address] = ''

In that case the empty IP addresses had been brought in by Active Directory Import because AeX AC TCPIP was enabled in the default column mappings for the Import Computer rule but was not configured to bring in real data. The problem was stopped by disabling this option.