Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
 Posted - 2008-05-19 : 04:52:35
|
So, our first foray into Brokers Service is nice and simple - we are using it to keep a legacy and 2 new-world databases in synch by sending messages acorss with each change on either side. All-in-all, the designer and developer came up with 19 different queues, just on 30 different message types, with 4 server working and sending the 100,000+ messages a day (24x7).Seriously, that is the application that is the first usage of SSBS here. Surprisingly, there are some issues  , amongst them a message syaing:<Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"> <Code>-8428</Code> <Description>The message type "SystemC/SystemA/Object/Action" is not found.</Description></Error>((message type name sanitized))Has anyone found anywhere with more detail on SSBs error codes and resolving them*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-19 : 05:28:23
|
-8428 The message type “%.*ls” is not found.This system error is sent to a conversation that is using a message type not found in the target databasehttp://rusanu.com/2007/12/
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2008-05-19 : 05:46:45
|
| Hmm - target database. Reviewing this so FAR it seems like it is in the target database. Where did you find that error message detail? The solution design tries to generically handle resend of messages that arrived out of sequnce - I am wondering whether the generic handler has sent this to the wrong DB - we will try digging in to find out.*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2008-05-20 : 13:54:22
|
| Discovered the issue- the TARGET database helped us - got the developer to re-review the generic SendMessage SP, and it was posting message to wrong queue for certain messaeg-types , that that queue didn't have that message type*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-20 : 14:46:54
|
Happy to help.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
|
|
SSBS error messages - WHERE TO FIND HELP?