Data-Driven Subscriptions

Each time I run a data-driven subscription, I recieve the following
information ... "Processing: 0 processed of 1 total; 0 errors" ... The report
runs fine manually and via a subscription, but not a data-driven
subscription. I'm at a lost, where do I start to find this problem?
--
~Jack~Start by looking the reportserverservice<data>.log file. See if it says
anything about picking up the items. What is the subscriptions result?
Have you checked if the subscriptions has succeeded but is just not
reporting it correctly?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> Each time I run a data-driven subscription, I recieve the following
> information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> report
> runs fine manually and via a subscription, but not a data-driven
> subscription. I'm at a lost, where do I start to find this problem?
> --
> ~Jack~|||Daniel,
Thanks for the reply. The data-driven subscription is designed to save the
file as an excel file to a shared folder. Late yesterday I had changed the
User name to my own credentials to see if this would help. Now I recieve the
message "Processing: 1 processed of 1 total; 0 errors"; but no file is
delivered/created to the shared folder. This is at least a step better since
before I had changed the credentials, the message was "Processing: 0
processed of 1 total; 0 errors" . I did look through the log files and found
no errors (wish I had, it would make it simpler to track down the issue)
"Daniel Reib [MSFT]" wrote:
> Start by looking the reportserverservice<data>.log file. See if it says
> anything about picking up the items. What is the subscriptions result?
> Have you checked if the subscriptions has succeeded but is just not
> reporting it correctly?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> > Each time I run a data-driven subscription, I recieve the following
> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> > report
> > runs fine manually and via a subscription, but not a data-driven
> > subscription. I'm at a lost, where do I start to find this problem?
> > --
> > ~Jack~
>
>|||Can you post a portion of the log file that contains the info for when the
subscription fired?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> Daniel,
> Thanks for the reply. The data-driven subscription is designed to save
> the
> file as an excel file to a shared folder. Late yesterday I had changed
> the
> User name to my own credentials to see if this would help. Now I recieve
> the
> message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> delivered/created to the shared folder. This is at least a step better
> since
> before I had changed the credentials, the message was "Processing: 0
> processed of 1 total; 0 errors" . I did look through the log files and
> found
> no errors (wish I had, it would make it simpler to track down the issue)
> "Daniel Reib [MSFT]" wrote:
>> Start by looking the reportserverservice<data>.log file. See if it says
>> anything about picking up the items. What is the subscriptions result?
>> Have you checked if the subscriptions has succeeded but is just not
>> reporting it correctly?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
>> > Each time I run a data-driven subscription, I recieve the following
>> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
>> > report
>> > runs fine manually and via a subscription, but not a data-driven
>> > subscription. I'm at a lost, where do I start to find this problem?
>> > --
>> > ~Jack~
>>|||Daniel, Here is the last log entries for the data-driven subscription
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item 09a38510-e45a-4050-a89d-856230aa4859
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
08:23:02.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item 09a38510-e45a-4050-a89d-856230aa4859
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
based subscription notification for subscription:
f914a139-fae6-4192-b98a-7d6ab51ec6e0
ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
08:23:02.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
processing item c7dffde0-062e-494b-b66e-e502b8eb714d
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
NotificationPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
DBUnProtectData failed: System.FormatException: Invalid length for a Base-64
char array.
at System.Convert.FromBase64String(String s)
at
Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
data)
ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
user: NT AUTHORITY\SYSTEM
ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
Error occured processing notification. Invalid length for a Base-64 char
array.
ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was saved.
ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status: Invalid
length for a Base-64 char array.
ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success: True,
Status: Invalid length for a Base-64 char array., DeliveryExtension: Report
Server FileShare, Report: Monthly Sales, Attempt 0
ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
NotificationPolling finished processing item
ab5e7c97-88d8-44af-83df-cff2ef6e7047
ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
chunks, 0 running jobs
"Daniel Reib [MSFT]" wrote:
> Can you post a portion of the log file that contains the info for when the
> subscription fired?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> > Daniel,
> >
> > Thanks for the reply. The data-driven subscription is designed to save
> > the
> > file as an excel file to a shared folder. Late yesterday I had changed
> > the
> > User name to my own credentials to see if this would help. Now I recieve
> > the
> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> > delivered/created to the shared folder. This is at least a step better
> > since
> > before I had changed the credentials, the message was "Processing: 0
> > processed of 1 total; 0 errors" . I did look through the log files and
> > found
> > no errors (wish I had, it would make it simpler to track down the issue)
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Start by looking the reportserverservice<data>.log file. See if it says
> >> anything about picking up the items. What is the subscriptions result?
> >> Have you checked if the subscriptions has succeeded but is just not
> >> reporting it correctly?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> >> > Each time I run a data-driven subscription, I recieve the following
> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ... The
> >> > report
> >> > runs fine manually and via a subscription, but not a data-driven
> >> > subscription. I'm at a lost, where do I start to find this problem?
> >> > --
> >> > ~Jack~
> >>
> >>
> >>
>
>|||Are you using Fileshare delivery? If so there is a known issue where you
can not use dynamic values for the user name and password. From the log,
this looks like the issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
news:BD5AF19E-5055-41B8-9E1B-83648CD11037@.microsoft.com...
> Daniel, Here is the last log entries for the data-driven subscription
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item 09a38510-e45a-4050-a89d-856230aa4859
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> 08:23:02.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item 09a38510-e45a-4050-a89d-856230aa4859
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
> based subscription notification for subscription:
> f914a139-fae6-4192-b98a-7d6ab51ec6e0
> ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> 08:23:02.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
> ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
> NotificationPolling processing 1 more items. 1 Total items in internal
> queue.
> ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
> DBUnProtectData failed: System.FormatException: Invalid length for a
> Base-64
> char array.
> at System.Convert.FromBase64String(String s)
> at
> Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> data)
> ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
> user: NT AUTHORITY\SYSTEM
> ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
> Error occured processing notification. Invalid length for a Base-64 char
> array.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
> Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was
> saved.
> ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status:
> Invalid
> length for a Base-64 char array.
> ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
> Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success:
> True,
> Status: Invalid length for a Base-64 char array., DeliveryExtension:
> Report
> Server FileShare, Report: Monthly Sales, Attempt 0
> ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> NotificationPolling finished processing item
> ab5e7c97-88d8-44af-83df-cff2ef6e7047
> ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
> chunks, 0 running jobs
>
> "Daniel Reib [MSFT]" wrote:
>> Can you post a portion of the log file that contains the info for when
>> the
>> subscription fired?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
>> > Daniel,
>> >
>> > Thanks for the reply. The data-driven subscription is designed to save
>> > the
>> > file as an excel file to a shared folder. Late yesterday I had changed
>> > the
>> > User name to my own credentials to see if this would help. Now I
>> > recieve
>> > the
>> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
>> > delivered/created to the shared folder. This is at least a step better
>> > since
>> > before I had changed the credentials, the message was "Processing: 0
>> > processed of 1 total; 0 errors" . I did look through the log files and
>> > found
>> > no errors (wish I had, it would make it simpler to track down the
>> > issue)
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Start by looking the reportserverservice<data>.log file. See if it
>> >> says
>> >> anything about picking up the items. What is the subscriptions
>> >> result?
>> >> Have you checked if the subscriptions has succeeded but is just not
>> >> reporting it correctly?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
>> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
>> >> > Each time I run a data-driven subscription, I recieve the following
>> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ...
>> >> > The
>> >> > report
>> >> > runs fine manually and via a subscription, but not a data-driven
>> >> > subscription. I'm at a lost, where do I start to find this problem?
>> >> > --
>> >> > ~Jack~
>> >>
>> >>
>> >>
>>|||Yes I'm using file share and yes I am dynamically storing the user name and
password. Manually entered the user name and passwor as you suggest. Work
like charm. Thanks for all the help!!!
"Daniel Reib [MSFT]" wrote:
> Are you using Fileshare delivery? If so there is a known issue where you
> can not use dynamic values for the user name and password. From the log,
> this looks like the issue.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> news:BD5AF19E-5055-41B8-9E1B-83648CD11037@.microsoft.com...
> > Daniel, Here is the last log entries for the data-driven subscription
> >
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item 09a38510-e45a-4050-a89d-856230aa4859
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> > 08:23:02.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item 09a38510-e45a-4050-a89d-856230aa4859
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 executed at 12/16/2004 08:23:02.
> > ReportingServicesService!schedule!1cf4!12/16/2004-08:23:02:: Creating Time
> > based subscription notification for subscription:
> > f914a139-fae6-4192-b98a-7d6ab51ec6e0
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:02:: Schedule
> > f1955b4a-8e29-4b1c-a137-cfaafd32e584 execution completed at 12/16/2004
> > 08:23:02.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item af247e4b-8fc1-451a-bcd2-5daaeaeebe52
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:02:: EventPolling
> > processing 1 more items. 1 Total items in internal queue.
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:02:: EventPolling
> > finished processing item c7dffde0-062e-494b-b66e-e502b8eb714d
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> > NotificationPolling processing item ab5e7c97-88d8-44af-83df-cff2ef6e7047
> > ReportingServicesService!dbpolling!1cbc!12/16/2004-08:23:03::
> > NotificationPolling processing 1 more items. 1 Total items in internal
> > queue.
> > ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: e ERROR:
> > DBUnProtectData failed: System.FormatException: Invalid length for a
> > Base-64
> > char array.
> > at System.Convert.FromBase64String(String s)
> > at
> > Microsoft.ReportingServices.Diagnostics.DataProtection.DBUnprotectData(String
> > data)
> > ReportingServicesService!crypto!1cf4!12/16/2004-08:23:03:: i INFO: Current
> > user: NT AUTHORITY\SYSTEM
> > ReportingServicesService!notification!1cf4!12/16/2004-08:23:03:: e ERROR:
> > Error occured processing notification. Invalid length for a Base-64 char
> > array.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Data Driven
> > Notification for activation id 9845a8ff-e063-4a16-b6e1-ee8b59ba22ef was
> > saved.
> > ReportingServicesService!library!1cf4!12/16/2004-08:23:03:: Status:
> > Invalid
> > length for a Base-64 char array.
> > ReportingServicesService!notification!1cf4!12/16/2004-08:23:03::
> > Notification ab5e7c97-88d8-44af-83df-cff2ef6e7047 completed. Success:
> > True,
> > Status: Invalid length for a Base-64 char array., DeliveryExtension:
> > Report
> > Server FileShare, Report: Monthly Sales, Attempt 0
> > ReportingServicesService!dbpolling!1cf4!12/16/2004-08:23:03::
> > NotificationPolling finished processing item
> > ab5e7c97-88d8-44af-83df-cff2ef6e7047
> > ReportingServicesService!library!1cf4!12/16/2004-08:25:30:: i INFO:
> > Cleaned
> > 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
> > chunks, 0 running jobs
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Can you post a portion of the log file that contains the info for when
> >> the
> >> subscription fired?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> news:E9BEDE9D-EEEA-4570-8D1D-B648986F46F4@.microsoft.com...
> >> > Daniel,
> >> >
> >> > Thanks for the reply. The data-driven subscription is designed to save
> >> > the
> >> > file as an excel file to a shared folder. Late yesterday I had changed
> >> > the
> >> > User name to my own credentials to see if this would help. Now I
> >> > recieve
> >> > the
> >> > message "Processing: 1 processed of 1 total; 0 errors"; but no file is
> >> > delivered/created to the shared folder. This is at least a step better
> >> > since
> >> > before I had changed the credentials, the message was "Processing: 0
> >> > processed of 1 total; 0 errors" . I did look through the log files and
> >> > found
> >> > no errors (wish I had, it would make it simpler to track down the
> >> > issue)
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Start by looking the reportserverservice<data>.log file. See if it
> >> >> says
> >> >> anything about picking up the items. What is the subscriptions
> >> >> result?
> >> >> Have you checked if the subscriptions has succeeded but is just not
> >> >> reporting it correctly?
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Jack Mac" <jackmacgregor@.aj-net.com> wrote in message
> >> >> news:A5766903-014B-44A2-928F-597B8986755B@.microsoft.com...
> >> >> > Each time I run a data-driven subscription, I recieve the following
> >> >> > information ... "Processing: 0 processed of 1 total; 0 errors" ...
> >> >> > The
> >> >> > report
> >> >> > runs fine manually and via a subscription, but not a data-driven
> >> >> > subscription. I'm at a lost, where do I start to find this problem?
> >> >> > --
> >> >> > ~Jack~
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Databse replication

Dear All

I've made transactional replication between two SQL 2005 servers.
Everything looks fine, synchronization working fine, no errors, however size of replicated database file = 97 Mb,
on Publications server the database file size = 184 Mb.

What is wrong :S ?

Best Regards
PiotrMB?

You should be using Access|||Sounds like the equivalent of shrinking to me...|||Sounds like the equivalent of shrinking to me...

It's funny you talk about shrinkage, and your name is George|||The data on the replicated server has been defragmented. behind the scenes, the snapshot bcp's out the data from the publisher, and bcp's it in to the subscriber. This removes any whitespace created by deletes and page splits.|||That's a much more elegant way of putting it...
I had the whole "Ya know when you defrag your PC..." conversation knocking about in my head.

Database versipn (C.0.8.40) does not match

When I click the "Upgrade" button while trying to configure reporting
services I get a couple of errors here are the two errors:
"Verify Database Version" First Yellow "!" Says :
The database version (C.0.8.40) does not match your reporting services
installation. You must upgrade your reporting services database.
"Create Upgrade Script for Database Version" Second Yellow "!" say:
Couldn't generate the upgrade script. There is no upgrade script available
for this version.
Has anyone seen these errors before. How to I get around these. Right now
my "Database Setup" in has a red "X" on the "Reporting Services Configuration
Manager" window.I have the same exact problem. Any fixes yet?
--
---
Yes, I searched first :)
"Greg Larsen" wrote:
> When I click the "Upgrade" button while trying to configure reporting
> services I get a couple of errors here are the two errors:
> "Verify Database Version" First Yellow "!" Says :
> The database version (C.0.8.40) does not match your reporting services
> installation. You must upgrade your reporting services database.
> "Create Upgrade Script for Database Version" Second Yellow "!" say:
> Couldn't generate the upgrade script. There is no upgrade script available
> for this version.
> Has anyone seen these errors before. How to I get around these. Right now
> my "Database Setup" in has a red "X" on the "Reporting Services Configuration
> Manager" window.
>|||Do you have a resolution to this issue? I ahve the exact same problem.
"Greg Larsen" wrote:
> When I click the "Upgrade" button while trying to configure reporting
> services I get a couple of errors here are the two errors:
> "Verify Database Version" First Yellow "!" Says :
> The database version (C.0.8.40) does not match your reporting services
> installation. You must upgrade your reporting services database.
> "Create Upgrade Script for Database Version" Second Yellow "!" say:
> Couldn't generate the upgrade script. There is no upgrade script available
> for this version.
> Has anyone seen these errors before. How to I get around these. Right now
> my "Database Setup" in has a red "X" on the "Reporting Services Configuration
> Manager" window.
>|||I had the same problem.
It was caused by that I had installed reporting services after I had run
SP1 on SQL Server 2005.
Solved it by runing SQL Server 2005 SP1 again.
Hope this helps!
"Rich" wrote:
> Do you have a resolution to this issue? I ahve the exact same problem.
> "Greg Larsen" wrote:
> > When I click the "Upgrade" button while trying to configure reporting
> > services I get a couple of errors here are the two errors:
> >
> > "Verify Database Version" First Yellow "!" Says :
> > The database version (C.0.8.40) does not match your reporting services
> > installation. You must upgrade your reporting services database.
> >
> > "Create Upgrade Script for Database Version" Second Yellow "!" say:
> > Couldn't generate the upgrade script. There is no upgrade script available
> > for this version.
> >
> > Has anyone seen these errors before. How to I get around these. Right now
> > my "Database Setup" in has a red "X" on the "Reporting Services Configuration
> > Manager" window.
> >