Search

The Activity Monitor is unable to execute queries against server XYZ. by ArthurZ

Closed

4
0
Sign in
 to vote
Type: Bug
ID: 776611
Opened: 1/15/2013 8:40:01 AM
Access Restriction: Public
0
Workaround(s)
2
User(s) can reproduce this bug
Getting repeated errors having the Activity Monitor running against SQL Server 2005 SP2 64Bit Pro using
Microsoft SQL Server Management Studio                        10.50.2550.0
Microsoft Analysis Services Client Tools                        10.50.2500.0
Microsoft Data Access Components (MDAC)                        6.1.7601.17514
Microsoft MSXML                        3.0 5.0 6.0
Microsoft Internet Explorer                        9.0.8112.16421
Microsoft .NET Framework                        2.0.50727.5466
Operating System                        6.1.7601

The full error is

TITLE: Microsoft SQL Server Management Studio
------------------------------

The Activity Monitor is unable to execute queries against server XYZ.
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.

------------------------------
ADDITIONAL INFORMATION:

Invalid length parameter passed to the SUBSTRING function. (Microsoft SQL Server, Error: 536)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5069&EvtSrc=MSSQLServer&EvtID=536&LinkId=20476
Details (expand)

Product Language

English

Version

SQL Server 2008 R2

Category

Tools (SSMS, Agent, Profiler, Migration, etc.)

Operating System

Windows 7 Professional

Operating System Language

US English

Steps to Reproduce

Run activity monitor for a long time. I do not have specific steps to reproduce because it happens periodically.

Actual Results

Error
TITLE: Microsoft SQL Server Management Studio
------------------------------

The Activity Monitor is unable to execute queries against server XYZ.
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.

------------------------------
ADDITIONAL INFORMATION:

Invalid length parameter passed to the SUBSTRING function. (Microsoft SQL Server, Error: 536)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.5069&EvtSrc=MSSQLServer&EvtID=536&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Expected Results

Activity Monitor carries on.

Platform

X64

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 1/29/2013 at 5:08 PM
Hello

We took a look at this bug along with several others recently.
Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future.
However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

Thanks for writing in to Microsoft.
Alex Grach[MSFT]
Posted by Microsoft on 1/15/2013 at 11:15 AM
Thank you for reporting this issue - we are investigating and will update you when we have more information.

Thanks,

Alex Grach [MSFT SQL SERVER]
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement