Cannot Delete Report

I have been using Reporting Services 2000 for a couple of years with
no issues. Now have verion 2005 installed and building some reports. I
created a report that no longer want and when I went to delete it by
"showing details", selecting the correct checkbox and clicking delete,
I am prompted to confirm that I want to delete but am getting the
following error: "An internal error has occured on the Report Server.
See the error log for more details. (rsInternalError)."
I checked the logs and have the following but it does not seem to
specify the reason for throwing the error:
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: An internal error
occurred on the report server. See the error log for more details. --
>
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details.
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
condition, String componentName)
at
Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
condition)
at
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
Item)
at
Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
Item)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean
asyncCall)
at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
Item)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
Item)
at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
at
Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
sender, EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
at
Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
want to install it on the Report Server. This link might provide some
insight. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
>
>
> > I have been using Reporting Services 2000 for a couple of years with
> > no issues. Now have verion 2005 installed and building some reports. I
> > created a report that no longer want and when I went to delete it by
> > "showing details", selecting the correct checkbox and clicking delete,
> > I am prompted to confirm that I want to delete but am getting the
> > following error: "An internal error has occured on the Report Server.
> > See the error log for more details. (rsInternalError)."
> > I checked the logs and have the following but it does not seem to
> > specify the reason for throwing the error:
> > System.Web.Services.Protocols.SoapException:
> > System.Web.Services.Protocols.SoapException: An internal error
> > occurred on the report server. See the error log for more details. --
> > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExcept=ion:
> > An internal error occurred on the report server. See the error log for
> > more details.
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Asser=t(Bo=ADolean
> > condition, String componentName)
> > at
> > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > condition)
> > at
> > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > -- End of inner exception stack trace --
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(S=trin=ADg
> > Item)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapC=lien=ADtMessage
> > message, WebResponse response, Stream responseStream, Boolean
> > asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> > at
> > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteIt=em(S=ADtring
> > Item)
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > Item)
> > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > at
> > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > sender, EventArgs e)
> > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > at
> > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > sourceControl, String eventArgument)
> > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > postData)
> > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> want to install it on the Report Server. This link might provide some
> insight. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant- Hide quoted text -
> - Show quoted text -
We did apply SP2 but it did not help the issue.|||I've seen the same thing, and I think it is a bug. Just click Edit from the
details view, and use the Delete function on that page.
--
Tom Garth
"davestub@.gmail.com" wrote:
> On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> >
> >
> >
> >
> >
> > > I have been using Reporting Services 2000 for a couple of years with
> > > no issues. Now have verion 2005 installed and building some reports. I
> > > created a report that no longer want and when I went to delete it by
> > > "showing details", selecting the correct checkbox and clicking delete,
> > > I am prompted to confirm that I want to delete but am getting the
> > > following error: "An internal error has occured on the Report Server.
> > > See the error log for more details. (rsInternalError)."
> >
> > > I checked the logs and have the following but it does not seem to
> > > specify the reason for throwing the error:
> >
> > > System.Web.Services.Protocols.SoapException:
> > > System.Web.Services.Protocols.SoapException: An internal error
> > > occurred on the report server. See the error log for more details. --
> >
> > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> > > An internal error occurred on the report server. See the error log for
> > > more details.
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Bo-olean
> > > condition, String componentName)
> > > at
> > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> > > condition)
> > > at
> > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > -- End of inner exception stack trace --
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(Strin-g
> > > Item)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClien-tMessage
> > > message, WebResponse response, Stream responseStream, Boolean
> > > asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(S-tring
> > > Item)
> > > at
> > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> > > Item)
> > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > at
> > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > sender, EventArgs e)
> > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> > > at
> > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> > > eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > sourceControl, String eventArgument)
> > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > postData)
> > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> >
> > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > want to install it on the Report Server. This link might provide some
> > insight. Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant- Hide quoted text -
> >
> > - Show quoted text -
> We did apply SP2 but it did not help the issue.
>|||On Sep 26, 9:36 am, Tom Garth <TomGa...@.discussions.microsoft.com>
wrote:
> I've seen the same thing, and I think it is a bug. Just click Edit from t=he
> details view, and use the Delete function on that page.
> --
> Tom Garth
>
> "daves...@.gmail.com" wrote:
> > On Sep 25, 5:27 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > > On Sep 25, 4:13 pm, daves...@.gmail.com wrote:
> > > > I have been using Reporting Services 2000 for a couple of years with
> > > > no issues. Now have verion 2005 installed and building some reports=. I
> > > > created a report that no longer want and when I went to delete it by
> > > > "showing details", selecting the correct checkbox and clicking dele=te,
> > > > I am prompted to confirm that I want to delete but am getting the
> > > > following error: "An internal error has occured on the Report Serve=r=2E
> > > > See the error log for more details. (rsInternalError)."
> > > > I checked the logs and have the following but it does not seem to
> > > > specify the reason for throwing the error:
> > > > System.Web.Services.Protocols.SoapException:
> > > > System.Web.Services.Protocols.SoapException: An internal error
> > > > occurred on the report server. See the error log for more details. =--
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogEx=ception:
> > > > An internal error occurred on the report server. See the error log =for
> > > > more details.
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.A=ssert(Bo=AD-olean
> > > > condition, String componentName)
> > > > at
> > > > Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Bo=olean
> > > > condition)
> > > > at
> > > > Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionN=ow()
> > > > at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > -- End of inner exception stack trace --
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005Impl.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteIt=em(Strin=AD-g
> > > > Item)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(S=oapClien=AD-tMessage
> > > > message, WebResponse response, Stream responseStream, Boolean
> > > > asyncCall)
> > > > at
> > > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > > methodName, Object[] parameters)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.ReportingService2005.Dele=teItem(S=AD-tring
> > > > Item)
> > > > at
> > > > Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(S=tring
> > > > Item)
> > > > at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> > > > at
> > > > Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> > > > sender, EventArgs e)
> > > > at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs= e)
> > > > at
> > > > Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(Stri=ng
> > > > eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > > > sourceControl, String eventArgument)
> > > > at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> > > > postData)
> > > > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > > > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > > If you have not yet installed SP1 or SP2 for SQL Server 2005, you will
> > > want to install it on the Report Server. This link might provide some
> > > insight. Hope this helps.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant- Hide quoted text -
> > > - Show quoted text -
> > We did apply SP2 but it did not help the issue.- Hide quoted text -
> - Show quoted text -
Just tried to delete from the properties page and received the same
error. Thanks for the suggestion.|||You have global "NOCOUNT" turned on on the SQL Server. Turn that off.
Reporting Services requires NOCOUNT off so that it knows that items/records
were actually deleted.
--
SQL Server Developer Support Engineer
"davestub@.gmail.com" wrote:
> I have been using Reporting Services 2000 for a couple of years with
> no issues. Now have verion 2005 installed and building some reports. I
> created a report that no longer want and when I went to delete it by
> "showing details", selecting the correct checkbox and clicking delete,
> I am prompted to confirm that I want to delete but am getting the
> following error: "An internal error has occured on the Report Server.
> See the error log for more details. (rsInternalError)."
> I checked the logs and have the following but it does not seem to
> specify the reason for throwing the error:
> System.Web.Services.Protocols.SoapException:
> System.Web.Services.Protocols.SoapException: An internal error
> occurred on the report server. See the error log for more details. --
> >
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details.
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTraceInternal.Assert(Boolean
> condition, String componentName)
> at
> Microsoft.ReportingServices.Diagnostics.Utilities.RSTrace.Assert(Boolean
> condition)
> at
> Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
> at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> -- End of inner exception stack trace --
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String
> Item)
> at
> Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String
> Item)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean
> asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices2005.ReportingService2005.DeleteItem(String
> Item)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.DeleteItem(String
> Item)
> at Microsoft.ReportingServices.UI.BaseProperties.DoDelete()
> at
> Microsoft.ReportingServices.UI.BaseProperties.DeleteBtn_Click(Object
> sender, EventArgs e)
> at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
> at
> Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String
> eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection
> postData)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
>