Can't delete or overwrite report

When I try to delete this report from the admin it times out, same if I try
to republish from the report designer. I am admin on the box and in reporting
services.
Error looks like:
System.Web.Services.Protocols.SoapException: Server was unable to process
request. --> System.Data.SqlClient.SqlException: Timeout expired. The
timeout period elapsed prior to completion of the operation or the server is
not responding. 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.DBInterface.DeleteObject(String
objectName) at
Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at
Microsoft.ReportingServices.Library.RSService.DeleteItem(CallParameters
parameters) at
Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at
Microsoft.ReportingServices.WebServer.ReportingService.ExecuteBatch() --
End of inner exception stack trace --
How can I delete the report?I have the exact same problem. I can move the report to another folder but
any attempt to delete it or overwrite it via Designer results in the Server
going to 100% CPU utilisation and everything grinding to a halt until the
timeout error below appears.
Can someone please help us? Thanks.
"bmurtha" wrote:
> When I try to delete this report from the admin it times out, same if I try
> to republish from the report designer. I am admin on the box and in reporting
> services.
> Error looks like:
> System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server is
> not responding. 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.DBInterface.DeleteObject(String
> objectName) at
> Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at
> Microsoft.ReportingServices.Library.RSService.DeleteItem(CallParameters
> parameters) at
> Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at
> Microsoft.ReportingServices.WebServer.ReportingService.ExecuteBatch() --
> End of inner exception stack trace --
> How can I delete the report?|||I finally deleted the culprit report by removing it from the ReportServer
database. First identify the datasource it is using and then delete the
datasource from this table:
reportserver.dbo.[datasource]
If it's shared you will have to recreate it again afterwards.
Then delete the offending report from:
reportserver.dbo.[catalog]
That did it for me, but obviously I have no idea what the consequences might
be!
"bmurtha" wrote:
> When I try to delete this report from the admin it times out, same if I try
> to republish from the report designer. I am admin on the box and in reporting
> services.
> Error looks like:
> System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.Data.SqlClient.SqlException: Timeout expired. The
> timeout period elapsed prior to completion of the operation or the server is
> not responding. 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.DBInterface.DeleteObject(String
> objectName) at
> Microsoft.ReportingServices.Library.RSService._DeleteItem(String item) at
> Microsoft.ReportingServices.Library.RSService.DeleteItem(CallParameters
> parameters) at
> Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId) at
> Microsoft.ReportingServices.WebServer.ReportingService.ExecuteBatch() --
> End of inner exception stack trace --
> How can I delete the report?