Error when programmatically creating a data driven subscription

Hi,
any ideas what causes this?
An internal error occurred on the report server. See the error log for more
details. --> An internal error occurred on the report server. See the error
log for more details. --> Subquery returned more than 1 value. This is not
permitted when the subquery follows =, !=, <, <= , >, >= or when
the subquery is used as an expression.
The statement has been terminated.
The log file shows
aspnet_wp!library!8c0!7/09/2004-09:08:27:: Using folder C:\Program
Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for
temporary files.
aspnet_wp!library!8c0!7/09/2004-09:08:27:: i INFO: Cleaned 0 batch records,
0 policies, 0 sessions, 0 cache entries, 1 snapshots, 4 chunks, 0 running
jobs
aspnet_wp!library!88c!09/07/2004-09:12:32:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: Subquery returned more
than 1 value. This is not permitted when the subquery follows =, !=, <, <= ,
>, >= or when the subquery is used as an expression.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.SubscriptionDB.CreateSubscription(Subscr
iptionImpl subscription)
-- End of inner exception stack trace --
thanks
MattActually, this is also occuring when trying to create a subscription via
report manager. I wonder if the reporting service installation is stuffed.
Any suggestions?
thanks
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:OxffpsHlEHA.3428@.TK2MSFTNGP14.phx.gbl...
> Hi,
> any ideas what causes this?
> An internal error occurred on the report server. See the error log for
more
> details. --> An internal error occurred on the report server. See the
error
> log for more details. --> Subquery returned more than 1 value. This is not
> permitted when the subquery follows =, !=, <, <= , >, >= or
when
> the subquery is used as an expression.
> The statement has been terminated.
> The log file shows
> aspnet_wp!library!8c0!7/09/2004-09:08:27:: Using folder C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for
> temporary files.
> aspnet_wp!library!8c0!7/09/2004-09:08:27:: i INFO: Cleaned 0 batch
records,
> 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 4 chunks, 0 running
> jobs
> aspnet_wp!library!88c!09/07/2004-09:12:32:: e ERROR: Throwing
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details., ;
> Info:
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
more
> details. --> System.Data.SqlClient.SqlException: Subquery returned more
> than 1 value. This is not permitted when the subquery follows =, !=, <, <=,
> >, >= or when the subquery is used as an expression.
> The statement has been terminated.
> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
> at
>
Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
> at
>
Microsoft.ReportingServices.Library.SubscriptionDB.CreateSubscription(Subscr
> iptionImpl subscription)
> -- End of inner exception stack trace --
> thanks
> Matt
>

Error Sending Email

Hello All
I have an issue sending email through a data driven subscription using
remote SMTP
ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
sending mail, CDO error -2147220977, will not resend
ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
sending email. System.Runtime.InteropServices.COMException (0x8004020F): The
server rejected one or more recipient addresses. The server response was:
550 must be authenticated
at ReportingServicesCDOInterop.MessageClass.Send()
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
notification)
I am logging to my m/c as a user with admin rights (No domain login). The
Reporting Service Service account is the same as login account. SQL agent
also runs as same user account.
SMTP is a ISP's. I have changed
<SendEmailToUserAlias>False</SendEmailToUserAlias>. In my Antivirus console
in Access protection I disabled prevent Mass Mailing worms from port 25. The
From Email is a valid email that I use with SMTP Server.
I am not sure how to resolve this authentication error. I have read
somewhere Reporting Service Service Account should have permission on SMTP
server. I don't know how this is possible with remote SMTP server.
Can someone help me with this? I have been trying to resolve this couple
of days now.
RegardsOn Dec 13, 7:34 pm, "Achuthan Sundar" <achu...@.cubisone.com> wrote:
> Hello All
> I have an issue sending email through a data driven subscription using
> remote SMTP
> ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
> sending mail, CDO error -2147220977, will not resend
> ReportingServicesService!emailextension!4!12/13/2007-07:29:52:: Error
> sending email. System.Runtime.InteropServices.COMException (0x8004020F): The
> server rejected one or more recipient addresses. The server response was:
> 550 must be authenticated
> at ReportingServicesCDOInterop.MessageClass.Send()
> at
> Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification
> notification)
> I am logging to my m/c as a user with admin rights (No domain login). The
> Reporting Service Service account is the same as login account. SQL agent
> also runs as same user account.
> SMTP is a ISP's. I have changed
> <SendEmailToUserAlias>False</SendEmailToUserAlias>. In my Antivirus console
> in Access protection I disabled prevent Mass Mailing worms from port 25. The
> From Email is a valid email that I use with SMTP Server.
> I am not sure how to resolve this authentication error. I have read
> somewhere Reporting Service Service Account should have permission on SMTP
> server. I don't know how this is possible with remote SMTP server.
> Can someone help me with this? I have been trying to resolve this couple
> of days now.
> Regards
This link might help.
http://www.systemwebmail.com/faq/4.3.2.aspx
Regards,
Enrique Martinez
Sr. Software Consultant