SQL Server Errors or Failures from Error: 9208 to Error: 9228

SQLServerF1

 

Error: 9208, Severity: 16, Query notification subscription could not get dialog endpoint. Could not open service broker dialog for service name ‘%.*ls’ of broker instance ‘%.*ls’.
Error: 9209, Severity: 16, Query notification subscription could not begin dialog with service name ‘%.*ls’ of broker instance ‘%.*ls’.
Error: 9210, Severity: 10, Query notification delivery could not send message on dialog ‘%.*ls’. Delivery failed for notification ‘%.*ls’ because of the following error in service broker: ‘%.*ls’.
Error: 9211, Severity: 10, Failed to check for pending query notifications in database “%d” because of the following error when opening the database: ‘%.*ls’.

Error: 9213, Severity: 10, Query notification subscription could not access database with id %d. Could not open broker dialog for service name ‘%.*ls’ of broker instance ‘%.*ls’.
Error: 9214, Severity: 16, The query notification delivery failed to decode the error message from the Service Broker.
Error: 9215, Severity: 16, Query notification delivery failed to encode message. Delivery failed for notification ‘%.*ls’.
Error: 9216, Severity: 10, Failed to delete the expired query notification subscription “%d”.
Error: 9217, Severity: 10, Failed to drop the unused internal query notification table “%d” in database “%d”.
Error: 9218, Severity: 16, Query notifications reached the internal limit of the maximum number of objects.

Error: 9219, Severity: 16, The query notification subscriptions cleanup operation failed. See previous errors for details.
Error: 9220, Severity: 10, Query notification dialog on conversation handle ‘%.*ls’ closed due to an unknown service broker error.
Error: 9221, Severity: 10, Query notification delivery could not get dialog endpoint for dialog ‘%.*ls’. Delivery failed for notification ‘%.*ls’ because of the following error in service broker ‘%.*ls’.
Error: 9222, Severity: 16, Internal query notification table has an outdated schema and the table has been dropped. Query notification cleanup has not been performed for this table.
Error: 9223, Severity: 10, %d active query notification subscription(s) owned by security identification number ‘%.*ls’ were dropped.
Error: 9224, Severity: 10, Query notification delivery could not access database with id %d. Delivery failed for notification ‘%.*ls’.
Error: 9225, Severity: 16, The notification options identifier string has %d characters. The maximum allowed length is %d characters.
Error: 9226, Severity: 16, A string value within the notification options identifier is too long. String with prefix ‘%.*ls’ must be %d characters or less.
Error: 9227, Severity: 16, Unmatched quote in notification options identifier string.
Error: 9228, Severity: 16, Name expected in notification options identifier option.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *