An error has occurred during report processing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

angelie128 - 09 Jul 2008 23:35 GMT

Hi Everyone!
I don't know what else to do but we I have now tallied 6 reports that
got either one of the errors below...and I'm not sure what else to
do..

Error 1

* An error has occurred during report processing.
o Query execution failed for data set 'dsMain_SQL'.
+ For more information about this error navigate to
the report server on the local server machine, or enable remote
errors

Error 2
An error has occurred during report processing.
Cannot read the next data row for the data set sales.
For more information about this error navigate to the report server on
the local server machine, or enable remote errors

Please help me!!

Thank you!!

Reply to this Message

Steve MunLeeuw - 10 Jul 2008 14:54 GMT

The query for the dataset failed for some reason, but becase you are not on
the local machine you are blocked from getting at the underlying error. You
will most likely want to configure for remote errors. The error message is
also in the log file for that server. I have remote errors turned on, but I
still find myself looking at the log file, really it's just whatever is
easiest for you at the time.

Log files:
\\myserver\c$\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
Services\LogFiles

Remote errors:
http://msdn.microsoft.com/en-us/library/aa337165.aspx
It seems weird to me that the configuration for this is through script. I
have RS 2008 RC0 installed, but I don't see an option for this in Reporting
Services Configuration Manager.

From Microsoft SQL Server Management Studio 2008 RC0 I don't have an option
to connect to a reporting services instance. Anyone know what I'm missing
in the install process?

Thanks,
Steve MunLeeuw

Reply to this Message