Classification has been delayed because the routing information...

Any ideas on why I get this message in the transmission status:

Classification has been delayed because the routing information is currently being updated.

I did create/drop some routes because I had pointed them to the wrong service, but that was some time ago.

I also just tried to restart the sql instance and it hung on stopping so I'm assuming something with the routing caused the issue.

Any ideas?

Thanks.

This error is cause by lock timeouts on reading the routing table (sys.routes) in the database where you're sending from and/or lock timeouts in the tempdb (where information about all SSB services in the SQL instance is stored). If you're hitting this, it means there must be some transaction holding a long lock on a route or on tempdb.

I would recommend using sys.dm_tran_locks, sys.syslockinfo or sp_lock to identify the lock that is blocking the SSB router from classifying messages.

|||

Thanks. I figured it out later on that I had inadventantly started a transaction to send a message and didn't commit it and after that I changed some of the routes so this held everything up.

Thanks.

clarification on Reporting services

hi folks,

I want to display a message "no records retrieved" in the preview tab of the report in RS when no records are retrieved for a query specified in the data tab of the report in RS.Is there any custom code for this?How to accomplish this?Can anyone help me find a solution for this?Pls send me the procedure for this .

You could:

1. Set the message in the NoRows property of the data region bound to the dataset.

2. Display the message in a textbox which is hidden if the dataset has rows or visible otherwise.

|||

Dear sir,

Thank you for your reply..I was successful with the first point.Can u tell me how to proceed with the second point?

How to display the message in the textbox?should i type something in the textbox value property?if so how?

Regards

Balaji

|||Drop a textbox in the report body with the desired text, e.g. "No data". Set the textbox Visibility Hidden expression to =IsNothing(First(Fields!<some field name>.Value, "<your dataset name>")) = Falsesqlsql

clarification on Reporting services

hi folks,

I want to display a message "no records retrieved" in the preview tab of the report in RS when no records are retrieved for a query specified in the data tab of the report in RS.Is there any custom code for this?How to accomplish this?Can anyone help me find a solution for this?Pls send me the procedure for this .

You could:

1. Set the message in the NoRows property of the data region bound to the dataset.

2. Display the message in a textbox which is hidden if the dataset has rows or visible otherwise.

|||

Dear sir,

Thank you for your reply..I was successful with the first point.Can u tell me how to proceed with the second point?

How to display the message in the textbox?should i type something in the textbox value property?if so how?

Regards

Balaji

|||Drop a textbox in the report body with the desired text, e.g. "No data". Set the textbox Visibility Hidden expression to =IsNothing(First(Fields!<some field name>.Value, "<your dataset name>")) = False

Check Server and Database Collations (Hari Prasad)

Hi Hari,
I see that you respond to my question but unfortunently i
cant see your response, its shown to me "message
unavailable"
It is possible that you send me your response to
jorge.mmendes@.optimus.pt or respond again to this post.
I'll appreciate your kindness
RegardsHi,
SQL 7 do not have those properties. COllation setting in SQL 7 is server
wise not database specific.
Execute the below command to get those details.
sp_helpsort
Thanks
Hari
MCDBA
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:ae8f01c4796a$63773eb0$a501280a@.phx.gbl...
> Hi Hari,
> I see that you respond to my question but unfortunently i
> cant see your response, its shown to me "message
> unavailable"
> It is possible that you send me your response to
> jorge.mmendes@.optimus.pt or respond again to this post.
> I'll appreciate your kindness
> Regards