June 2, 2014 at 5:29 pm
Hi All,
Attached is the report server logs I took out from the server, and the report hasn't been running.
It was all set by another DBA who is not available to comment.
Any suggestions on how do I proceed /troubleshoot as I don't have hands on Reporting services
June 2, 2014 at 6:44 pm
You'll need to get some hands on experience at this point with SSRS and the VS2008 studio (you need the right version of VS or BIDS for each version of SQL Server).
(One of) your error(s) is here:
Details: One or more parameters were not specified for the subreport, 'summaryOfJobsSubreport', located at: /Stash Reports/Monthly Report/Job SLAs and Workflows (Summary).
That's no longer a simple report if it's got subreports. You have to find the report that's the primary, locate the subreport, dig into the data source on it, and figure out what parameters are set against it. Then you have to figure out why the primary report isn't feeding it.
We'd have to see the RDLs of the involved reports to have a chance at helping you on this.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 2, 2014 at 7:10 pm
Hi,
Many thanks for your response. Attached is one of the reports (RDL file) that fails..
Can you please take a look and respond if you notice any errors?
Cheers
June 2, 2014 at 7:15 pm
The one which I attached above is an individual report. I did have installed VS 2010 shell and able to view the datasets and upon trying to view the report on the server directly I got the attached error..
June 3, 2014 at 11:30 am
nivedita talukdar (6/2/2014)
The one which I attached above is an individual report. I did have installed VS 2010 shell and able to view the datasets and upon trying to view the report on the server directly I got the attached error..
Regarding the inline SQL RDL you had in a previous post, that's a LOT of information to churn through. It would take me a few hours, so I'm afraid that's a bit beyond my time availability for a forum. I don't see anything directly.
For the one I quoted, that seems like a pretty straight forward error.
I would start at the basics. Rebuild this report in a new report, one piece at a time, until you find the error(s). Once you have that, you know where to begin investigating. There's just way too much going on in there to troubleshoot hands off. At least for me. Sorry.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 3, 2014 at 1:19 pm
nivedita talukdar (6/2/2014)
The one which I attached above is an individual report. I did have installed VS 2010 shell and able to view the datasets and upon trying to view the report on the server directly I got the attached error..
The error is straight forward: a conversion resulted in an overflow.
Take a look at the dataset, find out which strings are converted to datetimes and fix the problem.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply