embedding a DTS package which contains a 'Copy SQL Server Objects Task'

Hi,

I am getting an error when doing the above.

I create a new SSIS package, drag in an Execute DTS 2000 Package Task, select and embed a DTS package which consists only one one task (as above), and then change the source & destination details (svr + user/pwd). Then when I go to the Copy tab, I get the following error when I hit Select Objects, to view the objects which the embedded DTS package should copy:

SQL-DMO error 21776: general error.

On further inspection, none of the objects selected for copy within the atomic/original DTS package, remain selected for copy within the embedded DTS package.

I have googled to search for an answer to this one, but to no avail. Any ideas would be greatly welcomed.

Thanks,

Tamim.

Off the top of my head I am not sure...but I wonder if there is more to this or perhaps what the real goal is?

I ask because if your only dealing with one transfer task from a dts package, then why not just create a new SSIS package using the new ssis transfer tasks? Prehaps you have 100s of said DTS packages, and you need to keep them going rather than rebuild all. However, we should always keep in mind that while the Execute DTS 2000 Package Task is nice for 'keeping things running' from the old version, over time you will want to rebuild any DTS pacakge as a 'native' SSIS 2005 pacakge allows you to do a lot more AND DTS is considered a deprecated technology, which does mean its fading form the picure. If you want you can read more about that here.

http://msdn2.microsoft.com/en-us/library/ms403408.aspx

Hope that helps.

|||

'...if your only dealing with one transfer task from a dts package, then why not just create a new SSIS package using the new ssis transfer tasks?...'

Sure. And that's exactly what I did, thus reducing the problem to being merely academic - but it's still there....

Thanks Craig,

embedding a DTS package and logging/error reporting

Hi All,

When the embedded DTS package fails at runtime, and logging has been enabled for the package (and all log events selected for reporting on for the package and the task), the DTS error (i.e. any meaningful errors) are not thrown up to/caught by the SSIS/outer level. All you get is something like:

COMException - error returned from a call to a COM component.

Does anyone have any comments &/or know to get errors thrown from within an embedded DTS package, thrown up to the wrapping SSIS package?

Cheers,

Tamim.

Hi Tamim,

Try configuring your DTS package (using the old SQL 2000 designer) to log to an msdb database (it can be a SQL 2005 msdb). Then you will find the DTS messages logged to the tables eg sysdtspackagelog and sysdtssteplog.

Good luck.

Mike

embedding a DTS package and logging/error reporting

Hi All,

When the embedded DTS package fails at runtime, and logging has been enabled for the package (and all log events selected for reporting on for the package and the task), the DTS error (i.e. any meaningful errors) are not thrown up to/caught by the SSIS/outer level. All you get is something like:

COMException - error returned from a call to a COM component.

Does anyone have any comments &/or know to get errors thrown from within an embedded DTS package, thrown up to the wrapping SSIS package?

Cheers,

Tamim.

Hi Tamim,

Try configuring your DTS package (using the old SQL 2000 designer) to log to an msdb database (it can be a SQL 2005 msdb). Then you will find the DTS messages logged to the tables eg sysdtspackagelog and sysdtssteplog.

Good luck.

Mike

sql

Embedded Text Qualifiers no longer supported in Yukon ?

Hello,
I try to import the data below from a text file using the SQL Server 2005
import wizard with a "Flat File Source" and receive the error "SQL Server
Import and Export Wizard / The preview sample contains embedded text
qualifiers ("). The flat file parser does not support embedding text
qualifiers in data. Parsing columns that contain data with text qualifiers
will fail at run time."
With SQL Server 2000 this was no problem. The files I want to import are
about 100MB in size. Any workaround?
select @.@.version returns: Microsoft SQL Server 2005 - 9.00.1314.06 (X64)
Sep 2 2005 21:10:23 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
Sample data:
1 inch,"2""","3 inches","4, 5, and 6""",7 inches,"8"", 9"",""10""""",11
inches
Kind regards,
Frank
Hi Frank...

Found your post here:
http://www.eggheadcafe.com/forumarchives/sqlserverdts/oct2005/post24522404.asp

Any progress in the concerning topic?

Embedded Text Qualifiers no longer supported in Yukon ?

Hello,
I try to import the data below from a text file using the SQL Server 2005
import wizard with a "Flat File Source" and receive the error "SQL Server
Import and Export Wizard / The preview sample contains embedded text
qualifiers ("). The flat file parser does not support embedding text
qualifiers in data. Parsing columns that contain data with text qualifiers
will fail at run time."
With SQL Server 2000 this was no problem. The files I want to import are
about 100MB in size. Any workaround?
select @.@.version returns: Microsoft SQL Server 2005 - 9.00.1314.06 (X64)
Sep 2 2005 21:10:23 Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
Sample data:
1 inch,"2""","3 inches","4, 5, and 6""",7 inches,"8"", 9"",""10""""",11
inches
Kind regards,
Frank
Hi Frank...

Found your post here:
http://www.eggheadcafe.com/forumarchives/sqlserverdts/oct2005/post24522404.asp

Any progress in the concerning topic?
|||Check this:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7952c866-807b-4715-80ba-498e0a16ab18&DisplayLang=ensql

Email task failure urgent

i use email task and it dosent send an email at all....this task causes an error..

If i need to set up email for the package if the package fails...

or how should i set in the sql server agent...iknow there is an option there but i dont know how to..

Please let me know...

Sureshv,

Please post the error.

|||

Here is the error

[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".

|||Did you create an appropriate SMTP connection to your mail server? When editing the Send Mail task you'll be able create an SMTP connection. Make sure the information is correct and that you have permissions to the SMTP server.|||

Here is what i did..

I droped the send mail task to my control flow.

then smtp connection :i typed in the ip address

from:i typed in some email address

to :i typed in my email address

message source type:variable(dont know just put int theses)

message ource User::Variable( " )

priority normal...

when i run i come of with this message.

please let me know if i am right

|||MessageSourceType is exactly what it says. The message of the e-mail is either directly input in the box below, or it is a variable that already has the message assigned to it, or it is contained in a file somewhere.

Try to make sure the IP address is really an SMTP server and that it is accepting anonymous connections:

In windows, Start->Run->cmd.exe

From there, "telnet your-ip-address-here 25"

If you get something to come up, then simply type "quit".|||

i checked as u asked me to " telnet your-ip-address-here 25" it was jus blank and the came up with c:\documents and settigs\my name>

Whats that 25 for?

|||

sureshv wrote:

i checked as u asked me to " telnet your-ip-address-here 25" it was jus blank and the came up with c:\documents and settigs\my name>

Whats that 25 for?

It should've done something. Some message should've shown up.

telnet 111.222.333.444 25

"25" indicates the port on the server. Port 25 is the SMTP port.|||thanks..how to set this to a group of people receiving email...i want to set this email only on error in the package how do i set this..|||how to send email only on failure?|||Use the red arrows in the control flow to hook up to a send mail task.|||

i wonder if there are read arrows to data flow,execute sql etc...

|||Sorry. When you connect (for instance) a data flow to a send mail task, the arrow will initially be green. Double click on the arrow and change the "Value" parameter from "Success" to "Failure."

Then the arrow will turn red.|||thanks|||

I have data flow (DB1 to DB2) task and then send mail task. The package executes everyday and mail notificate sent regularly. But if DB1 or DB2 connection failed (due to expired password or server not available or any network issues), the package failing in validation stage itself and send mail task never executed.

The expected result is, email must be sent with the result of data flow task.

Anyone comments please

Email task failure urgent

i use email task and it dosent send an email at all....this task causes an error..

If i need to set up email for the package if the package fails...

or how should i set in the sql server agent...iknow there is an option there but i dont know how to..

Please let me know...

Sureshv,

Please post the error.

|||

Here is the error

[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.".

|||Did you create an appropriate SMTP connection to your mail server? When editing the Send Mail task you'll be able create an SMTP connection. Make sure the information is correct and that you have permissions to the SMTP server.|||

Here is what i did..

I droped the send mail task to my control flow.

then smtp connection :i typed in the ip address

from:i typed in some email address

to :i typed in my email address

message source type:variable(dont know just put int theses)

message ource User::Variable( " )

priority normal...

when i run i come of with this message.

please let me know if i am right

|||MessageSourceType is exactly what it says. The message of the e-mail is either directly input in the box below, or it is a variable that already has the message assigned to it, or it is contained in a file somewhere.

Try to make sure the IP address is really an SMTP server and that it is accepting anonymous connections:

In windows, Start->Run->cmd.exe

From there, "telnet your-ip-address-here 25"

If you get something to come up, then simply type "quit".|||

i checked as u asked me to " telnet your-ip-address-here 25" it was jus blank and the came up with c:\documents and settigs\my name>

Whats that 25 for?

|||

sureshv wrote:

i checked as u asked me to " telnet your-ip-address-here 25" it was jus blank and the came up with c:\documents and settigs\my name>

Whats that 25 for?

It should've done something. Some message should've shown up.

telnet 111.222.333.444 25

"25" indicates the port on the server. Port 25 is the SMTP port.|||thanks..how to set this to a group of people receiving email...i want to set this email only on error in the package how do i set this..|||how to send email only on failure?|||Use the red arrows in the control flow to hook up to a send mail task.|||

i wonder if there are read arrows to data flow,execute sql etc...

|||Sorry. When you connect (for instance) a data flow to a send mail task, the arrow will initially be green. Double click on the arrow and change the "Value" parameter from "Success" to "Failure."

Then the arrow will turn red.|||thanks|||

I have data flow (DB1 to DB2) task and then send mail task. The package executes everyday and mail notificate sent regularly. But if DB1 or DB2 connection failed (due to expired password or server not available or any network issues), the package failing in validation stage itself and send mail task never executed.

The expected result is, email must be sent with the result of data flow task.

Anyone comments please

Email task - no error - no mail

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

I'm sending email by sript component because in the company I cant send via SMTP...

Do you want to try send by script?

Regards!

|||Yes, I can make a try on it. Please send the script. Thanks.|||

Dhanasu wrote:

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

Perhaps it's getting caught up in a spam filter. Or the SMTP server isn't letting that e-mail through. Have you talked to the server admin?|||

here you have...

Code Snippet

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

'

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

Dim strServer As String = "mail.Grupo.com"

Dim strSender As String = "pedro"

Dim strTo As String = "mswail@.mail.com"

Dim strSenderAlias As String = "Pedro"

Dim strSubject As String = "SUCESS Import CLiq - " & Today()

Dim strBody As String = "OK"

Dim sUri As String

sUri = "http://" + strServer + "/Exchange/" + strSenderAlias

sUri = sUri + "/%23%23DavMailSubmissionURI%23%23/"

Dim myUri As System.Uri = New System.Uri(sUri)

Dim HttpWRequest As HttpWebRequest = CType(WebRequest.Create(myUri), HttpWebRequest)

Dim sQuery As String

sQuery = "To: " & strTo & vbNewLine & _

"Subject: " & strSubject & vbNewLine & _

"Date: " & Date.Now & vbNewLine & _

"X-Mailer: My DAV mailer" & vbNewLine & _

"MIME-Version: 1.0" & vbNewLine & _

"Content-Type: text/plain" & vbNewLine & _

"Charset = ""iso-8859-1""" & vbNewLine & _

"Content-Transfer-Encoding: 7bit" & vbNewLine & vbNewLine & _

strBody

Dim myCred As NetworkCredential = New NetworkCredential("GRUPOCGD\rhs0002", "275007")

Dim myCredentialCache As CredentialCache = New CredentialCache()

myCredentialCache.Add(myUri, "Basic", myCred)

HttpWRequest.Credentials = myCredentialCache

HttpWRequest.Headers.Set("Translate", "f")

HttpWRequest.ContentType = "message/rfc822"

HttpWRequest.ContentLength = sQuery.Length

HttpWRequest.Timeout = 300000

HttpWRequest.Method = "PUT"

Dim ByteQuery As Byte() = System.Text.Encoding.ASCII.GetBytes(sQuery)

HttpWRequest.ContentLength = ByteQuery.Length

Dim QueryStream As Stream = HttpWRequest.GetRequestStream()

QueryStream.Write(ByteQuery, 0, ByteQuery.Length)

QueryStream.Close()

Dim HttpWResponse As HttpWebResponse = CType(HttpWRequest.GetResponse(), HttpWebResponse)

Dim iStatCode As Integer = CType(HttpWResponse.StatusCode, Integer)

Dim sStatus As String = iStatCode.ToString()

myCred = Nothing

myCredentialCache = Nothing

HttpWRequest = Nothing

HttpWResponse = Nothing

QueryStream = Nothing

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

|||I am wiating for the reply from the admin. The from and to addresses are mine, so there are no possibility for Spam filter. If the SMTP is in error I hope I should get error message !!!|||

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

|||

Dhanasu wrote:

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

You mean you used the wrong server?

|||Yes, i was using wrong server.|||

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.|||

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks
|||

Karunakaran wrote:

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks

When I set it up to point to a server that doesn't exist, I get an error message: "[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". "

So if the OP above didn't get an error message and the task succeeded, then it must've been a valid SMTP server, just not the correct one.|||

An added question: Since the mail task is directly bind with the SMTP I can send emails from anonymous email as the "from email id". Is this an issue in my server configuration or in SSIS "send task"?

sql

Email task - no error - no mail

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

I'm sending email by sript component because in the company I cant send via SMTP...

Do you want to try send by script?

Regards!

|||Yes, I can make a try on it. Please send the script. Thanks.|||

Dhanasu wrote:

I am trying to explore the email task in SSIS. I have a task which has only the email task. When I run its not throwing any error instead it says successfuly run but I am not recieving mail. I dont know how to trace this, could someone help me on this?

Perhaps it's getting caught up in a spam filter. Or the SMTP server isn't letting that e-mail through. Have you talked to the server admin?|||

here you have...

Code Snippet

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Public Class ScriptMain

' The execution engine calls this method when the task executes.

' To access the object model, use the Dts object. Connections, variables, events,

' and logging features are available as static members of the Dts class.

' Before returning from this method, set the value of Dts.TaskResult to indicate success or failure.

'

' To open Code and Text Editor Help, press F1.

' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()

Dim strServer As String = "mail.Grupo.com"

Dim strSender As String = "pedro"

Dim strTo As String = "mswail@.mail.com"

Dim strSenderAlias As String = "Pedro"

Dim strSubject As String = "SUCESS Import CLiq - " & Today()

Dim strBody As String = "OK"

Dim sUri As String

sUri = "http://" + strServer + "/Exchange/" + strSenderAlias

sUri = sUri + "/%23%23DavMailSubmissionURI%23%23/"

Dim myUri As System.Uri = New System.Uri(sUri)

Dim HttpWRequest As HttpWebRequest = CType(WebRequest.Create(myUri), HttpWebRequest)

Dim sQuery As String

sQuery = "To: " & strTo & vbNewLine & _

"Subject: " & strSubject & vbNewLine & _

"Date: " & Date.Now & vbNewLine & _

"X-Mailer: My DAV mailer" & vbNewLine & _

"MIME-Version: 1.0" & vbNewLine & _

"Content-Type: text/plain" & vbNewLine & _

"Charset = ""iso-8859-1""" & vbNewLine & _

"Content-Transfer-Encoding: 7bit" & vbNewLine & vbNewLine & _

strBody

Dim myCred As NetworkCredential = New NetworkCredential("GRUPOCGD\rhs0002", "275007")

Dim myCredentialCache As CredentialCache = New CredentialCache()

myCredentialCache.Add(myUri, "Basic", myCred)

HttpWRequest.Credentials = myCredentialCache

HttpWRequest.Headers.Set("Translate", "f")

HttpWRequest.ContentType = "message/rfc822"

HttpWRequest.ContentLength = sQuery.Length

HttpWRequest.Timeout = 300000

HttpWRequest.Method = "PUT"

Dim ByteQuery As Byte() = System.Text.Encoding.ASCII.GetBytes(sQuery)

HttpWRequest.ContentLength = ByteQuery.Length

Dim QueryStream As Stream = HttpWRequest.GetRequestStream()

QueryStream.Write(ByteQuery, 0, ByteQuery.Length)

QueryStream.Close()

Dim HttpWResponse As HttpWebResponse = CType(HttpWRequest.GetResponse(), HttpWebResponse)

Dim iStatCode As Integer = CType(HttpWResponse.StatusCode, Integer)

Dim sStatus As String = iStatCode.ToString()

myCred = Nothing

myCredentialCache = Nothing

HttpWRequest = Nothing

HttpWResponse = Nothing

QueryStream = Nothing

Dts.TaskResult = Dts.Results.Success

End Sub

End Class

|||I am wiating for the reply from the admin. The from and to addresses are mine, so there are no possibility for Spam filter. If the SMTP is in error I hope I should get error message !!!|||

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

|||

Dhanasu wrote:

The SMTP i am trying is incorrect. I used the correct SMTP and it worked.

Question: Why does the SSIS not throwing error on incorrect SMTP.

You mean you used the wrong server?

|||Yes, i was using wrong server.|||

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.|||

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks
|||

Karunakaran wrote:

Phil Brammer wrote:

Dhanasu wrote:

Yes, i was using wrong server.

But it must've been a valid SMTP server -- one that accepts connections and such. So technically there wasn't an error.

If the SMTP server is invalid, because it will not be able to find that server at all, it wont throw any error for opening the connection I agree. But since its not able to find the server specified in the connection manager, it should throw the error for this right?

Thanks

When I set it up to point to a server that doesn't exist, I get an error message: "[Send Mail Task] Error: An error occurred with the following error message: "Failure sending mail.". "

So if the OP above didn't get an error message and the task succeeded, then it must've been a valid SMTP server, just not the correct one.|||

An added question: Since the mail task is directly bind with the SMTP I can send emails from anonymous email as the "from email id". Is this an issue in my server configuration or in SSIS "send task"?

Email Task

In my DTS package I tried to make an email task and it works if I execute it manualy, but if I schedule it I get the following error:

DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_16 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_16 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 8 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 8 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun OnStart: DTSStep_DTSSendMailTask_1 DTSRun OnError: DTSStep_DTSSendMailTask_1, Error = -2147220352 (80040480) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 1100 Error Detail Records: Error: -2147220352 (80040480); Provider Error: 0 (0) Error string: Logon failed: MapiLogonEx Failed due to MAPI error 273: MAPI Logon failed. Erro... Process Exit Code 1. The step failed.

What could it be?SQLAgent service account should be used to set up the mail profile.|||Got that to work, Thanks,

But now I am getting into another error:
Executed as user: UPSAPP\SQLService. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_16 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_16 DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_2 DTSRun OnError: DTSStep_DTSDataPumpTask_2, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 DTSRun OnFinish: DTSStep_DTSDataPumpTask_2 DTSRun: Package execution complete. Process Exit Code 1. The step failed.

This is happends when I am exporting a table into .xls file on the network drive.
Any ideas? Why is it using Microsoft JET Database Engine from SQL Server? Why can't it create a file, and why is it creating a file, i already have the file there.

Thanks in advance.|||So, if you're trying to append to the file, you just say so in your task desgn. The reason you're getting the error is because upon an attempt to append to the file it looks for it, and it can't find it because this account (SQLAgent service account) doesn't have permission to even read that share. So, it tries to create one (by design), and failes due to the same permission issue.|||So how would I tell the network admin to add that account for permission to that drive?|||First, confirm that permission is the issue by logging in with SQLAgent service account to demonstrate to yourself and then to your network admin that this is the case.|||And remember, when you execute a DTS package, it runs using your account. When you schedule it as a job, it runs as SQLAgent. This can confuse things when you are trying to debug permissions.

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