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
>