Questions tagged [service-broker]

provides the infrastructure for queue-based asynchronous message communication between databases.

Filter by
Sorted by
Tagged with
0
votes
0answers
71 views

Service Broker Error - The conversation handle is not found

All, A new third party application using Service Broker on SQL Server 2017 is causing the error log to report numerous failed query delivery notifications due to conversation handle not found. I've ...
2
votes
2answers
59 views

Adding a database with Service Broker to an existing Availability Group on a new replica

Server 1 - SQL Server 2016 (Primary in existing AG) Server 2 - SQL Server 2016 (Secondary in existing AG) Server 3 - SQL Server 2016 (Offsite Secondary in existing AG) Server 4 - SQL Server 2017 (New ...
1
vote
0answers
145 views

DNS lookup failed with error: '11001(No such host is known.)'

I have a server in the USA that should connect to one of our servers in Europe through service broker. The server in Europe is an Availability group, whose listener is called sqlst. when I run the ...
6
votes
1answer
55 views

Find which databases have a particular service in SQL Server Service Broker

From what I currently understand, the names of services are global to the instance and you can refer to them without knowing which database contains the service and associated queue etc. In addition, ...
1
vote
1answer
15 views

What is the permission necessary to drop a service in service-broker?

When I want to drop a service which is already created, this error happens: Msg 15151, Level 16, State 1, Line 316 Cannot drop the service '//Audit/Contract', because it does not exist or you do not ...
6
votes
0answers
145 views

SQL Server 2012+ & Service Broker: SSBDT Spam ending conversations after sending message to NULL conversation_handle

I'm mostly posting this for community awareness, but feel free to give feedback if you think there is a solution other than coding around the problem as we are doing. Crossposting this from my bug ...
1
vote
0answers
334 views

Service Broker - A previously existing connection with the same peer was detected during connection handshake.

There are good questions about service broker here, here and here. In none of those questions I see the following error message: Service Broker login attempt by user 'MYCOMPANY_USA\sqlservice.' ...
0
votes
1answer
30 views

time difference between two machines makes problem in service broker communication

I have two machines and each machine has a SQL Server instance. Between these machines I run service broker. One of my machines has a different time from the other. I mean the machine time of A is 9:...
1
vote
0answers
373 views

service broker - poison message - how to handle? how to enable poison messase handling?

I am getting constantly this error message on service broker: POISON MSSAGE - Message Removed from the queue to allow other messages to proceed - ApplicationID: 377411 select top 1000 * from ...
0
votes
0answers
45 views

is there a way to find out what route and endpoint my service broker session is using?

I have been trying in many way, from sys.conversation_endpoints to find out which route and which endpoint my service broker session is using. SELECT conversation_handle, is_initiator, s.name as '...
2
votes
0answers
53 views

is there any advantage when troubleshooting service broker, to create the queue with retention=ON?

from CREATE QUEUE (Transact-SQL): RETENTION Specifies the retention setting for the queue. If RETENTION = ON, all messages sent or received on conversations that use this queue are retained in ...
0
votes
2answers
243 views

How to script all the service broker elements for each database it is on, in the current server?

I have service broker running on different servers. Just recently I had to rebuild one of the test servers and it had a complete service broker solution running there. For the next time I need to ...
3
votes
0answers
297 views

Stored Procedure triggered by Service Broker can't access another database in SQLServer 2017

I make an extensive use of SQL Server Service Broker to trigger/parallelize data science tasks (data imports with SSIS or direct queries to another database on the same server, then data management ...
2
votes
1answer
196 views

How do I completely reset ServiceBroker including all messages, queues, triggers, etc?

I have a database where I have a ServiceBroker up and running. For unknown reasons we have experienced a lot of problems with missing conversation handlers; I.e. The conversation handle "D33EC01C-...
1
vote
0answers
75 views

Service Broker process active for too long in SQL Sever

Let me acknowledge, I don't know much about database efficiency neither Service Broker as a whole, where I work the dba that used tp handle these kind of things left some weeks ago. The company uses ...
1
vote
1answer
191 views

service broker with mirroring

After we tried configure a database with service broker into an always on environment and failed (the service broker is not working properly) we are now considering to try mirroring for high ...
-5
votes
1answer
222 views

What type of messages does SQL Service Broker send?

SQL Server has Service Broker, which provides messaging and queueing functions between instances. I am new to using this technology and want to know which kind of messages does it send between ...
1
vote
1answer
832 views

problem with service broker in always-on

one of my clients has a database that works with service broker, last week we tried to move the database to an always on environment without knowing the application uses the service broker. after ...
2
votes
1answer
24 views

Does a Target Service need to do anything for a conversation that is ended?

We have two queues, SSBInitiator and SSBTarget. In my example situation, I have ran the following code to create a conversation: BEGIN DIALOG CONVERSATION @ConversationHandle FROM ...
1
vote
0answers
17 views

Central db with satelites

I am facing the following challenge. I want to have a central MySql server having all the data and several satellites servers that hold part of the data. Satellites servers will hold some original ...
0
votes
0answers
56 views

Extracting Service name from stored procedure

I have the following procedure USE ServiceBrokerTest; GO CREATE PROCEDURE PublishNotification @NotificationData VARCHAR(1000) AS DECLARE @InitDlgHandle UNIQUEIDENTIFIER BEGIN ...
1
vote
1answer
972 views

Service broker not getting messages when enabled

Due to lack of my knowledge in service broker i am finding hard time in troubleshooting Service broker in one of the databases. Initially the Service broker somehow got disabled on this database ...
0
votes
0answers
202 views

Service broker stuck infinitely looping using outdated activation stored procedure

I was debugging and stuck a bunch of log statements into my activation procedure including a statement that logs the value of @@ROWCOUNT that is used in this manner: INSERT INTO ###Debug(SomeMessage, ...
0
votes
1answer
692 views

Drop service hangs indefinitely

I have a mirrored database that was using a service broker to push notifications to a client. The broker creation framework started making duplicates and this caused serious problems so i rolled back ...
1
vote
1answer
238 views

Service Broker-Certificate Not Found

My organization has been successfully using service broker, dialog security, for a few years. I have a new instance of service broker that I would like to configure, but I believe I am running into ...
3
votes
2answers
5k views

SQL Server Service Broker vs. RabbitMQ [closed]

We are considering RabbitMQ for queuing several thousand tasks per minute and then processing them from 300+ virtual machines. We have a smart scheduling web API that will intelligently (fairly) ...
1
vote
1answer
311 views

Is there a service broker target for an extended event session

We use Service Broker heavily for asynchronous background processing. Additionally we want to use it for extended event processing. Is it possible to use Service Broker listener as target for an ...
2
votes
0answers
386 views

Service Broker locks table even when committed

I hope someone can explain some behavior I've got within the Service Broker, which is the first time I've used it so it's probably my lack of understanding. I've got a complex set of stored ...
1
vote
0answers
165 views

Service Broker cryptographic error

I'm trying to set up a test environment for Service Broker communication between 2 SQL Server 2016 SP1 instances. I've created db master keys, certificates and endpoints in the master db for each ...
0
votes
1answer
272 views

Confusing error message from Service Broker / Activation procedure

I am facing a really confusing problem with our SQL Server, and I hope somebody can give me hint how to debug this issue. Grab a cup of coffee or something, this is going to get slightly convoluted. ...
0
votes
1answer
59 views

Service Broker Msg 33305

I restored a database from SQL Server 2014 Enterprise to SQL Server 2017 Standard. The restore went through fine without any issues/errors. I then run DBCC CHECKDB on the database and I get the ...
9
votes
1answer
1k views

Service Broker - Conversation Lifetime?

We are trying to get Service Broker working in our environment in order to solve a business case. I don't know if the message title is a good one, but my question is below. But it may not be a good ...
2
votes
1answer
99 views

How do I determine what is activating my SQL service broker proc?

I have several queues. One of which has suddenly started acting oddly. It activates repeatedly while nothing is in it's queue. I even manually removed old conversations and this thing is still ...
3
votes
0answers
95 views

sp_send_dbmail unable to execute from service broker activation sp [duplicate]

I'm using Service Broker to [maybe] monitor my database events, so I have my activation sp in some user database and it should react on some events by sending e-mail to admin. But it fails with the ...
2
votes
0answers
167 views

SSIS multiple parallel ETL: Task Scheduler or Service Broker

We have one SQL Server 2008 on which we run several ETL packages in parallel. This setup has always suffered stability issues. Since I have taken over I am trying to find a way to increase stability ...
2
votes
0answers
701 views

SQL Service Broker: “orphaned” messages in sys.sysxmitqueue

I have a database running under SQL 2016 that is using service broker to handle some business logic. I did not design the system, I'm still not 100% sure how it works, but I definitely know that it's ...
1
vote
0answers
536 views

Service Broker - Add to queue but don't process till later

Our current implementation has a data coming into the system onto a Service broker queue a small amount of processing is performed in case more pertaining data comes in, then a SQL Agent job running ...
2
votes
1answer
952 views

Service Broker repeating messages

In our estate we've set up Service Broker to perfom an action: Based on a schedule a query is executed and its results are sent, via service broker, to the other service on a remote server Message is ...
5
votes
2answers
1k views

Can't use msdb.dbo.sp_send_dbmail when in service broker - executes as guest?

I have a procedure TheNotificationProcedure that makes a cross-database call to msdb.dbo.sp_send_dbmail. It gets invoked (indirectly) from a service broker queue: CREATE QUEUE [Blah].[TheQueue] WITH ...
5
votes
2answers
6k views

Set TRUSTWORTHY On smacks down service broker from working

I've got a database running on a SQL-Server 2012 DBMS. Consider that the server running SQL Server is not part of the network domain. When I execute this sql command ALTER DATABASE myDatabase SET ...
0
votes
1answer
236 views

SQL Server, ServicerBroker for asynchronized execution of stored procedures

I followed this tutorial: https://gallery.technet.microsoft.com/scriptcenter/Using-Service-Broker-for-360c961a and it is working for me, However, I don't understand some thing: At PROCEDURE ...
2
votes
0answers
161 views

SQL Server Service Broker with DML triggers

What I want to do: Client database (C) is SQL Server 2008, has schema X My database (D) is PostgreSQL 9.1, has schema Y I want to transfer data from specific tables in C to D in near real time. My ...
3
votes
1answer
140 views

“Stored Procedures Invoked/sec” counter always increasing

We've implemented some feature using service broker and deployed recently on production. I am observing that "Stored Procedures Invoked/sec" counter is always increasing. However, I can see that other ...
1
vote
1answer
2k views

Service Broker activation procedure in C# with external dependencies

I am not entirely sure if I have come to the right place, because this question involves both SQL Server and .Net. Apologies if this is not an appropriate place for my question! I am currently ...
2
votes
2answers
539 views

Service Broker Using Wrong Certificates

After configuring two Service Broker instances that successfully send msg to remote server on separate databases, I am trying to set up a second service broker instance on one of the same, successful, ...
2
votes
1answer
2k views

Service Broker Connection handshake failed. There is no compatible encryption algorithm

My target server is not receiving the message and the following error shows in the target servers error logs. Service Broker login attempt failed with error: 'Connection handshake failed. There is no ...
6
votes
1answer
536 views

TempDB internal space usage slowly growing from service broker

Am running SQL Server 2012 (11.0.6540.0) in a AO high availability group with one other server. tempDB usage usually sits around 819MB (averaged over a week from 2 weeks ago) but since we did a fail-...
1
vote
1answer
160 views

Service Broker - DR

Our developers are currently working on Service Broker and will be implementing in production soon. What do I need to worry about with Log Shipping in regards to DR? The environment they are ...
0
votes
1answer
809 views

Enable Service Broker when deploying solution

I'm having an issue deploying the latest build of a database solution after creating some service broker objects. I am thinking that it could be related to not having service broker enabled on the ...
4
votes
0answers
213 views

Service broker internal spid hogging tempdb

We've recently decommissioned a rather badly implemented service broker setup after a number of near outages, however while doing my morning checks I've noticed that there are 2 Service Broker ...