Errors in log when running data-driven subscriptions

The following messages are displayed in one of the RS logs when running a
data-driven subscription:
ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR: There
is no data for the field at position 277.
ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR: There
is no data for the field at position 278.
ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR: There
is no data for the field at position 279.
What do they mean? What is the position referring to? The data-driven
subscription uses a query that selects a subset of the records in a table.
Thanks.I believe it is referring to the fields in the query. Does you query return
280 columns? How did you create the DD subscription, via Report Manager or
SOAP? If it was via soap, it is possible that your field list is not
identical to what is returned from the query. If you run the query through
PrepareQuery you should get an appropriate field listing.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:E5E8B150-0891-4154-9C9B-7532FB911E7F@.microsoft.com...
> The following messages are displayed in one of the RS logs when running a
> data-driven subscription:
> ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> There
> is no data for the field at position 277.
> ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> There
> is no data for the field at position 278.
> ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> There
> is no data for the field at position 279.
> What do they mean? What is the position referring to? The data-driven
> subscription uses a query that selects a subset of the records in a table.
> Thanks.|||The query only returns 1 column from a table with 4 columns total. I created
the subscription using the Report Manager.
"Daniel Reib [MSFT]" wrote:
> I believe it is referring to the fields in the query. Does you query return
> 280 columns? How did you create the DD subscription, via Report Manager or
> SOAP? If it was via soap, it is possible that your field list is not
> identical to what is returned from the query. If you run the query through
> PrepareQuery you should get an appropriate field listing.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "PD" <PD@.discussions.microsoft.com> wrote in message
> news:E5E8B150-0891-4154-9C9B-7532FB911E7F@.microsoft.com...
> > The following messages are displayed in one of the RS logs when running a
> > data-driven subscription:
> >
> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> > There
> > is no data for the field at position 277.
> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> > There
> > is no data for the field at position 278.
> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> > There
> > is no data for the field at position 279.
> >
> > What do they mean? What is the position referring to? The data-driven
> > subscription uses a query that selects a subset of the records in a table.
> >
> > Thanks.
>
>|||Hmmm. Can you send a little more of the log file. Perhaps that will shed
some light.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:1C6EA567-4DF7-40C1-8713-FCD68ABC32DF@.microsoft.com...
> The query only returns 1 column from a table with 4 columns total. I
> created
> the subscription using the Report Manager.
> "Daniel Reib [MSFT]" wrote:
>> I believe it is referring to the fields in the query. Does you query
>> return
>> 280 columns? How did you create the DD subscription, via Report Manager
>> or
>> SOAP? If it was via soap, it is possible that your field list is not
>> identical to what is returned from the query. If you run the query
>> through
>> PrepareQuery you should get an appropriate field listing.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "PD" <PD@.discussions.microsoft.com> wrote in message
>> news:E5E8B150-0891-4154-9C9B-7532FB911E7F@.microsoft.com...
>> > The following messages are displayed in one of the RS logs when running
>> > a
>> > data-driven subscription:
>> >
>> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
>> > There
>> > is no data for the field at position 277.
>> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
>> > There
>> > is no data for the field at position 278.
>> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
>> > There
>> > is no data for the field at position 279.
>> >
>> > What do they mean? What is the position referring to? The data-driven
>> > subscription uses a query that selects a subset of the records in a
>> > table.
>> >
>> > Thanks.
>>|||Daniel,
I have the same problem. The error occurs when I run as a scheduled report
... the report runs fine all other times.
Here is an excerpt from my log file. See the error message after RenderFirst.
aspnet_wp!library!504!12/20/2004-15:41:07:: i INFO: Call to GetPermissions:/
aspnet_wp!library!504!12/20/2004-15:41:07:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4b4!12/20/2004-15:42:16:: i INFO: Call to GetPermissions:/
aspnet_wp!library!4b4!12/20/2004-15:42:16:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!504!12/20/2004-15:42:33:: i INFO: Call to
GetPermissions:/Dashboards
aspnet_wp!library!504!12/20/2004-15:42:33:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4b4!12/20/2004-15:42:35:: i INFO: Call to
GetPermissions:/Dashboards/PatientVolumeActivity
aspnet_wp!library!4b4!12/20/2004-15:42:35:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4b4!12/20/2004-15:42:36:: i INFO: Call to RenderFirst(
'/Dashboards/PatientVolumeActivity' )
aspnet_wp!processing!b18!12/20/2004-15:42:37:: e ERROR: There is no data for
the field at position 3.
aspnet_wp!library!4b4!12/20/2004-15:42:37:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!4b4!12/20/2004-15:42:37:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream=''
aspnet_wp!chunks!4b4!12/20/2004-15:42:38:: i INFO: ###
GetReportChunk('C_3_S', 1), chunk was not found!
this=d27cd042-e1ce-45c5-bc6a-2211ddca2424
aspnet_wp!chunks!504!12/20/2004-15:42:38:: i INFO: ###
GetReportChunk('C_50_S', 1), chunk was not found!
this=d27cd042-e1ce-45c5-bc6a-2211ddca2424
aspnet_wp!webserver!4b4!12/20/2004-15:42:38:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream='C_3_S'
aspnet_wp!webserver!504!12/20/2004-15:42:38:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream='C_50_S'
aspnet_wp!chunks!504!12/20/2004-15:42:38:: i INFO: ###
GetReportChunk('C_111_S', 1), chunk was not found!
this=d27cd042-e1ce-45c5-bc6a-2211ddca2424
aspnet_wp!chunks!4b4!12/20/2004-15:42:38:: i INFO: ###
GetReportChunk('C_140_S', 1), chunk was not found!
this=d27cd042-e1ce-45c5-bc6a-2211ddca2424
aspnet_wp!webserver!504!12/20/2004-15:42:38:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream='C_111_S'
aspnet_wp!webserver!4b4!12/20/2004-15:42:38:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream='C_140_S'
aspnet_wp!library!504!12/20/2004-15:42:40:: i INFO: Call to
GetPermissions:/Dashboards/PatientVolumeActivity
aspnet_wp!library!504!12/20/2004-15:42:40:: i INFO: Call to
GetSystemPermissions
"Daniel Reib [MSFT]" wrote:
> Hmmm. Can you send a little more of the log file. Perhaps that will shed
> some light.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "PD" <PD@.discussions.microsoft.com> wrote in message
> news:1C6EA567-4DF7-40C1-8713-FCD68ABC32DF@.microsoft.com...
> > The query only returns 1 column from a table with 4 columns total. I
> > created
> > the subscription using the Report Manager.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> I believe it is referring to the fields in the query. Does you query
> >> return
> >> 280 columns? How did you create the DD subscription, via Report Manager
> >> or
> >> SOAP? If it was via soap, it is possible that your field list is not
> >> identical to what is returned from the query. If you run the query
> >> through
> >> PrepareQuery you should get an appropriate field listing.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "PD" <PD@.discussions.microsoft.com> wrote in message
> >> news:E5E8B150-0891-4154-9C9B-7532FB911E7F@.microsoft.com...
> >> > The following messages are displayed in one of the RS logs when running
> >> > a
> >> > data-driven subscription:
> >> >
> >> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> >> > There
> >> > is no data for the field at position 277.
> >> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> >> > There
> >> > is no data for the field at position 278.
> >> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> >> > There
> >> > is no data for the field at position 279.
> >> >
> >> > What do they mean? What is the position referring to? The data-driven
> >> > subscription uses a query that selects a subset of the records in a
> >> > table.
> >> >
> >> > Thanks.
> >>
> >>
> >>
>
>