April 19, 2015 at 8:13 am
My error log was keep on increasing and consuming entire disk space because of below error.
An exception occurred while enqueueing a message in the target queue. Error: 9728, State: 1. Cannot find the security certificate because the lookup database principal ID (9) is not valid. The security principal may have been dropped after the conversation was created.
April 19, 2015 at 8:32 am
m.rajesh.uk (4/19/2015)
My error log was keep on increasing and consuming entire disk space because of below error.An exception occurred while enqueueing a message in the target queue. Error: 9728, State: 1. Cannot find the security certificate because the lookup database principal ID (9) is not valid. The security principal may have been dropped after the conversation was created.
And the question is? Not much to go on here, Biztalk? Expired account? Dropped account?
😎
April 20, 2015 at 2:21 am
Service Broker gone wild? Check SB DMVs.
-- Gianluca Sartori
April 20, 2015 at 2:31 am
It's Service Broker, but there's not that much more of use. You're going to have to debug Service Broker and figure out why it's throwing errors. Certificates in database 9 may be a good place to start
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 23, 2015 at 9:26 pm
The database in which this error is through is in mirroring.
I am not aware how to troubleshoot it.
Can any one give some point here i need to start debugging
April 24, 2015 at 2:48 am
It's a service broker error. Do some reading on Service Broker architecture and security requirements, then trace through what you have any where the error's coming from.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply