Target Queue Disabled: Strange Message On The Event Viewer

Jun 15, 2007

Hello,

I have almost finished to design my Service Broker application and I found out something strange.



I was tring to handle the Target queue disabled scenario, because I want to save to message that was not sent so I can create an alert to the user to say that some messages as not been sent.



To disable to queue I run:

Alter queue [dbo].[Receivedqueue] with status = off



I had the Event Viewer in front of me and I have seen the suddenly it appeared a lot of this informational events:

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 9724
Date: 15/06/2007
Time: 15:00:47

Description:
The activated proc [dbo].[OnReceived] running on queue TestReceiver.dbo.Receivedqueue output the following: 'The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.'

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.



What this message means?

I would like to avoid to have it because it appears a lot of time and I don't want to fill up my Event Viewer!!



I don't know of it is important but in the moment I executed the code there was not CONVERSING conversation and all the queues were empty.



Somebody has seen this error before or I have to send to the forum the [dbo].[OnReceived] code as well?

thankx



Marina B.

View 3 Replies


ADVERTISEMENT

Target Queue Disabled

Mar 25, 2006

Hi,

I receive messages in my target queue but target queue continously become disabled even aften I enable and receive message it still says target queue is disabled?



Please Guide

View 1 Replies View Related

Event Notification On Disabled Queue: The Conversation Must End?

Jun 19, 2007

Hello,

I have configured an Event Notification for BROKER_QUEUE_DISABLED.



I created a Queue different from the one the Receive my normal messages and on this queue I define an activation.



The Activated SP takes the [EventNotification] message and execute a

RAISEERROR('Message',0,1) WITH LOG.



The error is properly logged in the SQL server event log but I gave a look the Initiator and target sys.conversation_endpoints catalog view and I have see the the conversations are in the status CONVERSING or SI ...

Do I have to call the END CONVERSATION after the commit or these statuses are caused by some mistakes on the message process workflow?



Thank you

Marina B.

View 4 Replies View Related

How To Log That A Message Has Been Retained In The Transmission_queue When The Queue Is Disabled.

Jun 16, 2007

Hi was wondering whether it is possible to log somewhere outside SB that there are messages in the transmission_queue because the Target queue was disabled.



I was testing this scenario:

try to send messages on a disabled queue and log the problem.



But the transmission_status from the trasmission_queue is always empty.



This is the code that I tried to execute between the send and the commit and after the commit:




WHILE (1=1)

BEGIN

BEGIN DIALOG CONVERSATION .....


SEND ON CONVERSATION ......


if select count(*) from sys.transmission_queue <> 0
BEGIN

set @transmission_status = (select transmission_status from sys.transmission_queue where conversation_handle=@dialog_handle);

if @transmission_status = ''

--Successful send - Exit the LOOP

BEGIN

UPDATE Mytable set isReceivedSuccessfully = 1 where ID = @IDMessageXML;

BREAK;

END

ELSE

raiserror(@transmission_status,1,1) with log;

END

ELSE

BEGIN

UPDATE [dbo].[tblDumpMsg] set isReceivedSuccessfully = 1 where ID = @IDMessageXML;

BREAK;

END

END

COMMIT TRANSACTION;

As I wrote before the @transmission_status variable is always empty and I have the same result even if I put the code after the commit transaction!



Maybe what I'm trying to reach has no sense?


With the event notification I can notify when the queue is disable because the receive rollsback 5 times but what if by mistake the target queue is disabled outside the SB environment? I can I catch it and handle it properly?

Thank you!Marina B

View 3 Replies View Related

Warning Message In The Event Viewer

Jun 7, 2001

Hi

Can anyone tell me what this warning message in the Quotes below...
I get this on one of our servers every 15 minutes in the event Viewer..

Here is the message in the event Viewer..
"Replication of license information failed because the License Logging Service on server PSNJRPDC could not be contacted."

Thanks All,
Venu

View 1 Replies View Related

Event VIEWER ---ERROR Message

Mar 6, 2001

Hi All,

I see this error message on one of my servers Event Viewer..Can anyon tell me what it means and how to resolve it..

The library file "C:WINNTSystem32BEPerfDll.dll" specified for the "Backup Exec" service could not be opened. Performance data for this service will not be available. Status code is data DWORD 0.

Thanks,
Venu

View 1 Replies View Related

How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log

Sep 12, 2005

How do I prevent SQL Server 2000 from posting successful backupcompletion messages to the Windows 2000 Application Event Log?I have scheduled jobs which backup my transaction logs on 50+ databasesand it always writes to the Windows 2000 application event log uponcompletion.Due to the frequency of the jobs it only takes a day for theApplication Log to fill up, which is causing other jobs to get hung upwhen trying to write to it. On my Windows 2000 server, I have theapplication log event viewer setting correctly set as:"When maximum log size is reached - Overwrite events as needed" but forsome reason this setting no longer applies like it did for the pastthree years. SQLServerAgent and MSSQLSERVER both run under a localAdmin account, without a domain.When I researched how prevent SQL Server from logging this type ofmessage, I found that I can use sp_update_alert to disable thismessage, but I cannot findthe message_id to correctly disable this message. In sysmessages, themessage I am trying to suppress iserror:18265severity:10dlevel:128description:Log backed up: Database:%1, creation date(time): %2(%3), first LSN: %4, last LSN: %5, number ofdump devices: %7!d!, device information: (%8).mslangid:1033I tried calling sp_update_alert as follows:exec sp_update_alert @name = 'Log backed up: Database: %1, creationdate(time): %2(%3), first LSN: %4, last LSN: %5, number of dumpdevices: %7!d!, device information: (%8).', @enabled = 0but got the error message:Server: Msg 14262, Level 16, State 1, Procedure sp_update_alert, Line105The specified @name ('Log backed up: Database: %1, creation date(time):%2(%3), first LSN: %4, last LSN: %5, number of dump devices: %7!d!,device inf') does not exist.Looks like it can only handle 128 characters.How can I disable this message from being logged in the ApplicationLog? Or alternatively, how can I get the event viewer to behave asexpected and"Overwrite events as needed"?Thanks,Mike Orlando

View 9 Replies View Related

Query Or Script To Get The Event Viewer Event Properties?

Nov 2, 2007



Hi all,


Can we get the event properties by using a query?
Are there any extended stored procuder to get the above?

Scenario:

>Desktop>Right Click on My Computer
>Go to Manage and click
>Expand System Tools
>Expand Event Viewer
>Application

click on one event.We can get the log info which is the manual procudure.

But now i want to get the event properties through the Query analyzer...

Any help would be great?


Thanks,

View 4 Replies View Related

Service Queue Disabled

Jan 21, 2008



Hi all -

I have an event in my sql server 2005 box that is fired every 5 seconds. Source MSSQLSERVER event ID 9274.


The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'The service queue "ExternalMailQueue" is currently disabled.'

I don't know anything about this queue that is mentioned above. How do I disable this message or get rid of that queue?

TIA

View 11 Replies View Related

Service Queue Is Currently Disabled - I See This Error A Lot Of Times

Jun 4, 2007

I use ALTER QUEUE statement to disable a Service Broker QUEUE then i see message -Service Queue is currently disabled every 5 sec in SQL server error Log. How can i stop this messages it is enought to see it only one time?

View 1 Replies View Related

Error: The Service Queue ClientQueue Is Currently Disabled.

Nov 16, 2005

Well I downloaded an example (HelloWorld) from www.SQLServiceBroker.com yesterday and it WAS working this morning, however; now I'm getting this error:

View 3 Replies View Related

Auto Process Messages In Target Queue

Mar 25, 2006

I am little confused with this statement, can please some one clarify!

Create QUEUE ReceiverQueue WITH STATUS = ON,

ACTIVATION ( PROCEDURE_NAME = dbo.process, MAX_QUEUE_READERS = 1, EXECUTE AS 'dbo' )

Does this mean when a message reaches to ReceiverQueue, it will automatically processed by dbo.Process procedure

Create PROC dbo.process As

Begin

DECLARE @conversationHandle UNIQUEIDENTIFIER

DECLARE @message_body varchar(100)

DECLARE @rid int

Begin Transaction;

While (1=1)

Begin

RECEIVE TOP(1)

@rid = Cast(Convert(Nvarchar(max),message_body) as int)

From ReceiverQueue

If (@@RowCount = 0 Or @@ERROR <> 0 ) Break



Exec PriceChange.Extract_AS400Data @rid



End

Commit Transaction;

End

Or do I have to put WAITFOR statement in my stored proc (dbo.Process) to run it continously.

Please guide

Thanks

View 5 Replies View Related

First Service Broker Attempt, Prajdic's Example, Error: Queue Has Been Disabled

Sep 17, 2007



I am using the Centralized Asynchronous Auditing with Service Broker article example to set up my first Service Broker attempt. We want to start logging search criteria and search results for our product search page. We wanted it to be asynchronous and be stored in another dbase, this seemed like the perfect example.

I modified the example above to save into an Audit table we created and to read a custom message that I generated the XML for. I'm pretty certain that should all work. However, I didn't change much else but I can't get the message to send.

This is the error I'm getting in profiler:
This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742.

I am sending from one database to another within the same SQL server instance. Here are the profiler details
SQL:BatchStarting
EXEC dbo.usp_SendAuditData @X Microsoft SQL Server Management Studio - Query Larry APP1Larry
Broker:Conversation Group Microsoft SQL Server Management Studio - Query Larry
Broker:Conversation STARTED_OUTBOUND Microsoft SQL Server Management Studio - Query Larry
Broker:Conversation CONVERSING Microsoft SQL Server Management Studio - Query Larry
Broker:Message Classify Microsoft SQL Server Management Studio - Query Larry
Broker:Message Undeliverable This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742. Microsoft SQL Server Management Studio - Query Larry APP1Larry
SQL:BatchCompleted
EXEC dbo.usp_SendAuditData @X Microsoft SQL Server Management Studio - Query Larry APP1Larry
Broker:Message Classify
Broker:Remote Message Acknowledgement
Broker:Remote Message Acknowledgement
Broker:Remote Message Acknowledgement
Broker:Message Classify
Broker:Message Undeliverable This message could not be delivered because the destination queue has been disabled. Queue ID: 197575742. sa
Broker:Message Undeliverable This message was dropped because it could not be dispatched on time. State: 2 sa
Broker:Message Undeliverable This message was dropped because it could not be dispatched on time. State: 2 sa


When I run SELECT * FROM sys.transmission_queue I get this in the transmission_status:
"One or more messages could not be delivered to the local service targeted by this dialog."


I'm hoping someone can point me in the right direciton, thanks.

View 11 Replies View Related

Hyperlink Target In SharePoint Report Viewer Web Part

Jun 7, 2007

Has anyone been successful in configuring the Hyperlink Target property in the SSRS Sharepoint Web Part? I've tried every setting, including _blank, yet the behavior does not change.

Am I doing something incorrectly or is this not implemented correctly?

View 4 Replies View Related

Initiator Running On SQL Express Edition Get Extra Messages From Target In Transmission Queue

Mar 11, 2008

Scenario: (1) Initiator/Target are running on different machines; (2) Target is on SQL Standard Edition with service pack 1; (3) Initiator ends the conversation.

If Initiator is running on SQL Express Edition with service pack 1 or 2, €śSend message€? and €śEnd conversion€? will introduce two messages in initiator€™s sys.transmission_queue. One is empty message with correct message type; the other is empty message with no message type. Both of them are from the Target to the Initiator.

If Initiator is running on SQL Standard Edition with service pack 1, with same stored procedure (attached below), there is no message left in initiator€™s sys.transmission_queue.

We like to find the way to make Initiator on SQL Express Edition acting same as it on SQL Standard Edition, namely not left messages in the initiator€™s sys.transmission_queue

CREATE PROCEDURE [dbo].[CreateMessageForQueue]
@message varchar(max)
AS
BEGIN

SET NOCOUNT ON;

DECLARE @handle UNIQUEIDENTIFIER;

BEGIN DIALOG CONVERSATION @handle
FROM SERVICE [TCP://Initiator:4321]
TO SERVICE N'TCP://Target:4567'
ON CONTRACT LogContract
WITH ENCRYPTION = OFF;

SEND ON CONVERSATION @handle
MESSAGE TYPE LogMessage(@message);

END CONVERSATION @handle
END




Thanks,

View 2 Replies View Related

Event Viewer

Feb 1, 2002

I tried to save an event viewer file as a .txt format file and when I open the saved file, it's not readable.

Can someone have an idea of what format should I save the event viewer file so I will be able to view it's contents?

Thanks in advance!!

View 2 Replies View Related

Event Viewer Errors

Jan 7, 2005

My boss has now decided that he doesnt want to see SQL errors in the event viewer, unless they are actual errors.

The two errors are:
A - When the DB log is truncated it goes into the event viewer as an error. This needs to either not go into the event viewer at all, or be classed as something other than an error.

B - "Sqllib error: Database x is not simple." This one I dont even know what causes it, but the same thing applies, either it shouldnt be logged, or it needs to be logged as something other than an error. Although what does cause this message?

Any help on these would be appresiated

Thanks :)

View 3 Replies View Related

Event Viewer Msg Thrown For Ms Sql

Apr 10, 2006

Hi guys

i am puzzled on how to decipher the below msg on my sql server
Had tried adjusting the settings but apparantly doesnt work

is this due to my license or what other reasons?

Error msg:
17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 30 queries and performance may be adversely affected.


sql server : MS SQL Enterprise 8.0

View 1 Replies View Related

Error In Event Viewer

Apr 14, 2004

Hi I am getting the following error:

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 4/14/2004
Time: 09:32:05 AM
User: SYSTEM
Computer: BSEW2k01
Description:
Error: 50000, Severity: 5, State: 1
Error Calling StatusToStreet In DCS0 Code 7202

Please help.

Thanks

View 2 Replies View Related

Write To Windows NT Event Viewer

Mar 19, 2001

Hi for everyone!
I need any example to use raise error that write into event Viewer I use WITH LOG directive
but it's no success.
Sincerely.
FAin Boris

View 2 Replies View Related

SQL 6.5 Vs. SQL 7 - Username Missing In Event Viewer

Mar 24, 1999

Hello Everyone:

I'm in the process of verifying that all functionality in a version 6.5 database is still there in SQL 7.0. After the upgrade, one issue seems different.

When I attach to a SQL 6.5 database, the full username used in the connection is displayed in the Windows NT Event Viewer. But when I attach to the same database in SQL 7, the username shows up in the Event Viewer as 'N/A'. I've verified that audit permissions are set the same on both boxes both under SQL and in User Manager. Any ideas??

View 1 Replies View Related

Exporting Event Viewer Logs To Db..

Jul 14, 2004

l am trying to see how to export event veiwer log to database(mssql) and incremental updates.

sql MS server and with window 2000
if anyone knows how to do this in .net or third party software pls let me know.

View 1 Replies View Related

EXCEPTION_ACCESS_VIOLATION: Odd Error In Event Viewer

Jul 23, 2005

I have a stored procedure that I use for call a aspx page from within SQL. The stored procedure itself runs finewith no errors but I keep getting errors in the event viewer everytimeit runs (with .vbs, .NET, .vb6 client) outside Enterprise manager or SQL Query Analyzer.....This is error:Error: 0, Severity: 19, State: 0SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.I think that this is the same problem seen inhttp://www.sqlmonster.com/Uwe/Forum...in-Event-ViewerI've test with XP sp2, W2003 server, SQL 2000 sp3a......on the same machine.ANY SUGGESTIONS??????Thanks--Message posted via http://www.sqlmonster.com

View 3 Replies View Related

Report Viewer Loaded Event

Oct 24, 2007

Is there a way to handle an event when the report viewer has completed loading the report? I have handled the report viewer load event but also want to handle an event for when it has completed loading.

I am wanting this because the "report is being generated" message is far off of the screen when I use a large report viewer.

So, on page load I simply make a textbox visible that says "report is being generated". When it completes generating the report, I want it to make that message invisible.

The disposed and unload events don't seem to handle this correctly.

View 7 Replies View Related

How To Write Messages To The Windows NT Event Viewer ?

Oct 3, 2001

Hi all,
I want send messages(e.g. error description,record count...)to NT event viewer,how can I implement with sql?
thanks

View 1 Replies View Related

Log Events Is Interrelated With Event Viewer Windows?

Dec 11, 2006

Hi everyone,
I was wondering how do for 'Log Events' info going to Event Viewer Windows visor. Is it possible or it's just only private info for you SSIS.

Thanks for your input,

View 2 Replies View Related

Message Queue Task

Apr 18, 2006

Ok, im making some progress. So what i have is a Message Queue Task which is bound to a message queue connection manager (which 'tests' ok). The Message Queue Task is set to recieve, variable from string message (declared a variable of type string) and to remove the message from the queue. The output of that task is piped into the data flow task.
The data flow task expands into a XML Source which is configured to get its input from the string i declared in the Message Queue Task and i point the schemas path to an appropriate schema. I then pipe the output of that into a SQL server destination which ive mapped all the columns from the XML message to a table (which the SQL server destination created for me).

It all looks good on paper, and builds properly with no errors etc. There is already a message in the appropriate private queue. When i go to debug it, it just sits on the Message Queue Task node (its yellow) and goes no further. No data is put into the DB. I have put a watcher on the link between the XML Source and the SQL server destination, and can see no data being piped through.
Even if i send another message, the execution of my package doesnt step passed the Message Queue Task. Its just sitting there waiting for something? what? I thought it would block until there was a message on that queue, and then process it if and when it arrives. But it doesnt seem to do that.

Any ideas??

I read on MSDN that you need integration services installed. I have checked and i do, and its running. Is theres something else i need to configure?

Help!

View 15 Replies View Related

Message Queue Task

Aug 2, 2007

Simple Question.

I have a requirement to read XML Messages from a Remote private MSMQ.
These messages are essentially Database records that will need cleaning up and insterting into a Local Database table.

Is this possible with SSIS?
Would Biztalk be a more suitable tool for this type of process?

If its possible, are there any resources taht can point me in the right direction?

Thanks for your help!
J.

View 1 Replies View Related

Using Message Queue Task And Serialization

Mar 7, 2007

I have a C# application that get data (i.e. select Firstname, LastName from person) to form a DataSet object (i.e. PersonName variable inside my code). Then I want to post this DataSet object into a local private queue (the path is: .privatemyTestQ). Note that I carefully labled the message to be "Variables Message" (as needed per anothre thread discussion here in this forum).

I created a receiving package, in which I want to use SSIS's Message Queue task to retreive the above DataSet object (from C# application). I got failure:

[Message Queue Task] Error: An error occurred with the following error message: "Root element is missing.".

However, As a comparison research, I created another SSIS sending-package. And I used ADO.NET provider to get the same data to store the sull result set in a package-level variable. Then I use Message Queue task to post this variable (i.e. object) to the same private queue above. Then I run my above receiving package. I was successful to read back the messge that I posted from SSIS sending package. (Please note that if I use OLEDB provider for sending package to get data from database, the MSMQ task for sending failed due to serializtion issue for __ComObject. With ADO.NET provider, the result set is represented as a type of DataSet).



I then curiously looked into message body from Computer Management Counsol. I found that message sent from SSIS is in SOAP format while message from my C# application is NOT in SOAP (but only in XML format). Obviously SSIS MSMQ task serialize objects into SOAP format.



Can anyone here please help on how to serialize my DataSet object from my C# app) in compliance with the MSMQ task's spec so that I can read message from Q using SSIS package.



I use Visual Studio 2005 and MSMQ 3.0 version.

Your help is appreciated.

View 2 Replies View Related

Modify Message Order In Queue?

Jun 12, 2007

Is it possible to modify the sequence of messages in a SSB queue? Or to create messages so that their sequence is based on a value in the message rather than the order in which they were sent to the queue?



I am trying to determine if SSB will help me solve a situation where BizTalk needs to process a prescribed sequence of messages that may not be received in the correct order. (i.e. I need to resequence the messages). Each message contains a field with the sequence number and also a field identifying the total number of messages in the sequence.



I realise that the Sequential Convoy Aggregrator EAI pattern can potentially provide a solution to this, or even the Sequence Guards pattern by McGeeky, but I guess I was hoping that SSB might provide a slightly more efficient solution(?)



Thanks,

Dan

View 2 Replies View Related

How To Use Message Queue Task In Integration Services

Jan 17, 2007

How To Use Message Queue Task In Integration Services

View 1 Replies View Related

How To Determine Date/time Message Was Placed Onto Queue?

Oct 2, 2006

I need to determine the actual date/time that a message was placed on the queue. In my "activated" procedure I want to log this information and pass it along to further processing routines. From what I can tell, the Queue table itself does not have this information captured.

View 4 Replies View Related

Can't Receive Message From Queue (Async Trigger)

Sep 1, 2006

Hi Folks,

I've found a pretty good code example on http://www.dotnetfun.com for a Asynchronous Trigger.

I've parsed through the Code, to understand how to wirte my own Async Trigger with a Service Broker, but the Code isn't working! It seems that the stored procedure don't receive the messages in the queue, but the queue get's filled.

MessageType


 CREATE MESSAGE TYPE  myMsgXML
 VALIDATION = WELL_FORMED_XML;
Contract

CREATE CONTRACT myContractANY
 (myMsgXML SENT BY ANY)
Queue

CREATE QUEUE myQueue
 WITH STATUS = ON,
 RETENTION = ON,
 ACTIVATION
 (
  STATUS = ON,
  PROCEDURE_NAME = sp_myServiceProgram,
  MAX_QUEUE_READERS = 5,
  EXECUTE AS SELF
 )
Service

CREATE SERVICE myService ON QUEUE myQueue  (myContractANY)
Procedure (greped from http://www.dotnetfun.com/)

CREATE PROC sp_myServiceProgram
AS
-- This procedure will get triggered automatically
-- when a message arrives at the
-- Let's retrieve any messages sent to us here:
DECLARE @XML XML,
  @MessageBody VARBINARY(MAX),
  @MessageTypeName SYSNAME,
  @ID INT,
  @COL2 VARCHAR(MAX);
DECLARE @Queue TABLE (
  MessageBody VARBINARY(MAX),
  MessageTypeName SYSNAME);
WHILE (1 = 1)
BEGIN
 WAITFOR (
  RECEIVE message_body, message_type_name
  FROM myQueue  INTO @Queue
 ), TIMEOUT 5000;
 -- If no messages exist, then break out of the loop:
 IF NOT EXISTS(SELECT * FROM @Queue) BREAK;
 DECLARE c_Test CURSOR FAST_FORWARD
  FOR SELECT * FROM @Queue;
 OPEN c_Test;
 FETCH NEXT FROM c_Test
  INTO @MessageBody, @MessageTypeName;
 WHILE @@FETCH_STATUS = 0
 BEGIN
  -- Let's only deal with messages of Message Type
  -- myMsgXML:
  IF @MessageTypeName = 'myMsgXML'
  BEGIN
   SET @XML = CAST(@MessageBody AS XML);
   -- Now let's save the XML records into the
   -- historical table:
   INSERT INTO tblDotNetFunTriggerTestHistory
    SELECT tbl.rows.value('@ID', 'INT') AS ID,
     tbl.rows.value('@COL2', 'VARCHAR(MAX)') AS COL2,
     GETDATE() AS UPDATED
    FROM @XML.nodes('/inserted') tbl(rows);
  END
  FETCH NEXT FROM c_Test
   INTO @MessageBody, @MessageTypeName;
 END
 CLOSE c_Test;
 DEALLOCATE c_Test;
 -- Purge the temporary in-proc table:
 DELETE FROM @Queue;
END
Send Message in a Update Trigger

SELECT @XML = (SELECT * FROM inserted FOR XML AUTO);
  -- Send the XML records to the Service Broker queue:
  DECLARE @DialogHandle UNIQUEIDENTIFIER,
   @ConversationID UNIQUEIDENTIFIER;
  /*
   The target Service Broker service is the same
   service as the initiating service; however, you
   can set up this type of trigger to send messages
   to a remote server or another database.
  */
  BEGIN DIALOG CONVERSATION @DialogHandle
   FROM SERVICE myService
   TO SERVICE 'myService'
   ON CONTRACT myContractANY;
  SEND ON CONVERSATION @DialogHandle
   MESSAGE TYPE myMsgXML
   (@XML);
  -- Let's detect an error state for this dialog
  -- and rollback the entire transaction if one is
  -- detected:
  IF EXISTS(SELECT * FROM sys.conversation_endpoints
   WHERE conversation_handle = @DialogHandle
   AND state = 'ER')
   RAISERROR('Dialog in error state.', 18, 127);
  ELSE
  BEGIN
   --I want to list the queue after the trigger so I disabled
   --END CONVERSATION @DialogHandle;
   COMMIT TRAN;
  END
The Problem is, that the Procedure doesn't even get started! So I tried to receive the Queues manually

WAITFOR (
  RECEIVE message_body, message_type_name
  FROM myQueue  INTO @Queue
 ), TIMEOUT 5000;

and I run always into the timeout and get nothing back. A Select * FROM myQueue gives me some results back. Why I can't recevie?
Would be grateful for help, or at least a good tutorial, I haven't found one yet....
thx and greez
     Karsten

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved