Stored procedures missing after installation of SP3 as a new install

Article:TECH12065  |  Created: 2006-01-23  |  Updated: 2006-04-11  |  Article URL http://www.symantec.com/docs/TECH12065
Article Type
Technical Solution



Issue



I installed Notification Server and some solutions and then noticed that when they went into the Resource Manager on computers they were getting errors. The log files listed the following error message when attempting to load the resource manager:

Jan 20 11:00:08  E  Error attempting to build context menu with FactoryGuid:[ 206a5140-d662-4ca7-80cb-8308161da00d ] ( Unhandled exception. Type=System.Data.SqlClient.SqlException Msg=Invalid object name 'vResourceTypeItemAction'. Src=.Net SqlClient Data Provider StackTrace= 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(CommandBehavior 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(DataTable dataTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at Altiris.Resource.ResourceItem.GetItemActionsForResourceItem(Guid resourceTypeGuid) at Altiris.Resource.ResourceItem.GetContextMenuForItemActions(ContextMenu menu) at Altiris.Resource.ResourceItem.GetCurrentContextMenu(Hashtable args) at Altiris.NS.ItemManagement.ItemContextMenuFactory.GetContextMenu(String strUrl, String strKey, String strData, Guid pageGuid, HttpStateArgs httpStateArgs) at Altiris.NS.UI.ContextMenus.GridViewContextMenuFactory.GetContextMenu(String strUrl, String strKey, String strData, Guid pageGuid, HttpStateArgs httpStateArgs) at Altiris.NS.UI.CoreWebService.GetContextMenu(String strContextMenuFactoryGuid, String strPageGuid, String strUrl, String strKey, String strData) )  Altiris.NS.UI.CoreWebSer

Here are other instances which seem to cause the errors to occur:

  1. Double-clicking or right-clicking on a computer resource gets an error: spGetResourceAssociationType missing.
  2. Missing packages (Blue Box Icon) for PC Transplant agents, Software Delivery agent, Deployment Solution AClient. Agents are in their assigned folders, must be missing the linkage from the task to the program/packages.
  3. Patch Management has no language files or exclude files in the global configuration.
  4. Tasks in Patch Management for the Microsoft getting errors.
  5. Inventory Rules same issues.

Additional error messages in the log files are as follows:

Module: AltirisNativeHelper.dll
Source: Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch
Description: ItemMessageDispatcherService::Dispatch ( Unhandled exception. Type=System.Data.SqlClient.SqlException Msg=Could not find stored procedure 'spGetResourceAssociationTypes'. Src=.Net SqlClient Data Provider
StackTrace=
at Altiris.NS.LegacyInterop.ItemMessageDispatcherService.Dispatch(String message, Boolean useFilename) )

and

Module: AltirisNativeHelper.dll
Source: Altiris.NS.ClientMessaging.FileDispatcher.ProcessFileCallback
Description: Unable to process the file "D:\Program Files\Altiris\Notification Server\NSCap\EvtQFast\Process\nse53D6.tmp" Moving to "D:\Program Files\Altiris\Notification Server\NSCap\EvtQFast\Bad\SqlException\nse53D7.tmp".
Reason: Could not find stored procedure 'spGetResourceAssociationTypes'.

It was then found that the stored procedure of spGetResourceAssociationType could not be found in Database. This was not restricted to the stored procedure in question as there was at least one other stored procedure that was not listed in the stored procedures list.


Environment



Windows 2000 server
Notification Server 6.0.6074

Cause



Unknown.

Solution



Approach A: From a Notification server installation that works properly, get the query that generates the vResourceTypeItemAction view or whatever the missing view may be and run it in Query Analyzer. You can do this by opening Enterprise manager and going to the View table in the Altiris database. Find the view and double-click on it. In the text section, copy the query and run it on the Query Analyzer. It will generate the missing view.

Approach B: The resolution ended up as updating from Windows 2000 server to Windows 2003 server. Previous to the update we had tried running a repair on the Notification Server, Nssetup.aspx and removing and reinstalling the Notification Server.

Legacy ID



18448


Article URL http://www.symantec.com/docs/TECH12065


Terms of use for this information are found in Legal Notices