embedding RS into a java (j2ee) application

Can anyone point me to some useful information on embedding reports into a
java (J2EE) application?
StephanieNot specifically but I can tell you your options. There are three ways to
integrate reports into an application: roll your own with web services, use
URL integration, use the reportviewer control that comes with VS 2005. Of
these you can use the first two. The control is a 2.0 framework control and
is of no use to you.
The easiest is URL access(search BOL for URL).
Report Manager itself uses web services (Report Manager is really just a
portal that ships with RS. It does nothing that you can't do yourself with
published web services)
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
> Can anyone point me to some useful information on embedding reports into a
> java (J2EE) application?
> Stephanie|||Thanks, Bruce. I can see how you can hide the Toolbar if you want to
(&rc:Toolbar=false). Is there a way to hide sections above the toolbar?
Basically, I want the user to only see the Toolbar and below within the app.
Perhaps the application can manage the Back button functionality?
Also, another quick question: Can you hide the report header and footer with
this sort of option or would you have to add hidden parameters to do that?
Some reports are used within the app and outside the app. When inside the
app, I do not want the report header and footer to show. I'm thinking I have
to add yet another hidden parameter.
S.
"Bruce L-C [MVP]" wrote:
> Not specifically but I can tell you your options. There are three ways to
> integrate reports into an application: roll your own with web services, use
> URL integration, use the reportviewer control that comes with VS 2005. Of
> these you can use the first two. The control is a 2.0 framework control and
> is of no use to you.
> The easiest is URL access(search BOL for URL).
> Report Manager itself uses web services (Report Manager is really just a
> portal that ships with RS. It does nothing that you can't do yourself with
> published web services)
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
> news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
> > Can anyone point me to some useful information on embedding reports into a
> > java (J2EE) application?
> >
> > Stephanie
>
>|||You can hid the parameter area too. This link shows the things you can
control for the html viewer. I tend to hide the parameter area but not the
toolbar.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsprg9/html/1c3e680a-83ea-4979-8e79-fa2337ae12a3.htm
Correct about the hidden parameter for the report header and footer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
news:DD1721F3-3164-479A-BB25-AB4218CA6E40@.microsoft.com...
> Thanks, Bruce. I can see how you can hide the Toolbar if you want to
> (&rc:Toolbar=false). Is there a way to hide sections above the toolbar?
> Basically, I want the user to only see the Toolbar and below within the
> app.
> Perhaps the application can manage the Back button functionality?
> Also, another quick question: Can you hide the report header and footer
> with
> this sort of option or would you have to add hidden parameters to do that?
> Some reports are used within the app and outside the app. When inside the
> app, I do not want the report header and footer to show. I'm thinking I
> have
> to add yet another hidden parameter.
> S.
> "Bruce L-C [MVP]" wrote:
>> Not specifically but I can tell you your options. There are three ways to
>> integrate reports into an application: roll your own with web services,
>> use
>> URL integration, use the reportviewer control that comes with VS 2005. Of
>> these you can use the first two. The control is a 2.0 framework control
>> and
>> is of no use to you.
>> The easiest is URL access(search BOL for URL).
>> Report Manager itself uses web services (Report Manager is really just a
>> portal that ships with RS. It does nothing that you can't do yourself
>> with
>> published web services)
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Stephanie" <Stephanie@.discussions.microsoft.com> wrote in message
>> news:015E15B4-EFDB-422C-917E-B6E7ECACACB5@.microsoft.com...
>> > Can anyone point me to some useful information on embedding reports
>> > into a
>> > java (J2EE) application?
>> >
>> > Stephanie
>>

Embedding reports in Winform App...

I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
application using SQL Server 2K.
Thanks everyone.Use fyiReporting component (http://www.fyireporting.com). Is open source and
read RDL files with Windows Forms Viewer component.
[]s
"Terry Mulvany" <terry.mulvany@.rouseservices.com> escreveu na mensagem
news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>application using SQL Server 2K.
> Thanks everyone.
>|||Thanks Pedro, do you or anyone else know of any similar 3rd party (pay or
open source) components that actually use the infrastructure of SQL Server
Reporting Services (i.e. ReportServer web service and it's corresponding
security) rather than just simply being able to load an RDL file and view it
as the FYIReporting stuff does.
(I know .Net 2.0 and Yukon will support this but we do not have that as an
option)
Thanks all.
-Terry
"Pedro Jr." <pedro.alvesjr@.gmail.com> wrote in message
news:epT5CvMqFHA.2776@.TK2MSFTNGP10.phx.gbl...
> Use fyiReporting component (http://www.fyireporting.com). Is open source
> and read RDL files with Windows Forms Viewer component.
> []s
>
> "Terry Mulvany" <terry.mulvany@.rouseservices.com> escreveu na mensagem
> news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>>application using SQL Server 2K.
>> Thanks everyone.
>|||You can use web services to return a stream rendered how you want and then
display that (pdf, excel, html, etc). Or you can use URL integration. Put a
IE browser control and set its URL appropriately. With .Net 2.0 where will
be a winform control which will make all of this extremely easy.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:eh4oCnMqFHA.2072@.TK2MSFTNGP14.phx.gbl...
>I am looking for options for rendering RDLs in a .Net 1.1 Windows Forms
>application using SQL Server 2K.
> Thanks everyone.
>

Embedding reporting services as a standalone product

Hi,
In the application that I am working on, we currently use Crystal Reports as
the embedded reporting engine. I am trying to evaluate if we should move
over to Microsoft Reporting Services. However, one thing confuses me. It
seems Microsoft Reporting Services will work only as a server under IIS.
This will not work for our customers. I am wondering if Reporting Services
has any embedded component much like Crystal Reports that we could use.
Thank you in advance for your help.
SunnyVersion 2 will have a web form and a winform that does not require the
server (works with the server if there but does not require it).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sansanee" <sansanee@.nospam.com> wrote in message
news:%23LD40RJ3EHA.1144@.TK2MSFTNGP09.phx.gbl...
> Hi,
> In the application that I am working on, we currently use Crystal Reports
as
> the embedded reporting engine. I am trying to evaluate if we should move
> over to Microsoft Reporting Services. However, one thing confuses me. It
> seems Microsoft Reporting Services will work only as a server under IIS.
> This will not work for our customers. I am wondering if Reporting Services
> has any embedded component much like Crystal Reports that we could use.
> Thank you in advance for your help.
> Sunny
>

Embedding plug-ins in Reports

Hi,
I am trying to figure out the way to embed a plug-in (Chime for Windows)
into my report, so that I can display a certain object from a database, that
is stored there as a string. This Chime plug-in would read the input string
and convert it to video display.
This embedding is easily done in simple HTML:
<embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
hlabels2d='terminalhetero' structure= [encrypted string from the database
follows]>
I am wondering is there a way to do such embedding straight into my report
by using the report designer features or by modifying an RDL file for my
report?
Thank you.
Anton Bagayev,
TransForm Pharmaceuticals, Inc.
29 Hartwell Avenue
Lexington, MA 02421Or even simpler, is it possible to embed an HTML in a report.
That would be an exiting idea.
Thanks in advance.
Anton.
"Anton" wrote:
> Hi,
> I am trying to figure out the way to embed a plug-in (Chime for Windows)
> into my report, so that I can display a certain object from a database, that
> is stored there as a string. This Chime plug-in would read the input string
> and convert it to video display.
> This embedding is easily done in simple HTML:
> <embed type='chemical/x-mdl-molfile' display2d=true width=200 height=200
> hlabels2d='terminalhetero' structure= [encrypted string from the database
> follows]>
> I am wondering is there a way to do such embedding straight into my report
> by using the report designer features or by modifying an RDL file for my
> report?
> Thank you.
> Anton Bagayev,
> TransForm Pharmaceuticals, Inc.
> 29 Hartwell Avenue
> Lexington, MA 02421sql

Embedding literals in RDL that will come through in HTML

I am trying to create some reports that when rendered in HTML are supposed to have some interactivity built into them. I understand that there aren't any facilities in RDL itself that would help facilitate this process for me, but is there any way to embed some literal strings that will come through in the HTML?

The items I'm trying to finesse through are <script> blocks, checkboxes, and <object> tags. When I use the designer to put these items into textboxes, they get encoded with the HTML values (&gt; instead of >, etc...) so that the code is displayed instead of interpreted.

I thought maybe there would be a VB function that I can wrap around the HTML to prevent it from being encoded so that when the report is displayed on the screen that the interactive elements are there.

Any ideas?

I think this relates to formatting text within a cell, which does not appear to be possible. Perhaps some sort of javascript which will change the innerHTML of the report document?|||

Thanks for the response.

I think that I have solved the problem for my situation. Here's what I've discovered so far:

If you use a textbox control, you can set the value of it to an HTML snippet (I'm using an object tag with some param tags as well as checkbox controls). When the report is rendered to HTML, the HTML that was embedded into the report shows as source on the page. I've taken that HTML, saved it off to a file and modified it using some .NET classes. Specifically the HTTPUtility.HtmlDecode function. That function will take the HTML file and undo all of the encoding that Reporting Services has done to your HTML. I also did a small test where I inserted a "&lt;" character somewhere else in the HTML document to simulate something that may actually occur. When I decoded the file that time, all of the encoded HTML snippets were properly decoded, and the less than sign was left alone.

If someone were rendering using the Web Service APIs for Reporting Services, this would work because you are given the stream back. In the case of using a WebForms ReportViewer though, it might be more difficult.

I hope this helps anyone who has a similar problem.

|||Sounds interesting, can you post the code or a snippet of it?
This may help MS to build as a feature in the next SP as this seems like a pretty common thing (how do I embed html/change style within a text box)|||

Hi Ken,

i'm new with sql reporting service, may i know anyway to make my report export with html format and allow me to send to customer using the ms outlook?

my report contain chart and also table, and image.

i did trying to export using mhtml, but after i send it using the email. at my desktop i able to see it. but my manager not able to read all the image and chart.

thanks for your help.

|||

Hello,

Can you please share the code or detail the approach you have taken?

Thanks

Embedding literals in RDL that will come through in HTML

I am trying to create some reports that when rendered in HTML are supposed to have some interactivity built into them. I understand that there aren't any facilities in RDL itself that would help facilitate this process for me, but is there any way to embed some literal strings that will come through in the HTML?

The items I'm trying to finesse through are <script> blocks, checkboxes, and <object> tags. When I use the designer to put these items into textboxes, they get encoded with the HTML values (&gt; instead of >, etc...) so that the code is displayed instead of interpreted.

I thought maybe there would be a VB function that I can wrap around the HTML to prevent it from being encoded so that when the report is displayed on the screen that the interactive elements are there.

Any ideas?

I think this relates to formatting text within a cell, which does not appear to be possible. Perhaps some sort of javascript which will change the innerHTML of the report document?|||

Thanks for the response.

I think that I have solved the problem for my situation. Here's what I've discovered so far:

If you use a textbox control, you can set the value of it to an HTML snippet (I'm using an object tag with some param tags as well as checkbox controls). When the report is rendered to HTML, the HTML that was embedded into the report shows as source on the page. I've taken that HTML, saved it off to a file and modified it using some .NET classes. Specifically the HTTPUtility.HtmlDecode function. That function will take the HTML file and undo all of the encoding that Reporting Services has done to your HTML. I also did a small test where I inserted a "&lt;" character somewhere else in the HTML document to simulate something that may actually occur. When I decoded the file that time, all of the encoded HTML snippets were properly decoded, and the less than sign was left alone.

If someone were rendering using the Web Service APIs for Reporting Services, this would work because you are given the stream back. In the case of using a WebForms ReportViewer though, it might be more difficult.

I hope this helps anyone who has a similar problem.

|||Sounds interesting, can you post the code or a snippet of it?
This may help MS to build as a feature in the next SP as this seems like a pretty common thing (how do I embed html/change style within a text box)|||

Hi Ken,

i'm new with sql reporting service, may i know anyway to make my report export with html format and allow me to send to customer using the ms outlook?

my report contain chart and also table, and image.

i did trying to export using mhtml, but after i send it using the email. at my desktop i able to see it. but my manager not able to read all the image and chart.

thanks for your help.

|||

Hello,

Can you please share the code or detail the approach you have taken?

Thanks

sql

Embedding literals in RDL that will come through in HTML

I am trying to create some reports that when rendered in HTML are supposed to have some interactivity built into them. I understand that there aren't any facilities in RDL itself that would help facilitate this process for me, but is there any way to embed some literal strings that will come through in the HTML?

The items I'm trying to finesse through are <script> blocks, checkboxes, and <object> tags. When I use the designer to put these items into textboxes, they get encoded with the HTML values (&gt; instead of >, etc...) so that the code is displayed instead of interpreted.

I thought maybe there would be a VB function that I can wrap around the HTML to prevent it from being encoded so that when the report is displayed on the screen that the interactive elements are there.

Any ideas?

I think this relates to formatting text within a cell, which does not appear to be possible. Perhaps some sort of javascript which will change the innerHTML of the report document?|||

Thanks for the response.

I think that I have solved the problem for my situation. Here's what I've discovered so far:

If you use a textbox control, you can set the value of it to an HTML snippet (I'm using an object tag with some param tags as well as checkbox controls). When the report is rendered to HTML, the HTML that was embedded into the report shows as source on the page. I've taken that HTML, saved it off to a file and modified it using some .NET classes. Specifically the HTTPUtility.HtmlDecode function. That function will take the HTML file and undo all of the encoding that Reporting Services has done to your HTML. I also did a small test where I inserted a "&lt;" character somewhere else in the HTML document to simulate something that may actually occur. When I decoded the file that time, all of the encoded HTML snippets were properly decoded, and the less than sign was left alone.

If someone were rendering using the Web Service APIs for Reporting Services, this would work because you are given the stream back. In the case of using a WebForms ReportViewer though, it might be more difficult.

I hope this helps anyone who has a similar problem.

|||Sounds interesting, can you post the code or a snippet of it?
This may help MS to build as a feature in the next SP as this seems like a pretty common thing (how do I embed html/change style within a text box)|||

Hi Ken,

i'm new with sql reporting service, may i know anyway to make my report export with html format and allow me to send to customer using the ms outlook?

my report contain chart and also table, and image.

i did trying to export using mhtml, but after i send it using the email. at my desktop i able to see it. but my manager not able to read all the image and chart.

thanks for your help.

|||

Hello,

Can you please share the code or detail the approach you have taken?

Thanks

embedding html

Just curious if anyone has any hints to embed HTML directly into a report. I
am doing reports that will be exported to excel when run as a subscription
and using an index (which jump to bookmarks) and page breaks to get each
report onto new tabs.
My current report, done with a different tool, has 2 "Help" tabs that are
formatted text that describe how to interpret the report. I need to
replicate this in reporting services. One problem is that textbox in RS is
way too limited in its functionality.
I could probably link out to an HTML page, but I want the new help tabs to
export to excel along with the report.
Any ideas?I can't think of a way until HTML is supported in text boxes.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"asnewbie+rs=argh" <asnewbiersargh@.discussions.microsoft.com> wrote in
message news:DDC6A10A-32BE-43BE-9296-F2B64769DEAA@.microsoft.com...
> Just curious if anyone has any hints to embed HTML directly into a report.
> I
> am doing reports that will be exported to excel when run as a subscription
> and using an index (which jump to bookmarks) and page breaks to get each
> report onto new tabs.
> My current report, done with a different tool, has 2 "Help" tabs that are
> formatted text that describe how to interpret the report. I need to
> replicate this in reporting services. One problem is that textbox in RS
> is
> way too limited in its functionality.
> I could probably link out to an HTML page, but I want the new help tabs to
> export to excel along with the report.
> Any ideas?

Embedding Dundas Chart Pro Charts in RS

This there a way to integrate the full version of Dundas Chart Pro in RS reports by using the extensibility API?
Including a URL accessed image of a Dundas Chart doesn't cut it if the rendering is to be done by PDF - my experence is showing that the image will be heavily pixelated.
TIA
JeffNot yet. I expect the Yukon version to support extensibility.
see www.sqlreportingservices.net
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"jbarts" <jbarts@.discussions.microsoft.com> wrote in message
news:A41DEF90-1E42-4C54-9C42-6191E08BA533@.microsoft.com...
> This there a way to integrate the full version of Dundas Chart Pro in RS
reports by using the extensibility API?
> Including a URL accessed image of a Dundas Chart doesn't cut it if the
rendering is to be done by PDF - my experence is showing that the image will
be heavily pixelated.
> TIA
> Jeff

Embedded Reports

hi,
do i have access to subreports '
for example: how many rows were created?
a have a tablerow with a sub report.
i want to set the visibility to hidden, if no rows were created in the
subreport...
regards
PatrickThe parent report doesn't have access to properties of the subreport.
You may want to consider setting the NoRows property on the subreport
control in the master report.
Or make the subreport control in the master report very small and then have
the subreport hide its own contents if there are no rows of data.
As a last resort, you could put a query in the master report that returns a
count of the rows of the subreport (or if you're calling the subreport
inside of a list, you would include the count as a column in your master
query) and then base the visibility on that count.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Patrick Ruhnow" <pruhnow@.dornbracht.de> wrote in message
news:uOSD0kAaEHA.556@.tk2msftngp13.phx.gbl...
> hi,
> do i have access to subreports '
> for example: how many rows were created?
> a have a tablerow with a sub report.
> i want to set the visibility to hidden, if no rows were created in the
> subreport...
>
> regards
> Patrick
>

Embedded Images ....

Hi...
How can I setup the reports so that they do not require the images to be
Embedded? Meaning, I want to pull a logo from the Images folder but it's not
letting me. I realize that I can hack the XML but when reviewing that it
appears as if the image doesn't exist just the name of the image.
Thanks!Can you provide me an example of the URL approach? I might be a little blind
but I'm not seeing it or an example in my book.
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:D9BB937B-4B6C-43E9-81EC-6BA962F61EE2@.microsoft.com...
> For your problem you can have two solutions provided by images control.
> 1. Web
> 2. project.
> In the first you can give a URL so that when ever the page gets loaded
> with
> results it pulls the image from the URL
> In the second, you can add an item of image in the project itself so that
> can be refered in the layout image control.
> I think 2nd option is best.
> Amarnath
> "Chris Marsh" wrote:
>> Hi...
>> How can I setup the reports so that they do not require the images to be
>> Embedded? Meaning, I want to pull a logo from the Images folder but it's
>> not
>> letting me. I realize that I can hack the XML but when reviewing that it
>> appears as if the image doesn't exist just the name of the image.
>> Thanks!
>>|||Actually, I have found it...thank you again.
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:es3lRNoOHHA.404@.TK2MSFTNGP02.phx.gbl...
> Can you provide me an example of the URL approach? I might be a little
> blind but I'm not seeing it or an example in my book.
>
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:D9BB937B-4B6C-43E9-81EC-6BA962F61EE2@.microsoft.com...
>> For your problem you can have two solutions provided by images control.
>> 1. Web
>> 2. project.
>> In the first you can give a URL so that when ever the page gets loaded
>> with
>> results it pulls the image from the URL
>> In the second, you can add an item of image in the project itself so that
>> can be refered in the layout image control.
>> I think 2nd option is best.
>> Amarnath
>> "Chris Marsh" wrote:
>> Hi...
>> How can I setup the reports so that they do not require the images to be
>> Embedded? Meaning, I want to pull a logo from the Images folder but it's
>> not
>> letting me. I realize that I can hack the XML but when reviewing that it
>> appears as if the image doesn't exist just the name of the image.
>> Thanks!
>>
>

Embedded Fonts anytime soon?

Hi,
Does anyone know if Microsoft is planning to support embedded fonts in the
near future?
We have been using Crystal Reports for our reporting. We are trying out
Reporting Services for the new reports and we like what we see so far, but
there is one major issue: embedded fonts.
We have lots of customers lined up that require the use of OCRA and Barcode
fonts in their pdf documents. Installing these fonts on each client machine
is not an option.
If there is no such plan to include embedded fonts in the near future, we
may have to go back to Crystal Reports.
Thanks,
George
Thanks,
GeorgeGeorge,
From what I understand, the font must be installed on the report server
itself and of course, you must have had it installed on your designer
workstation when you designed the report. Have you done a test?
As an example, we use the font Ariel Unicode to properly display our
diatrics properly - but the legal way to have this font is to install
Microsoft Word - so we now have our customers install MS Word 2003 on the
web server to get this font.
=-Chris
"george tharakan" <georgetharakan@.discussions.microsoft.com> wrote in
message news:C7373491-754E-4F4F-A277-7BF35840E4E5@.microsoft.com...
> Hi,
> Does anyone know if Microsoft is planning to support embedded fonts in the
> near future?
> We have been using Crystal Reports for our reporting. We are trying out
> Reporting Services for the new reports and we like what we see so far, but
> there is one major issue: embedded fonts.
> We have lots of customers lined up that require the use of OCRA and
> Barcode
> fonts in their pdf documents. Installing these fonts on each client
> machine
> is not an option.
> If there is no such plan to include embedded fonts in the near future, we
> may have to go back to Crystal Reports.
> Thanks,
> George
> Thanks,
> George|||Hi Chris,
I do have the font installed on the reportserver and on the designer
workstation. My reports are exported to PDF. When I view the reports on my
machine I get to see the Barcode and OCRA fonts. When I view the report on a
machine which doesnt have these fonts , the fonts just don't show up. The
issue has to do with embedding fonts with the pdf, in which case the fonts
will show up on all client machines. I know that currently RS doesnt support
embedding fonts. There were some rumours that they might consider something
in a future release. Would just like to hear from them regarding a more
specific timeframe.
If it's like in a couple of months, we could wait, else we have to do this
in crystal.
Thanks|||George - what would happen if you save that PDF file on your local machine,
then go over to the machine that doesn't have this font and open the PDF
document - does it render the PDF correctly?
=-Chris
"george tharakan" <georgetharakan@.discussions.microsoft.com> wrote in
message news:53CD3E02-4BE2-4B5A-A337-EC0D5D005739@.microsoft.com...
> Hi Chris,
> I do have the font installed on the reportserver and on the designer
> workstation. My reports are exported to PDF. When I view the reports on my
> machine I get to see the Barcode and OCRA fonts. When I view the report on
> a
> machine which doesnt have these fonts , the fonts just don't show up. The
> issue has to do with embedding fonts with the pdf, in which case the fonts
> will show up on all client machines. I know that currently RS doesnt
> support
> embedding fonts. There were some rumours that they might consider
> something
> in a future release. Would just like to hear from them regarding a more
> specific timeframe.
> If it's like in a couple of months, we could wait, else we have to do this
> in crystal.
> Thanks|||Chris,
No lucj with that either. The pdf shows correctly only on the machine that
has the font installed.
Thanks,
George

e-mailing reports and refreshing reports automatically

Hello:
I know that you can e-mail SQL Reporting Services reports. But, can the
reports be configured to refresh their data automatically and be e-mailed to
users automatically with the refreshed data?
Or, would someone have to go into SQL Reporting Services, manually refresh,
and manually e-mail the reports?
Thanks!
childofthe1980sOrdinarily, this is automatic. Unless you tell a report to pull from a
stored snapshot, it is running your queries and re-pulling the data
automatically each time the report is run...
Maybe I misunderstand your question?
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> Hello:
> I know that you can e-mail SQL Reporting Services reports. But, can the
> reports be configured to refresh their data automatically and be e-mailed
> to
> users automatically with the refreshed data?
> Or, would someone have to go into SQL Reporting Services, manually
> refresh,
> and manually e-mail the reports?
> Thanks!
> childofthe1980s|||Well, what I meant is have SQL refresh reports and e-mail the results
automatically behind the scenes without user intervention.
Thanks!
childofthe1980s
"Lisa Slater Nicholls" wrote:
> Ordinarily, this is automatic. Unless you tell a report to pull from a
> stored snapshot, it is running your queries and re-pulling the data
> automatically each time the report is run...
> Maybe I misunderstand your question?
> >L<
> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
> > Hello:
> >
> > I know that you can e-mail SQL Reporting Services reports. But, can the
> > reports be configured to refresh their data automatically and be e-mailed
> > to
> > users automatically with the refreshed data?
> >
> > Or, would someone have to go into SQL Reporting Services, manually
> > refresh,
> > and manually e-mail the reports?
> >
> > Thanks!
> >
> > childofthe1980s
>|||Then, like I said, this is the way it works <s>. You don't have to
"intervene". Unless you *told* the report to hold a static snapshot, it
*always* pulls the data live, at each subscription run instance.
>L<
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
message news:8BDC82B6-1B23-452E-A01A-4730069AEF60@.microsoft.com...
> Well, what I meant is have SQL refresh reports and e-mail the results
> automatically behind the scenes without user intervention.
> Thanks!
> childofthe1980s
> "Lisa Slater Nicholls" wrote:
>> Ordinarily, this is automatic. Unless you tell a report to pull from a
>> stored snapshot, it is running your queries and re-pulling the data
>> automatically each time the report is run...
>> Maybe I misunderstand your question?
>> >L<
>> "childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in
>> message news:1303F3AC-1430-46BB-ADF4-17FA3FE03798@.microsoft.com...
>> > Hello:
>> >
>> > I know that you can e-mail SQL Reporting Services reports. But, can
>> > the
>> > reports be configured to refresh their data automatically and be
>> > e-mailed
>> > to
>> > users automatically with the refreshed data?
>> >
>> > Or, would someone have to go into SQL Reporting Services, manually
>> > refresh,
>> > and manually e-mail the reports?
>> >
>> > Thanks!
>> >
>> > childofthe1980s
>>

Emailing Reports

Hi everyone I have a database that I am creating for another department. He emails applications to potential vendors. And I was wanting sql to do this for him. I was reading about xtended procedures XP_Sendmail, but this is the first time I have created an extended stored procedure. I need for it to email an attachment (the report)Read BOL on xp_sendmail. It's all there.sql

Emailing from the SQL 2000 server

I have a few maintenance routines created and SQL 2000 has options to email
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to emai
l
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the S
QL
> server as the account used to run SQL server to configure Outlook. If tha
t
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/...sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>

Emailing from the SQL 2000 server

I have a few maintenance routines created and SQL 2000 has options to email
the reports. Do I need to have Outlook installed on the SQL server to do
these emails.
Also, since outlook uses user profiles I assume that I must log onto the SQL
server as the account used to run SQL server to configure Outlook. If that
is the case, how can I have other administrators configure notifications
without everyone using the same account to configure the SQL server? I
loose accountability when everyone uses the same account.Hello jordan
Yes, thats true, you must install Outlook in the SQL Servers Windows
profile.
But
I use SQLDev.NET:s xp_smtp_sendmail. Its working very good.
http://www.sqldev.net
Then you can create a SQL Alert to use for DBMaint.
http://www.dbmaint.com/SmtpAlerter.asp
Have just tried the Alert, but i dont have it in production
Best Regards
/Jens
Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.|||Jordan wrote:
> I have a few maintenance routines created and SQL 2000 has options to email
> the reports. Do I need to have Outlook installed on the SQL server to do
> these emails.
> Also, since outlook uses user profiles I assume that I must log onto the SQL
> server as the account used to run SQL server to configure Outlook. If that
> is the case, how can I have other administrators configure notifications
> without everyone using the same account to configure the SQL server? I
> loose accountability when everyone uses the same account.
>
Outlook must be installed and a profile configured ONLY under the login
that the SQL services run under, not under each administrator's login.
You'll then configure the SQL Mail component to use that profile. Your
admins will continue to configure notifications as they do now.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Take a look into this URL on configuring Email.
http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html
Thanks
Hari
SQL Server MVP
"Jordan" <none@.here.com> wrote in message
news:eD1DB6rwGHA.888@.TK2MSFTNGP02.phx.gbl...
>I have a few maintenance routines created and SQL 2000 has options to email
>the reports. Do I need to have Outlook installed on the SQL server to do
>these emails.
> Also, since outlook uses user profiles I assume that I must log onto the
> SQL server as the account used to run SQL server to configure Outlook. If
> that is the case, how can I have other administrators configure
> notifications without everyone using the same account to configure the SQL
> server? I loose accountability when everyone uses the same account.
>

emailing excel and pdf not working

I can email Web Archive reports successfully. However, I cannot send reports
in Excel or PDF.
I have Acrobat Pro 6 installed.
I DO NOT have Excel 2003 installed, but I can if necessary.
Did I missing a configuration step or something?Afte a few weeks of troubleshooting I got it to work. It was totally
unrelated to RS.
"Matt Temple" <mtemple@.dslextreme.com> wrote in message
news:10djruhppn13j04@.corp.supernews.com...
> I can email Web Archive reports successfully. However, I cannot send
reports
> in Excel or PDF.
> I have Acrobat Pro 6 installed.
> I DO NOT have Excel 2003 installed, but I can if necessary.
> Did I missing a configuration step or something?
>

Emailed Reports in Blackberry

Does anyone have a way to get reports that are emailed out via the
Subscriptions service as a WebArchive to appear normally in a
Blackberry? Each element in a row in a table gets put into a new line.
It looks fine in any normal email interface, but not in a Blackberry.
e.g.
Row1Col1 Row1Col2
Row2Col1 Row2Col2
will display in the Blackberry as
Row1Col1
Row1Col2
Row2Col1
Row2Col2
There seems to be a <p> tag in the raw html in each table item.
Any help is much appreciated.On Oct 3, 4:29 pm, TGav <cara...@.gmail.com> wrote:
> Does anyone have a way to get reports that are emailed out via the
> Subscriptions service as a WebArchive to appear normally in a
> Blackberry? Each element in a row in a table gets put into a new line.
> It looks fine in any normal email interface, but not in a Blackberry.
> e.g.
> Row1Col1 Row1Col2
> Row2Col1 Row2Col2
> will display in the Blackberry as
> Row1Col1
> Row1Col2
> Row2Col1
> Row2Col2
> There seems to be a <p> tag in the raw html in each table item.
> Any help is much appreciated.
You might try changing the report format to accommodate the
Blackberry. Also, you might want to look into a different export
option and/or a different type solution that possibly is geared toward
Visual Studio on Mobile Devices. Sorry that I could not be of greater
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Email Subscriptions Problem

Hi,
We recently have troubleshoots with email subscriptions. Some reports are
correctly sent, others aren't... There are no error messages in the "state"
column of all those subscriptions, "mail sent to.." is displayed.
Everything seems correct in the log files, RS tells us that all messages
have been sent correctly. The only "strange" info line is this one before
report execution for subscription:
ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
/<report_path>, userName: <domain>\<user> not found in the database.
Another user in the newsgroup is facing the same problem:
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
For information, we are using Reporting Services SP2 on Windows Server 2K3.
Thanks in advance.
Grégory.You can try having the emails dropped to a folder instead. If all the
emails are getting correctly dropped then your SMTP server is having an
issue passing them on and you should look into that.
To get the emails to drop to a folder, set the SMTPPickupDirectory element
in the RSReportServer.config file to a folder location, then set the
SendUsing element to 1. All emails will then be placed in that folder. If
some are not being placed then the log files should state why they are not.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> Hi,
> We recently have troubleshoots with email subscriptions. Some reports are
> correctly sent, others aren't... There are no error messages in the
> "state"
> column of all those subscriptions, "mail sent to.." is displayed.
> Everything seems correct in the log files, RS tells us that all messages
> have been sent correctly. The only "strange" info line is this one before
> report execution for subscription:
> ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> /<report_path>, userName: <domain>\<user> not found in the database.
> Another user in the newsgroup is facing the same problem:
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> For information, we are using Reporting Services SP2 on Windows Server
> 2K3.
> Thanks in advance.
> Grégory.
>|||Hi Daniel,
This is a pretty interesting option! I'll try this and let you know what the
results are.
thanks for your support.
Grégory.
"Daniel Reib [MSFT]" wrote:
> You can try having the emails dropped to a folder instead. If all the
> emails are getting correctly dropped then your SMTP server is having an
> issue passing them on and you should look into that.
> To get the emails to drop to a folder, set the SMTPPickupDirectory element
> in the RSReportServer.config file to a folder location, then set the
> SendUsing element to 1. All emails will then be placed in that folder. If
> some are not being placed then the log files should state why they are not.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> > Hi,
> >
> > We recently have troubleshoots with email subscriptions. Some reports are
> > correctly sent, others aren't... There are no error messages in the
> > "state"
> > column of all those subscriptions, "mail sent to.." is displayed.
> >
> > Everything seems correct in the log files, RS tells us that all messages
> > have been sent correctly. The only "strange" info line is this one before
> > report execution for subscription:
> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> > /<report_path>, userName: <domain>\<user> not found in the database.
> >
> > Another user in the newsgroup is facing the same problem:
> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >
> > For information, we are using Reporting Services SP2 on Windows Server
> > 2K3.
> >
> > Thanks in advance.
> > Grégory.
> >
>
>|||I got the same issue, yesterday email working fine, but this morning not
working, and I try your option. Email message file .eml does droped in the
SMTPServerPickupFolder. But does it mean the issue of SMTP server passing? Is
it possible that RS fail to trigger SMTP to sending email? Thanks.
Tony
"Daniel Reib [MSFT]" wrote:
> You can try having the emails dropped to a folder instead. If all the
> emails are getting correctly dropped then your SMTP server is having an
> issue passing them on and you should look into that.
> To get the emails to drop to a folder, set the SMTPPickupDirectory element
> in the RSReportServer.config file to a folder location, then set the
> SendUsing element to 1. All emails will then be placed in that folder. If
> some are not being placed then the log files should state why they are not.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> > Hi,
> >
> > We recently have troubleshoots with email subscriptions. Some reports are
> > correctly sent, others aren't... There are no error messages in the
> > "state"
> > column of all those subscriptions, "mail sent to.." is displayed.
> >
> > Everything seems correct in the log files, RS tells us that all messages
> > have been sent correctly. The only "strange" info line is this one before
> > report execution for subscription:
> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> > /<report_path>, userName: <domain>\<user> not found in the database.
> >
> > Another user in the newsgroup is facing the same problem:
> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >
> > For information, we are using Reporting Services SP2 on Windows Server
> > 2K3.
> >
> > Thanks in advance.
> > Grégory.
> >
>
>|||If all the emails are being dropped then RS is doing everything it can to
send the emails. We use the CDO objects to generate and send the emails.
If it reports no errors then from RS everything is working. The most
reliable way to set up RS to forward emails is to have it drop the .eml
files to the local SMTP pickup directory and have this relay the emails to
your SMTP server. Using the local smtp server gives you much better retry
logic as well as more configuration options.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony" <Tony@.discussions.microsoft.com> wrote in message
news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>I got the same issue, yesterday email working fine, but this morning not
> working, and I try your option. Email message file .eml does droped in the
> SMTPServerPickupFolder. But does it mean the issue of SMTP server passing?
> Is
> it possible that RS fail to trigger SMTP to sending email? Thanks.
> Tony
> "Daniel Reib [MSFT]" wrote:
>> You can try having the emails dropped to a folder instead. If all the
>> emails are getting correctly dropped then your SMTP server is having an
>> issue passing them on and you should look into that.
>> To get the emails to drop to a folder, set the SMTPPickupDirectory
>> element
>> in the RSReportServer.config file to a folder location, then set the
>> SendUsing element to 1. All emails will then be placed in that folder.
>> If
>> some are not being placed then the log files should state why they are
>> not.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> > Hi,
>> >
>> > We recently have troubleshoots with email subscriptions. Some reports
>> > are
>> > correctly sent, others aren't... There are no error messages in the
>> > "state"
>> > column of all those subscriptions, "mail sent to.." is displayed.
>> >
>> > Everything seems correct in the log files, RS tells us that all
>> > messages
>> > have been sent correctly. The only "strange" info line is this one
>> > before
>> > report execution for subscription:
>> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
>> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
>> > /<report_path>, userName: <domain>\<user> not found in the database.
>> >
>> > Another user in the newsgroup is facing the same problem:
>> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> >
>> > For information, we are using Reporting Services SP2 on Windows Server
>> > 2K3.
>> >
>> > Thanks in advance.
>> > Grégory.
>> >
>>|||Daniel, thanks for the answer. I see.
This time I took off SMTP pickup directory and also took off SendUse=1. It
works fine. I guess that's because I restart the ReportServer service.
Yesterday, I also missed some email, I tried to delete the subscription and
create a new one, if fixed as well.
So my suggestion to Greg is, to restart service and recreate the subscription.
So far they are working fine. Hope not missing again...
"Daniel Reib [MSFT]" wrote:
> If all the emails are being dropped then RS is doing everything it can to
> send the emails. We use the CDO objects to generate and send the emails.
> If it reports no errors then from RS everything is working. The most
> reliable way to set up RS to forward emails is to have it drop the .eml
> files to the local SMTP pickup directory and have this relay the emails to
> your SMTP server. Using the local smtp server gives you much better retry
> logic as well as more configuration options.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >I got the same issue, yesterday email working fine, but this morning not
> > working, and I try your option. Email message file .eml does droped in the
> > SMTPServerPickupFolder. But does it mean the issue of SMTP server passing?
> > Is
> > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >
> > Tony
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> You can try having the emails dropped to a folder instead. If all the
> >> emails are getting correctly dropped then your SMTP server is having an
> >> issue passing them on and you should look into that.
> >>
> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> >> element
> >> in the RSReportServer.config file to a folder location, then set the
> >> SendUsing element to 1. All emails will then be placed in that folder.
> >> If
> >> some are not being placed then the log files should state why they are
> >> not.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> > Hi,
> >> >
> >> > We recently have troubleshoots with email subscriptions. Some reports
> >> > are
> >> > correctly sent, others aren't... There are no error messages in the
> >> > "state"
> >> > column of all those subscriptions, "mail sent to.." is displayed.
> >> >
> >> > Everything seems correct in the log files, RS tells us that all
> >> > messages
> >> > have been sent correctly. The only "strange" info line is this one
> >> > before
> >> > report execution for subscription:
> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> >> > /<report_path>, userName: <domain>\<user> not found in the database.
> >> >
> >> > Another user in the newsgroup is facing the same problem:
> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >
> >> > For information, we are using Reporting Services SP2 on Windows Server
> >> > 2K3.
> >> >
> >> > Thanks in advance.
> >> > Grégory.
> >> >
> >>
> >>
> >>
>
>|||Again, when I create new Email subscription for new report, this time data
driven, not working at all, not matter I re-create or restart server. On the
report manager, showing executed successfully, but I did not receive any
email... Look like Email subscription not working properly. Anybody please
help.
In the log file, I have following:
ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO: Call to
RenderFirst( '/MyQReports/POWithoutSOAgingReportByBuyer' )
ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!session!870!01/09/2006-16:36:05:: i INFO:
LoadSnapshot: Item with session: mbiqao45tcm10y45x3t0jqfv, reportPath:
/MyQReports/POWithoutSOAgingReportByBuyer, userName:
[mydomaion]\[myDomainUser] not found in the database
ReportingServicesService!cache!870!01/09/2006-16:36:05:: i INFO: Image from
cache : /MyQReports/POWithoutSOAgingReportByBuyer
ReportingServicesService!emailextension!870!01/09/2006-16:36:05:: Email
successfully sent to "tonyl@.cormine.com" <tonyl@.cormine.com>
ReportingServicesService!library!870!01/09/2006-16:36:05:: Data Driven
Notification for activation id 0ab9cb1f-4267-447a-8806-65d8be1c201f was saved.
ReportingServicesService!library!870!01/09/2006-16:36:05:: Status: Mail sent
to tonyl@.cormine.com
"Daniel Reib [MSFT]" wrote:
> If all the emails are being dropped then RS is doing everything it can to
> send the emails. We use the CDO objects to generate and send the emails.
> If it reports no errors then from RS everything is working. The most
> reliable way to set up RS to forward emails is to have it drop the .eml
> files to the local SMTP pickup directory and have this relay the emails to
> your SMTP server. Using the local smtp server gives you much better retry
> logic as well as more configuration options.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >I got the same issue, yesterday email working fine, but this morning not
> > working, and I try your option. Email message file .eml does droped in the
> > SMTPServerPickupFolder. But does it mean the issue of SMTP server passing?
> > Is
> > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >
> > Tony
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> You can try having the emails dropped to a folder instead. If all the
> >> emails are getting correctly dropped then your SMTP server is having an
> >> issue passing them on and you should look into that.
> >>
> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> >> element
> >> in the RSReportServer.config file to a folder location, then set the
> >> SendUsing element to 1. All emails will then be placed in that folder.
> >> If
> >> some are not being placed then the log files should state why they are
> >> not.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> > Hi,
> >> >
> >> > We recently have troubleshoots with email subscriptions. Some reports
> >> > are
> >> > correctly sent, others aren't... There are no error messages in the
> >> > "state"
> >> > column of all those subscriptions, "mail sent to.." is displayed.
> >> >
> >> > Everything seems correct in the log files, RS tells us that all
> >> > messages
> >> > have been sent correctly. The only "strange" info line is this one
> >> > before
> >> > report execution for subscription:
> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> >> > /<report_path>, userName: <domain>\<user> not found in the database.
> >> >
> >> > Another user in the newsgroup is facing the same problem:
> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >
> >> > For information, we are using Reporting Services SP2 on Windows Server
> >> > 2K3.
> >> >
> >> > Thanks in advance.
> >> > Grégory.
> >> >
> >>
> >>
> >>
>
>|||Can you look in the ReportServerService_<timestamp>.log file? This should
have info about the subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony" <Tony@.discussions.microsoft.com> wrote in message
news:77031B41-7C47-4E47-B53A-A6E8AE1DB71D@.microsoft.com...
> Again, when I create new Email subscription for new report, this time data
> driven, not working at all, not matter I re-create or restart server. On
> the
> report manager, showing executed successfully, but I did not receive any
> email... Look like Email subscription not working properly. Anybody please
> help.
> In the log file, I have following:
> ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO: Call to
> RenderFirst( '/MyQReports/POWithoutSOAgingReportByBuyer' )
> ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO:
> Initializing EnableExecutionLogging to 'True' as specified in Server
> system
> properties.
> ReportingServicesService!session!870!01/09/2006-16:36:05:: i INFO:
> LoadSnapshot: Item with session: mbiqao45tcm10y45x3t0jqfv, reportPath:
> /MyQReports/POWithoutSOAgingReportByBuyer, userName:
> [mydomaion]\[myDomainUser] not found in the database
> ReportingServicesService!cache!870!01/09/2006-16:36:05:: i INFO: Image
> from
> cache : /MyQReports/POWithoutSOAgingReportByBuyer
> ReportingServicesService!emailextension!870!01/09/2006-16:36:05:: Email
> successfully sent to "tonyl@.cormine.com" <tonyl@.cormine.com>
> ReportingServicesService!library!870!01/09/2006-16:36:05:: Data Driven
> Notification for activation id 0ab9cb1f-4267-447a-8806-65d8be1c201f was
> saved.
> ReportingServicesService!library!870!01/09/2006-16:36:05:: Status: Mail
> sent
> to tonyl@.cormine.com
>
> "Daniel Reib [MSFT]" wrote:
>> If all the emails are being dropped then RS is doing everything it can to
>> send the emails. We use the CDO objects to generate and send the emails.
>> If it reports no errors then from RS everything is working. The most
>> reliable way to set up RS to forward emails is to have it drop the .eml
>> files to the local SMTP pickup directory and have this relay the emails
>> to
>> your SMTP server. Using the local smtp server gives you much better
>> retry
>> logic as well as more configuration options.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>> >I got the same issue, yesterday email working fine, but this morning not
>> > working, and I try your option. Email message file .eml does droped in
>> > the
>> > SMTPServerPickupFolder. But does it mean the issue of SMTP server
>> > passing?
>> > Is
>> > it possible that RS fail to trigger SMTP to sending email? Thanks.
>> >
>> > Tony
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> You can try having the emails dropped to a folder instead. If all the
>> >> emails are getting correctly dropped then your SMTP server is having
>> >> an
>> >> issue passing them on and you should look into that.
>> >>
>> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
>> >> element
>> >> in the RSReportServer.config file to a folder location, then set the
>> >> SendUsing element to 1. All emails will then be placed in that
>> >> folder.
>> >> If
>> >> some are not being placed then the log files should state why they are
>> >> not.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > We recently have troubleshoots with email subscriptions. Some
>> >> > reports
>> >> > are
>> >> > correctly sent, others aren't... There are no error messages in the
>> >> > "state"
>> >> > column of all those subscriptions, "mail sent to.." is displayed.
>> >> >
>> >> > Everything seems correct in the log files, RS tells us that all
>> >> > messages
>> >> > have been sent correctly. The only "strange" info line is this one
>> >> > before
>> >> > report execution for subscription:
>> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
>> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
>> >> > reportPath:
>> >> > /<report_path>, userName: <domain>\<user> not found in the database.
>> >> >
>> >> > Another user in the newsgroup is facing the same problem:
>> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> >> >
>> >> > For information, we are using Reporting Services SP2 on Windows
>> >> > Server
>> >> > 2K3.
>> >> >
>> >> > Thanks in advance.
>> >> > Grégory.
>> >> >
>> >>
>> >>
>> >>
>>|||Below copied logs was from the ReportServerService_<timestamp>.log file. It
tells userName:
> > [mydomaion]\[myDomainUser] not found in the database, but following with email sent successfully. I have no idea how to check it out.
We are using exchange server, last time I check the sentbox of the service
account, it has non email relating to RS email, event some of them I received.
Thanks.
Tony
"Daniel Reib [MSFT]" wrote:
> Can you look in the ReportServerService_<timestamp>.log file? This should
> have info about the subscriptions.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> news:77031B41-7C47-4E47-B53A-A6E8AE1DB71D@.microsoft.com...
> > Again, when I create new Email subscription for new report, this time data
> > driven, not working at all, not matter I re-create or restart server. On
> > the
> > report manager, showing executed successfully, but I did not receive any
> > email... Look like Email subscription not working properly. Anybody please
> > help.
> > In the log file, I have following:
> > ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO: Call to
> > RenderFirst( '/MyQReports/POWithoutSOAgingReportByBuyer' )
> > ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO:
> > Initializing EnableExecutionLogging to 'True' as specified in Server
> > system
> > properties.
> > ReportingServicesService!session!870!01/09/2006-16:36:05:: i INFO:
> > LoadSnapshot: Item with session: mbiqao45tcm10y45x3t0jqfv, reportPath:
> > /MyQReports/POWithoutSOAgingReportByBuyer, userName:
> > [mydomaion]\[myDomainUser] not found in the database
> > ReportingServicesService!cache!870!01/09/2006-16:36:05:: i INFO: Image
> > from
> > cache : /MyQReports/POWithoutSOAgingReportByBuyer
> > ReportingServicesService!emailextension!870!01/09/2006-16:36:05:: Email
> > successfully sent to "tonyl@.cormine.com" <tonyl@.cormine.com>
> > ReportingServicesService!library!870!01/09/2006-16:36:05:: Data Driven
> > Notification for activation id 0ab9cb1f-4267-447a-8806-65d8be1c201f was
> > saved.
> > ReportingServicesService!library!870!01/09/2006-16:36:05:: Status: Mail
> > sent
> > to tonyl@.cormine.com
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> If all the emails are being dropped then RS is doing everything it can to
> >> send the emails. We use the CDO objects to generate and send the emails.
> >> If it reports no errors then from RS everything is working. The most
> >> reliable way to set up RS to forward emails is to have it drop the .eml
> >> files to the local SMTP pickup directory and have this relay the emails
> >> to
> >> your SMTP server. Using the local smtp server gives you much better
> >> retry
> >> logic as well as more configuration options.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> >I got the same issue, yesterday email working fine, but this morning not
> >> > working, and I try your option. Email message file .eml does droped in
> >> > the
> >> > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> > passing?
> >> > Is
> >> > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> >
> >> > Tony
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> You can try having the emails dropped to a folder instead. If all the
> >> >> emails are getting correctly dropped then your SMTP server is having
> >> >> an
> >> >> issue passing them on and you should look into that.
> >> >>
> >> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> >> >> element
> >> >> in the RSReportServer.config file to a folder location, then set the
> >> >> SendUsing element to 1. All emails will then be placed in that
> >> >> folder.
> >> >> If
> >> >> some are not being placed then the log files should state why they are
> >> >> not.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> >> > Hi,
> >> >> >
> >> >> > We recently have troubleshoots with email subscriptions. Some
> >> >> > reports
> >> >> > are
> >> >> > correctly sent, others aren't... There are no error messages in the
> >> >> > "state"
> >> >> > column of all those subscriptions, "mail sent to.." is displayed.
> >> >> >
> >> >> > Everything seems correct in the log files, RS tells us that all
> >> >> > messages
> >> >> > have been sent correctly. The only "strange" info line is this one
> >> >> > before
> >> >> > report execution for subscription:
> >> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> >> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> >> > reportPath:
> >> >> > /<report_path>, userName: <domain>\<user> not found in the database.
> >> >> >
> >> >> > Another user in the newsgroup is facing the same problem:
> >> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >> >
> >> >> > For information, we are using Reporting Services SP2 on Windows
> >> >> > Server
> >> >> > 2K3.
> >> >> >
> >> >> > Thanks in advance.
> >> >> > Grégory.
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Hi Tony and Daniel,
Well... After restarting ReportServer service, everything worked well during
2 days... and this morning the problem was back again!
I've tried to change SMTP Pickup Directory and SendUsing options, but since
we have to restart service for changes to take effect , it's always working
after that and eml files are created in the directory.
Mails are correctly sent too when i restart ReportServer, so the best way
would be to test the first option during some days.. But since the server is
our production server, it's impossible.
Is there a way to have messages dropped in the directory and sent via SMTP
in the meantime.
Thanx in advance.
Grégory.
"Tony" wrote:
> Daniel, thanks for the answer. I see.
> This time I took off SMTP pickup directory and also took off SendUse=1. It
> works fine. I guess that's because I restart the ReportServer service.
> Yesterday, I also missed some email, I tried to delete the subscription and
> create a new one, if fixed as well.
> So my suggestion to Greg is, to restart service and recreate the subscription.
> So far they are working fine. Hope not missing again...
> "Daniel Reib [MSFT]" wrote:
> > If all the emails are being dropped then RS is doing everything it can to
> > send the emails. We use the CDO objects to generate and send the emails.
> > If it reports no errors then from RS everything is working. The most
> > reliable way to set up RS to forward emails is to have it drop the .eml
> > files to the local SMTP pickup directory and have this relay the emails to
> > your SMTP server. Using the local smtp server gives you much better retry
> > logic as well as more configuration options.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> > >I got the same issue, yesterday email working fine, but this morning not
> > > working, and I try your option. Email message file .eml does droped in the
> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server passing?
> > > Is
> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> > >
> > > Tony
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > >> You can try having the emails dropped to a folder instead. If all the
> > >> emails are getting correctly dropped then your SMTP server is having an
> > >> issue passing them on and you should look into that.
> > >>
> > >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> > >> element
> > >> in the RSReportServer.config file to a folder location, then set the
> > >> SendUsing element to 1. All emails will then be placed in that folder.
> > >> If
> > >> some are not being placed then the log files should state why they are
> > >> not.
> > >>
> > >> --
> > >> -Daniel
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> > >> > Hi,
> > >> >
> > >> > We recently have troubleshoots with email subscriptions. Some reports
> > >> > are
> > >> > correctly sent, others aren't... There are no error messages in the
> > >> > "state"
> > >> > column of all those subscriptions, "mail sent to.." is displayed.
> > >> >
> > >> > Everything seems correct in the log files, RS tells us that all
> > >> > messages
> > >> > have been sent correctly. The only "strange" info line is this one
> > >> > before
> > >> > report execution for subscription:
> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> > >> > /<report_path>, userName: <domain>\<user> not found in the database.
> > >> >
> > >> > Another user in the newsgroup is facing the same problem:
> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> > >> >
> > >> > For information, we are using Reporting Services SP2 on Windows Server
> > >> > 2K3.
> > >> >
> > >> > Thanks in advance.
> > >> > Grégory.
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >|||Yes, this is the most reliable way to send emails from RS. To do this you
must have the local SMTP server installed. You then configure the SMTP
server to relay the messages, then configure RS to drop the eml files to the
SMTP server's pickup directory.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> Hi Tony and Daniel,
> Well... After restarting ReportServer service, everything worked well
> during
> 2 days... and this morning the problem was back again!
> I've tried to change SMTP Pickup Directory and SendUsing options, but
> since
> we have to restart service for changes to take effect , it's always
> working
> after that and eml files are created in the directory.
> Mails are correctly sent too when i restart ReportServer, so the best way
> would be to test the first option during some days.. But since the server
> is
> our production server, it's impossible.
> Is there a way to have messages dropped in the directory and sent via SMTP
> in the meantime.
> Thanx in advance.
> Grégory.
> "Tony" wrote:
>> Daniel, thanks for the answer. I see.
>> This time I took off SMTP pickup directory and also took off SendUse=1.
>> It
>> works fine. I guess that's because I restart the ReportServer service.
>> Yesterday, I also missed some email, I tried to delete the subscription
>> and
>> create a new one, if fixed as well.
>> So my suggestion to Greg is, to restart service and recreate the
>> subscription.
>> So far they are working fine. Hope not missing again...
>> "Daniel Reib [MSFT]" wrote:
>> > If all the emails are being dropped then RS is doing everything it can
>> > to
>> > send the emails. We use the CDO objects to generate and send the
>> > emails.
>> > If it reports no errors then from RS everything is working. The most
>> > reliable way to set up RS to forward emails is to have it drop the .eml
>> > files to the local SMTP pickup directory and have this relay the emails
>> > to
>> > your SMTP server. Using the local smtp server gives you much better
>> > retry
>> > logic as well as more configuration options.
>> >
>> > --
>> > -Daniel
>> > This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >
>> >
>> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>> > >I got the same issue, yesterday email working fine, but this morning
>> > >not
>> > > working, and I try your option. Email message file .eml does droped
>> > > in the
>> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
>> > > passing?
>> > > Is
>> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
>> > >
>> > > Tony
>> > >
>> > > "Daniel Reib [MSFT]" wrote:
>> > >
>> > >> You can try having the emails dropped to a folder instead. If all
>> > >> the
>> > >> emails are getting correctly dropped then your SMTP server is having
>> > >> an
>> > >> issue passing them on and you should look into that.
>> > >>
>> > >> To get the emails to drop to a folder, set the SMTPPickupDirectory
>> > >> element
>> > >> in the RSReportServer.config file to a folder location, then set the
>> > >> SendUsing element to 1. All emails will then be placed in that
>> > >> folder.
>> > >> If
>> > >> some are not being placed then the log files should state why they
>> > >> are
>> > >> not.
>> > >>
>> > >> --
>> > >> -Daniel
>> > >> This posting is provided "AS IS" with no warranties, and confers no
>> > >> rights.
>> > >>
>> > >>
>> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> > >> > Hi,
>> > >> >
>> > >> > We recently have troubleshoots with email subscriptions. Some
>> > >> > reports
>> > >> > are
>> > >> > correctly sent, others aren't... There are no error messages in
>> > >> > the
>> > >> > "state"
>> > >> > column of all those subscriptions, "mail sent to.." is displayed.
>> > >> >
>> > >> > Everything seems correct in the log files, RS tells us that all
>> > >> > messages
>> > >> > have been sent correctly. The only "strange" info line is this one
>> > >> > before
>> > >> > report execution for subscription:
>> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
>> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
>> > >> > reportPath:
>> > >> > /<report_path>, userName: <domain>\<user> not found in the
>> > >> > database.
>> > >> >
>> > >> > Another user in the newsgroup is facing the same problem:
>> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> > >> >
>> > >> > For information, we are using Reporting Services SP2 on Windows
>> > >> > Server
>> > >> > 2K3.
>> > >> >
>> > >> > Thanks in advance.
>> > >> > Grégory.
>> > >> >
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >|||I'm not sure what the issue could be. From the RS side, it has completed
the mailing successfully. I'm not sure why you are not receiving the
emails.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tony" <Tony@.discussions.microsoft.com> wrote in message
news:1D7BBD81-0405-4948-B096-E259B302D8DC@.microsoft.com...
> Below copied logs was from the ReportServerService_<timestamp>.log file.
> It
> tells userName:
>> > [mydomaion]\[myDomainUser] not found in the database, but following
>> > with email sent successfully. I have no idea how to check it out.
> We are using exchange server, last time I check the sentbox of the service
> account, it has non email relating to RS email, event some of them I
> received.
> Thanks.
> Tony
> "Daniel Reib [MSFT]" wrote:
>> Can you look in the ReportServerService_<timestamp>.log file? This
>> should
>> have info about the subscriptions.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> news:77031B41-7C47-4E47-B53A-A6E8AE1DB71D@.microsoft.com...
>> > Again, when I create new Email subscription for new report, this time
>> > data
>> > driven, not working at all, not matter I re-create or restart server.
>> > On
>> > the
>> > report manager, showing executed successfully, but I did not receive
>> > any
>> > email... Look like Email subscription not working properly. Anybody
>> > please
>> > help.
>> > In the log file, I have following:
>> > ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO: Call
>> > to
>> > RenderFirst( '/MyQReports/POWithoutSOAgingReportByBuyer' )
>> > ReportingServicesService!library!870!01/09/2006-16:36:05:: i INFO:
>> > Initializing EnableExecutionLogging to 'True' as specified in Server
>> > system
>> > properties.
>> > ReportingServicesService!session!870!01/09/2006-16:36:05:: i INFO:
>> > LoadSnapshot: Item with session: mbiqao45tcm10y45x3t0jqfv, reportPath:
>> > /MyQReports/POWithoutSOAgingReportByBuyer, userName:
>> > [mydomaion]\[myDomainUser] not found in the database
>> > ReportingServicesService!cache!870!01/09/2006-16:36:05:: i INFO: Image
>> > from
>> > cache : /MyQReports/POWithoutSOAgingReportByBuyer
>> > ReportingServicesService!emailextension!870!01/09/2006-16:36:05:: Email
>> > successfully sent to "tonyl@.cormine.com" <tonyl@.cormine.com>
>> > ReportingServicesService!library!870!01/09/2006-16:36:05:: Data Driven
>> > Notification for activation id 0ab9cb1f-4267-447a-8806-65d8be1c201f was
>> > saved.
>> > ReportingServicesService!library!870!01/09/2006-16:36:05:: Status: Mail
>> > sent
>> > to tonyl@.cormine.com
>> >
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> If all the emails are being dropped then RS is doing everything it can
>> >> to
>> >> send the emails. We use the CDO objects to generate and send the
>> >> emails.
>> >> If it reports no errors then from RS everything is working. The most
>> >> reliable way to set up RS to forward emails is to have it drop the
>> >> .eml
>> >> files to the local SMTP pickup directory and have this relay the
>> >> emails
>> >> to
>> >> your SMTP server. Using the local smtp server gives you much better
>> >> retry
>> >> logic as well as more configuration options.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> >> news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>> >> >I got the same issue, yesterday email working fine, but this morning
>> >> >not
>> >> > working, and I try your option. Email message file .eml does droped
>> >> > in
>> >> > the
>> >> > SMTPServerPickupFolder. But does it mean the issue of SMTP server
>> >> > passing?
>> >> > Is
>> >> > it possible that RS fail to trigger SMTP to sending email? Thanks.
>> >> >
>> >> > Tony
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> You can try having the emails dropped to a folder instead. If all
>> >> >> the
>> >> >> emails are getting correctly dropped then your SMTP server is
>> >> >> having
>> >> >> an
>> >> >> issue passing them on and you should look into that.
>> >> >>
>> >> >> To get the emails to drop to a folder, set the SMTPPickupDirectory
>> >> >> element
>> >> >> in the RSReportServer.config file to a folder location, then set
>> >> >> the
>> >> >> SendUsing element to 1. All emails will then be placed in that
>> >> >> folder.
>> >> >> If
>> >> >> some are not being placed then the log files should state why they
>> >> >> are
>> >> >> not.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> >> >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> >> >> > Hi,
>> >> >> >
>> >> >> > We recently have troubleshoots with email subscriptions. Some
>> >> >> > reports
>> >> >> > are
>> >> >> > correctly sent, others aren't... There are no error messages in
>> >> >> > the
>> >> >> > "state"
>> >> >> > column of all those subscriptions, "mail sent to.." is displayed.
>> >> >> >
>> >> >> > Everything seems correct in the log files, RS tells us that all
>> >> >> > messages
>> >> >> > have been sent correctly. The only "strange" info line is this
>> >> >> > one
>> >> >> > before
>> >> >> > report execution for subscription:
>> >> >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
>> >> >> > INFO:
>> >> >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
>> >> >> > reportPath:
>> >> >> > /<report_path>, userName: <domain>\<user> not found in the
>> >> >> > database.
>> >> >> >
>> >> >> > Another user in the newsgroup is facing the same problem:
>> >> >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> >> >> >
>> >> >> > For information, we are using Reporting Services SP2 on Windows
>> >> >> > Server
>> >> >> > 2K3.
>> >> >> >
>> >> >> > Thanks in advance.
>> >> >> > Grégory.
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Hi,
I've got some news!
I've made some test with the AntiVirus protection on the server... and guess
what... when I stop the antivirus, subscriptions on a particular problematic
report are working ... when I start it again, mails aren't sent.
We are actually using Symantec AntiVirus 10, this version has been installed
mid-december. Is there any incomatibility beetween this progam and Reporting
Services ?
Once again Daniel, thanks for your support.
Grégory.
"Daniel Reib [MSFT]" wrote:
> Yes, this is the most reliable way to send emails from RS. To do this you
> must have the local SMTP server installed. You then configure the SMTP
> server to relay the messages, then configure RS to drop the eml files to the
> SMTP server's pickup directory.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> > Hi Tony and Daniel,
> >
> > Well... After restarting ReportServer service, everything worked well
> > during
> > 2 days... and this morning the problem was back again!
> >
> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> > since
> > we have to restart service for changes to take effect , it's always
> > working
> > after that and eml files are created in the directory.
> > Mails are correctly sent too when i restart ReportServer, so the best way
> > would be to test the first option during some days.. But since the server
> > is
> > our production server, it's impossible.
> >
> > Is there a way to have messages dropped in the directory and sent via SMTP
> > in the meantime.
> >
> > Thanx in advance.
> > Grégory.
> >
> > "Tony" wrote:
> >
> >> Daniel, thanks for the answer. I see.
> >> This time I took off SMTP pickup directory and also took off SendUse=1.
> >> It
> >> works fine. I guess that's because I restart the ReportServer service.
> >> Yesterday, I also missed some email, I tried to delete the subscription
> >> and
> >> create a new one, if fixed as well.
> >> So my suggestion to Greg is, to restart service and recreate the
> >> subscription.
> >> So far they are working fine. Hope not missing again...
> >>
> >> "Daniel Reib [MSFT]" wrote:
> >>
> >> > If all the emails are being dropped then RS is doing everything it can
> >> > to
> >> > send the emails. We use the CDO objects to generate and send the
> >> > emails.
> >> > If it reports no errors then from RS everything is working. The most
> >> > reliable way to set up RS to forward emails is to have it drop the .eml
> >> > files to the local SMTP pickup directory and have this relay the emails
> >> > to
> >> > your SMTP server. Using the local smtp server gives you much better
> >> > retry
> >> > logic as well as more configuration options.
> >> >
> >> > --
> >> > -Daniel
> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> > rights.
> >> >
> >> >
> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> > >I got the same issue, yesterday email working fine, but this morning
> >> > >not
> >> > > working, and I try your option. Email message file .eml does droped
> >> > > in the
> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> > > passing?
> >> > > Is
> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> > >
> >> > > Tony
> >> > >
> >> > > "Daniel Reib [MSFT]" wrote:
> >> > >
> >> > >> You can try having the emails dropped to a folder instead. If all
> >> > >> the
> >> > >> emails are getting correctly dropped then your SMTP server is having
> >> > >> an
> >> > >> issue passing them on and you should look into that.
> >> > >>
> >> > >> To get the emails to drop to a folder, set the SMTPPickupDirectory
> >> > >> element
> >> > >> in the RSReportServer.config file to a folder location, then set the
> >> > >> SendUsing element to 1. All emails will then be placed in that
> >> > >> folder.
> >> > >> If
> >> > >> some are not being placed then the log files should state why they
> >> > >> are
> >> > >> not.
> >> > >>
> >> > >> --
> >> > >> -Daniel
> >> > >> This posting is provided "AS IS" with no warranties, and confers no
> >> > >> rights.
> >> > >>
> >> > >>
> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> > >> > Hi,
> >> > >> >
> >> > >> > We recently have troubleshoots with email subscriptions. Some
> >> > >> > reports
> >> > >> > are
> >> > >> > correctly sent, others aren't... There are no error messages in
> >> > >> > the
> >> > >> > "state"
> >> > >> > column of all those subscriptions, "mail sent to.." is displayed.
> >> > >> >
> >> > >> > Everything seems correct in the log files, RS tells us that all
> >> > >> > messages
> >> > >> > have been sent correctly. The only "strange" info line is this one
> >> > >> > before
> >> > >> > report execution for subscription:
> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> > >> > reportPath:
> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> >> > >> > database.
> >> > >> >
> >> > >> > Another user in the newsgroup is facing the same problem:
> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> > >> >
> >> > >> > For information, we are using Reporting Services SP2 on Windows
> >> > >> > Server
> >> > >> > 2K3.
> >> > >> >
> >> > >> > Thanks in advance.
> >> > >> > Grégory.
> >> > >> >
> >> > >>
> >> > >>
> >> > >>
> >> >
> >> >
> >> >
>
>|||I have not heard of this kind of issue before. Is this when the emails are
being dropped to a folder or sent directly to the SMTP server? Does it
repro if you leave the antivirus on and don't scan the RSTempFiles
directory? Are you excluding the ASP.Net temporary files directory?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> Hi,
> I've got some news!
> I've made some test with the AntiVirus protection on the server... and
> guess
> what... when I stop the antivirus, subscriptions on a particular
> problematic
> report are working ... when I start it again, mails aren't sent.
> We are actually using Symantec AntiVirus 10, this version has been
> installed
> mid-december. Is there any incomatibility beetween this progam and
> Reporting
> Services ?
> Once again Daniel, thanks for your support.
> Grégory.
> "Daniel Reib [MSFT]" wrote:
>> Yes, this is the most reliable way to send emails from RS. To do this
>> you
>> must have the local SMTP server installed. You then configure the SMTP
>> server to relay the messages, then configure RS to drop the eml files to
>> the
>> SMTP server's pickup directory.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
>> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
>> > Hi Tony and Daniel,
>> >
>> > Well... After restarting ReportServer service, everything worked well
>> > during
>> > 2 days... and this morning the problem was back again!
>> >
>> > I've tried to change SMTP Pickup Directory and SendUsing options, but
>> > since
>> > we have to restart service for changes to take effect , it's always
>> > working
>> > after that and eml files are created in the directory.
>> > Mails are correctly sent too when i restart ReportServer, so the best
>> > way
>> > would be to test the first option during some days.. But since the
>> > server
>> > is
>> > our production server, it's impossible.
>> >
>> > Is there a way to have messages dropped in the directory and sent via
>> > SMTP
>> > in the meantime.
>> >
>> > Thanx in advance.
>> > Grégory.
>> >
>> > "Tony" wrote:
>> >
>> >> Daniel, thanks for the answer. I see.
>> >> This time I took off SMTP pickup directory and also took off
>> >> SendUse=1.
>> >> It
>> >> works fine. I guess that's because I restart the ReportServer service.
>> >> Yesterday, I also missed some email, I tried to delete the
>> >> subscription
>> >> and
>> >> create a new one, if fixed as well.
>> >> So my suggestion to Greg is, to restart service and recreate the
>> >> subscription.
>> >> So far they are working fine. Hope not missing again...
>> >>
>> >> "Daniel Reib [MSFT]" wrote:
>> >>
>> >> > If all the emails are being dropped then RS is doing everything it
>> >> > can
>> >> > to
>> >> > send the emails. We use the CDO objects to generate and send the
>> >> > emails.
>> >> > If it reports no errors then from RS everything is working. The
>> >> > most
>> >> > reliable way to set up RS to forward emails is to have it drop the
>> >> > .eml
>> >> > files to the local SMTP pickup directory and have this relay the
>> >> > emails
>> >> > to
>> >> > your SMTP server. Using the local smtp server gives you much better
>> >> > retry
>> >> > logic as well as more configuration options.
>> >> >
>> >> > --
>> >> > -Daniel
>> >> > This posting is provided "AS IS" with no warranties, and confers no
>> >> > rights.
>> >> >
>> >> >
>> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
>> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
>> >> > >I got the same issue, yesterday email working fine, but this
>> >> > >morning
>> >> > >not
>> >> > > working, and I try your option. Email message file .eml does
>> >> > > droped
>> >> > > in the
>> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
>> >> > > passing?
>> >> > > Is
>> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
>> >> > >
>> >> > > Tony
>> >> > >
>> >> > > "Daniel Reib [MSFT]" wrote:
>> >> > >
>> >> > >> You can try having the emails dropped to a folder instead. If
>> >> > >> all
>> >> > >> the
>> >> > >> emails are getting correctly dropped then your SMTP server is
>> >> > >> having
>> >> > >> an
>> >> > >> issue passing them on and you should look into that.
>> >> > >>
>> >> > >> To get the emails to drop to a folder, set the
>> >> > >> SMTPPickupDirectory
>> >> > >> element
>> >> > >> in the RSReportServer.config file to a folder location, then set
>> >> > >> the
>> >> > >> SendUsing element to 1. All emails will then be placed in that
>> >> > >> folder.
>> >> > >> If
>> >> > >> some are not being placed then the log files should state why
>> >> > >> they
>> >> > >> are
>> >> > >> not.
>> >> > >>
>> >> > >> --
>> >> > >> -Daniel
>> >> > >> This posting is provided "AS IS" with no warranties, and confers
>> >> > >> no
>> >> > >> rights.
>> >> > >>
>> >> > >>
>> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
>> >> > >> message
>> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
>> >> > >> > Hi,
>> >> > >> >
>> >> > >> > We recently have troubleshoots with email subscriptions. Some
>> >> > >> > reports
>> >> > >> > are
>> >> > >> > correctly sent, others aren't... There are no error messages in
>> >> > >> > the
>> >> > >> > "state"
>> >> > >> > column of all those subscriptions, "mail sent to.." is
>> >> > >> > displayed.
>> >> > >> >
>> >> > >> > Everything seems correct in the log files, RS tells us that all
>> >> > >> > messages
>> >> > >> > have been sent correctly. The only "strange" info line is this
>> >> > >> > one
>> >> > >> > before
>> >> > >> > report execution for subscription:
>> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
>> >> > >> > INFO:
>> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
>> >> > >> > reportPath:
>> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
>> >> > >> > database.
>> >> > >> >
>> >> > >> > Another user in the newsgroup is facing the same problem:
>> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
>> >> > >> >
>> >> > >> > For information, we are using Reporting Services SP2 on Windows
>> >> > >> > Server
>> >> > >> > 2K3.
>> >> > >> >
>> >> > >> > Thanks in advance.
>> >> > >> > Grégory.
>> >> > >> >
>> >> > >>
>> >> > >>
>> >> > >>
>> >> >
>> >> >
>> >> >
>>|||Greg,
When you say "not sent", what does log say about it? Is it still not error,
but the receipt not receive the email? I was using outlook to receive email,
email went to "Junk E-Mail" box, I though I did not receive them at all.
(Daniel, sorry about my last message, in fact it was working fine.). If you
are include the report as "Web Archive" and you turn on your outlook "Junk
Email" setting, the email will go to "Junk E-Mail". But with Excel format, it
will go to your inbox, or rountie by some rules you define.
I guess, with "Web Archive" the email message will contain some script
outlook "thinks" un-save to it. So I guess, when you run AntiVirus, for
protection, the email either filter to Junk mail box by outlook, or filter by
the mail server, thought?
Tony
"Daniel Reib [MSFT]" wrote:
> I have not heard of this kind of issue before. Is this when the emails are
> being dropped to a folder or sent directly to the SMTP server? Does it
> repro if you leave the antivirus on and don't scan the RSTempFiles
> directory? Are you excluding the ASP.Net temporary files directory?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> > Hi,
> >
> > I've got some news!
> > I've made some test with the AntiVirus protection on the server... and
> > guess
> > what... when I stop the antivirus, subscriptions on a particular
> > problematic
> > report are working ... when I start it again, mails aren't sent.
> >
> > We are actually using Symantec AntiVirus 10, this version has been
> > installed
> > mid-december. Is there any incomatibility beetween this progam and
> > Reporting
> > Services ?
> >
> > Once again Daniel, thanks for your support.
> >
> > Grégory.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Yes, this is the most reliable way to send emails from RS. To do this
> >> you
> >> must have the local SMTP server installed. You then configure the SMTP
> >> server to relay the messages, then configure RS to drop the eml files to
> >> the
> >> SMTP server's pickup directory.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> >> > Hi Tony and Daniel,
> >> >
> >> > Well... After restarting ReportServer service, everything worked well
> >> > during
> >> > 2 days... and this morning the problem was back again!
> >> >
> >> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> >> > since
> >> > we have to restart service for changes to take effect , it's always
> >> > working
> >> > after that and eml files are created in the directory.
> >> > Mails are correctly sent too when i restart ReportServer, so the best
> >> > way
> >> > would be to test the first option during some days.. But since the
> >> > server
> >> > is
> >> > our production server, it's impossible.
> >> >
> >> > Is there a way to have messages dropped in the directory and sent via
> >> > SMTP
> >> > in the meantime.
> >> >
> >> > Thanx in advance.
> >> > Grégory.
> >> >
> >> > "Tony" wrote:
> >> >
> >> >> Daniel, thanks for the answer. I see.
> >> >> This time I took off SMTP pickup directory and also took off
> >> >> SendUse=1.
> >> >> It
> >> >> works fine. I guess that's because I restart the ReportServer service.
> >> >> Yesterday, I also missed some email, I tried to delete the
> >> >> subscription
> >> >> and
> >> >> create a new one, if fixed as well.
> >> >> So my suggestion to Greg is, to restart service and recreate the
> >> >> subscription.
> >> >> So far they are working fine. Hope not missing again...
> >> >>
> >> >> "Daniel Reib [MSFT]" wrote:
> >> >>
> >> >> > If all the emails are being dropped then RS is doing everything it
> >> >> > can
> >> >> > to
> >> >> > send the emails. We use the CDO objects to generate and send the
> >> >> > emails.
> >> >> > If it reports no errors then from RS everything is working. The
> >> >> > most
> >> >> > reliable way to set up RS to forward emails is to have it drop the
> >> >> > .eml
> >> >> > files to the local SMTP pickup directory and have this relay the
> >> >> > emails
> >> >> > to
> >> >> > your SMTP server. Using the local smtp server gives you much better
> >> >> > retry
> >> >> > logic as well as more configuration options.
> >> >> >
> >> >> > --
> >> >> > -Daniel
> >> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> >> > rights.
> >> >> >
> >> >> >
> >> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> >> > >I got the same issue, yesterday email working fine, but this
> >> >> > >morning
> >> >> > >not
> >> >> > > working, and I try your option. Email message file .eml does
> >> >> > > droped
> >> >> > > in the
> >> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> >> > > passing?
> >> >> > > Is
> >> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> >> > >
> >> >> > > Tony
> >> >> > >
> >> >> > > "Daniel Reib [MSFT]" wrote:
> >> >> > >
> >> >> > >> You can try having the emails dropped to a folder instead. If
> >> >> > >> all
> >> >> > >> the
> >> >> > >> emails are getting correctly dropped then your SMTP server is
> >> >> > >> having
> >> >> > >> an
> >> >> > >> issue passing them on and you should look into that.
> >> >> > >>
> >> >> > >> To get the emails to drop to a folder, set the
> >> >> > >> SMTPPickupDirectory
> >> >> > >> element
> >> >> > >> in the RSReportServer.config file to a folder location, then set
> >> >> > >> the
> >> >> > >> SendUsing element to 1. All emails will then be placed in that
> >> >> > >> folder.
> >> >> > >> If
> >> >> > >> some are not being placed then the log files should state why
> >> >> > >> they
> >> >> > >> are
> >> >> > >> not.
> >> >> > >>
> >> >> > >> --
> >> >> > >> -Daniel
> >> >> > >> This posting is provided "AS IS" with no warranties, and confers
> >> >> > >> no
> >> >> > >> rights.
> >> >> > >>
> >> >> > >>
> >> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
> >> >> > >> message
> >> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> >> > >> > Hi,
> >> >> > >> >
> >> >> > >> > We recently have troubleshoots with email subscriptions. Some
> >> >> > >> > reports
> >> >> > >> > are
> >> >> > >> > correctly sent, others aren't... There are no error messages in
> >> >> > >> > the
> >> >> > >> > "state"
> >> >> > >> > column of all those subscriptions, "mail sent to.." is
> >> >> > >> > displayed.
> >> >> > >> >
> >> >> > >> > Everything seems correct in the log files, RS tells us that all
> >> >> > >> > messages
> >> >> > >> > have been sent correctly. The only "strange" info line is this
> >> >> > >> > one
> >> >> > >> > before
> >> >> > >> > report execution for subscription:
> >> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
> >> >> > >> > INFO:
> >> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> >> > >> > reportPath:
> >> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> >> >> > >> > database.
> >> >> > >> >
> >> >> > >> > Another user in the newsgroup is facing the same problem:
> >> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >> > >> >
> >> >> > >> > For information, we are using Reporting Services SP2 on Windows
> >> >> > >> > Server
> >> >> > >> > 2K3.
> >> >> > >> >
> >> >> > >> > Thanks in advance.
> >> >> > >> > Grégory.
> >> >> > >> >
> >> >> > >>
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>|||I just had the same problem with Symantec Mail Security which is
included in the Corporate Edition of Symanted Antivirus. This may be
what's causing your error. If you right click on the email message in
Outlook -> Options and see something similar in the Internet headers,
it a clear indication that Symantec Mail Security could be to blame.
Microsoft Mail Internet Headers Version 2.0
X-SMSMSE-SCL: 2
I resolved the issue by adding my domain to sender whitelist within the
Symantec Antivirus web configuration tool under Real Time Blacklists
and Whitelists.
Larry|||Tony,
The log says that message has been sent. But I receive nothing, I checked
"Junk Mails" and nothing was there too.
The fact is that the Antivirus is on the RS Server, not on the client
desktop. So, I think that I'm encountering a Server problem more than a
client one.
Best Regards,
Grégory.
"Tony" wrote:
> Greg,
> When you say "not sent", what does log say about it? Is it still not error,
> but the receipt not receive the email? I was using outlook to receive email,
> email went to "Junk E-Mail" box, I though I did not receive them at all.
> (Daniel, sorry about my last message, in fact it was working fine.). If you
> are include the report as "Web Archive" and you turn on your outlook "Junk
> Email" setting, the email will go to "Junk E-Mail". But with Excel format, it
> will go to your inbox, or rountie by some rules you define.
> I guess, with "Web Archive" the email message will contain some script
> outlook "thinks" un-save to it. So I guess, when you run AntiVirus, for
> protection, the email either filter to Junk mail box by outlook, or filter by
> the mail server, thought?
> Tony
>
> "Daniel Reib [MSFT]" wrote:
> > I have not heard of this kind of issue before. Is this when the emails are
> > being dropped to a folder or sent directly to the SMTP server? Does it
> > repro if you leave the antivirus on and don't scan the RSTempFiles
> > directory? Are you excluding the ASP.Net temporary files directory?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> > news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> > > Hi,
> > >
> > > I've got some news!
> > > I've made some test with the AntiVirus protection on the server... and
> > > guess
> > > what... when I stop the antivirus, subscriptions on a particular
> > > problematic
> > > report are working ... when I start it again, mails aren't sent.
> > >
> > > We are actually using Symantec AntiVirus 10, this version has been
> > > installed
> > > mid-december. Is there any incomatibility beetween this progam and
> > > Reporting
> > > Services ?
> > >
> > > Once again Daniel, thanks for your support.
> > >
> > > Grégory.
> > >
> > > "Daniel Reib [MSFT]" wrote:
> > >
> > >> Yes, this is the most reliable way to send emails from RS. To do this
> > >> you
> > >> must have the local SMTP server installed. You then configure the SMTP
> > >> server to relay the messages, then configure RS to drop the eml files to
> > >> the
> > >> SMTP server's pickup directory.
> > >>
> > >> --
> > >> -Daniel
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> > >> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> > >> > Hi Tony and Daniel,
> > >> >
> > >> > Well... After restarting ReportServer service, everything worked well
> > >> > during
> > >> > 2 days... and this morning the problem was back again!
> > >> >
> > >> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> > >> > since
> > >> > we have to restart service for changes to take effect , it's always
> > >> > working
> > >> > after that and eml files are created in the directory.
> > >> > Mails are correctly sent too when i restart ReportServer, so the best
> > >> > way
> > >> > would be to test the first option during some days.. But since the
> > >> > server
> > >> > is
> > >> > our production server, it's impossible.
> > >> >
> > >> > Is there a way to have messages dropped in the directory and sent via
> > >> > SMTP
> > >> > in the meantime.
> > >> >
> > >> > Thanx in advance.
> > >> > Grégory.
> > >> >
> > >> > "Tony" wrote:
> > >> >
> > >> >> Daniel, thanks for the answer. I see.
> > >> >> This time I took off SMTP pickup directory and also took off
> > >> >> SendUse=1.
> > >> >> It
> > >> >> works fine. I guess that's because I restart the ReportServer service.
> > >> >> Yesterday, I also missed some email, I tried to delete the
> > >> >> subscription
> > >> >> and
> > >> >> create a new one, if fixed as well.
> > >> >> So my suggestion to Greg is, to restart service and recreate the
> > >> >> subscription.
> > >> >> So far they are working fine. Hope not missing again...
> > >> >>
> > >> >> "Daniel Reib [MSFT]" wrote:
> > >> >>
> > >> >> > If all the emails are being dropped then RS is doing everything it
> > >> >> > can
> > >> >> > to
> > >> >> > send the emails. We use the CDO objects to generate and send the
> > >> >> > emails.
> > >> >> > If it reports no errors then from RS everything is working. The
> > >> >> > most
> > >> >> > reliable way to set up RS to forward emails is to have it drop the
> > >> >> > .eml
> > >> >> > files to the local SMTP pickup directory and have this relay the
> > >> >> > emails
> > >> >> > to
> > >> >> > your SMTP server. Using the local smtp server gives you much better
> > >> >> > retry
> > >> >> > logic as well as more configuration options.
> > >> >> >
> > >> >> > --
> > >> >> > -Daniel
> > >> >> > This posting is provided "AS IS" with no warranties, and confers no
> > >> >> > rights.
> > >> >> >
> > >> >> >
> > >> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> > >> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> > >> >> > >I got the same issue, yesterday email working fine, but this
> > >> >> > >morning
> > >> >> > >not
> > >> >> > > working, and I try your option. Email message file .eml does
> > >> >> > > droped
> > >> >> > > in the
> > >> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> > >> >> > > passing?
> > >> >> > > Is
> > >> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> > >> >> > >
> > >> >> > > Tony
> > >> >> > >
> > >> >> > > "Daniel Reib [MSFT]" wrote:
> > >> >> > >
> > >> >> > >> You can try having the emails dropped to a folder instead. If
> > >> >> > >> all
> > >> >> > >> the
> > >> >> > >> emails are getting correctly dropped then your SMTP server is
> > >> >> > >> having
> > >> >> > >> an
> > >> >> > >> issue passing them on and you should look into that.
> > >> >> > >>
> > >> >> > >> To get the emails to drop to a folder, set the
> > >> >> > >> SMTPPickupDirectory
> > >> >> > >> element
> > >> >> > >> in the RSReportServer.config file to a folder location, then set
> > >> >> > >> the
> > >> >> > >> SendUsing element to 1. All emails will then be placed in that
> > >> >> > >> folder.
> > >> >> > >> If
> > >> >> > >> some are not being placed then the log files should state why
> > >> >> > >> they
> > >> >> > >> are
> > >> >> > >> not.
> > >> >> > >>
> > >> >> > >> --
> > >> >> > >> -Daniel
> > >> >> > >> This posting is provided "AS IS" with no warranties, and confers
> > >> >> > >> no
> > >> >> > >> rights.
> > >> >> > >>
> > >> >> > >>
> > >> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
> > >> >> > >> message
> > >> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> > >> >> > >> > Hi,
> > >> >> > >> >
> > >> >> > >> > We recently have troubleshoots with email subscriptions. Some
> > >> >> > >> > reports
> > >> >> > >> > are
> > >> >> > >> > correctly sent, others aren't... There are no error messages in
> > >> >> > >> > the
> > >> >> > >> > "state"
> > >> >> > >> > column of all those subscriptions, "mail sent to.." is
> > >> >> > >> > displayed.
> > >> >> > >> >
> > >> >> > >> > Everything seems correct in the log files, RS tells us that all
> > >> >> > >> > messages
> > >> >> > >> > have been sent correctly. The only "strange" info line is this
> > >> >> > >> > one
> > >> >> > >> > before
> > >> >> > >> > report execution for subscription:
> > >> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
> > >> >> > >> > INFO:
> > >> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> > >> >> > >> > reportPath:
> > >> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> > >> >> > >> > database.
> > >> >> > >> >
> > >> >> > >> > Another user in the newsgroup is facing the same problem:
> > >> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> > >> >> > >> >
> > >> >> > >> > For information, we are using Reporting Services SP2 on Windows
> > >> >> > >> > Server
> > >> >> > >> > 2K3.
> > >> >> > >> >
> > >> >> > >> > Thanks in advance.
> > >> >> > >> > Grégory.
> > >> >> > >> >
> > >> >> > >>
> > >> >> > >>
> > >> >> > >>
> > >> >> >
> > >> >> >
> > >> >> >
> > >>
> > >>
> > >>
> >
> >
> >|||Daniel,
It's when email are sent directly to the SMTP Server.
For the moment, we have disabled Symantec auto-protect on the server. We
will investigate further in a couple of days. I'll let you know which
directories have to be excluded from the scan.
Grégory.
"Daniel Reib [MSFT]" wrote:
> I have not heard of this kind of issue before. Is this when the emails are
> being dropped to a folder or sent directly to the SMTP server? Does it
> repro if you leave the antivirus on and don't scan the RSTempFiles
> directory? Are you excluding the ASP.Net temporary files directory?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> > Hi,
> >
> > I've got some news!
> > I've made some test with the AntiVirus protection on the server... and
> > guess
> > what... when I stop the antivirus, subscriptions on a particular
> > problematic
> > report are working ... when I start it again, mails aren't sent.
> >
> > We are actually using Symantec AntiVirus 10, this version has been
> > installed
> > mid-december. Is there any incomatibility beetween this progam and
> > Reporting
> > Services ?
> >
> > Once again Daniel, thanks for your support.
> >
> > Grégory.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Yes, this is the most reliable way to send emails from RS. To do this
> >> you
> >> must have the local SMTP server installed. You then configure the SMTP
> >> server to relay the messages, then configure RS to drop the eml files to
> >> the
> >> SMTP server's pickup directory.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> >> > Hi Tony and Daniel,
> >> >
> >> > Well... After restarting ReportServer service, everything worked well
> >> > during
> >> > 2 days... and this morning the problem was back again!
> >> >
> >> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> >> > since
> >> > we have to restart service for changes to take effect , it's always
> >> > working
> >> > after that and eml files are created in the directory.
> >> > Mails are correctly sent too when i restart ReportServer, so the best
> >> > way
> >> > would be to test the first option during some days.. But since the
> >> > server
> >> > is
> >> > our production server, it's impossible.
> >> >
> >> > Is there a way to have messages dropped in the directory and sent via
> >> > SMTP
> >> > in the meantime.
> >> >
> >> > Thanx in advance.
> >> > Grégory.
> >> >
> >> > "Tony" wrote:
> >> >
> >> >> Daniel, thanks for the answer. I see.
> >> >> This time I took off SMTP pickup directory and also took off
> >> >> SendUse=1.
> >> >> It
> >> >> works fine. I guess that's because I restart the ReportServer service.
> >> >> Yesterday, I also missed some email, I tried to delete the
> >> >> subscription
> >> >> and
> >> >> create a new one, if fixed as well.
> >> >> So my suggestion to Greg is, to restart service and recreate the
> >> >> subscription.
> >> >> So far they are working fine. Hope not missing again...
> >> >>
> >> >> "Daniel Reib [MSFT]" wrote:
> >> >>
> >> >> > If all the emails are being dropped then RS is doing everything it
> >> >> > can
> >> >> > to
> >> >> > send the emails. We use the CDO objects to generate and send the
> >> >> > emails.
> >> >> > If it reports no errors then from RS everything is working. The
> >> >> > most
> >> >> > reliable way to set up RS to forward emails is to have it drop the
> >> >> > .eml
> >> >> > files to the local SMTP pickup directory and have this relay the
> >> >> > emails
> >> >> > to
> >> >> > your SMTP server. Using the local smtp server gives you much better
> >> >> > retry
> >> >> > logic as well as more configuration options.
> >> >> >
> >> >> > --
> >> >> > -Daniel
> >> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> >> > rights.
> >> >> >
> >> >> >
> >> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> >> > >I got the same issue, yesterday email working fine, but this
> >> >> > >morning
> >> >> > >not
> >> >> > > working, and I try your option. Email message file .eml does
> >> >> > > droped
> >> >> > > in the
> >> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> >> > > passing?
> >> >> > > Is
> >> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> >> > >
> >> >> > > Tony
> >> >> > >
> >> >> > > "Daniel Reib [MSFT]" wrote:
> >> >> > >
> >> >> > >> You can try having the emails dropped to a folder instead. If
> >> >> > >> all
> >> >> > >> the
> >> >> > >> emails are getting correctly dropped then your SMTP server is
> >> >> > >> having
> >> >> > >> an
> >> >> > >> issue passing them on and you should look into that.
> >> >> > >>
> >> >> > >> To get the emails to drop to a folder, set the
> >> >> > >> SMTPPickupDirectory
> >> >> > >> element
> >> >> > >> in the RSReportServer.config file to a folder location, then set
> >> >> > >> the
> >> >> > >> SendUsing element to 1. All emails will then be placed in that
> >> >> > >> folder.
> >> >> > >> If
> >> >> > >> some are not being placed then the log files should state why
> >> >> > >> they
> >> >> > >> are
> >> >> > >> not.
> >> >> > >>
> >> >> > >> --
> >> >> > >> -Daniel
> >> >> > >> This posting is provided "AS IS" with no warranties, and confers
> >> >> > >> no
> >> >> > >> rights.
> >> >> > >>
> >> >> > >>
> >> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
> >> >> > >> message
> >> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> >> > >> > Hi,
> >> >> > >> >
> >> >> > >> > We recently have troubleshoots with email subscriptions. Some
> >> >> > >> > reports
> >> >> > >> > are
> >> >> > >> > correctly sent, others aren't... There are no error messages in
> >> >> > >> > the
> >> >> > >> > "state"
> >> >> > >> > column of all those subscriptions, "mail sent to.." is
> >> >> > >> > displayed.
> >> >> > >> >
> >> >> > >> > Everything seems correct in the log files, RS tells us that all
> >> >> > >> > messages
> >> >> > >> > have been sent correctly. The only "strange" info line is this
> >> >> > >> > one
> >> >> > >> > before
> >> >> > >> > report execution for subscription:
> >> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
> >> >> > >> > INFO:
> >> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> >> > >> > reportPath:
> >> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> >> >> > >> > database.
> >> >> > >> >
> >> >> > >> > Another user in the newsgroup is facing the same problem:
> >> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >> > >> >
> >> >> > >> > For information, we are using Reporting Services SP2 on Windows
> >> >> > >> > Server
> >> >> > >> > 2K3.
> >> >> > >> >
> >> >> > >> > Thanks in advance.
> >> >> > >> > Grégory.
> >> >> > >> >
> >> >> > >>
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>|||We finally found the solution. In the "Configure" menu, we have disabled
"Internet E-mail Auto-protect".
Now everything works fine.
Grégory.
"Daniel Reib [MSFT]" wrote:
> I have not heard of this kind of issue before. Is this when the emails are
> being dropped to a folder or sent directly to the SMTP server? Does it
> repro if you leave the antivirus on and don't scan the RSTempFiles
> directory? Are you excluding the ASP.Net temporary files directory?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> news:86506F24-662F-4038-A6E5-D9C8766B1E31@.microsoft.com...
> > Hi,
> >
> > I've got some news!
> > I've made some test with the AntiVirus protection on the server... and
> > guess
> > what... when I stop the antivirus, subscriptions on a particular
> > problematic
> > report are working ... when I start it again, mails aren't sent.
> >
> > We are actually using Symantec AntiVirus 10, this version has been
> > installed
> > mid-december. Is there any incomatibility beetween this progam and
> > Reporting
> > Services ?
> >
> > Once again Daniel, thanks for your support.
> >
> > Grégory.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Yes, this is the most reliable way to send emails from RS. To do this
> >> you
> >> must have the local SMTP server installed. You then configure the SMTP
> >> server to relay the messages, then configure RS to drop the eml files to
> >> the
> >> SMTP server's pickup directory.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in message
> >> news:73376ECB-98E3-423F-AB38-BB267DB862A9@.microsoft.com...
> >> > Hi Tony and Daniel,
> >> >
> >> > Well... After restarting ReportServer service, everything worked well
> >> > during
> >> > 2 days... and this morning the problem was back again!
> >> >
> >> > I've tried to change SMTP Pickup Directory and SendUsing options, but
> >> > since
> >> > we have to restart service for changes to take effect , it's always
> >> > working
> >> > after that and eml files are created in the directory.
> >> > Mails are correctly sent too when i restart ReportServer, so the best
> >> > way
> >> > would be to test the first option during some days.. But since the
> >> > server
> >> > is
> >> > our production server, it's impossible.
> >> >
> >> > Is there a way to have messages dropped in the directory and sent via
> >> > SMTP
> >> > in the meantime.
> >> >
> >> > Thanx in advance.
> >> > Grégory.
> >> >
> >> > "Tony" wrote:
> >> >
> >> >> Daniel, thanks for the answer. I see.
> >> >> This time I took off SMTP pickup directory and also took off
> >> >> SendUse=1.
> >> >> It
> >> >> works fine. I guess that's because I restart the ReportServer service.
> >> >> Yesterday, I also missed some email, I tried to delete the
> >> >> subscription
> >> >> and
> >> >> create a new one, if fixed as well.
> >> >> So my suggestion to Greg is, to restart service and recreate the
> >> >> subscription.
> >> >> So far they are working fine. Hope not missing again...
> >> >>
> >> >> "Daniel Reib [MSFT]" wrote:
> >> >>
> >> >> > If all the emails are being dropped then RS is doing everything it
> >> >> > can
> >> >> > to
> >> >> > send the emails. We use the CDO objects to generate and send the
> >> >> > emails.
> >> >> > If it reports no errors then from RS everything is working. The
> >> >> > most
> >> >> > reliable way to set up RS to forward emails is to have it drop the
> >> >> > .eml
> >> >> > files to the local SMTP pickup directory and have this relay the
> >> >> > emails
> >> >> > to
> >> >> > your SMTP server. Using the local smtp server gives you much better
> >> >> > retry
> >> >> > logic as well as more configuration options.
> >> >> >
> >> >> > --
> >> >> > -Daniel
> >> >> > This posting is provided "AS IS" with no warranties, and confers no
> >> >> > rights.
> >> >> >
> >> >> >
> >> >> > "Tony" <Tony@.discussions.microsoft.com> wrote in message
> >> >> > news:8741570E-4313-4624-970E-57A047057244@.microsoft.com...
> >> >> > >I got the same issue, yesterday email working fine, but this
> >> >> > >morning
> >> >> > >not
> >> >> > > working, and I try your option. Email message file .eml does
> >> >> > > droped
> >> >> > > in the
> >> >> > > SMTPServerPickupFolder. But does it mean the issue of SMTP server
> >> >> > > passing?
> >> >> > > Is
> >> >> > > it possible that RS fail to trigger SMTP to sending email? Thanks.
> >> >> > >
> >> >> > > Tony
> >> >> > >
> >> >> > > "Daniel Reib [MSFT]" wrote:
> >> >> > >
> >> >> > >> You can try having the emails dropped to a folder instead. If
> >> >> > >> all
> >> >> > >> the
> >> >> > >> emails are getting correctly dropped then your SMTP server is
> >> >> > >> having
> >> >> > >> an
> >> >> > >> issue passing them on and you should look into that.
> >> >> > >>
> >> >> > >> To get the emails to drop to a folder, set the
> >> >> > >> SMTPPickupDirectory
> >> >> > >> element
> >> >> > >> in the RSReportServer.config file to a folder location, then set
> >> >> > >> the
> >> >> > >> SendUsing element to 1. All emails will then be placed in that
> >> >> > >> folder.
> >> >> > >> If
> >> >> > >> some are not being placed then the log files should state why
> >> >> > >> they
> >> >> > >> are
> >> >> > >> not.
> >> >> > >>
> >> >> > >> --
> >> >> > >> -Daniel
> >> >> > >> This posting is provided "AS IS" with no warranties, and confers
> >> >> > >> no
> >> >> > >> rights.
> >> >> > >>
> >> >> > >>
> >> >> > >> "Greg - NEOS" <GregNEOS@.discussions.microsoft.com> wrote in
> >> >> > >> message
> >> >> > >> news:ABCBAC49-30D3-480E-8E9A-DF72F4AC4697@.microsoft.com...
> >> >> > >> > Hi,
> >> >> > >> >
> >> >> > >> > We recently have troubleshoots with email subscriptions. Some
> >> >> > >> > reports
> >> >> > >> > are
> >> >> > >> > correctly sent, others aren't... There are no error messages in
> >> >> > >> > the
> >> >> > >> > "state"
> >> >> > >> > column of all those subscriptions, "mail sent to.." is
> >> >> > >> > displayed.
> >> >> > >> >
> >> >> > >> > Everything seems correct in the log files, RS tells us that all
> >> >> > >> > messages
> >> >> > >> > have been sent correctly. The only "strange" info line is this
> >> >> > >> > one
> >> >> > >> > before
> >> >> > >> > report execution for subscription:
> >> >> > >> > ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i
> >> >> > >> > INFO:
> >> >> > >> > LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd,
> >> >> > >> > reportPath:
> >> >> > >> > /<report_path>, userName: <domain>\<user> not found in the
> >> >> > >> > database.
> >> >> > >> >
> >> >> > >> > Another user in the newsgroup is facing the same problem:
> >> >> > >> > http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> >> >> > >> >
> >> >> > >> > For information, we are using Reporting Services SP2 on Windows
> >> >> > >> > Server
> >> >> > >> > 2K3.
> >> >> > >> >
> >> >> > >> > Thanks in advance.
> >> >> > >> > Grégory.
> >> >> > >> >
> >> >> > >>
> >> >> > >>
> >> >> > >>
> >> >> >
> >> >> >
> >> >> >
> >>
> >>
> >>
>
>|||Do you know how to fix this problem?
My logfile has the following messages:
ReportingServicesService!crypto!d58!3/30/2006-12:08:54:: i INFO:
Initializing crypto as user: ACTRANSIT\AdminSQLDW
ReportingServicesService!crypto!d58!3/30/2006-12:08:54:: i INFO: Exporting
public key
ReportingServicesService!crypto!d58!3/30/2006-12:08:54:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d58!3/30/2006-12:08:54:: i INFO: Importing
existing encryption key
ReportingServicesService!library!d58!3/30/2006-12:08:54:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
ReportingServicesService!library!d58!3/30/2006-12:08:54:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!d58!3/30/2006-12:08:54:: Attempting to
start service again...
Thanks!
Henry
"Greg - NEOS" wrote:
> Hi,
> We recently have troubleshoots with email subscriptions. Some reports are
> correctly sent, others aren't... There are no error messages in the "state"
> column of all those subscriptions, "mail sent to.." is displayed.
> Everything seems correct in the log files, RS tells us that all messages
> have been sent correctly. The only "strange" info line is this one before
> report execution for subscription:
> ReportingServicesService!session!d9c!01/05/2006-10:58:03:: i INFO:
> LoadSnapshot: Item with session: oeu4yqy5w1pcei45oo3xx2jd, reportPath:
> /<report_path>, userName: <domain>\<user> not found in the database.
> Another user in the newsgroup is facing the same problem:
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=e4cb35ba-f73e-412a-928e-0db4b093072d&mid=e4cb35ba-f73e-412a-928e-0db4b093072d
> For information, we are using Reporting Services SP2 on Windows Server 2K3.
> Thanks in advance.
> Grégory.
>