The error "Thread was being aborted. <SQL query>" occurs in the Notification Server logs when timeouts or out of memory errors occur in Helpdesk.
Thread was being aborted. <SQL query>
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 SQL query 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: