January 20, 2009 at 1:35 pm
Hi All,
I've the following queue
CREATE QUEUE [dbo].[]
WITH
STATUS = ON ,
RETENTION = OFF ,
ACTIVATION
(
STATUS = ON ,
PROCEDURE_NAME = [dbo].[] ,
MAX_QUEUE_READERS = 1 ,
EXECUTE AS N'dbo'
)
My problem is that the queue is not getting activated by the stored proc ''
The message is sitting in the queue instead of getting activated by the stored proc
Thanks in advance
January 20, 2009 at 1:49 pm
Do the following:
1) Check to see that the Queue and the Activation procedure are still enabled (Service Broker will turn them off in "poison message" situations).
2) Check your SQL Server's error log for any message from SB or your activation procedure.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 20, 2009 at 1:52 pm
Here's a set of scripts to diagnose SSB.
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31867/
And don't forget the SQLserver Errorlog !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 20, 2009 at 2:07 pm
Hi,
i'm getting an error with the principal 'dbo'. It says 'dbo' doesn't exist or i dont have permission
I tried changing it to SELF. But again it is changing back to 'dbo'
What do I need to do?
CREATE QUEUE [dbo].[]
WITH
STATUS = ON ,
RETENTION = OFF ,
ACTIVATION
(
STATUS = ON ,
PROCEDURE_NAME = [dbo].[] ,
MAX_QUEUE_READERS = 1 ,
EXECUTE AS N'dbo'
)
January 20, 2009 at 2:34 pm
Please post the exact error message here, and tell us where you saw it.
Also, please post the activation procedure, as I am pretty sure that that is where this is going to lead.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 20, 2009 at 2:43 pm
Hi i've seen the below error in the SQL Server error logs
error:
The activated proc [dbo].[] running on queue x output the following 'Cannot execute as the database prinicpal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.'
January 20, 2009 at 4:03 pm
Hmmm, I ought to know this one...
Try changing your queue setup to "EXECUTE AS OWNER".
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 20, 2009 at 4:13 pm
A couple of unrelated things that I noticed:
1) an Activated proc should not need WAITFOR (unless it is looping). It should still be OK the way it is though.
2) You should probably test to see if you actually got a message (which you will not if it times out, for instance). If there is no message then the conversation_handle should be NULL.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 29, 2009 at 11:46 am
How did this work out for you?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
January 29, 2009 at 3:34 pm
Hi Barry,
CREATE QUEUE [dbo].[]
WITH
STATUS = ON ,
RETENTION = OFF ,
ACTIVATION
(
STATUS = ON ,
PROCEDURE_NAME = [dbo].[] ,
MAX_QUEUE_READERS = 1 ,
EXECUTE AS N'dbo'
)
In the above queue i changed the account 'dbo' to another account 'xyz'
then it worked for me.
January 29, 2009 at 5:42 pm
OK, glad it worked out for you.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply