The error "Timeout expired. Timeout period elapsed prior to completion of the operation or the server is not responding. <stored procedure name>" occurs in the Notification Server logs when timeouts or out of memory errors occur in Helpdesk.
Timeout expired. Timeout period elapsed prior to completion of the operation or the server is not responding. <stored procedure name>
Helpdesk incidents that have comments exceeding 4,000 characters in even one incident can cause .NET to overflow and the Helpdesk database (Altiris_Incidents) to increase substantially in size. The more incidents that have this issue, the more frequent the slow performance, timeouts or out of memory errors will occur.
Note: This error will appear to indicate that the specified stored procedure is the cause of the issue. This is incorrect; this is a symptom of the timeout, not the cause.
Truncate or delete incidents that have large comments and apply business rules to prevent future occurrences. Refer to the following article for more information: