This message could not be delivered because it is duplicate

Hot Topic

Problems with SQL Task
Example code for consuming a SSIS datareader from ASP.net
default parameter values not updated
Writeback
duplicated data display
SQL Reporting Date Parameters
SSIS Tutorial - Package configuration issue
Forgotten DTS package passwords
building an .asdatabase file from the command line
SQL server express 2005 problems

SQL Server

Simple Question: Testing an Update Script
Creating Reports on SQL Server 2005 Mobile Edition
Stored proc, strange error
C# user defined function: Is there a way to access the name of the sql server?
Passing constants in data flows
calculate weekendings for a date range
After Installed sql express sp1, install sql sp1 error.
Two issues with SSIS script
xml data source, not sure why i'm losing data
Simulating Errors

This message could not be delivered because it is duplicate

    When I send message from Server1 to Server2,I found the error "This message could not be delivered because it is duplicate" in SQLProfiler on Target, why message can be duplicate who can help me

    My environment is :

    Instance1 on Server1,Instance2 and Instance3 on Server2,Instance1 and Instance2 is a sqlserver2005 cluster,message is sent from Instance1 to Instance3.




Answer this question

This message could not be delivered because it is duplicate

  • jrv

    That means that the source is resending the message because it didn't receive the acknowledgement from the target.  The second time the target gets the message it looks in the conversation endpoint and finds it already has that message.  The most common cause for that is the route from the target machine back to the initiator machine is missing or wrong.  A firewall on the initiator can also block the returning acknowlegements.

  • Rodrigo Tom Back

    AFAIK, there is no real good source for error info. Try Roger's book, there may be some info there. Whet problems are you encountering BTW, some of your best friends when trying to solve SSB problems are the sys.transmission_queue queue and the SQL Server Profiler.

  • Marcus Mac Innes

    Thx,it is really helpful for my problem.

    BTW,Because I have encountered many problem when I built up service broker. where can I find all error detail of service broker

  • This message could not be delivered because it is duplicate
Answer this question