February 17, 2010 at 10:27 am
We have some reports that are not executing. We looked at the ReportServer.log and there were two errors that were thrown quite often. We are not sure if they are related. They are as follows:
1) w3wp!runningjobs!e!2/16/2010-11:28:19:: w WARN: Thread pool pressure. Using current thread for a work item.
2) w3wp!processing!8!2/16/2010-11:28:25:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 33., ;
We understand that the first error means that the system maxed out on thread pools and it will default to the Current thread, which causes the report to take longer.
We don't understand what the second error is: "There is no data for the field at position 33".
So, our questions are:
1) Is the 2nd error related to the first error and what does it mean.
2) Assuming the real problem is that we have maxed out on the threadpool, what causes this (ie. large reports?) and what is the fix.
3) Are the errors in the ReportServer.log thrown out of order (by order I mean in report order) or are they just thrown as they happen.
Thanks
February 17, 2010 at 2:15 pm
Found the following here
Hope it helps...
Common error: The dataset ‘GetReturnValue’ contains a definition for the Field ‘GetReturnValueResponse’. This field is missing from the returned result set from the data source.
[rsErrorReadingDataSetField] The dataset ‘GetReturnValue’ contains a definition for the Field ‘GetReturnValueResponse’. The data extension returned an error during reading the field. There is no data for the field at position 2.
Resolution: This is due to the Field Source having the incorrect value. We need to change the Field Source from GetReturnValueResponse to GetReturnValueResult.
18) Under the GetReturnValue dataset, right click GetReturnValueResponse and select Field Properties.
19) Find the GetReturnValue row and change value under the Field Source column to "GetReturnValueResult".
May 12, 2010 at 1:25 am
Hi Team I am new to SSRS ,we are facing the erors like below could you please help me to resolve this issue.
w3wp!library!1!05/11/2010-14:42:02:: Call to SetReportParametersAction(/Reportname).
w3wp!library!1!05/11/2010-14:42:03:: Call to SetReportParametersAction(Reportname).
w3wp!library!1!05/11/2010-14:42:04:: Call to CreateSnapshotAction().
w3wp!processing!1!5/11/2010-14:42:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1.
w3wp!processing!1!5/11/2010-14:42:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 2., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 2.
w3wp!processing!1!5/11/2010-14:42:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 3., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 3.
w3wp!processing!1!5/11/2010-14:42:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 4., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 4.
w3wp!processing!1!5/11/2010-14:42:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 5., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 5.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply