We started using RS 2005 web farm a month ago. Since then we have
problem delivering reports trough email. When using shared
subscription with several reports some reports are sent and some are
not.
Errors displayed by various parts of system are below:
Subscription Last Status text:
The delivery extension for this subscription could not be loaded.
Windows Application event log:
Report Server (MSSQLSERVER) cannot load the Report Server
DocumentLibrary
extension.
At first we thought that problem is our postfix mail server so we
transferred from directly sending mail to sending mail to local SMTP
which then sends mail to postfix. One problem was a connection
timeout. It seems that connection with mail server is opened at the
same time the shared schedule execution has started. With SMTP service
standard time-out of 10 minutes or so reports lasting more than that
have no chance to be sent. So my solution was installing local SMTP
Service from windows components setup and setting its timeout to
timeout needed by our reports. But the problem didn't go away. I was
hoping that unsent mail will be in badmail SMTP folder or that I will
find it in drop folder as unsent mail. Strange thing is that all the
folders are empty. There is no bad mail. My SRS can't send mail to my
local SMTP! When shared subscription with several reports is fired
connection to local SMTP is created. I can see it in Current Sessions.
If subscription is shared I suppose that reports, belonging to shared
subscription, are being executed one by one and sent to SMTP server as
they are finished. Time out of my SMTP is 180 minutes. All the reports
executed one by one take about 30 minutes so I guess now time out is
not a problem. I think that there are 2 possible reasons:
1. Opened connection to SMTP somehow brakes between two reports being
sent and can't be reestablished
2. SRS successfully execute some reports and send them to SMTP and
when next report is finished and have to be sent, SRS can't load DLL
needed to send mail.
Every suggestion will be appreciated!Any ideas?
ijeremi...@.gmail.com wrote:
> We started using RS 2005 web farm a month ago. Since then we have
> problem delivering reports trough email. When using shared
> subscription with several reports some reports are sent and some are
> not.
> Errors displayed by various parts of system are below:
> Subscription Last Status text:
> The delivery extension for this subscription could not be loaded.
> Windows Application event log:
> Report Server (MSSQLSERVER) cannot load the Report Server
> DocumentLibrary
> extension.
> At first we thought that problem is our postfix mail server so we
> transferred from directly sending mail to sending mail to local SMTP
> which then sends mail to postfix. One problem was a connection
> timeout. It seems that connection with mail server is opened at the
> same time the shared schedule execution has started. With SMTP service
> standard time-out of 10 minutes or so reports lasting more than that
> have no chance to be sent. So my solution was installing local SMTP
> Service from windows components setup and setting its timeout to
> timeout needed by our reports. But the problem didn't go away. I was
> hoping that unsent mail will be in badmail SMTP folder or that I will
> find it in drop folder as unsent mail. Strange thing is that all the
> folders are empty. There is no bad mail. My SRS can't send mail to my
> local SMTP! When shared subscription with several reports is fired
> connection to local SMTP is created. I can see it in Current Sessions.
> If subscription is shared I suppose that reports, belonging to shared
> subscription, are being executed one by one and sent to SMTP server as
> they are finished. Time out of my SMTP is 180 minutes. All the reports
> executed one by one take about 30 minutes so I guess now time out is
> not a problem. I think that there are 2 possible reasons:
> 1. Opened connection to SMTP somehow brakes between two reports being
> sent and can't be reestablished
> 2. SRS successfully execute some reports and send them to SMTP and
> when next report is finished and have to be sent, SRS can't load DLL
> needed to send mail.
> Every suggestion will be appreciated!|||If no-one responds here I suggest trying the web based forums. That is where
MS people hang out and the other RS MVP.
http://forums.microsoft.com/msdn/showforum.aspx?forumid=82&siteid=1
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<ijeremicyu@.gmail.com> wrote in message
news:1184243847.242957.320910@.w3g2000hsg.googlegroups.com...
> Any ideas?
> ijeremi...@.gmail.com wrote:
>> We started using RS 2005 web farm a month ago. Since then we have
>> problem delivering reports trough email. When using shared
>> subscription with several reports some reports are sent and some are
>> not.
>> Errors displayed by various parts of system are below:
>> Subscription Last Status text:
>> The delivery extension for this subscription could not be loaded.
>> Windows Application event log:
>> Report Server (MSSQLSERVER) cannot load the Report Server
>> DocumentLibrary
>> extension.
>> At first we thought that problem is our postfix mail server so we
>> transferred from directly sending mail to sending mail to local SMTP
>> which then sends mail to postfix. One problem was a connection
>> timeout. It seems that connection with mail server is opened at the
>> same time the shared schedule execution has started. With SMTP service
>> standard time-out of 10 minutes or so reports lasting more than that
>> have no chance to be sent. So my solution was installing local SMTP
>> Service from windows components setup and setting its timeout to
>> timeout needed by our reports. But the problem didn't go away. I was
>> hoping that unsent mail will be in badmail SMTP folder or that I will
>> find it in drop folder as unsent mail. Strange thing is that all the
>> folders are empty. There is no bad mail. My SRS can't send mail to my
>> local SMTP! When shared subscription with several reports is fired
>> connection to local SMTP is created. I can see it in Current Sessions.
>> If subscription is shared I suppose that reports, belonging to shared
>> subscription, are being executed one by one and sent to SMTP server as
>> they are finished. Time out of my SMTP is 180 minutes. All the reports
>> executed one by one take about 30 minutes so I guess now time out is
>> not a problem. I think that there are 2 possible reasons:
>> 1. Opened connection to SMTP somehow brakes between two reports being
>> sent and can't be reestablished
>> 2. SRS successfully execute some reports and send them to SMTP and
>> when next report is finished and have to be sent, SRS can't load DLL
>> needed to send mail.
>> Every suggestion will be appreciated!
>sql
Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts
Wednesday, March 21, 2012
Tuesday, March 20, 2012
RS.EXE parameters not working
Hi Everyone,
I am having a problem with the RS utility not recognizing my query parameters that I am passing to my timed subscription. I have set up my report with a "WorkOrder" parameter. I have created a trigger that causes my subscription to fire, and that trigger passes in the workorder number to the utility. The subscription fires successfully, but I am getting a blank report.
I set the parameter value to "can be blank" so that I could create my subscription w/o an error. I know that my subscription id is correct when I use the fire method, because I DO get the appropriate report.
I am also having the same problem when I actually log in to the report server and execute the utility from the command line. I believe my report is good. Once the report is generated, I am able to follow my URL, plug in the workorder id, and it works.
What would cause the variable not to be passed in/recognized? This is how I am calling it from the command line:
rs -i C:\ReportingServices\asbuilts.rss -v WorkOrder="10610" -s http://(servername)/ReportServer
Thanks!
Wanda
Wanda,
Here's an example of my command line:
rs -i BOPReportPublisher.rss -s http://myserver/reportserver -v reportFolder=Reports
I place my server first and pass parameter in without quotes.
I hope this helps.
Ham
|||
Thanks, Ham, for responding, but that did not work. I also tried it WITH the quotes in the order you specified, but no luck.
I'm really banging my head on this one...
Any more suggestions?
Wanda
|||Can you post your script code so we can take a look?|||Wanda,
Also note, that the parameter variables are case sensitive, I just thought I would say that.
Ham
|||Here is the trigger:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Wanda Wilburn
-- Create date: 12/15/2006
-- Description: Automatically generate SQL Reports based on completion dates entered
-- =============================================
ALTER TRIGGER [azteca].[tPostCompletionDates] ON [azteca].[WOTASK]
FOR UPDATE
AS
DECLARE @.command VARCHAR(100)
DECLARE @.task VARCHAR(20)
DECLARE @.wo VARCHAR(20)
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
--IF @.@.ROWCOUNT = 0 RETURN
IF UPDATE (actfinishdate)
Begin
SET @.task = (SELECT taskname FROM INSERTED)
SET @.wo = (SELECT workorderid FROM INSERTED)
IF @.task = 'AsBuilts Rec/Approve'
SET @.command = 'rs.exe -i C:\ReportingServices\asbuilts.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
--SET @.command = 'rs.exe -i C:\ReportingServices\asbuilts.rss -v Workorder=10610 -s http://myserver/ReportServer'
IF @.task = 'ManholeCoat Timeline'
SET @.command = 'rs.exe -i C:\ReportingServices\coatsys.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = 'CostConstrucTimeline'
SET @.command = 'rs.exe -i C:\ReportingServices\costcon.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = 'FireProtection Avail'
SET @.command = 'rs.exe -i C:\ReportingServices\firepro.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = '1-Yr Inspect Process'
SET @.command = 'rs.exe -i C:\ReportingServices\release.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = 'Sewer Complete'
SET @.command = 'rs.exe -i C:\ReportingServices\sewerap.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = 'VideoInspectTimeline'
SET @.command = 'rs.exe -i C:\ReportingServices\videoin.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
End
IF UPDATE(actstartdate)
Begin
SET @.task = (SELECT taskname FROM INSERTED)
SET @.wo = (SELECT workorderid FROM INSERTED)
IF @.task = 'Acceptance Letter'
SET @.command = 'rs.exe -i C:\ReportingServices\yr1war.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = 'Slug/Disinfect Line'
SET @.command = 'rs.exe -i C:\ReportingServices\slugln.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = '60 Days Confirmation'
SET @.command = 'rs.exe -i C:\ReportingServices\begin60.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = 'PreCon Meeting'
SET @.command = 'rs.exe -i C:\ReportingServices\precon.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
IF @.task = '1-Yr Correspondence'
SET @.command = 'rs.exe -i C:\ReportingServices\inspect.rss -v WorkOrder="' + @.wo + '" -s http://myserver/ReportServer'
End
EXEC [myserver].[master].[dbo].[xp_cmdshell] @.command
-- Insert statements for trigger here
END
(Note...once again...I have tried this from the command line of the actual report server/changing order of parameters & variables/single-double-no quotes)
The following is the code for the asbuilts.rss file...
Sub Main()
rs.Fireevent("TimedSubscription",baf15621-f564-4774-8e4e-76bd94af1f33")
End Sub
Yes, I am aware of the case-sensitivity, and I have double-triple checked this.
Thanks for all of your help...
Wanda
|||
Wanda,
I do not see the reference for the "workorder" variable in your example of "asbuilts.rss". Is this the complete code?
Ham.
|||This is it. The subscription for the report contains the variable field. The command line that gets generated from the trigger should fire the subscription with the workorder variable. The rss file is only telling which subscription to fire. Am I missing something that should be included in the rss file (i.e. parameter)?
EXEC [reportservername].[master].[dbo].[xp_cmdshell] @.command
|||Wanda,
I believe what you need is to setSubscriptionProperties
public void SetSubscriptionProperties (
string SubscriptionID,
ExtensionSettings ExtensionSettings,
string Description,
string EventType,
string MatchData,
ParameterValue[] Parameters
)
You can pass your WorkOrder value in the Parameter value and then use rs.fireevent to launch your subscription.
Ham
|||
Would this code be included in the RSS code, the trigger, or the report?
Wanda
|||Wanda,
This will be in the RSS code. I have given you a link that should tell you what you need to move forward.
http://msdn2.microsoft.com/en-us/library/aa225857(SQL.80).aspx
Ham
|||Hammer2 is correct. When you run the subscription it is using the parameter values that have been stored previously. If you want to use new parameter values you would have to call SetSubscriptionProperties first. Of course this does not guarantee that somebody else will set the parameter values after you do. There is now way to say run a subscription with these parameters.|||
Ok, I will try this, and I will let you know the results. I guess I assumed that this was being done automatically by the rs.exe and that the code existed to do this if a -v switch/data was passed in.
Thanks. Wanda
|||Can you give me an example of the call to this method?
I'm assuming you are saying that the "v" parameter that is used in the rs.exe passes the parameter to the .rss file, which, in turn, must call the SetSubscriptionProperties method using that data, correct?
I've tried to find examples but I can't find any.
Thanks! Wanda
|||Wanda,
I do not have an example on hand, I can get you a reference to a very similar process and you can modified it to your needs. Let me know if this works for you.
http://msdn2.microsoft.com/ru-ru/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listsubscriptions.aspx
Ham
Monday, March 12, 2012
RS Subscriptions not running
Hi, I'm having some problems with email subscriptions.
I've set up the subscription and schedule time but the schedule just doesn't
seem to run. It's reporting no errors, there's nothing in the log and the
subscription just looks like a new subscription that's never run.
Can anyone out there help, it would be appreaciated.
Many thanksCan you check to see if the corresponding SQL Agent job is firing and if
there are any issues? Also make sure that the ReportServer service is
running.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sandra" <Sandra@.discussions.microsoft.com> wrote in message
news:7D7C4C13-C9B6-4B15-9D6C-00DE601D15D9@.microsoft.com...
> Hi, I'm having some problems with email subscriptions.
> I've set up the subscription and schedule time but the schedule just
> doesn't
> seem to run. It's reporting no errors, there's nothing in the log and the
> subscription just looks like a new subscription that's never run.
> Can anyone out there help, it would be appreaciated.
> Many thanks|||I've checked the job and it is running correctly, the job is being inserted
into the Event table but it just doesn't move from there.|||You should check to see if the reportserver windows service is running. If
it is, check in the ReportServerService_<timestamp>.log file to see if there
are any errors indicating why the events are not being processed.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sandra" <Sandra@.discussions.microsoft.com> wrote in message
news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> I've checked the job and it is running correctly, the job is being
> inserted
> into the Event table but it just doesn't move from there.|||Sandra,
Did you ever find a solution? We're having the same issue.
"Daniel Reib [MSFT]" wrote:
> You should check to see if the reportserver windows service is running. If
> it is, check in the ReportServerService_<timestamp>.log file to see if there
> are any errors indicating why the events are not being processed.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > I've checked the job and it is running correctly, the job is being
> > inserted
> > into the Event table but it just doesn't move from there.
>
>|||The problem was in the implementation. We just used the wrong timezone for
the execution date. Therefore the schedule was always created one hour before
the intended time. After changing the timezone in the code it worked!
"daw" wrote:
> Sandra,
> Did you ever find a solution? We're having the same issue.
> "Daniel Reib [MSFT]" wrote:
> > You should check to see if the reportserver windows service is running. If
> > it is, check in the ReportServerService_<timestamp>.log file to see if there
> > are any errors indicating why the events are not being processed.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > > I've checked the job and it is running correctly, the job is being
> > > inserted
> > > into the Event table but it just doesn't move from there.
> >
> >
> >|||We have the same problem, but not related to time zone settings.
Before the subscriptions are running several month without problem.
SQL Agent is started, smtp server available. I can start the jobs direct in
SQL Agent jobs. The job is marked as successfull. No log entries where ever
possible. RS just don't start to create the report and send it. On the test
server it still works, everything is exact the same on the testsystem.
Before this occured the database log file was full. And we thought that
couses the problem. After fix this, the beheavoiour is still the same.
Has anybody a clues!
"Sandra Geisler" wrote:
> The problem was in the implementation. We just used the wrong timezone for
> the execution date. Therefore the schedule was always created one hour before
> the intended time. After changing the timezone in the code it worked!
> "daw" wrote:
> > Sandra,
> > Did you ever find a solution? We're having the same issue.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > You should check to see if the reportserver windows service is running. If
> > > it is, check in the ReportServerService_<timestamp>.log file to see if there
> > > are any errors indicating why the events are not being processed.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > >
> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > > > I've checked the job and it is running correctly, the job is being
> > > > inserted
> > > > into the Event table but it just doesn't move from there.
> > >
> > >
> > >|||Hello,
did I understand correctly, that the email subscription has the correct
start date and time, but does not start though?
"Dev Main" <DevMain@.discussions.microsoft.com> schrieb im Newsbeitrag
news:2892A909-D1A8-4FE4-B572-49B2FD36E457@.microsoft.com...
> We have the same problem, but not related to time zone settings.
> Before the subscriptions are running several month without problem.
> SQL Agent is started, smtp server available. I can start the jobs direct
> in
> SQL Agent jobs. The job is marked as successfull. No log entries where
> ever
> possible. RS just don't start to create the report and send it. On the
> test
> server it still works, everything is exact the same on the testsystem.
> Before this occured the database log file was full. And we thought that
> couses the problem. After fix this, the beheavoiour is still the same.
> Has anybody a clues!
> "Sandra Geisler" wrote:
>> The problem was in the implementation. We just used the wrong timezone
>> for
>> the execution date. Therefore the schedule was always created one hour
>> before
>> the intended time. After changing the timezone in the code it worked!
>> "daw" wrote:
>> > Sandra,
>> > Did you ever find a solution? We're having the same issue.
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> > > You should check to see if the reportserver windows service is
>> > > running. If
>> > > it is, check in the ReportServerService_<timestamp>.log file to see
>> > > if there
>> > > are any errors indicating why the events are not being processed.
>> > >
>> > > --
>> > > -Daniel
>> > > This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >
>> > >
>> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
>> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
>> > > > I've checked the job and it is running correctly, the job is being
>> > > > inserted
>> > > > into the Event table but it just doesn't move from there.
>> > >
>> > >
>> > >|||Yes! Date and time are absolut correct. I veryfied this after reading your
post.
There are no log entries. Not in Event Viewer, not in log files from
reporting services.
"Sandra Geisler" wrote:
> Hello,
> did I understand correctly, that the email subscription has the correct
> start date and time, but does not start though?
>
> "Dev Main" <DevMain@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:2892A909-D1A8-4FE4-B572-49B2FD36E457@.microsoft.com...
> > We have the same problem, but not related to time zone settings.
> >
> > Before the subscriptions are running several month without problem.
> >
> > SQL Agent is started, smtp server available. I can start the jobs direct
> > in
> > SQL Agent jobs. The job is marked as successfull. No log entries where
> > ever
> > possible. RS just don't start to create the report and send it. On the
> > test
> > server it still works, everything is exact the same on the testsystem.
> >
> > Before this occured the database log file was full. And we thought that
> > couses the problem. After fix this, the beheavoiour is still the same.
> >
> > Has anybody a clues!
> >
> > "Sandra Geisler" wrote:
> >
> >> The problem was in the implementation. We just used the wrong timezone
> >> for
> >> the execution date. Therefore the schedule was always created one hour
> >> before
> >> the intended time. After changing the timezone in the code it worked!
> >>
> >> "daw" wrote:
> >>
> >> > Sandra,
> >> > Did you ever find a solution? We're having the same issue.
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> > > You should check to see if the reportserver windows service is
> >> > > running. If
> >> > > it is, check in the ReportServerService_<timestamp>.log file to see
> >> > > if there
> >> > > are any errors indicating why the events are not being processed.
> >> > >
> >> > > --
> >> > > -Daniel
> >> > > This posting is provided "AS IS" with no warranties, and confers no
> >> > > rights.
> >> > >
> >> > >
> >> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> >> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> >> > > > I've checked the job and it is running correctly, the job is being
> >> > > > inserted
> >> > > > into the Event table but it just doesn't move from there.
> >> > >
> >> > >
> >> > >
>
>
I've set up the subscription and schedule time but the schedule just doesn't
seem to run. It's reporting no errors, there's nothing in the log and the
subscription just looks like a new subscription that's never run.
Can anyone out there help, it would be appreaciated.
Many thanksCan you check to see if the corresponding SQL Agent job is firing and if
there are any issues? Also make sure that the ReportServer service is
running.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sandra" <Sandra@.discussions.microsoft.com> wrote in message
news:7D7C4C13-C9B6-4B15-9D6C-00DE601D15D9@.microsoft.com...
> Hi, I'm having some problems with email subscriptions.
> I've set up the subscription and schedule time but the schedule just
> doesn't
> seem to run. It's reporting no errors, there's nothing in the log and the
> subscription just looks like a new subscription that's never run.
> Can anyone out there help, it would be appreaciated.
> Many thanks|||I've checked the job and it is running correctly, the job is being inserted
into the Event table but it just doesn't move from there.|||You should check to see if the reportserver windows service is running. If
it is, check in the ReportServerService_<timestamp>.log file to see if there
are any errors indicating why the events are not being processed.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sandra" <Sandra@.discussions.microsoft.com> wrote in message
news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> I've checked the job and it is running correctly, the job is being
> inserted
> into the Event table but it just doesn't move from there.|||Sandra,
Did you ever find a solution? We're having the same issue.
"Daniel Reib [MSFT]" wrote:
> You should check to see if the reportserver windows service is running. If
> it is, check in the ReportServerService_<timestamp>.log file to see if there
> are any errors indicating why the events are not being processed.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > I've checked the job and it is running correctly, the job is being
> > inserted
> > into the Event table but it just doesn't move from there.
>
>|||The problem was in the implementation. We just used the wrong timezone for
the execution date. Therefore the schedule was always created one hour before
the intended time. After changing the timezone in the code it worked!
"daw" wrote:
> Sandra,
> Did you ever find a solution? We're having the same issue.
> "Daniel Reib [MSFT]" wrote:
> > You should check to see if the reportserver windows service is running. If
> > it is, check in the ReportServerService_<timestamp>.log file to see if there
> > are any errors indicating why the events are not being processed.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > > I've checked the job and it is running correctly, the job is being
> > > inserted
> > > into the Event table but it just doesn't move from there.
> >
> >
> >|||We have the same problem, but not related to time zone settings.
Before the subscriptions are running several month without problem.
SQL Agent is started, smtp server available. I can start the jobs direct in
SQL Agent jobs. The job is marked as successfull. No log entries where ever
possible. RS just don't start to create the report and send it. On the test
server it still works, everything is exact the same on the testsystem.
Before this occured the database log file was full. And we thought that
couses the problem. After fix this, the beheavoiour is still the same.
Has anybody a clues!
"Sandra Geisler" wrote:
> The problem was in the implementation. We just used the wrong timezone for
> the execution date. Therefore the schedule was always created one hour before
> the intended time. After changing the timezone in the code it worked!
> "daw" wrote:
> > Sandra,
> > Did you ever find a solution? We're having the same issue.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> > > You should check to see if the reportserver windows service is running. If
> > > it is, check in the ReportServerService_<timestamp>.log file to see if there
> > > are any errors indicating why the events are not being processed.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no rights.
> > >
> > >
> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> > > > I've checked the job and it is running correctly, the job is being
> > > > inserted
> > > > into the Event table but it just doesn't move from there.
> > >
> > >
> > >|||Hello,
did I understand correctly, that the email subscription has the correct
start date and time, but does not start though?
"Dev Main" <DevMain@.discussions.microsoft.com> schrieb im Newsbeitrag
news:2892A909-D1A8-4FE4-B572-49B2FD36E457@.microsoft.com...
> We have the same problem, but not related to time zone settings.
> Before the subscriptions are running several month without problem.
> SQL Agent is started, smtp server available. I can start the jobs direct
> in
> SQL Agent jobs. The job is marked as successfull. No log entries where
> ever
> possible. RS just don't start to create the report and send it. On the
> test
> server it still works, everything is exact the same on the testsystem.
> Before this occured the database log file was full. And we thought that
> couses the problem. After fix this, the beheavoiour is still the same.
> Has anybody a clues!
> "Sandra Geisler" wrote:
>> The problem was in the implementation. We just used the wrong timezone
>> for
>> the execution date. Therefore the schedule was always created one hour
>> before
>> the intended time. After changing the timezone in the code it worked!
>> "daw" wrote:
>> > Sandra,
>> > Did you ever find a solution? We're having the same issue.
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> > > You should check to see if the reportserver windows service is
>> > > running. If
>> > > it is, check in the ReportServerService_<timestamp>.log file to see
>> > > if there
>> > > are any errors indicating why the events are not being processed.
>> > >
>> > > --
>> > > -Daniel
>> > > This posting is provided "AS IS" with no warranties, and confers no
>> > > rights.
>> > >
>> > >
>> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
>> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
>> > > > I've checked the job and it is running correctly, the job is being
>> > > > inserted
>> > > > into the Event table but it just doesn't move from there.
>> > >
>> > >
>> > >|||Yes! Date and time are absolut correct. I veryfied this after reading your
post.
There are no log entries. Not in Event Viewer, not in log files from
reporting services.
"Sandra Geisler" wrote:
> Hello,
> did I understand correctly, that the email subscription has the correct
> start date and time, but does not start though?
>
> "Dev Main" <DevMain@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:2892A909-D1A8-4FE4-B572-49B2FD36E457@.microsoft.com...
> > We have the same problem, but not related to time zone settings.
> >
> > Before the subscriptions are running several month without problem.
> >
> > SQL Agent is started, smtp server available. I can start the jobs direct
> > in
> > SQL Agent jobs. The job is marked as successfull. No log entries where
> > ever
> > possible. RS just don't start to create the report and send it. On the
> > test
> > server it still works, everything is exact the same on the testsystem.
> >
> > Before this occured the database log file was full. And we thought that
> > couses the problem. After fix this, the beheavoiour is still the same.
> >
> > Has anybody a clues!
> >
> > "Sandra Geisler" wrote:
> >
> >> The problem was in the implementation. We just used the wrong timezone
> >> for
> >> the execution date. Therefore the schedule was always created one hour
> >> before
> >> the intended time. After changing the timezone in the code it worked!
> >>
> >> "daw" wrote:
> >>
> >> > Sandra,
> >> > Did you ever find a solution? We're having the same issue.
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> > > You should check to see if the reportserver windows service is
> >> > > running. If
> >> > > it is, check in the ReportServerService_<timestamp>.log file to see
> >> > > if there
> >> > > are any errors indicating why the events are not being processed.
> >> > >
> >> > > --
> >> > > -Daniel
> >> > > This posting is provided "AS IS" with no warranties, and confers no
> >> > > rights.
> >> > >
> >> > >
> >> > > "Sandra" <Sandra@.discussions.microsoft.com> wrote in message
> >> > > news:EF8BDA76-B94E-493C-9FD7-378A6B3F4D24@.microsoft.com...
> >> > > > I've checked the job and it is running correctly, the job is being
> >> > > > inserted
> >> > > > into the Event table but it just doesn't move from there.
> >> > >
> >> > >
> >> > >
>
>
RS Subscription Failures
RS Subscriptions are generating the following errors for some (not all)
subscriptions:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
The only difference I can see between our working subscriptions and the non
working subscriptions are the owners of the subscriptions.
A log file I was able to find with a failed email reference is as follows.
ReportingServicesService!dbpolling!25f4!4/18/2005-02:00:13::
NotificationPolling processing 1 more items. 2 Total items in internal
queue.
ReportingServicesService!library!27e4!04/18/2005-02:00:14:: i INFO: Call to
RenderFirst( '/Production Systems' )
ReportingServicesService!library!27e4!04/18/2005-02:00:15:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!27e4!04/18/2005-02:00:15:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!27e4!04/18/2005-02:00:15:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification
notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
notification)
ReportingServicesService!notification!27e4!04/18/2005-02:00:15::
Notification 75812118-974c-4618-98b1-5327eb230d09 completed. Success:
False, Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension:
Report Server Email, Report: Production Systems, Attempt 0
ReportingServicesService!dbpolling!27e4!04/18/2005-02:00:15::
NotificationPolling finished processing item
75812118-974c-4618-98b1-5327eb230d09
ReportingServicesService!library!1ef8!04/18/2005-02:00:23:: i INFO:
Initializing SessionTimeout to '600' second(s) as specified in Server system
properties.
ReportingServicesService!library!1ef8!04/18/2005-02:00:23:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1ef8!04/18/2005-02:00:26:: Email
successfully sent to "someone@.x.com" <someone@.x.com>
ReportingServicesService!notification!1ef8!04/18/2005-02:00:26::
Notification 7f32758e-2511-4a4d-8ac2-f91c31691db7 completed. Success: True,
Status: Mail sent to someone@.x.com, DeliveryExtension: Report Server Email,
Report: Production Systems, Attempt 0
ReportingServicesService!dbpolling!1ef8!04/18/2005-02:00:26::
NotificationPolling finished processing item
7f32758e-2511-4a4d-8ac2-f91c31691db7
Any help would be greatly appreciated. Thanks!
BrentHi Brent,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood your Reporting Services' subscription
is not able to send email as you expected. If I have misunderstood your
concern, please feel free to point it out.
According to the error message, I think there might be something wrong with
your configuration file. Please compare rsreportserver.config file in your
working subscriptions machine and non working subscriptions machine. You
may also post the file here and let's check the parameter
You could refer the MSDN Online or RS BooksOnline for detailed information
Configuring a Report Server for E-Mail Delivery
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/arp_configserver_v1_4bzl.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||This is one RS Server. Subscriptions that I subscribe to work perfectly, and
have been working perfectly. Subscriptions that other users subscribe to are
failing on the same server. I've reviewed the BOL, but this appears to be
configured properly. Below is the .config file:
<Configuration>
<Dsn>removed encrypted for this post</Dsn>
<ConnectionType>Default</ConnectionType>
<LogonUser>removed encrypted for this post</LogonUser>
<LogonDomain>removed encrypted for this post</LogonDomain>
<LogonCred>removed encrypted for this post</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{6435f6bb-db14-43d3-b565-ccd72a245bd3}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://SDBMSP-CTC01/ReportServer</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smarthost.fnfinc.com</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>brent@.nospam.nospam</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
"Michael Cheng [MSFT]" wrote:
> Hi Brent,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood your Reporting Services' subscription
> is not able to send email as you expected. If I have misunderstood your
> concern, please feel free to point it out.
> According to the error message, I think there might be something wrong with
> your configuration file. Please compare rsreportserver.config file in your
> working subscriptions machine and non working subscriptions machine. You
> may also post the file here and let's check the parameter
> You could refer the MSDN Online or RS BooksOnline for detailed information
> Configuring a Report Server for E-Mail Delivery
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> /arp_configserver_v1_4bzl.asp
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Brent,
Thanks for your prompt update and sorry for my lateness!
I looked into your Reporting Services log and found the following entry
--
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
The Report Server has encountered a configuration error; more details in
the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
--
Based on my knowledge, when your Reporting Services is running under
Windows Server 2003 and your Reporting Services and SQL Server are both
running under domain user account, you should apply the hotfix in the
following KB
"The specified domain either does not exist or could not be contacted"
error message in Windows Server 2003
http://support.microsoft.com/kb/834859
You may also apply Windows Server 2003 Service Pack 1, within which, I
believe this hotfix had been included
http://www.microsoft.com/downloads/details.aspx?FamilyID=22cfc239-337c-4d81-
8354-72593b1c1f43&DisplayLang=en
NOTE that it will be a FREE/REFUND case if you only asking for hotfix.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
subscriptions:
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
The only difference I can see between our working subscriptions and the non
working subscriptions are the owners of the subscriptions.
A log file I was able to find with a failed email reference is as follows.
ReportingServicesService!dbpolling!25f4!4/18/2005-02:00:13::
NotificationPolling processing 1 more items. 2 Total items in internal
queue.
ReportingServicesService!library!27e4!04/18/2005-02:00:14:: i INFO: Call to
RenderFirst( '/Production Systems' )
ReportingServicesService!library!27e4!04/18/2005-02:00:15:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
ReportingServicesService!library!27e4!04/18/2005-02:00:15:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!27e4!04/18/2005-02:00:15:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report
Server has encountered a configuration error; more details in the log
files -->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
at
Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr
userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String
userName)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String
userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType
catItemType, Byte[] secDesc, ReportOperation rptOper)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext
reportContext, String historyID, Boolean forRendering, Guid& reportID,
Int32& executionOption, String& savedParametersXml, ReportSnapshot&
compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime&
historyDate)
at
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum
type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String
renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
message, Notification notification, SubscriptionData data)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification
notification)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
notification)
ReportingServicesService!notification!27e4!04/18/2005-02:00:15::
Notification 75812118-974c-4618-98b1-5327eb230d09 completed. Success:
False, Status: Failure sending mail: The Report Server has encountered a
configuration error; more details in the log files, DeliveryExtension:
Report Server Email, Report: Production Systems, Attempt 0
ReportingServicesService!dbpolling!27e4!04/18/2005-02:00:15::
NotificationPolling finished processing item
75812118-974c-4618-98b1-5327eb230d09
ReportingServicesService!library!1ef8!04/18/2005-02:00:23:: i INFO:
Initializing SessionTimeout to '600' second(s) as specified in Server system
properties.
ReportingServicesService!library!1ef8!04/18/2005-02:00:23:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!emailextension!1ef8!04/18/2005-02:00:26:: Email
successfully sent to "someone@.x.com" <someone@.x.com>
ReportingServicesService!notification!1ef8!04/18/2005-02:00:26::
Notification 7f32758e-2511-4a4d-8ac2-f91c31691db7 completed. Success: True,
Status: Mail sent to someone@.x.com, DeliveryExtension: Report Server Email,
Report: Production Systems, Attempt 0
ReportingServicesService!dbpolling!1ef8!04/18/2005-02:00:26::
NotificationPolling finished processing item
7f32758e-2511-4a4d-8ac2-f91c31691db7
Any help would be greatly appreciated. Thanks!
BrentHi Brent,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood your Reporting Services' subscription
is not able to send email as you expected. If I have misunderstood your
concern, please feel free to point it out.
According to the error message, I think there might be something wrong with
your configuration file. Please compare rsreportserver.config file in your
working subscriptions machine and non working subscriptions machine. You
may also post the file here and let's check the parameter
You could refer the MSDN Online or RS BooksOnline for detailed information
Configuring a Report Server for E-Mail Delivery
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
/arp_configserver_v1_4bzl.asp
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||This is one RS Server. Subscriptions that I subscribe to work perfectly, and
have been working perfectly. Subscriptions that other users subscribe to are
failing on the same server. I've reviewed the BOL, but this appears to be
configured properly. Below is the .config file:
<Configuration>
<Dsn>removed encrypted for this post</Dsn>
<ConnectionType>Default</ConnectionType>
<LogonUser>removed encrypted for this post</LogonUser>
<LogonDomain>removed encrypted for this post</LogonDomain>
<LogonCred>removed encrypted for this post</LogonCred>
<InstanceId>MSSQL.1</InstanceId>
<InstallationID>{6435f6bb-db14-43d3-b565-ccd72a245bd3}</InstallationID>
<Add Key="SecureConnectionLevel" Value="0"/>
<Add Key="InstanceName" Value="MSSQLSERVER"/>
<Add Key="ProcessRecycleOptions" Value="0"/>
<Add Key="CleanupCycleMinutes" Value="10"/>
<Add Key="SQLCommandTimeoutSeconds" Value="60"/>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DatabaseQueryTimeout" Value="120"/>
<Add Key="RunningRequestsScavengerCycle" Value="60"/>
<Add Key="RunningRequestsDbCycle" Value="60"/>
<Add Key="RunningRequestsAge" Value="30"/>
<Add Key="MaxScheduleWait" Value="5"/>
<Add Key="DisplayErrorLink" Value="true"/>
<Service>
<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<MemoryLimit>60</MemoryLimit>
<RecycleTime>720</RecycleTime>
<MaximumMemoryLimit>80</MaximumMemoryLimit>
<MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
<MaxQueueThreads>0</MaxQueueThreads>
<UrlRoot>http://SDBMSP-CTC01/ReportServer</UrlRoot>
<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>
<PolicyLevel>rssrvpolicy.config</PolicyLevel>
</Service>
<Extensions>
<Delivery>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smarthost.fnfinc.com</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>brent@.nospam.nospam</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
<Extension Name="IMAGE"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="PDF"
Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/>
<Extension Name="HTML4.0"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
<Extension Name="MHTML"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
<Extension Name="EXCEL"
Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
<Extension Name="HTMLOWC"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.HtmlOWCRenderingExtension,Microsoft.ReportingServices.HtmlRendering">
<Configuration>
<OWCConfiguration>
<OWCDownloadLocation
language="de">http://office.microsoft.com/germany/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="en">http://office.microsoft.com/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ja">http://office.microsoft.com/japan/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-chs">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="zh-cht">http://office.microsoft.com/china/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="es">http://office.microsoft.com/spain/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="ko">http://office.microsoft.com/korea/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="fr">http://office.microsoft.com/france/downloads/2002/owc10.aspx</OWCDownloadLocation>
<OWCDownloadLocation
language="it">http://office.microsoft.com/italy/downloads/2002/owc10.aspx</OWCDownloadLocation>
</OWCConfiguration>
</Configuration>
</Extension>
</Render>
<Data>
<Extension Name="SQL"
Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="OLEDB"
Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ORACLE"
Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
<Extension Name="ODBC"
Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
</Data>
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,
Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,
Microsoft.ReportingServices.Authorization"/>
</Authentication>
<EventProcessing>
<Extension Name="SnapShot Extension"
Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
<Event>
<Type>ReportHistorySnapshotCreated</Type>
</Event>
</Extension>
<Extension Name="Timed Subscription Extension"
Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
<Event>
<Type>TimedSubscription</Type>
</Event>
</Extension>
<Extension Name="Cache Update Extension"
Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
<Event>
<Type>SnapshotUpdated</Type>
</Event>
</Extension>
</EventProcessing>
</Extensions>
</Configuration>
"Michael Cheng [MSFT]" wrote:
> Hi Brent,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood your Reporting Services' subscription
> is not able to send email as you expected. If I have misunderstood your
> concern, please feel free to point it out.
> According to the error message, I think there might be something wrong with
> your configuration file. Please compare rsreportserver.config file in your
> working subscriptions machine and non working subscriptions machine. You
> may also post the file here and let's check the parameter
> You could refer the MSDN Online or RS BooksOnline for detailed information
> Configuring a Report Server for E-Mail Delivery
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm
> /arp_configserver_v1_4bzl.asp
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Brent,
Thanks for your prompt update and sorry for my lateness!
I looked into your Reporting Services log and found the following entry
--
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorEx
ception:
The Report Server has encountered a configuration error; more details in
the
log files, AuthzInitializeContextFromSid: Win32 error: 5; possible reason -
service account doesn't have rights to check domain user SIDs.;
--
Based on my knowledge, when your Reporting Services is running under
Windows Server 2003 and your Reporting Services and SQL Server are both
running under domain user account, you should apply the hotfix in the
following KB
"The specified domain either does not exist or could not be contacted"
error message in Windows Server 2003
http://support.microsoft.com/kb/834859
You may also apply Windows Server 2003 Service Pack 1, within which, I
believe this hotfix had been included
http://www.microsoft.com/downloads/details.aspx?FamilyID=22cfc239-337c-4d81-
8354-72593b1c1f43&DisplayLang=en
NOTE that it will be a FREE/REFUND case if you only asking for hotfix.
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
Saturday, February 25, 2012
RS Data Driven Subscription is out of control...
Hi - I'm hoping someone can help me with a subscription problem (SQL 2000, Reporting SErvice SP2). Created a data driven subscription and made a mistake in the parameter list. It was really long, and now I can't get the subscription to stop. I've bounced the server, but as soon as we restart RS the job starts back up again. I tried to delete the subscription, but it gives me a timeout error. I've already changed the subscription (because I didn't realize the trouble) and I'm wondering if there is a way to get rid of it. Right now, I've left RS service stopped.
Thanks,
Mary
The subscription runs via the SQL Server Agent. You should be able to stop the agent which will stop the subscriptions from running. While stopped, you should be able to delete the subscription.
Please let me know if this helps. bradsyAtmicrosoftdotcom
|||Brad - I did try that but RS would not allow me to delete the subscription. I found another post though, that explained if I deleted from the ActiveSubscriptions and Notifications tables in ReportServer db I would be able to stop it from restarting. I tried that and it worked.Thanks for your help.
m
|||
Please give me more details on the other post you used to find the answer.
Thanks
Chetan
RS Data Driven Subscription is out of control...
Hi - I'm hoping someone can help me with a subscription problem (SQL 2000, Reporting SErvice SP2). Created a data driven subscription and made a mistake in the parameter list. It was really long, and now I can't get the subscription to stop. I've bounced the server, but as soon as we restart RS the job starts back up again. I tried to delete the subscription, but it gives me a timeout error. I've already changed the subscription (because I didn't realize the trouble) and I'm wondering if there is a way to get rid of it. Right now, I've left RS service stopped.
Thanks,
Mary
The subscription runs via the SQL Server Agent. You should be able to stop the agent which will stop the subscriptions from running. While stopped, you should be able to delete the subscription.
Please let me know if this helps. bradsyAtmicrosoftdotcom
|||Brad - I did try that but RS would not allow me to delete the subscription. I found another post though, that explained if I deleted from the ActiveSubscriptions and Notifications tables in ReportServer db I would be able to stop it from restarting. I tried that and it worked.Thanks for your help.
m|||
Please give me more details on the other post you used to find the answer.
Thanks
Chetan
RS and Subscription Mail Delivery
Hi Guy,
During installation of Reporting Services we didn't completed SMTP info.
Up to now thos info are really important for subsription delivery via mail.
I found an article in Technet describing which parameter configure in
RSWebApplication.config file to activate RS SMTP Service.
The config file is an XML format and i think i wrote it wrong because, even
if i restarted everything i don't have availability of mail delivery in
subscription configuration.
Someone could help me?
Can you show me an example of your config file if you correctly setted SMTP
info during setup?
Thanks in advance for your help.
Ciao
StefanoHere is a working configuration (done after the install but that doesn't
matter). Note that I have the IP address of the server hardcoded. You should
not have to do this, you should be able to use the name. Note that most of
configurations are left blank. The IP address is the IP address of a SMTP
server that we have.
<RSEmailDPConfiguration>
<SMTPServer>123.45.6.78</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>somebody@.bogus.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:ewbUSSnaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Hi Guy,
> During installation of Reporting Services we didn't completed SMTP info.
> Up to now thos info are really important for subsription delivery via
mail.
> I found an article in Technet describing which parameter configure in
> RSWebApplication.config file to activate RS SMTP Service.
> The config file is an XML format and i think i wrote it wrong because,
even
> if i restarted everything i don't have availability of mail delivery in
> subscription configuration.
> Someone could help me?
> Can you show me an example of your config file if you correctly setted
SMTP
> info during setup?
> Thanks in advance for your help.
> Ciao
> Stefano
>|||Thanks Bruce,
But i have an additional request for you.....where i have to place those
line in the file.
My config file is actually done in this way:
<Configuration>
<UI>
<ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
rControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
ol,ReportingServicesFileShareDeliveryProvider">
<Configuration>
<FileShare>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</FileShare>
</Configuration>
</Extension>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
Thanks and Ciao
Stefano|||Did you start editing and deleting lines. Yours looks different. For
instance. I have <Delivery> and you have <DeliveryUI>
When I went in and manually modified entries for email I did not have to add
any lines, I just edited lines that were there.
Do you have your original file?
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> Thanks Bruce,
> But i have an additional request for you.....where i have to place those
> line in the file.
> My config file is actually done in this way:
> <Configuration>
> <UI>
> <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> </UI>
> <Extensions>
> <DeliveryUI>
> <Extension Name="Report Server Email"
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> rControl,ReportingServicesEmailDeliveryProvider">
> <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> <Configuration>
> <RSEmailDPConfiguration>
> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server FileShare"
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> ol,ReportingServicesFileShareDeliveryProvider">
> <Configuration>
> <FileShare>
> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> </FileShare>
> </Configuration>
> </Extension>
> </DeliveryUI>
> </Extensions>
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> <Add Key="DisplayErrorLink" Value="true"/>
> </Configuration>
> Thanks and Ciao
> Stefano
>|||Stefano is looking the wrong file. Look in the RSReportServer.config file
for the elements that Bruce was mentioning.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uCTlpxoaEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Did you start editing and deleting lines. Yours looks different. For
> instance. I have <Delivery> and you have <DeliveryUI>
> When I went in and manually modified entries for email I did not have to
add
> any lines, I just edited lines that were there.
> Do you have your original file?
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > Thanks Bruce,
> > But i have an additional request for you.....where i have to place
those
> > line in the file.
> > My config file is actually done in this way:
> >
> > <Configuration>
> > <UI>
> > <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> > </UI>
> > <Extensions>
> > <DeliveryUI>
> > <Extension Name="Report Server Email"
> >
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> > rControl,ReportingServicesEmailDeliveryProvider">
> > <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> > <Extension Name="Report Server FileShare"
> >
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> > ol,ReportingServicesFileShareDeliveryProvider">
> > <Configuration>
> > <FileShare>
> > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > </FileShare>
> > </Configuration>
> > </Extension>
> > </DeliveryUI>
> > </Extensions>
> > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> > <Add Key="DisplayErrorLink" Value="true"/>
> > </Configuration>
> >
> > Thanks and Ciao
> > Stefano
> >
> >
>|||Ahh. Great. Thanks for jumping in.
Bruce L-C
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uINrD$oaEHA.752@.TK2MSFTNGP09.phx.gbl...
> Stefano is looking the wrong file. Look in the RSReportServer.config file
> for the elements that Bruce was mentioning.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uCTlpxoaEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > Did you start editing and deleting lines. Yours looks different. For
> > instance. I have <Delivery> and you have <DeliveryUI>
> >
> > When I went in and manually modified entries for email I did not have to
> add
> > any lines, I just edited lines that were there.
> >
> > Do you have your original file?
> >
> > Bruce L-C
> >
> > "Steph" <steph@.steph.it> wrote in message
> > news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > > Thanks Bruce,
> > > But i have an additional request for you.....where i have to place
> those
> > > line in the file.
> > > My config file is actually done in this way:
> > >
> > > <Configuration>
> > > <UI>
> > > <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> > > </UI>
> > > <Extensions>
> > > <DeliveryUI>
> > > <Extension Name="Report Server Email"
> > >
> >
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> > > rControl,ReportingServicesEmailDeliveryProvider">
> > > <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> > > <Configuration>
> > > <RSEmailDPConfiguration>
> > > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > > </RSEmailDPConfiguration>
> > > </Configuration>
> > > </Extension>
> > > <Extension Name="Report Server FileShare"
> > >
> >
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> > > ol,ReportingServicesFileShareDeliveryProvider">
> > > <Configuration>
> > > <FileShare>
> > > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > > </FileShare>
> > > </Configuration>
> > > </Extension>
> > > </DeliveryUI>
> > > </Extensions>
> > > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> > > <Add Key="DisplayErrorLink" Value="true"/>
> > > </Configuration>
> > >
> > > Thanks and Ciao
> > > Stefano
> > >
> > >
> >
> >
>|||Thanks for your help.
I've done the settings and everything looks good except when you try to
confirm subscription or change the schedule i get an error telling that the
value for the field StartDateTime is not valid for this field. It's
impposible to convert string value in the requested type.
Can you help me again?
Thanks in advance!
Stefano|||Are you doing this from Report Manager? Or are you controlling the
subscription via web services. My suggestion is to first do it from Report
Manager to make sure everything is setup correctly. If this is via web
services then I can't help you, no experience with them.
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> Thanks for your help.
> I've done the settings and everything looks good except when you try to
> confirm subscription or change the schedule i get an error telling that
the
> value for the field StartDateTime is not valid for this field. It's
> impposible to convert string value in the requested type.
> Can you help me again?
> Thanks in advance!
> Stefano
>|||Hi Bruce,
I don't use web services, i do entirely from report manager.
Ciao
Stefano
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Are you doing this from Report Manager? Or are you controlling the
> subscription via web services. My suggestion is to first do it from Report
> Manager to make sure everything is setup correctly. If this is via web
> services then I can't help you, no experience with them.
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > Thanks for your help.
> > I've done the settings and everything looks good except when you try to
> > confirm subscription or change the schedule i get an error telling that
> the
> > value for the field StartDateTime is not valid for this field. It's
> > impposible to convert string value in the requested type.
> > Can you help me again?
> > Thanks in advance!
> > Stefano
> >
> >
>|||OK, I was confused. Have you tested the report standalone. This seems to me
to be a report parameter problem. Is the report parameter of date data type
(instead of string)
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:uwIP%23zzaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Hi Bruce,
> I don't use web services, i do entirely from report manager.
> Ciao
> Stefano
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> > Are you doing this from Report Manager? Or are you controlling the
> > subscription via web services. My suggestion is to first do it from
Report
> > Manager to make sure everything is setup correctly. If this is via web
> > services then I can't help you, no experience with them.
> >
> > Bruce L-C
> >
> > "Steph" <steph@.steph.it> wrote in message
> > news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > > Thanks for your help.
> > > I've done the settings and everything looks good except when you try
to
> > > confirm subscription or change the schedule i get an error telling
that
> > the
> > > value for the field StartDateTime is not valid for this field. It's
> > > impposible to convert string value in the requested type.
> > > Can you help me again?
> > > Thanks in advance!
> > > Stefano
> > >
> > >
> >
> >
>|||It doesn't have any parameter......and it works perfectly!
If can help in your problem solving, before inserting the line to activate
e-mail delivey, cliccking on scheduling to have a schedule for save the
report on disk, scheduling was working perfectly!
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23EFuri0aEHA.1644@.tk2msftngp13.phx.gbl...
> OK, I was confused. Have you tested the report standalone. This seems to
me
> to be a report parameter problem. Is the report parameter of date data
type
> (instead of string)
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:uwIP%23zzaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > Hi Bruce,
> > I don't use web services, i do entirely from report manager.
> > Ciao
> > Stefano
> >
> > "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> > > Are you doing this from Report Manager? Or are you controlling the
> > > subscription via web services. My suggestion is to first do it from
> Report
> > > Manager to make sure everything is setup correctly. If this is via web
> > > services then I can't help you, no experience with them.
> > >
> > > Bruce L-C
> > >
> > > "Steph" <steph@.steph.it> wrote in message
> > > news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > > > Thanks for your help.
> > > > I've done the settings and everything looks good except when you try
> to
> > > > confirm subscription or change the schedule i get an error telling
> that
> > > the
> > > > value for the field StartDateTime is not valid for this field. It's
> > > > impposible to convert string value in the requested type.
> > > > Can you help me again?
> > > > Thanks in advance!
> > > > Stefano
> > > >
> > > >
> > >
> > >
> >
> >
>
During installation of Reporting Services we didn't completed SMTP info.
Up to now thos info are really important for subsription delivery via mail.
I found an article in Technet describing which parameter configure in
RSWebApplication.config file to activate RS SMTP Service.
The config file is an XML format and i think i wrote it wrong because, even
if i restarted everything i don't have availability of mail delivery in
subscription configuration.
Someone could help me?
Can you show me an example of your config file if you correctly setted SMTP
info during setup?
Thanks in advance for your help.
Ciao
StefanoHere is a working configuration (done after the install but that doesn't
matter). Note that I have the IP address of the server hardcoded. You should
not have to do this, you should be able to use the name. Note that most of
configurations are left blank. The IP address is the IP address of a SMTP
server that we have.
<RSEmailDPConfiguration>
<SMTPServer>123.45.6.78</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>somebody@.bogus.com</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:ewbUSSnaEHA.2812@.TK2MSFTNGP11.phx.gbl...
> Hi Guy,
> During installation of Reporting Services we didn't completed SMTP info.
> Up to now thos info are really important for subsription delivery via
mail.
> I found an article in Technet describing which parameter configure in
> RSWebApplication.config file to activate RS SMTP Service.
> The config file is an XML format and i think i wrote it wrong because,
even
> if i restarted everything i don't have availability of mail delivery in
> subscription configuration.
> Someone could help me?
> Can you show me an example of your config file if you correctly setted
SMTP
> info during setup?
> Thanks in advance for your help.
> Ciao
> Stefano
>|||Thanks Bruce,
But i have an additional request for you.....where i have to place those
line in the file.
My config file is actually done in this way:
<Configuration>
<UI>
<ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
</UI>
<Extensions>
<DeliveryUI>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
rControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare"
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
ol,ReportingServicesFileShareDeliveryProvider">
<Configuration>
<FileShare>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</FileShare>
</Configuration>
</Extension>
</DeliveryUI>
</Extensions>
<Add Key="MaxActiveReqForOneUser" Value="20"/>
<Add Key="DisplayErrorLink" Value="true"/>
</Configuration>
Thanks and Ciao
Stefano|||Did you start editing and deleting lines. Yours looks different. For
instance. I have <Delivery> and you have <DeliveryUI>
When I went in and manually modified entries for email I did not have to add
any lines, I just edited lines that were there.
Do you have your original file?
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> Thanks Bruce,
> But i have an additional request for you.....where i have to place those
> line in the file.
> My config file is actually done in this way:
> <Configuration>
> <UI>
> <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> </UI>
> <Extensions>
> <DeliveryUI>
> <Extension Name="Report Server Email"
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> rControl,ReportingServicesEmailDeliveryProvider">
> <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> <Configuration>
> <RSEmailDPConfiguration>
> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="Report Server FileShare"
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> ol,ReportingServicesFileShareDeliveryProvider">
> <Configuration>
> <FileShare>
> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> </FileShare>
> </Configuration>
> </Extension>
> </DeliveryUI>
> </Extensions>
> <Add Key="MaxActiveReqForOneUser" Value="20"/>
> <Add Key="DisplayErrorLink" Value="true"/>
> </Configuration>
> Thanks and Ciao
> Stefano
>|||Stefano is looking the wrong file. Look in the RSReportServer.config file
for the elements that Bruce was mentioning.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uCTlpxoaEHA.1000@.TK2MSFTNGP12.phx.gbl...
> Did you start editing and deleting lines. Yours looks different. For
> instance. I have <Delivery> and you have <DeliveryUI>
> When I went in and manually modified entries for email I did not have to
add
> any lines, I just edited lines that were there.
> Do you have your original file?
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > Thanks Bruce,
> > But i have an additional request for you.....where i have to place
those
> > line in the file.
> > My config file is actually done in this way:
> >
> > <Configuration>
> > <UI>
> > <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> > </UI>
> > <Extensions>
> > <DeliveryUI>
> > <Extension Name="Report Server Email"
> >
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> > rControl,ReportingServicesEmailDeliveryProvider">
> > <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> > <Extension Name="Report Server FileShare"
> >
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> > ol,ReportingServicesFileShareDeliveryProvider">
> > <Configuration>
> > <FileShare>
> > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > </FileShare>
> > </Configuration>
> > </Extension>
> > </DeliveryUI>
> > </Extensions>
> > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> > <Add Key="DisplayErrorLink" Value="true"/>
> > </Configuration>
> >
> > Thanks and Ciao
> > Stefano
> >
> >
>|||Ahh. Great. Thanks for jumping in.
Bruce L-C
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:uINrD$oaEHA.752@.TK2MSFTNGP09.phx.gbl...
> Stefano is looking the wrong file. Look in the RSReportServer.config file
> for the elements that Bruce was mentioning.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uCTlpxoaEHA.1000@.TK2MSFTNGP12.phx.gbl...
> > Did you start editing and deleting lines. Yours looks different. For
> > instance. I have <Delivery> and you have <DeliveryUI>
> >
> > When I went in and manually modified entries for email I did not have to
> add
> > any lines, I just edited lines that were there.
> >
> > Do you have your original file?
> >
> > Bruce L-C
> >
> > "Steph" <steph@.steph.it> wrote in message
> > news:et1NN7naEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > > Thanks Bruce,
> > > But i have an additional request for you.....where i have to place
> those
> > > line in the file.
> > > My config file is actually done in this way:
> > >
> > > <Configuration>
> > > <UI>
> > > <ReportServerUrl>http://SQLLUCEPLAN/ReportServer</ReportServerUrl>
> > > </UI>
> > > <Extensions>
> > > <DeliveryUI>
> > > <Extension Name="Report Server Email"
> > >
> >
>
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProvide
> > > rControl,ReportingServicesEmailDeliveryProvider">
> > > <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
> > > <Configuration>
> > > <RSEmailDPConfiguration>
> > > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > > </RSEmailDPConfiguration>
> > > </Configuration>
> > > </Extension>
> > > <Extension Name="Report Server FileShare"
> > >
> >
>
Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIContr
> > > ol,ReportingServicesFileShareDeliveryProvider">
> > > <Configuration>
> > > <FileShare>
> > > <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
> > > </FileShare>
> > > </Configuration>
> > > </Extension>
> > > </DeliveryUI>
> > > </Extensions>
> > > <Add Key="MaxActiveReqForOneUser" Value="20"/>
> > > <Add Key="DisplayErrorLink" Value="true"/>
> > > </Configuration>
> > >
> > > Thanks and Ciao
> > > Stefano
> > >
> > >
> >
> >
>|||Thanks for your help.
I've done the settings and everything looks good except when you try to
confirm subscription or change the schedule i get an error telling that the
value for the field StartDateTime is not valid for this field. It's
impposible to convert string value in the requested type.
Can you help me again?
Thanks in advance!
Stefano|||Are you doing this from Report Manager? Or are you controlling the
subscription via web services. My suggestion is to first do it from Report
Manager to make sure everything is setup correctly. If this is via web
services then I can't help you, no experience with them.
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> Thanks for your help.
> I've done the settings and everything looks good except when you try to
> confirm subscription or change the schedule i get an error telling that
the
> value for the field StartDateTime is not valid for this field. It's
> impposible to convert string value in the requested type.
> Can you help me again?
> Thanks in advance!
> Stefano
>|||Hi Bruce,
I don't use web services, i do entirely from report manager.
Ciao
Stefano
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Are you doing this from Report Manager? Or are you controlling the
> subscription via web services. My suggestion is to first do it from Report
> Manager to make sure everything is setup correctly. If this is via web
> services then I can't help you, no experience with them.
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > Thanks for your help.
> > I've done the settings and everything looks good except when you try to
> > confirm subscription or change the schedule i get an error telling that
> the
> > value for the field StartDateTime is not valid for this field. It's
> > impposible to convert string value in the requested type.
> > Can you help me again?
> > Thanks in advance!
> > Stefano
> >
> >
>|||OK, I was confused. Have you tested the report standalone. This seems to me
to be a report parameter problem. Is the report parameter of date data type
(instead of string)
Bruce L-C
"Steph" <steph@.steph.it> wrote in message
news:uwIP%23zzaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> Hi Bruce,
> I don't use web services, i do entirely from report manager.
> Ciao
> Stefano
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> > Are you doing this from Report Manager? Or are you controlling the
> > subscription via web services. My suggestion is to first do it from
Report
> > Manager to make sure everything is setup correctly. If this is via web
> > services then I can't help you, no experience with them.
> >
> > Bruce L-C
> >
> > "Steph" <steph@.steph.it> wrote in message
> > news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > > Thanks for your help.
> > > I've done the settings and everything looks good except when you try
to
> > > confirm subscription or change the schedule i get an error telling
that
> > the
> > > value for the field StartDateTime is not valid for this field. It's
> > > impposible to convert string value in the requested type.
> > > Can you help me again?
> > > Thanks in advance!
> > > Stefano
> > >
> > >
> >
> >
>|||It doesn't have any parameter......and it works perfectly!
If can help in your problem solving, before inserting the line to activate
e-mail delivey, cliccking on scheduling to have a schedule for save the
report on disk, scheduling was working perfectly!
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23EFuri0aEHA.1644@.tk2msftngp13.phx.gbl...
> OK, I was confused. Have you tested the report standalone. This seems to
me
> to be a report parameter problem. Is the report parameter of date data
type
> (instead of string)
> Bruce L-C
> "Steph" <steph@.steph.it> wrote in message
> news:uwIP%23zzaEHA.3716@.TK2MSFTNGP11.phx.gbl...
> > Hi Bruce,
> > I don't use web services, i do entirely from report manager.
> > Ciao
> > Stefano
> >
> > "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:OzfAkrzaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> > > Are you doing this from Report Manager? Or are you controlling the
> > > subscription via web services. My suggestion is to first do it from
> Report
> > > Manager to make sure everything is setup correctly. If this is via web
> > > services then I can't help you, no experience with them.
> > >
> > > Bruce L-C
> > >
> > > "Steph" <steph@.steph.it> wrote in message
> > > news:ee$VbtxaEHA.3944@.tk2msftngp13.phx.gbl...
> > > > Thanks for your help.
> > > > I've done the settings and everything looks good except when you try
> to
> > > > confirm subscription or change the schedule i get an error telling
> that
> > > the
> > > > value for the field StartDateTime is not valid for this field. It's
> > > > impposible to convert string value in the requested type.
> > > > Can you help me again?
> > > > Thanks in advance!
> > > > Stefano
> > > >
> > > >
> > >
> > >
> >
> >
>
RS 2005: Subscription fails with Internal error
Hi all,
I have a (for me) strange problem with subscribing reports.
I've setup several reports that I want to create monthly and store to a file share.
In BIDS Preview and deployed to the report server everything works fine.
Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly.
When the time to render the reports has gone, I just see the following behind each subscription:
Failure writing file LIS04 : An internal error occurred on the report
server. See the error log for more details.
The Log file contains the following: (I highlighted what I think to be the key error)
ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!e!12/19/2006-10:20:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:21:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:22:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:23:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!17!12/19/2006-10:24:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!17!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!3!12/19/2006-10:25:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:26:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!13!12/19/2006-10:27:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:28:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:29:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:30:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM.
ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54
ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!13!12/19/2006-10:32:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
End of inner exception stack trace
ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
Does anyone have an idea what goes wrong here?
Best regards
Florian
Are you running 64 bit RS? If yes, it looks like a known problem that will be fixed in SP2.
Tuesday, February 21, 2012
RS 2005 Subscription Disabled
Hello,
I'm using SQL 2005 SP2 build 3215 x64 Enterprise (4x dualcore 8Gram)
Everything is working OK (SQL,SSIS,AS,RS) except creating data driven
subscriptions.
I have an report with an custom data source (to AS) wich is working OK.
The credentials are stored in DB, SQL Agent is working a.so.
The web services is running under NT\SYSTEM, I am connected with a
domain user which is local admin.
Report Manager web interface:
I can create "normal" subscriptions and they are working OK.
I can't create data driven subscription (there is no option to create
it). (yes, it is enterprise version, see appendix :) )
Management Studio (started on the server via Remote desktop, logged in
as a domain user in the local admin group):
Both "New Subscription" and "New Data Driven Subscription" are grayed
out (disabled).
I can see the subscription created via Report Manager but I can't access
its properties , I can only delete it.
Question:
How can I create a data driven subscription from Management Studio?
How can I get the Items (create subscription) enabled in the context menu?
What I'm doing wrong ? :)
Cheers,
Radu
APPENDIX:
select @.@.version:
Microsoft SQL Server 2005 - 9.00.3215.00 (X64) Dec 8 2007 17:58:16
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
All the components SQL, AS, RS are running on the same server.I want to add that we have made some time ago an upgrade from Standard
Edition to Enterprise Edition
Maybe something get wrong with upgrading the RS?
Radu
I'm using SQL 2005 SP2 build 3215 x64 Enterprise (4x dualcore 8Gram)
Everything is working OK (SQL,SSIS,AS,RS) except creating data driven
subscriptions.
I have an report with an custom data source (to AS) wich is working OK.
The credentials are stored in DB, SQL Agent is working a.so.
The web services is running under NT\SYSTEM, I am connected with a
domain user which is local admin.
Report Manager web interface:
I can create "normal" subscriptions and they are working OK.
I can't create data driven subscription (there is no option to create
it). (yes, it is enterprise version, see appendix :) )
Management Studio (started on the server via Remote desktop, logged in
as a domain user in the local admin group):
Both "New Subscription" and "New Data Driven Subscription" are grayed
out (disabled).
I can see the subscription created via Report Manager but I can't access
its properties , I can only delete it.
Question:
How can I create a data driven subscription from Management Studio?
How can I get the Items (create subscription) enabled in the context menu?
What I'm doing wrong ? :)
Cheers,
Radu
APPENDIX:
select @.@.version:
Microsoft SQL Server 2005 - 9.00.3215.00 (X64) Dec 8 2007 17:58:16
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition
(64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
All the components SQL, AS, RS are running on the same server.I want to add that we have made some time ago an upgrade from Standard
Edition to Enterprise Edition
Maybe something get wrong with upgrading the RS?
Radu
Subscribe to:
Posts (Atom)