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.
> >>
> >>
> >>
>
>

Error-14010-remote server not defined as subscription server

Running SQL Server Personal Ed (Server A) on Tablet PC (publication and distribution setup here) trying to push data to SQL Server 2000 Enterprise Ed. (Server B). When I start sync I get two failures. First is 'remote server not defined as subscription server'. Second, subscription to publication xx not valid (error# -2147201019). The snapshot is succeeding fine. What do I need to setup on Server B? I have the same db on both servers.

Try with running sp_addsubscriber 'Server B' to see if it will be fixed.|||

I did run sp_add subscriber only to verify Server B already exists. A subscription shows up on server B; listed as never started.

I have not been able to succeed this task.

Server A db properties-replication tab-configure-subscribers tab-set agent connection to subscriber to impersonate-rerun PUSH suscription-response-login fail for anonymous logon.

How to setup both servers to accept anonymous logon?

|||

This issue has been resolved.

Security settings was the problem on both servers.

thx..bt

ERROR: Subscription

After setting up and running the report subscription, the following Job error
message is returned?
'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
SERVER'. The step failedI am sending the logfile for review. Thank you.
ReportingServicesService!dbpolling!9!11/28/2005-01:34:45:: EventPolling
polling service stopped
ReportingServicesService!dbpolling!c!11/28/2005-01:34:45:: EventPolling
heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!9!11/28/2005-01:34:45::
NotificationPolling polling service stopped
ReportingServicesService!dbpolling!b!11/28/2005-01:34:45::
NotificationPolling heartbeat thread exiting for stop.
ReportingServicesService!dbpolling!9!11/28/2005-01:34:45:: SchedulePolling
polling service stopped
ReportingServicesService!dbpolling!9!11/28/2005-01:34:45:: UpgradePolling
polling service stopped
ReportingServicesService!servicecontroller!9!11/28/2005-01:34:47:: Service
controller exiting.
"Terry" wrote:
> After setting up and running the report subscription, the following Job error
> message is returned?
> 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK
> SERVER'. The step failed
>|||Hi Terry,
Do you allow 'NT AUTHORITY\NETWORK SERVER' to access your database?
if i not wrong, the 'NT AUTHORITY\NETWORK SERVER' don't have permission to
access the database
thanks
Nicky

Error: Subreport could not be shown.

Does anyone have an idea what would cause this error when viewing this in
Report Manager or thru a subscription to be rendered as a PDF attachment?
Subreports view fine through Visual Studio .NET Report project.
Thanks in advance.whats the error u r getting?
"Microsoft PrivateNews" <Dave.Troyer@.cliftoncpa.com> wrote in message news:<uRRh35dwEHA.1524@.TK2MSFTNGP09.phx.gbl>...
> Does anyone have an idea what would cause this error when viewing this in
> Report Manager or thru a subscription to be rendered as a PDF attachment?
> Subreports view fine through Visual Studio .NET Report project.
> Thanks in advance.|||I figured out the problem. In report manager, the error displayed was
'Error: Subreport could not be shown.' What happen was when I uploaded the
reports thru report manager and then change the name of the reports in
report manager. The subreport could not be found that was specified
originally.
Thanks for replying.
"Amit Bhandari" <abhandari2004@.gmail.com> wrote in message
news:c3d1e67b.0411041027.63b0acf4@.posting.google.com...
> whats the error u r getting?
>
> "Microsoft PrivateNews" <Dave.Troyer@.cliftoncpa.com> wrote in message
> news:<uRRh35dwEHA.1524@.TK2MSFTNGP09.phx.gbl>...
>> Does anyone have an idea what would cause this error when viewing this in
>> Report Manager or thru a subscription to be rendered as a PDF attachment?
>> Subreports view fine through Visual Studio .NET Report project.
>> Thanks in advance.