How to Address Issues with Reports Causing System Performance Issues (Deleted Documents)
Who is this article for?
All Ideagen Quality Management Admins with report permissions.Ideagen Quality Management site accessis needed.
Customers may encounter issues where they are having performance issues with the Ideagen Quality Management site and a scheduled report is found to be the root cause.
To make troubleshooting this issue easier to learn, this article is split into three sections so that you can either walk through the steps in sequence or you can jump to the section relevant to what you are finding:
1. Issue Experienced
This section will explain what occurs when the customer is experiencing the issue.
The customer will have noticed their site had performance issues (slow loading times) and they had to refresh IIS and the server. Event Viewer logs were pulled and a similar entry to the one below was found.
Error Logged:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2/1/2019 3:24:01 PM
Event time (UTC): 2/1/2019 8:24:01 PM
Event ID: d9c15d1f34364efea31933255f25d828
Event sequence: 1328
Event occurrence: 1
Event detail code: 0Application information:
Application domain: /LM/W3SVC/2/ROOT-1-131935175567683735
Trust level: Full
Application Virtual Path: /
Application Path: D:\Ideagen Quality Management\Web\
Machine name: VSS359Process information:
Process ID: 8656
Process name: w3wp.exe
Account name: NMSDOMAIN\st_qualtraxException information:
Exception type: Ideagen Quality ManagementEntityNotFoundException
Exception message: Document 7683 does not exist.
at Ideagen Quality Management.Core.Documents.Document.Init(Int32 lDocID)
at Ideagen Quality Management.Core.Documents.Document..ctor(Int32 lDocID, IIdeagen Quality ManagementConnection connection, Ideagen Quality ManagementCommand command)
at Ideagen Quality Management.Core.Documents.Repositories.DocumentRepository.Get(Int32 documentId)
at Ideagen Quality Management.Web.ShowDocumentPage.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)Request information:
Request URL: https://qualtrax:443/ShowDocument.aspx?ID=7683&Mode=ARCHIVE&Revision=1
Request path: /ShowDocument.aspx
User host address: 10.12.0.29
User: NMSDOMAIN\st_qualtrax
Is authenticated: True
Authentication Type: Negotiate
Thread account name: NMSDOMAIN\st_qualtraxThread information:
Thread ID: 52
Thread account name: NMSDOMAIN\st_qualtrax
Is impersonating: False
Stack trace: at Ideagen Quality Management.Core.Documents.Document.Init(Int32 lDocID)
at Ideagen Quality Management.Core.Documents.Document..ctor(Int32 lDocID, IIdeagen Quality ManagementConnection connection, Ideagen Quality ManagementCommand command)
at Ideagen Quality Management.Core.Documents.Repositories.DocumentRepository.Get(Int32 documentId)
at Ideagen Quality Management.Web.ShowDocumentPage.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoi
2. Resolution
This section will provide the resolution for the performance issues.
There was a report that had been scheduled and the scheduled instance was still in the Scheduled Tasks page. The report was still looking for a document that had been deleted and thus was causing the IIS worker process to become hung up. The solution was to deleted the scheduled report instance.
3. Further Reading
This section will provide important links to further troubleshooting and resources.
- External Article - Microsoft article on Event Viewer logs and how to pull them.