Cannot Delete Report - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Cannot Delete Report

Author

Topic

pshaw
Starting Member

5 Posts

Posted - 2013-05-22 : 13:00:04

I just installed SSRS on a new server, Windows 2003 Server. I can publish and move reports between directories, but I cannot delete a report or directory. I get this error message: An internal error occurred on the report server. See the error log for more details. The log file doesn't offer much help either:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.5057.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__05_22_2013_10_55_32.log</Path>
<SystemName>DB-PLATFORM</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!webserver!1!5/22/2013-10:55:32:: i INFO: Reporting Web Server started
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!5/22/2013-10:55:32:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!5/22/2013-10:55:32:: i INFO: Reporting Services starting SKU: Standard
w3wp!resourceutilities!1!5/22/2013-10:55:32:: i INFO: Evaluation copy: 0 days left
w3wp!resourceutilities!1!5/22/2013-10:55:32:: i INFO: Running on 1 physical processors, 4 logical processors
w3wp!runningjobs!1!5/22/2013-10:55:32:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!5/22/2013-10:55:32:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/22/2013-10:55:32:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!5/22/2013-10:55:32:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!05/22/2013-10:55:33:: Call to GetPermissionsAction(/).
w3wp!library!1!05/22/2013-10:55:33:: i INFO: Catalog SQL Server Edition = Standard
w3wp!library!1!05/22/2013-10:55:33:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!1!05/22/2013-10:55:33:: Call to GetSystemPermissionsAction().
w3wp!library!1!05/22/2013-10:55:33:: Call to ListChildrenAction(/, False).
w3wp!library!1!05/22/2013-10:55:33:: Call to GetSystemPropertiesAction().
w3wp!library!1!05/22/2013-10:55:33:: Call to GetSystemPropertiesAction().
w3wp!library!1!05/22/2013-10:55:41:: Call to GetPermissionsAction(/).
w3wp!library!1!05/22/2013-10:55:41:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!1!05/22/2013-10:55:41:: Call to GetSystemPermissionsAction().
w3wp!library!7!05/22/2013-10:55:41:: Call to ListChildrenAction(/, False).
w3wp!library!1!05/22/2013-10:55:41:: Call to GetSystemPropertiesAction().
w3wp!library!1!05/22/2013-10:55:41:: Call to GetSystemPropertiesAction().
w3wp!library!5!05/22/2013-10:55:47:: Call to GetPermissionsAction(/).
w3wp!library!1!05/22/2013-10:55:47:: Call to GetPropertiesAction(/, PathBased).
w3wp!library!1!05/22/2013-10:55:47:: Call to GetSystemPermissionsAction().
w3wp!library!1!05/22/2013-10:55:47:: Call to ListChildrenAction(/, False).
w3wp!library!1!05/22/2013-10:55:47:: Call to GetSystemPropertiesAction().
w3wp!library!1!05/22/2013-10:55:48:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionNow()
Microsoft.ReportingServices.Library.DeleteItemAction.PerformActionInBatch(CallParameters parameters)
Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId)
Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ExecuteBatch()
Microsoft.ReportingServices.WebServer.ReportingService2005.ExecuteBatch()
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!1!05/22/2013-10:55:48:: 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.
w3wp!library!1!05/22/2013-10:55:48:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!05/22/2013-10:55:48:: Call to GetSystemPropertiesAction().

Can anyone help me solve this? Thanks, Phill

pshaw
Starting Member

5 Posts

Posted - 2013-05-29 : 17:02:27

Here is more information from the dump:
Microsoft (R) Windows Debugger Version 6.12.0002.633 X86
Copyright (c) Microsoft Corporation. All rights reserved.

Loading Dump File [C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0020.mdmp]
User Mini Dump File: Only registers, stack and portions of memory are available

Comment: 'Exception message: An internal error occurred on the report server. See the error log for more details. additional message: un-named assertion fired for component library'
Comment: 'Exception message: An internal error occurred on the report server. See the error log for more details. additional message: un-named assertion fired for component library'
Symbol search path is: SRV*c:\symbols*http://msdl.microsoft.com/download/symbols;srv*
Executable search path is:
Windows Server 2003 Version 3790 (Service Pack 2) MP (4 procs) Free x86 compatible
Product: Server, suite: Enterprise TerminalServer SingleUserTS
Machine Name:
Debug session time: Wed May 29 11:40:58.000 2013 (UTC - 5:00)
System Uptime: not available
Process Uptime: 0 days 0:00:28.000
................................................................
................................................................
................................................................
................................................................
................................................................
............................................................
Loading unloaded module list
.........
This dump file has an exception of interest stored in it.
The stored exception information can be accessed via .ecxr.
(13ec.7b8): Unknown exception - code 000042ac (first/second chance not available)
eax=04008010 ebx=00000000 ecx=00000010 edx=00000000 esi=00001eec edi=00000000
eip=7c82845c esp=207ce614 ebp=207ce684 iopl=0 nv up ei ng nz ac pe cy
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00000297
ntdll!KiFastSystemCallRet:
7c82845c c3 ret
0:029> !analyze -v
*******************************************************************************
* *
* Exception Analysis *
* *
*******************************************************************************

*** WARNING: Unable to verify checksum for ReportingServicesNativeClient.ni.dll
*** WARNING: Unable to verify checksum for mscorlib.ni.dll
*** WARNING: Unable to verify checksum for System.Web.Services.ni.dll
*** WARNING: Unable to verify checksum for System.Web.ni.dll
*** WARNING: Unable to verify checksum for System.ni.dll
*** WARNING: Unable to verify checksum for Microsoft.ReportingServices.Diagnostics.ni.dll
GetPageUrlData failed, server returned HTTP status 404
URL requested: http://watson.microsoft.com/StageOne/w3wp_exe/6_0_3790_3959/ReportingServicesNativeClient_ni_dll/2005_90_5000_0/0002e721.htm?Retriage=1

FAULTING_IP:
ReportingServicesNativeClient_ni!__dyn_tls_init_callback <PERF> (ReportingServicesNativeClient_ni+0x2e721)+0
4743e721 c6460801 mov byte ptr [esi+8],1

EXCEPTION_RECORD: ffffffff -- (.exr 0xffffffffffffffff)
ExceptionAddress: 4743e721 (ReportingServicesNativeClient_ni!__dyn_tls_init_callback <PERF> (ReportingServicesNativeClient_ni+0x2e721))
ExceptionCode: 000042ac
ExceptionFlags: 00000000
NumberParameters: 0

PROCESS_NAME: w3wp.exe

ERROR_CODE: (NTSTATUS) 0x42ac - <Unable to get error code text>

EXCEPTION_CODE: (Win32) 0x42ac (17068) - <Unable to get error code text>

MOD_LIST: <ANALYSIS/>

NTGLOBALFLAG: 0

MANAGED_STACK: !dumpstack -EE
No export dumpstack found

ADDITIONAL_DEBUG_TEXT: Followup set based on attribute [Is_ChosenCrashFollowupThread] from Frame:[0] on thread:[PSEUDO_THREAD]

LAST_CONTROL_TRANSFER: from 1efc0e95 to 77e4bef7

FAULTING_THREAD: ffffffff

DEFAULT_BUCKET_ID: NOSOS

PRIMARY_PROBLEM_CLASS: NOSOS

BUGCHECK_STR: APPLICATION_FAULT_NOSOS_WRONG_SYMBOLS_STACKIMMUNE

STACK_TEXT:
00000000 00000000 w3wp.exe+0x0

SYMBOL_NAME: w3wp.exe

FOLLOWUP_NAME: MachineOwner

MODULE_NAME: w3wp

IMAGE_NAME: w3wp.exe

DEBUG_FLR_IMAGE_TIMESTAMP: 45d6968e

STACK_COMMAND: ** Pseudo Context ** ; kb

FAILURE_BUCKET_ID: NOSOS_42ac_w3wp.exe!Unknown

BUCKET_ID: APPLICATION_FAULT_NOSOS_WRONG_SYMBOLS_STACKIMMUNE_w3wp.exe

FOLLOWUP_IP:
w3wp!_imp__RevertToSelf <PERF> (w3wp+0x0)+0
01000000 4d dec ebp

WATSON_STAGEONE_URL: http://watson.microsoft.com/StageOne/w3wp_exe/6_0_3790_3959/45d6968e/ReportingServicesNativeClient_ni_dll/2005_90_5000_0/4d027d5e/42ac/0002e721.htm?Retriage=1

Followup: MachineOwner

pshaw
Starting Member

5 Posts

Posted - 2013-05-30 : 10:44:16

Resolved! This is for anyone else that has the problem. With SQL you can set nocount on for all users which turns off the message returned at the end of each statement that states how many rows were affected. SSRS 2005 relies on this and NOCOUNT must be disabled for SSRS 2005 Stored procedures to work correctly

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources