Error when deleting report in Report Manager and SQL Management Studio

I am getting a rsInternalError when I try to delete a report in Report Manager and SQL Management Studio. I am able to deploy, move (as long as the report doesn't exist at the destination) and upload but not delete.

This is the error dump:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3050.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.10\Reporting Services\LogFiles\ReportServer__09_19_2007_00_02_45.log</Path>
<SystemName>HLTHS2</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!9/19/2007-00:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-00:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-00:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-00:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-01:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-01:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-02:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-02:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-02:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-03:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-04:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-04:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-05:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-05:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:02:48:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-06:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-07:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-09:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!09/19/2007-09:07:20:: Call to GetItemTypeAction(/Test).
w3wp!library!1!09/19/2007-09:07:21:: Call to CreateFolderAction(Test, /).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources/Warehouse).
w3wp!library!5!09/19/2007-09:07:22:: Call to GetItemTypeAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:07:25:: Call to CreateReportAction(Invoice Balance, /Test, True).
w3wp!library!7!09/19/2007-09:07:29:: Call to SetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPermissionsAction(/).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to ListChildrenAction(/, False).
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:29:: Call to GetPermissionsAction(/Test).
w3wp!library!1!09/19/2007-09:08:29:: Call to GetPropertiesAction(/Test, PathBased).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!9/19/2007-09:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!09/19/2007-09:15:04:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:04:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:05:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!1!09/19/2007-09:15:05:: Call to ListEventsAction().
w3wp!library!1!09/19/2007-09:15:08:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:13:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:15:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:18:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!1!09/19/2007-09:15:18:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!7!09/19/2007-09:15:18:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:18:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!5!09/19/2007-09:15:18:: Call to DeleteItemAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:19:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item)
Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item)
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

w3wp!library!5!09/19/2007-09:15:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component library;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

The error in the event log is:

EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 45cd6edb, P7 0, P8 00005253, P9 00000000, P10 NIL.

Thanks in advance!

Lori

Just a few things that might be worth doing.

Have you got all of the latest Service Packs installed? That is Service Pack 2 for SQL Server 2005.

Are you an Administrator, Content Manager or Publisher in Report Manager? You could check the Site Settings then look at the 3 links in the Security pane to make sure you are allocated the correct levels of security to complete the tasks.

Graham

|||

Yes, I have Service Pack 2 installed for SQL Server 2005 (vers. 9.00.3050) and all the permissions are setup correctly. I'm setup as the browser, content manager, my reports, publisher and report builder. I'm also part of the Administrators group.

Lori

|||

Has anyone figured this out yet? I have the same problem. I have SP2 installed and have all roles assigned to my user account. No one else (admins and such) can delete either. We can do everything else such as deploy and run, but not delete.

|||

I turned off the global "NOCOUNT" for SQL Server and this fixed my problem.

Lori

Error when deleting report in Report Manager and SQL Management Studio

I am getting a rsInternalError when I try to delete a report in Report Manager and SQL Management Studio. I am able to deploy, move (as long as the report doesn't exist at the destination) and upload but not delete.

This is the error dump:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3050.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.10\Reporting Services\LogFiles\ReportServer__09_19_2007_00_02_45.log</Path>
<SystemName>HLTHS2</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!9/19/2007-00:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-00:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-00:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-00:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-00:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-01:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-01:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-01:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-02:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-02:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-02:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-02:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-03:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-03:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-03:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-04:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-04:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-04:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-05:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-05:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-05:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-05:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:02:48:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!9/19/2007-06:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-06:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-07:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-07:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-07:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:22:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:32:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!7!9/19/2007-08:42:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!1!9/19/2007-08:52:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!9/19/2007-09:02:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!5!09/19/2007-09:07:20:: Call to GetItemTypeAction(/Test).
w3wp!library!1!09/19/2007-09:07:21:: Call to CreateFolderAction(Test, /).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources).
w3wp!library!7!09/19/2007-09:07:21:: Call to GetItemTypeAction(/Data Sources/Warehouse).
w3wp!library!5!09/19/2007-09:07:22:: Call to GetItemTypeAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:07:25:: Call to CreateReportAction(Invoice Balance, /Test, True).
w3wp!library!7!09/19/2007-09:07:29:: Call to SetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPermissionsAction(/).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!7!09/19/2007-09:08:25:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to ListChildrenAction(/, False).
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:25:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:08:29:: Call to GetPermissionsAction(/Test).
w3wp!library!1!09/19/2007-09:08:29:: Call to GetPropertiesAction(/Test, PathBased).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:08:29:: Call to GetSystemPropertiesAction().
w3wp!library!6!9/19/2007-09:12:45:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
w3wp!library!6!09/19/2007-09:15:04:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:04:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:04:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:05:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!1!09/19/2007-09:15:05:: Call to ListEventsAction().
w3wp!library!1!09/19/2007-09:15:08:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:13:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetSystemPropertiesAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:14:: Call to GetSystemPermissionsAction().
w3wp!library!6!09/19/2007-09:15:14:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/, False).
w3wp!library!6!09/19/2007-09:15:14:: Call to ListChildrenAction(/Test, False).
w3wp!library!5!09/19/2007-09:15:14:: Call to GetItemDataSourcesAction(/Test/Invoice Balance).
w3wp!library!6!09/19/2007-09:15:15:: Call to GetSystemPropertiesAction().
w3wp!library!1!09/19/2007-09:15:18:: Call to GetPermissionsAction(/Test/Invoice Balance).
w3wp!library!1!09/19/2007-09:15:18:: Call to GetSystemPropertiesAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!7!09/19/2007-09:15:18:: Call to GetReportParametersAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:18:: Call to GetSystemPermissionsAction().
w3wp!library!5!09/19/2007-09:15:18:: Call to GetPropertiesAction(/Test/Invoice Balance, PathBased).
w3wp!library!5!09/19/2007-09:15:18:: Call to DeleteItemAction(/Test/Invoice Balance).
w3wp!library!5!09/19/2007-09:15:19:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.DeleteItem(String Item)
Microsoft.ReportingServices.WebServer.ReportingService2005.DeleteItem(String Item)
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication+ApplicationStepManager.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

w3wp!library!5!09/19/2007-09:15:19:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component library;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.

The error in the event log is:

EventType sql90exception, P1 w3wp.exe, P2 6.0.3790.1830, P3 42435be1, P4 reportingservicesnativeclient.ni.dll, P5 2005.90.3042.0, P6 45cd6edb, P7 0, P8 00005253, P9 00000000, P10 NIL.

Thanks in advance!

Lori

Just a few things that might be worth doing.

Have you got all of the latest Service Packs installed? That is Service Pack 2 for SQL Server 2005.

Are you an Administrator, Content Manager or Publisher in Report Manager? You could check the Site Settings then look at the 3 links in the Security pane to make sure you are allocated the correct levels of security to complete the tasks.

Graham

|||

Yes, I have Service Pack 2 installed for SQL Server 2005 (vers. 9.00.3050) and all the permissions are setup correctly. I'm setup as the browser, content manager, my reports, publisher and report builder. I'm also part of the Administrators group.

Lori

|||

Has anyone figured this out yet? I have the same problem. I have SP2 installed and have all roles assigned to my user account. No one else (admins and such) can delete either. We can do everything else such as deploy and run, but not delete.

|||

I turned off the global "NOCOUNT" for SQL Server and this fixed my problem.

Lori

Error when deleting a folder in Report Manager

Hi
I received the error message pasted below, when I tried to delete a folder
through Report Manager. There have been no problems deleting folders, until
now. (SP1 has not, as of yet, been applied)
Does anyone know what could cause this error and what the best solution is
in the event it happens again?
"System.Web.Services.Protocols.SoapException: Server was unable to process
request. --> System.Data.SqlClient.SqlException: The COMMIT TRANSACTION
request has no corresponding BEGIN TRANSACTION. at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
TdsParserState state) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
TdsParserState state) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at
System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand cmdHandler,
SqlDataReader dataStream) at
System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
sqlBatch, String method) at
System.Data.SqlClient.SqlConnection.ExecuteTransaction(String sqlBatch,
String method) at System.Data.SqlClient.SqlTransaction.Commit() at
Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()
at Microsoft.ReportingServices.Library.RSService.DisconnectStorage() at
Microsoft.ReportingServices.Library.RSService.CreateBatch() at
Microsoft.ReportingServices.WebServer.ReportingService.CreateBatch(String&
BatchID) -- End of inner exception stack trace --"
Thanks,
MarkThe problem was that the report server was out of disk space.
Mark
"MCC" <cmc_za@.hotmail.com> wrote in message
news:%23ClGvUpWEHA.1380@.TK2MSFTNGP09.phx.gbl...
> Hi
> I received the error message pasted below, when I tried to delete a folder
> through Report Manager. There have been no problems deleting folders,
until
> now. (SP1 has not, as of yet, been applied)
> Does anyone know what could cause this error and what the best solution is
> in the event it happens again?
> "System.Web.Services.Protocols.SoapException: Server was unable to process
> request. --> System.Data.SqlClient.SqlException: The COMMIT TRANSACTION
> request has no corresponding BEGIN TRANSACTION. at
> System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
> TdsParserState state) at
> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
> TdsParserState state) at
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at
> System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand
cmdHandler,
> SqlDataReader dataStream) at
> System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String
> sqlBatch, String method) at
> System.Data.SqlClient.SqlConnection.ExecuteTransaction(String sqlBatch,
> String method) at System.Data.SqlClient.SqlTransaction.Commit() at
> Microsoft.ReportingServices.Library.ConnectionManager.CommitTransaction()
> at Microsoft.ReportingServices.Library.RSService.DisconnectStorage() at
> Microsoft.ReportingServices.Library.RSService.CreateBatch() at
> Microsoft.ReportingServices.WebServer.ReportingService.CreateBatch(String&
> BatchID) -- End of inner exception stack trace --"
> Thanks,
> Mark
>

Error when deleting

I have a msde back end for my application.
I also have an Access data file with linked tables to the SQL one.
My app accesses the data through the Access one through ODBC.

I have a data control and when try to delete a record as so:
DataControl.Recordset.Delete
I get a 'ODBC Call Failed' error.

Any ideas why?
The recordset's updateable property is true.

Thanks,THAT is the reason why I hate bound controls! Throw them away, replace dynamic calls with sp's, and live happily ever after! You think you have problems now while developing? Try putting it into prod, with more than 1 user, and you'll see what I mean (this is not an attack, just my heart screaming "WATCH OUT! THIS IS NOT A LIGHT AT THE END OF THE TUNNEL! IT IS A TRAIN!")|||Have you posted this on the Access forum for input?

Have you considered changing your Access interface to an Access Data Project? It synchronizes with SQL Server much better.

Have you checked to make sure that each of your linked tables has an enforced unique key and that Access was aware of this key when your table was linked?

Have you checked that your login has permission to delete those records?

Have you checked to be sure that the records in the table are participating in non-cascading relationships with other tables?|||...Have you checked it's plugged in?

Have you checked its pulse?

Have you checked your pulse?

...Have you checked if the neiborhood bar has started the happy hour? Go check it! It helps me!|||Here is my ms_sql_dba approved response:

OBVIOUSLY it is plugged in, or he wouldn't be getting an error message! But you didn't THINK about that, did you? And computers don't HAVE pulses, which you'd know if you bothered to read the manual!|||...?...|||...That was a joke...though I know I was accused of making my jokes somewhat untranslateable at times...But hey, that's what made me what I am, so there you have it!|||Originally posted by blindman
Here is my ms_sql_dba approved response:

OBVIOUSLY it is plugged in, or he wouldn't be getting an error message! But you didn't THINK about that, did you? And computers don't HAVE pulses, which you'd know if you bothered to read the manual!

Incorrigible

error S0022 while deleting

Hi,
I have this query to delete a company and it goes like
this:
<cfquery ......>
delete from companies
where companyname = '#url.object#'
</cfquery>
I end up getting the error code S0022 column not found
and it goes on to say
Invalid column name 'companyname'.
I went to SQL server and typed in a query:
delete from companies
where companyname = 'somecompany'
it still gave me the same error.
I used to have companyname as the PK but now it's
companyid.
so i tried using companyid in the where clause and it
still gave me the same error even
in sql server. Usually this error has to do with quotes
but since i'm typing the query straight
into sql server and running it properly and it doesn't
work, it must be something else.
Please advise.
Thanks,
PremSQL Server doesn't have errors like S0022. What do you mean that you went to
SQL Server? Do you mean to the SQL Server machine? Or do you mean Query
Analyzer, which is a client tool for communicating with SQL Server? Can you
please post the exact error message that you copy and paste from Query
Analyzer.
If you meant 50022, then it is a user defined error, and my guess would be
that there is delete trigger on the table.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"premzero" <premzero@.hotmail.com> wrote in message
news:031301c39126$aad38700$a401280a@.phx.gbl...
> Hi,
> I have this query to delete a company and it goes like
> this:
> <cfquery ......>
> delete from companies
> where companyname = '#url.object#'
> </cfquery>
> I end up getting the error code S0022 column not found
> and it goes on to say
> Invalid column name 'companyname'.
> I went to SQL server and typed in a query:
> delete from companies
> where companyname = 'somecompany'
> it still gave me the same error.
> I used to have companyname as the PK but now it's
> companyid.
> so i tried using companyid in the where clause and it
> still gave me the same error even
> in sql server. Usually this error has to do with quotes
> but since i'm typing the query straight
> into sql server and running it properly and it doesn't
> work, it must be something else.
> Please advise.
> Thanks,
> Prem
>|||When I run it on the SQL Server machine it simply gives
me the message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid
column name 'companyname'.
When I run it on SQL query analyser it says:
Server: Msg 207, Level 16, State 3, Procedure
trigger_delete_companyname, Line 6
Invalid column name 'companyname'.
So it must be the trigger as mentioned above. I'm not too
familiar with SQL server. Where are the triggers
accessible from? I'm looking under stored procedures in
sql enterprise manager and can't see it under there.
>--Original Message--
>SQL Server doesn't have errors like S0022. What do you
mean that you went to
>SQL Server? Do you mean to the SQL Server machine? Or do
you mean Query
>Analyzer, which is a client tool for communicating with
SQL Server? Can you
>please post the exact error message that you copy and
paste from Query
>Analyzer.
>If you meant 50022, then it is a user defined error, and
my guess would be
>that there is delete trigger on the table.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"premzero" <premzero@.hotmail.com> wrote in message
>news:031301c39126$aad38700$a401280a@.phx.gbl...
>> Hi,
>> I have this query to delete a company and it goes like
>> this:
>> <cfquery ......>
>> delete from companies
>> where companyname = '#url.object#'
>> </cfquery>
>> I end up getting the error code S0022 column not found
>> and it goes on to say
>> Invalid column name 'companyname'.
>> I went to SQL server and typed in a query:
>> delete from companies
>> where companyname = 'somecompany'
>> it still gave me the same error.
>> I used to have companyname as the PK but now it's
>> companyid.
>> so i tried using companyid in the where clause and it
>> still gave me the same error even
>> in sql server. Usually this error has to do with quotes
>> but since i'm typing the query straight
>> into sql server and running it properly and it doesn't
>> work, it must be something else.
>> Please advise.
>> Thanks,
>> Prem
>
>.
>|||Ok I figured it out. Just right click a table and manage
triggers. I've changed it and it works fine now.
thanks alot!
>--Original Message--
>SQL Server doesn't have errors like S0022. What do you
mean that you went to
>SQL Server? Do you mean to the SQL Server machine? Or do
you mean Query
>Analyzer, which is a client tool for communicating with
SQL Server? Can you
>please post the exact error message that you copy and
paste from Query
>Analyzer.
>If you meant 50022, then it is a user defined error, and
my guess would be
>that there is delete trigger on the table.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"premzero" <premzero@.hotmail.com> wrote in message
>news:031301c39126$aad38700$a401280a@.phx.gbl...
>> Hi,
>> I have this query to delete a company and it goes like
>> this:
>> <cfquery ......>
>> delete from companies
>> where companyname = '#url.object#'
>> </cfquery>
>> I end up getting the error code S0022 column not found
>> and it goes on to say
>> Invalid column name 'companyname'.
>> I went to SQL server and typed in a query:
>> delete from companies
>> where companyname = 'somecompany'
>> it still gave me the same error.
>> I used to have companyname as the PK but now it's
>> companyid.
>> so i tried using companyid in the where clause and it
>> still gave me the same error even
>> in sql server. Usually this error has to do with quotes
>> but since i'm typing the query straight
>> into sql server and running it properly and it doesn't
>> work, it must be something else.
>> Please advise.
>> Thanks,
>> Prem
>
>.
>