ITMS 7.6 HF7 - Manage Custom Data classes page times out due to custom large data class tables.

book

Article ID: 171051

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

Manage Custom Data classes page times out due to custom large data class tables.

HTTP Request failed:
/Altiris/Inventory/CustomInventory/DataClassConfiguration.aspx?Guid=28cc7402-0a7f-40b8-acf9-73db2ad654de&Url=http%3a%2f%2flocalhost%2fAltiris%2fConsole%2ftree.aspx%3fViewGuid%3da57fb0e9-0676-4e00-929a-6bb37dc1f888%26%26ConsoleGuid%3d1b22db4e-a898-443f-9b99-855b1653d3f5&TreeGuid=a57fb0e9-0676-4e00-929a-6bb37dc1f888&ParentGuid=00000000-0000-0000-0000-000000000000&ItemGuid=28cc7402-0a7f-40b8-acf9-73db2ad654de&ViewGuid=a57fb0e9-0676-4e00-929a-6bb37dc1f888&ConsoleGuid=1b22db4e-a898-443f-9b99-855b1653d3f5

Request timed out.
[System.Web.HttpException @ ]


Exception logged from:
at Altiris.NS.UI.AltirisWebApplication.ReportApplicationError(HttpContext ctx)
at System.Web.HttpApplication.RaiseOnError()
at System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

Cause

Altiris Profiler shows a very long execution time for sp_Inv_GetDataClass_CustomDataClasses.

Environment

ITMS 7.6 HF7

Resolution

Symantec engineering is working on updating the design to work better with large custom data class tables.

Workaround: Contact Symantec Support for an updated version of the sp_Inv_GetDataClass_CustomDataClasses procedure.

Perform a full backup of the Symantec_CMDB database before changing the stored procedure.

Attachments

Modified sp_Inv_GetDataClass_CustomDataClasses 8.1RU5.sql get_app
Modified sp_Inv_GetDataClass_CustomDataClasses 7.6HF7.sql get_app