KNOWN ISSUE: Patch Management Dashboard times out or is slow to render
|Article:TECH25255|||||Created: 2006-11-15|||||Updated: 2009-03-31|||||Article URL http://www.symantec.com/docs/TECH25255|
|NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.|
Under the Reports tab when I click on the Patch Management Dashboard, the page either takes a long time to render, or times out.
Patch Management 6.2
The SQL Stored Procedure used to populate this page is ineffecient and must be modified.
Download the new Stored Procedure attached to the KB.
Instructions to update:
- Unzip the file to a convenient location.
- Open SQL Query Analyzer.
- Select the Altiris database.
- Copy and paste the contents of the .sql file into Query Analyzer.
- Execute query.
*Note: Even after applying the modified stored procedure, the Patch Management dashboard, on occasion, fails to render. If this is the case, download the attached SQL queries, which will create Indexes on heavily used tables.
Note: KB46144 Combined fixes for known Patch Report Discrepencies, Dashboard issues etc also includes this fix and several more.
|Description||Logged in sydd2 (Altiris - Sydney) database|
Article URL http://www.symantec.com/docs/TECH25255