The timeout period elapsed prior to the completion of a Transact-SQL statement.

Details
Product: SQL Server Notification Services
Event ID: 1009
Source: NotificationServices
Version: 2.0.9999.9
Message: The timeout period elapsed prior to the completion of a Transact-SQL statement.
   
Explanation
This error occurs when an executing query or stored procedure does not complete within the specified timeout. It typically indicates that SQL Server is too busy. (A different error message is returned if the execution of an event rule or a subscription rule exceeds the timeout specified in the ActionTimeout parameter.)

The event log entry for this error includes the description of the actual error that caused it.

   
User Action
Examine the event log entry for additional information on the action that timed out.

If vacuuming was the cause of the failure then it may be necessary to manually vacuum expired events and notifications by running the NSVacuum stored procedure.

Notification Services uses a timeout value of 30 seconds for many operations. If possible, reduce the processing of the affected action such that it can complete within 30 seconds.

Related:

Leave a Reply