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 |
Problem
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:
- Double-clicking or right-clicking on a computer resource gets an error: spGetResourceAssociationType missing.
- 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.
- Patch Management has no language files or exclude files in the global configuration.
- Tasks in Patch Management for the Microsoft getting errors.
- 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 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
Thank you.