Unable to Remove Report Model
I am getting an Internal Error when I am trying to delete a report model from either the manager page or within Management Studio. When I look at the logs I get some information that really isn't telling me what is going on. Any help out there?
R
SQLDUMPER_ERRORLOG.Log
08/24/06 09:35:14, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 2492
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
08/24/06 09:35:14, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
08/24/06 09:35:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
08/24/06 09:35:22, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\SQLDmpr0008.mdmp
08/24/06 09:35:22, ACTION, aspnet_wp.exe, Watson Invoke: No
Normal ReportServer logfile
aspnet_wp!processing!1!8/24/2006-10:54:14:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown.
aspnet_wp!processing!1!8/24/2006-10:54:16:: e ERROR: An exception has occurred in data source 'dataSet'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The Sort expression used in grouping ‘table_Logo’ returned a data type that is not valid.
aspnet_wp!processing!1!8/24/2006-10:54:16:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
aspnet_wp!processing!1!8/24/2006-10:54:16:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The Sort expression used in grouping ‘table_Logo’ returned a data type that is not valid.
End of inner exception stack trace
aspnet_wp!processing!1!8/24/2006-10:54:16:: w WARN: Data source 'dataSource1': Report processing has been aborted.
aspnet_wp!processing!1!8/24/2006-10:54:16:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The Sort expression used in grouping ‘table_Logo’ returned a data type that is not valid.
End of inner exception stack trace
aspnet_wp!webserver!1!08/24/2006-10:54:16:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The Sort expression used in grouping ‘table_Logo’ returned a data type that is not valid.
aspnet_wp!library!1!08/24/2006-10:56:10:: i INFO: Call to SetModelDefinition('/Models/Therapy Source', def)
aspnet_wp!library!6!8/24/2006-10:56:31:: i INFO: Cleaned -1 batch records, -1 policies, 0 sessions, -1 cache entries, 0 snapshots, 0 chunks, -1 running jobs, -1 persisted streams
SQLDmpr0008.log
aspnet_wp!library!1!08/24/2006-09:35:13:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.Library.RSService._DeleteItem(String item)
Microsoft.ReportingServices.Library.RSService.ExecuteBatch(Guid batchId)
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.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)
aspnet_wp!library!1!08/24/2006-09:35:13:: 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.
