Unable to edit a Software Release or Managed Delivery Policy - Internal Server Error

book

Article ID: 170686

calendar_today

Updated On:

Products

Software Management Solution

Issue/Introduction

Unable to edit a Software Release or Managed Delivery Policy - Internal Server Error.



Exception of type 'System.Web.HttpUnhandledException' was thrown.

There is a bunch of other info also: [System.Web.HttpUnhandledException @ System.Web]
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at Altiris.NS.UI.Controls.PageCachePage.ProcessRequest(HttpContext context)
at Altiris.NS.UI.AltirisPage.ProcessRequest(HttpContext context)

Column 'DeviceTarget' not found in data source.
[System.Exception @ ComponentArt.Web.UI]
at ComponentArt.Web.UI.Grid.LoadGridLevels(DataView oDataView)
at ComponentArt.Web.UI.Grid.DataBindToDataView(DataView dv)
at ComponentArt.Web.UI.Grid.DataBind()
at Altiris.WebControls.GridControl.DoGridDataBind()
at Altiris.WebControls.GridControl.SaveDataSource(Object& dataSource)
at Altiris.SoftwareManagementSolution.Controls.UserPortal.ctrlSoftwarePublishing.FillPermissionGrid()
at Altiris.SoftwareManagementSolution.Controls.UserPortal.ctrlSoftwarePublishing.LoadUI(Boolean isAfterSave)
at Altiris.SoftwareManagementSolution.Controls.UserPortal.ctrlSoftwarePublishing.CreatePage()
at Altiris.SoftwareManagementSolution.Controls.UserPortal.ctrlSoftwarePublishing.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Exception logged from:
at Altiris.NS.UI.AltirisPage.ProcessRequest(System.Web.HttpContext)
at ComponentArt.Web.UI.CallbackHandler.ProcessRequest(System.Web.HttpContext)
at System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(System.Web.HttpApplication+IExecutionStep, Boolean&)
at System.Web.HttpApplication+PipelineStepManager.ResumeSteps(Exception)
at System.Web.HttpApplication.BeginProcessRequestNotification(System.Web.HttpContext, AsyncCallback)
at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(System.Web.Hosting.IIS7WorkerRequest, System.Web.HttpContext)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr, IntPtr, IntPtr, Int32)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr, IntPtr, IntPtr, Int32)
at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr, System.Web.RequestNotificationStatus&)
at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr, System.Web.RequestNotificationStatus&)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr, IntPtr, IntPtr, Int32)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr, IntPtr, IntPtr, Int32)

Cause

The stored procedure spSWP_GetPublishingSettings wasn't updated during the upgrade to 8.1 RU4 or higher.

Environment

8.1 RU4

Resolution

To resolve this issue, follow these steps:

  1. Open up SQL Server Enterprise Management Studio.
  2. Open a new Query window.
  3. Paste the below SQL into the query window. Be sure to target your Altiris database for the query window.
  4. Execute the query.

/****** Object:  StoredProcedure [dbo].[spSWP_GetPublishingSettings]    Script Date: 12/17/2018 11:23:58 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[spSWP_GetPublishingSettings]
            @PublishingItemGuid UNIQUEIDENTIFIER

            AS
                CREATE TABLE #TempSPSSP01 (TrusteeId nvarchar(1000), DeviceTarget nvarchar(1000), Setting nvarchar(50), Value int)
                INSERT INTO #TempSPSSP01 (TrusteeId, DeviceTarget, [Setting] , Value)
                SELECT TrusteeSid, DeviceTarget, [Setting], Value
                FROM SWP_PublishingItemSetting
                WHERE PublishingItemGuid = @PublishingItemGuid

              SELECT DISTINCT
                  TrusteeId AS TrusteeId,
                  DeviceTarget AS DeviceTarget,
                  (CASE WHEN  [IsApproved] IS NULL then 0    else 1 end) as [IsApproved],
                  (CASE WHEN  [IsRequiringApproval] IS NULL then 0 else 1 end) as [IsRequiringApproval],
                  (CASE WHEN  [IsRecommended] IS NULL then 0 else 1 end) as [IsRecommended]
                FROM
                  (
                  SELECT TrusteeId, DeviceTarget, Value , Setting
                  FROM #TempSPSSP01
                ) src
                pivot
                  (
                  SUM (Value)
                  FOR Setting in ([IsApproved], [IsRequiringApproval], [IsRecommended])
                ) piv;
GO

 

If the above doesn't fix it, these steps can be used to resolve the issue:

  1. Go into Symantec Installation Manager (SIM) and uninstall Software Management Solution 8.1.
  2. When complete, delete the following folder: <install drive letter>:\Program Files\Altiris\SoftwareManagementSolution
  3. Delete the Assembly folders for SoftwareManagementSolution found under C:\WIndows\Microsoft.Net\assembly\GAC_MSIL\:
    1. Altiris.SoftwareManagementSolution
    2. Altiris.SoftwareManagementSolution.Controls
    3. Altiris.SoftwarePortal
  4. Go into Regedit. Do a search for "SoftwareManagementSolution" (no quotes) and remove any install reference to 8.0, especially under: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall.
  5. The search will return a lot of results. Make sure you are removing install references to the Solution, not the plug-in, and don't worry about items under any user-specific key. You can review the current position at the bottom of Regedit where the path is shown.
  6. Using SIM run the install for Software Management Solution 8.1 RU4.

Attachments