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 saving package to msdb (IA64 - April CTP)

When attempting to save a copy of my .dtsx package (from BI Dev Studio), I get the following error. Any one have any ideas? - note: This is an IA64 machine running W2k3 Server (SP1). If I select * from msdb.dbo.sysdtspackages90 I get no rows.

Thanks!
=============================================

The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.). The SQL statement issued has failed.
(Microsoft Visual Studio)

-
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.ExistsOnSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

=============================================

The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.). The SQL statement issued has failed.

-
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.ExistsOnSQLServer(String bstrPackagePath, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.ExistsOnSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword)

Additional Info: I've been checking the public newsgroups and this error appears with SQL2000, too. Most proposed solutions relate to certificates being installed. I've checked the various places (xyz\certificates\personal) where the problem certificates might be and have found none, so uninstalling these certificates is not a solution.

Any other ideas? Any would be appreciated!

Thanks!|||I just blogged about this:
http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/09/15772.aspx
Basically, with earlier CTP releases you have two options, supply a self signed cert to the server or upgrade to the June CTP.
Thanks,
K