The "Manage Software Updates" page takes a long time to load or times out

Article:TECH12547

Created: 2006-02-18

Updated: 2009-03-31

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

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

Problem

When selecting the "Manage Software Updates" page within the Patch Management Solution it either takes a very long time to load, or times-out with the following error:

Description: Unexpected exception encountered while running a query.Report "All
Software Bulletins" All Software Bulletins. ( Unhandled exception.

Environment

Patch Management 6.2 SP1

Cause

The root cause is unknown, but typically the problem is seen when multiple languages are being managed.

Solution

The prefered supported method is to increase the timeout within the Web.config located in C:\Program Files\Altiris\Patch Management\Core\Web.

1. Navigate to C:\Program Files\Altiris\Patch Management\Core\Web
2. Open the Web.config in notepad.
3. Add the following entry <httpRuntime executionTimeout="630"/> just before the </system.web>
4. Save and Attempt to Open the Manage Software Update Pages again.

An additional but method, is to replace the stored procedure with the one attached to this article.

Steps to modify the stored procedure.

1. Open Query Analyzer.
2.  Rename the Original Stored Procedure to .old
3.  Set the database to Altiris.
4.  Copy and paste the information from the attached stored procedure into query analyzer.
5.  Press the 'Excecute' button on the toolbar, or F5 Key to execute the query.

KB46144 "Combined fixes for known Patch Report Discrepencies, Dashboard issues etc" also includes this fix and several more.

Attachments

spPMCoreReport_AllSoftwareBulletins.zip (2 kBytes)

Legacy ID

19811