Patch Management: Excessive logs errors for invalid item 'vSoftwareUpdateInventoryRuleAssociations'

book

Article ID: 180727

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Problem
After working through various uninstalling of solutions, the NS Repair ran through correctly and all NS Functions returned to normal.

Support the recommended repairing Patch Management Solution, as this was upgraded several days ago, but using a TS connection to the server NOT in console mode.

This repair was performed, and since there are excessive errors in the logs which seem to relate to Patch Mgmt Soln, see attached log.

Upgrading from PM 6.1 to 6.2.

See below an extract of the log files:
<![CDATA[PatchSoftwareUpdateResource::Build Attribute XML Invalid object name 'vSoftwareUpdateInventoryRuleAssociations'.]]>
</event>
<event date='Dec 15 09:07:57' severity='1' hostName='NS1' source='Altiris.PatchManagementCore.Policies.SoftwareUpdateAdvertisement.OnBuildClientConfigXml2' module='AltirisNativeHelper.dll' process='aexsvc.exe' pid='1520' thread='6364' tickCount='15951500' >
  <![CDATA[SoftwareUpdateAdvertisment::BuildClientConfig2() error generating sofwtare update config Invalid object name 'vSoftwareUpdateInventoryRuleAssociations'.]]>
</event>
<event date='Dec 15 09:07:57' severity='1' hostName='NS1' source='Altiris.NS.ClientConfigManagement.ClientConfigManager.GetClientConfigXml' module='AltirisNativeHelper.dll' process='aexsvc.exe' pid='1520' thread='6364' tickCount='15951500' >
  <![CDATA[Unable to get the config xml for the specified item (Item: {140553d5-9154-428d-a2a9-20c606b2c723}, Exception: System.Data.SqlClient.SqlException: Invalid object name 'vSoftwareUpdateInventoryRuleAssociations'.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader()
   at Altiris.PatchManagementCore.Utilities.StoredProcStubs.GetConfigInfoForSoftwareUpdate(Guid guidSoftwareUpdate, String& strBulletinName, Guid& guidVendor, Guid& guidPackage, Int32& rebootRequiredCode, Int32& rebootBeforeInstallCode, Guid& guidIsInstalled, Guid& guidIsApplicable)
   at Altiris.PatchManagementCore.Resources.PatchSoftwareUpdateResource.BuildConfigXml(XmlTextWriter xmlBuilder)
   at Altiris.PatchManagementCore.Policies.SoftwareUpdateAdvertisement.OnBuildClientConfigXml2(Guid workstationGuid, XmlNode requestDocumentElement, XmlTextWriter xmlBuilder)
   at Altiris.NS.StandardItems.Policies.ClientConfigPolicy.Altiris.NS.ItemManagement.IItemClientConfig2.GetConfigXml(Guid resourceGuid, String requestXml)
   at Altiris.NS.ClientConfigManagement.ClientConfigManager.GetClientConfigXml(GuidCollection itemGuids, Hashtable itemConfigXml, Guid resourceGuid, String requestXml, String extraKey))]]>
</event>
<event date='Dec 15 09:07:57' severity='1' hostName='NS1' source='Altiris.PatchManagementCore.Utilities.StoredProcStubs.GetConfigInfoForSoftwareUpdate' module='AltirisNativeHelper.dll' process='aexsvc.exe' pid='1520' thread='6364' tickCount='15951515' >
  <![CDATA[GetConfigInfoForSoftwareUpdate()::error calling stored procedure Invalid object name 'vSoftwareUpdateInventoryRuleAssociations'.]]>
</event>

_________________

Log File Name: D:\Altiris\Notification Server\Logs\a.log
Priority: 4
Date: 1/30/2007 11:54:24 AM
Tick Count: 343702328
Host Name: NS1
Process: w3wp.exe (5036)
Thread ID: 2356
Module: AltirisNativeHelper.dll
Source: SqlQueryBase/RunQuery
Description: Query run with suspected missing table:
System.Data.SqlClient.SqlException: Invalid object name
'dbo.vSoftwareUpdateInventoryRuleAssociations'.
Invalid object name 'dbo.vSoftwareUpdateInventoryRuleAssociations'.
Invalid object name 'dbo.vSoftwareUpdateInventoryRuleAssociations'.
Invalid object name 'dbo.vSoftwareUpdateInventoryRuleAssociations'.
Invalid object name 'dbo.vSoftwareUpdateInventoryRuleAssociations'.
Invalid object name 'dbo.vSoftwareUpdateInventoryRuleAssociations'.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Comman dBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Altiris.NS.StandardItems.Query.BuilderQuery.RunQuery(DataSet ds)

Environment
PMS 6.1.2369 to PMS 6.2.3540

Cause

During the upgrade process the view vSoftwareUpdateInventoryRuleAssociations was not recreated

Resolution
Run the attached piece of SQL on the NS database to create the vSoftwareUpdateInventoryRuleAssociations View.

Attachments

Create vSoftwareUpdateInventoryRuleAssociations.sql get_app
Create vSoftwareUpdateInventoryRuleAssociations.sql get_app