Customer recently upgraded and he noticed that some of the agent policies work and some do not. When he selects one of the broken policies, he gets just a generic error page.
Message 1:
HTTP Request failed:
/Altiris/NS/Admin/SoftwareDeli
Invalid object name '#trusteeScopeCollections'.
Message 2:
Failed to process web request.
Exception of type 'System.Web.HttpUnhandledExcep
[System.Web.HttpUnhandledExcep
at System.Web.UI.Page.HandleError
at System.Web.UI.Page.ProcessRequ
at System.Web.UI.Page.ProcessRequ
at System.Web.UI.Page.ProcessRequ
at System.Web.UI.Page.ProcessRequ
at Altiris.NS.UI.Controls.PageCac
at Altiris.NS.UI.AltirisPage.Proc
Invalid object name '#trusteeScopeCollections'.
Some stored procedures, in this case spResourceTargetTempPopulate and spResolveResourceTargetFullPre
Grab the same stored procedures from a working server and run them on the customer's database. The proper references should be created.
Attached the stored procedures on this KB as reference.