Report Server Diagnostic Reports

Question

Post reply

Report Server Diagnostic Reports

Viewing 15 posts - 46 through 60 (of 117 total)

You must be logged in to reply to this topic. Login to reply

Rick Burrows SSC Enthusiast Points: 151 More actions · Answer 1

Rick Burrows

SSC Enthusiast

Points: 151

February 4, 2010 at 2:02 pm

#1114010

Download worked fine for me in Google Chrome

Warren Bauer SSC Enthusiast Points: 151 More actions · Answer 2

Great timing for me as well and very helpful; but I am getting this error when selecting the 'command text' report.

Error: Subreport could not be shown.

Any idea what I did wrong?

michael_davis2 Mr or Mrs. 500 Points: 521 More actions · Answer 3

Verify the name of the report (probably case sensative). I just downloaded the pack and placed the reports in a new reporting project and they appear fine. I also deployed them to a development report server and all worked there as well.

If you find the issue is persisting, let me know...I just don't see anything.

SDM SSCommitted Points: 1581 More actions · Answer 4

Great work.

Like many others, I had created reports for some of the admin issues covered here. Sadly (for my colleagues) my reports are not as nice as these.

I'll make sure they get to use the prettier ones.

Thanks

roger_os SSC Eights! Points: 831 More actions · Answer 5

roger_os

SSC Eights!

Points: 831

February 5, 2010 at 2:10 am

#1114252

Thanks again

Jim Parzych SSC Journeyman Points: 86 More actions · Answer 6

This does not appear to be quite right. We have stored procedures called from within the report stored procedure.

For example sp Rpt.Supplies is the stored proc called by the report. within Rpt.Supplies i have a call to another sp - Rpt.GetDateTypes

Rpt.GetDateTypes is what is displayed when i run this query:

;with RS as

(

SELECT [Name],

CAST(CAST([Content] AS VARBINARY(MAX)) AS XML) AS reportXML,

CAST(CAST(CAST([Content] AS VARBINARY(MAX)) AS XML) AS Varchar(max)) AS reportText

FROM [Catalog] WITH (NOLOCK)

WHERE --get only reports, not folders or other resources

[Type] = 2

)

select name,

reportXML,

substring(reportText, charindex('<commandText>',reportText)+13, charindex('</commandText>',reportText)-charindex('<commandText>',reportText)-13)

from RS

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 7

Thanks Michael .... for sharing your good stuff to SQL server community !

Works Great ... 🙂

\\K

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

craig_feldman Grasshopper Points: 24 More actions · Answer 8

These reports are great. Thanks for sharing your hard work.

athurgar SSCrazy Points: 2816 More actions · Answer 9

Excellent set of scripts and reports. Easy to deploy. Great work.

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 10

Hello all,

when I try to run report: ReportQueries, I am getting below error:

Msg 9420, Level 16, State 1, Line 1

XML parsing: line 90, character 10, illegal xml character

Any ideas !

when I run the below query in reportserver db, I am getting the same error:

set transaction isolation level read uncommitted

;with RS as

(

selectitemID,

[name],

[path],

CAST(CAST(CAST([Content] AS VARBINARY(MAX)) AS XML) AS Varchar(max)) AS reportText

from[catalog]

where[Type] = 2

and (@reportID = convert(varchar(500),itemID) or @reportID = 'NOID')

)

selectitemID,

[name],

[path],

substring(reportText, charindex('<commandText>',reportText)+13, charindex('</commandText>',reportText)-charindex('<commandText>',reportText)-13) as commandText

fromRS

Also, I have deployed reports on my local machine, that works fine. IS the problem related to reportserver DB ?

Thanks,

\\K

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

michael_davis2 Mr or Mrs. 500 Points: 521 More actions · Answer 11

My guess is that one of the reports on the server getting the error has a query that is causing the problem. This is something I would like to fix - should one row produce an error I would like to state "Could not read the report query" as opposed to failing the whole dataset. I'm pretty sure that is where the problem is for you. Someone earlier had a similar issue I believe.

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 12

michael_davis2 (2/8/2010)
My guess is that one of the reports on the server getting the error has a query that is causing the problem. This is something I would like to fix - should one row produce an error I would like to state "Could not read the report query" as opposed to failing the whole dataset. I'm pretty sure that is where the problem is for you. Someone earlier had a similar issue I believe.

Thanks Michael for your response,

Any workaround to resolve the issue ?

Thanks,

\\K

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 13

nice article

only thing i'm looking for now is if there is a way to audit SSRS. Us DBA's are responsible for watching it, but our BI dev's have access to change reports any time they want. we suspect some of our outages or problems with reports are caused by the BI devs making changes during business hours

Cris E Ten Centuries Points: 1255 More actions · Answer 14

It occurs on reports where there are no data sources used (like a REPORTS ARE UNAVAILABLE report we put up) and the ChARINDEX functions both return 0.

To fix it replace the second SELECT with this:

[font="Courier New" size="2"]selectitemID,

[name],

[path],

case when charindex('<commandText>',reportText) = 0 or charindex('</commandText>',reportText) = 0 then '(no query)'

else substring(reportText, charindex('<commandText>',reportText)+13, charindex('</commandText>',reportText)-charindex('<commandText>',reportText)-13) end as commandText

fromRS[/font]

EDIT: OK, the formatting experience is a bit frustrating today...

[font="Arial"]Are you lost daddy? I asked tenderly.
Shut up he explained.[/font]
- Ring Lardner

Jim Parzych SSC Journeyman Points: 86 More actions · Answer 15

There is also a problem when there are more than 1 datasets belonging to a report. This solution only prints out the value for the first occurance of <commandText>