Hi all,
i have copied out the database backup from development center to my local machine,it is having approx.8GB in size and when
i m trying to restote this database backup in SQL Server 2000 it is showing me error.
An internal consistency error occurred. Contact Technical Support for assistance.
RESTORE DATABASE is terminating abnormally.
Plz. anyone can help me..
mukul:confused:
I think I'm hosed...anyone ever seen this before?
Server: Msg 3270, Level 16, State 1, Line 1
An internal consistency error occurred. Contact Technical Support for assistance.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
We have received a backup of a database from an external company for a project that we are taking over. We have attempted to restore the database and it fails giving us the error: "Internal consistency error occurred."
We have run the restore verifyonly command with the results: "The backup set is valid." However, I don't have confidence that the verify is telling the complete story.
It appears that the database is restored and the overall restore is failing on the transaction log file.
Any help is appreciated. This is rather urgent.
I have been running log shipping for more than a year now and it has been very successful until just recently. For some reason the SQL Agent jobs that backup the database, ship it across the network to a standby server and restore it are failing. On the source server the backup process is running, the log shipping is running however when it tries to restore it on the destination server it fails with the following error:
SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 3013 (BC5) Error string: RESTORE DATABASE is terminating abnormally. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217900 (80040E14); Provider Error: 3270 (CC6) Error string: An internal consistency error occurred. Contact Technical Support for assistance. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: 0 (0); Provider Error: 3211 (C8B) Error string: 10 percent restored. Error source: Microsoft OLE DB Prov... Process Exit Code 1. The step failed.
If I delete the database on the destination server, re-run the sql agent job that ships the backup job, and re-run the restore job on the destination server the process will succeed without error. This tells me the original backup was fine but something may have been lost during the shipping. Have you ever seen this message before? What does it mean and what should I be looking at to resolve the error?
Thank you.
MBeal
I have a sql databaseI run dbcc checkdb and get no errorsI go to backup the database in enterprise manager, and it won'trestore because it has internal consistency errorsI can go back to an older version of the databaseI run a particular procedure in our accounting software packageNever do I get errors when running dbcc checkdbSometimes I get the backup and restore problem, sometimes I don'tI am doing this on a test server with about 220 megs of RAMI am trying the dbcc checkdb ('dbname',REPAIR_REBUILD) commandAny other ideas?
View 2 Replies View RelatedI am trying to restore a production database backup to a new location on a development workstation, and it fails with "An internal consistency error occurred, Contact Support". When I tried this on a more powerful workstation it ran without a hitch. The db is about 1.5GB, and I think the dev workstation may be running out of resources during the restore. I stopped non-essential services and ran from TSQL, and it still fails. Any suggestions other than getting a better workstation?
Thanks,
Rob
Hi all,
I am getting error message 'An internal consistency error occured sqlstate:42000" when i am trying to restore the database.
Regards,
Shashi.
We have reports deployed in the Report Server. While connecting from client, we are getting the error
"An internal error occurred on the report server. See the error log for more details. rsInternal Error)"
Then we went to Report Server, Reporting Service and SQL Server service are all are running fine.
Important thing is some time the reports are working fine, sometimes i am receiving this error. Please help.
We predict whether the services are automatically restarted or transaction logs exceeding the limit or any other parameters to set to avaoid this error?
Please help.
I have created an RDL file programatically. When I execute the code I get the error as mentioned below:
Error: Sub report cannot be shown.
An internal error occurred on the report server. See the error log for more details. (rsInternalError)
When I copy and paste the code of RDL file into new RDL file and try to preview the output I get correct result.
Note: The new RDL file does not give any error if the output is seen using preview tab but it gives the error only when executed from report viewer or from internet explorer.
Any Suggestion/feedback is highly appreciated.
Thank You.
The code of the sample RDL is shown below:
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource1">
<DataSourceReference>DataSource1</DataSourceReference>
<rd:DataSourceID>fe4806ee-0358-4a87-b764-ac5de049545e</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>0.25in</BottomMargin>
<RightMargin>0.25in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="machine_id">
<DataType>String</DataType>
<Prompt>machine_id</Prompt>
</ReportParameter>
<ReportParameter Name="from_date">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>From Date</Prompt>
</ReportParameter>
<ReportParameter Name="to_date">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>To Date</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Table Name="table1">
<DataSetName>Main_Report</DataSetName>
<TableGroups>
<TableGroup>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!syscode.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<Grouping Name="table1_Group1">
<PageBreakAtEnd>true</PageBreakAtEnd>
<GroupExpressions>
<GroupExpression>=Fields!syscode.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Subreport Name="subreport1">
<Parameters>
<Parameter Name="machine_id">
<Value>=Fields!machine_ip.Value</Value>
</Parameter>
<Parameter Name="syscode">
<Value>=Fields!syscode.Value</Value>
</Parameter>
<Parameter Name="from_date">
<Value>=Parameters!from_date.Value</Value>
</Parameter>
<Parameter Name="to_date">
<Value>=Parameters!to_date.Value</Value>
</Parameter>
</Parameters>
<ReportName>Holding_Summary_Multi_Period</ReportName>
</Subreport>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Details>
<TableColumns>
<TableColumn>
<Width>10.5in</Width>
</TableColumn>
</TableColumns>
<Height>0.5in</Height>
</Table>
</ReportItems>
<Height>0.75in</Height>
</Body>
<rd:ReportID>d0a1293a-e98c-4f75-9597-03426d2e7218</rd:ReportID>
<LeftMargin>0.25in</LeftMargin>
<DataSets>
<DataSet Name="Main_Report">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select account_syscode as syscode , 'display Name' as display_name , * from mars_customer_list
where machine_ip = @machine_id</CommandText>
<QueryParameters>
<QueryParameter Name="@machine_id">
<Value>=Parameters!machine_id.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>syscode</DataField>
</Field>
<Field Name="display_name">
<rd:TypeName>System.String</rd:TypeName>
<DataField>display_name</DataField>
</Field>
<Field Name="customer_syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>customer_syscode</DataField>
</Field>
<Field Name="account_syscode">
<rd:TypeName>System.Int64</rd:TypeName>
<DataField>account_syscode</DataField>
</Field>
<Field Name="machine_ip">
<rd:TypeName>System.String</rd:TypeName>
<DataField>machine_ip</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Code>Shared offset As Integer
Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer
If reset
offset = pagenumber - 1
End If
Return pagenumber - offset
End Function
</Code>
<Width>10.5in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Image Name="image1">
<Sizing>Fit</Sizing>
<Left>8.875in</Left>
<MIMEType />
<Width>1.5in</Width>
<Source>External</Source>
<Style />
<Value>bottom_right_logo.gif</Value>
</Image>
</ReportItems>
<Height>0.5in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>0.5in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>
Got this error running a query with ssms2014
on SqlServer2014
but db has Compatibiliy level 100 (sql2008)
no sql error code in message and no error found in eventviewr (sqlserver log, windows log, application log ecc)when i run that query i got this message in "messages" tab, and in results tab i got a strange result, indeed the value returned doesn't exists in table.
ex table1.field1 possible values= 2,3
it returns 1113344
we got that error thru jdbc too...that query use a lot of joins, unfortunatley i can't post it here. today got this error, so i make a copy of 1 of involved table into another db in the same instance, re run the query on the original db, and it works well.
Hi There,
I've got this error coming up while running the sql job for AS processing. I can't find anything about it on google or anywhere else. Has anyone had issues like this?
Code Snippet
Executed as user: xyzsvc_sqlsvr. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:21:02 PM Error: 2008-04-04 13:21:07.41 Code: 0xC1000000 Source: Analysis Services Processing Task Analysis Services Execute DDL Task Description: Internal error: An unexpected error occurred (file 'mdprocessdim.cpp', line 3429, function 'MDProcessPropertyJob::OnLaunch'). End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 1:21:02 PM Finished: 1:21:07 PM Elapsed: 5.141 seconds. The package execution failed. The step failed.
Thanks
Vivek
Hello everybody,
I am trying to use the reporting services on Windows 2003 with SQLServer 2005. Everything works fine in the report manager and I can access and render the reports without any problem. But when I try to access the reports directly with the URL from the ReportServer, I get the following error :
Reporting Services Error
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
SQL Server Reporting Services
So I went to see the error log, and here is what it says :
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__11_10_2006_13_43_22.log</Path>
<SystemName>VODAFONE</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!5!11/10/2006-13:43:23:: i INFO: Reporting Web Server started
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-13:43:23:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!5!11/10/2006-13:43:23:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!5!11/10/2006-13:43:23:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!5!11/10/2006-13:43:23:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!5!10/11/2006-13:43:23:: Unhandled exception was caught: Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance()
at Microsoft.Reporting.WebForms.ReportViewer.CreateServerReport()
at Microsoft.Reporting.WebForms.ReportViewer..ctor()
at Microsoft.ReportingServices.WebServer.ReportViewerHost..ctor()
at ASP.pages_reportviewer_aspx.__BuildControlReportViewerForm()
at ASP.pages_reportviewer_aspx.__BuildControlTree(pages_reportviewer_aspx __ctrl)
at ASP.pages_reportviewer_aspx.FrameworkInitialize()
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
w3wp!library!5!10/11/2006-13:43:23:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.Reporting.WebForms.InvalidConfigFileTypeException: The type Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 does not implement IReportServerConnection or could not be found
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.EnsurePropertyLoaded()
at Microsoft.Reporting.WebForms.ConfigFilePropertyInterface`1.GetInstance()
at Microsoft.Reporting.WebForms.ReportViewer.CreateServerReport()
at Microsoft.Reporting.WebForms.ReportViewer..ctor()
at Microsoft.ReportingServices.WebServer.ReportViewerHost..ctor()
at ASP.pages_reportviewer_aspx.__BuildControlReportViewerForm()
at ASP.pages_reportviewer_aspx.__BuildControlTree(pages_reportviewer_aspx __ctrl)
at ASP.pages_reportviewer_aspx.FrameworkInitialize()
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.pages_reportviewer_aspx.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--- End of inner exception stack trace ---
w3wp!library!5!10/11/2006-13:43:25:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!5!10/11/2006-13:43:26:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!webserver!5!11/10/2006-13:43:34:: i INFO: Reporting Web Server stopped
Does anyone have any idea about what happends ? Any suggestions maybe about anything I should try ?
Thanks very much in advance.
[edit] I just installed a few minutes ago the service pack 1 for SQL Server 2005 and Reporting services, but obviously it doesn't change anything to my problem. [/edit]
An internal error occurred on the report server. See the error log for more details. (rsInternalError) - This is the error I get when I try to edit a subcription then click finish.Where do I start in solving this?, heres the log -<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>GMT Daylight Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__06_14_2007_12_02_20.log</Path>
<SystemName>MCSCITRIX</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!14/06/2007-12:02:21:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!14/06/2007-12:06:09:: e ERROR: 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. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
w3wp!ui!5!14/06/2007-12:06:09:: e ERROR: HTTP status code --> 200
-------Details--------
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. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
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.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.UI.DataDrivenSubscription.Save()
at Microsoft.ReportingServices.UI.DataDrivenPropertiesControl.Buttons_FinishClick(Object sender, EventArgs args)
at Microsoft.ReportingServices.UI.WizardButtons.OnFinishedClicked(EventArgs args)
at Microsoft.ReportingServices.UI.WizardButtons.FinishButton_Click(Object sender, EventArgs args)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.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)
w3wp!ui!5!14/06/2007-12:06:09:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!b!6/14/2007-12:08:23:: e ERROR: 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. ---> System.Data.SqlClient.SqlException: Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.SqlAgentScheduler.DeleteTask(Guid id)
at Microsoft.ReportingServices.Library.SqlAgentScheduler.UpdateTask(Task task)
at Microsoft.ReportingServices.Library.SchedulingDBInterface.UpdateTaskProperties(Task task, Boolean updateSqlAgentSchedule)
at Microsoft.ReportingServices.Library.TimedSubscriptionHandler.ValidateSubscriptionData(Subscription subscription, String subscriptionData, UserContext userContext)
at Microsoft.ReportingServices.Library.SubscriptionManager.ValidateSubscriptionData(Subscription subscription, String eventType, String subscriptionData)
at Microsoft.ReportingServices.Library.SubscriptionManager.SetSubscriptionProperties(Guid id, String eventType, String matchData, ExtensionSettings extensionSettings, String description, ParameterValueOrFieldReference[] parameters, DataRetrievalPlan dataSettings)
at Microsoft.ReportingServices.Library.SetSubscriptionPropertiesAction.PerformActionNow()
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetSubscriptionProperties(String SubscriptionID, ExtensionSettings ExtensionSettings, Boolean isDataDriven, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
at Microsoft.ReportingServices.WebServer.ReportingService2005.SetDataDrivenSubscriptionProperties(String DataDrivenSubscriptionID, ExtensionSettings ExtensionSettings, DataRetrievalPlan DataRetrievalPlan, String Description, String EventType, String MatchData, ParameterValueOrFieldReference[] Parameters)
w3wp!ui!b!6/14/2007-12:08:23:: e ERROR: HTTP status code --> 200
-------Details--------
Why the error is coming:
"An internal error occurred on the report server. See the error log for more details. (rsInternalError)"
Well, I get the elusive error...
An internal error occurred on the report server. See the error log for more details.
I was trying to preview my report and this keeps coming up. I go to the logfiles to see what may be the issue and there are no errors in the log files(s). Can someone let me know what the usual path or name of the error log this is supposed to write to.
much appreciated,
Clint
I have rs2005 installed. I created some reports through SQL Server Business Intelligence Development Studio. I can preview reports fine in the studio. But after deploying it, on //localhost/reports, when I click the report, it takes a while to calculate and then give me error: "An internal error occurred on the report server. See the error log for more details. "
The weird thing is if I restart report service, it will display report fine on the first time, then fail on the following attempts.
Here is what's in the log file SQLDUMPER_ERRORLOG.log
03/20/06 16:48:18, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3808
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x000000004740E608
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
03/20/06 16:48:18, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
03/20/06 16:48:20, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
03/20/06 16:48:20, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0038.mdmp
03/20/06 16:48:20, ACTION, w3wp.exe, Watson Invoke: No
03/20/06 16:49:09, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3808
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x00000000086E2CF8
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
03/20/06 16:49:09, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
03/20/06 16:49:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
03/20/06 16:49:12, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0039.mdmp
03/20/06 16:49:12, ACTION, w3wp.exe, Watson Invoke: No
03/20/06 16:49:46, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 3808
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x00000000086E4128
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x0000000000000000
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x0000000000000000
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
03/20/06 16:49:46, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
03/20/06 16:49:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
03/20/06 16:49:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesSQLDmpr0040.mdmp
03/20/06 16:49:48, ACTION, w3wp.exe, Watson Invoke: No
Here is what is in SQL Dumpr0040.log:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Pacific Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__03_20_2006_16_48_01.log</Path>
<SystemName>MSI-SQL01</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!webserver!1!3/20/2006-16:48:02:: i INFO: Reporting Web Server started
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!3/20/2006-16:48:02:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!3/20/2006-16:48:02:: i INFO: Reporting Services starting SKU: Enterprise
w3wp!resourceutilities!1!3/20/2006-16:48:02:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!1!3/20/2006-16:48:02:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!3/20/2006-16:48:02:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!3/20/2006-16:48:02:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!3/20/2006-16:48:02:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!03/20/2006-16:48:05:: i INFO: Call to GetPermissions:/
w3wp!library!1!03/20/2006-16:48:05:: i INFO: Catalog SQL Server Edition = Enterprise
w3wp!library!5!03/20/2006-16:48:05:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:08:: i INFO: Call to GetPermissions:/StockSelfServie_Reports
w3wp!library!5!03/20/2006-16:48:09:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:10:: i INFO: Call to GetPermissions:/StockSelfServie_Reports/ESPP_Withdraw
w3wp!library!1!03/20/2006-16:48:10:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:12:: i INFO: Call to RenderFirst( '/StockSelfServie_Reports/ESPP_Withdraw' )
w3wp!library!1!03/20/2006-16:48:13:: Using folder C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesRSTempFiles for temporary files.
w3wp!webserver!1!03/20/2006-16:48:15:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Withdraw', Stream=''
w3wp!library!5!03/20/2006-16:48:17:: i INFO: Call to GetPermissions:/StockSelfServie_Reports
w3wp!library!5!03/20/2006-16:48:17:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:18:: i INFO: Call to GetPermissions:/StockSelfServie_Reports/ESPP_Withdraw
w3wp!library!1!03/20/2006-16:48:18:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:18:: i INFO: Call to RenderFirst( '/StockSelfServie_Reports/ESPP_Withdraw' )
w3wp!processing!1!03/20/2006-16:48:18:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.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)
w3wp!library!1!03/20/2006-16:48:18:: 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 processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
w3wp!library!1!03/20/2006-16:48:20:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!webserver!1!03/20/2006-16:48:21:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: 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.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
at Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!1!03/20/2006-16:48:24:: i INFO: Call to GetPermissions:/StockSelfServie_Reports
w3wp!library!1!03/20/2006-16:48:24:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:30:: i INFO: Call to GetPermissions:/StockSelfServie_Reports/ESPP_Enrollment
w3wp!library!1!03/20/2006-16:48:30:: i INFO: Call to GetSystemPermissions
w3wp!library!1!03/20/2006-16:48:30:: i INFO: Call to RenderFirst( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!webserver!1!03/20/2006-16:48:30:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Enrollment', Stream=''
w3wp!library!5!03/20/2006-16:48:37:: i INFO: Call to RenderNext( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!cache!5!03/20/2006-16:48:37:: i INFO: Session live: /StockSelfServie_Reports/ESPP_Enrollment
w3wp!webserver!5!03/20/2006-16:48:37:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Enrollment', Stream=''
w3wp!library!5!03/20/2006-16:48:38:: i INFO: Call to RenderNext( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!cache!5!03/20/2006-16:48:38:: i INFO: Session live: /StockSelfServie_Reports/ESPP_Enrollment
w3wp!webserver!5!03/20/2006-16:48:38:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Enrollment', Stream=''
w3wp!library!5!03/20/2006-16:48:38:: i INFO: Call to RenderNext( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!cache!5!03/20/2006-16:48:38:: i INFO: Session live: /StockSelfServie_Reports/ESPP_Enrollment
w3wp!webserver!5!03/20/2006-16:48:38:: i INFO: Processed report. Report='/StockSelfServie_Reports/ESPP_Enrollment', Stream=''
w3wp!library!5!03/20/2006-16:48:39:: i INFO: Call to RenderNext( '/StockSelfServie_Reports/ESPP_Enrollment' )
w3wp!processing!5!03/20/2006-16:48:39:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.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)
w3wp!library!5!03/20/2006-16:48:39:: 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 processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
w3wp!library!5!03/20/2006-16:49:12:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!webserver!5!03/20/2006-16:49:12:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: 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.ReportProcessing.ReportProcessing.UpdateTimingInformation(RunningJobContext jobContext, Int64 totalDurationMs, Int64 reportDataRetrievalDurationMs, Int64 reportRenderingDurationMs)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(IRenderingExtension renderer, CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderSnapshot(CreateReportChunk createChunkCallback, RenderingContext rc, GetResource getResourceCallback)
at Microsoft.ReportingServices.Library.RenderSnapshotAction.Render()
at Microsoft.ReportingServices.Library.RSService.RenderFromSessionNoCache(CatalogItemContext reportContext, ClientRequest session, RenderingResult& result)
at Microsoft.ReportingServices.Library.RSService.RenderFromSession(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderNext(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effecectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderNextCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RenderNextCancelableStep.RenderNext(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!5!03/20/2006-16:49:14:: i INFO: Call to GetPermissions:/StockSelfServie_Reports
w3wp!library!5!03/20/2006-16:49:14:: i INFO: Call to GetSystemPermissions
w3wp!library!5!03/20/2006-16:49:16:: i INFO: Call to GetPermissions:/StockSelfServie_Reports/ESPP_Change
w3wp!library!5!03/20/2006-16:49:16:: i INFO: Call to GetSystemPermissions
w3wp!library!5!03/20/2006-16:49:16:: i INFO: Call to RenderFirst( '/StockSelfServie_Reports/ESPP_Change' )
w3wp!processing!5!03/20/2006-16:49:16:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.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)
w3wp!library!5!03/20/2006-16:49:16:: 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 processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
Hi,
When I am trying to execute a delete query i'm getting the following error An internal error occurred. [ ID = 3639 ]. This is happening for some specific rows only. Other rows are getting deleted without any issues. Some 7 rows are there which i'm not able to delete. I am able to run update query on that rows. but not delete query
Pls help
Thanks
Nebu
Hello - can't find any info on this error - can anyone shed some light?
There was a deadlock - which preceeded this message by 2 seconds.
04/25/2007 08:20:12,spid108,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid108,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:12,spid108,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:12,spid108,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:12,spid108,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:12,spid108,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:12,spid108,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:12,spid108,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:12,spid108,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:12,spid108,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:12,spid108,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:12,spid108,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:12,spid108,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:12,spid108,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:12,spid108,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:12,spid108,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:12,spid108,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:12,spid108,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:12,spid108,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:12,spid108,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:12,spid108,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:12,spid108,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:12,spid108,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:12,spid108,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:12,spid108,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:12,spid108,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:12,spid108,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,* Short Stack Dump
04/25/2007 08:20:12,spid108,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,* SegSs: 00000023:
04/25/2007 08:20:12,spid108,Unknown,* Esp: 1302E584: 13025387 80C87378 80C872F0 00000000 78140001 0009D9C2
04/25/2007 08:20:12,spid108,Unknown,* EFlags: 00010202: 00610067 00650074 0049003B 0076006E 006C0061 00640069
04/25/2007 08:20:12,spid108,Unknown,* SegCs: 0000001B:
04/25/2007 08:20:12,spid108,Unknown,* Ebp: 1302F67C: 1302F788 01793310 13025373 80C872F0 7093AB12 801E8B38
04/25/2007 08:20:12,spid108,Unknown,* Eip: 0179438B: 828B118B 000000E0 C085D0FF 00B9850F 9D890000 FFFFEF8C
04/25/2007 08:20:12,spid108,Unknown,* Edx: 00000E38:
04/25/2007 08:20:12,spid108,Unknown,* Ecx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Ebx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Eax: A99EE598: 00000000 00000000 A99EE5B0 00000000 00000000 00000000
04/25/2007 08:20:12,spid108,Unknown,* Esi: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Edi: 80C872F0: 7093AB12 80C87FF0 00000007 B8A20008 7093AB15 00000000
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* dbghelp 14200000 14312FFF 00113000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 76780000 76913FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 764A0000 76633FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 76300000 76493FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 341D0000 343AFFFF 001e0000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 33590000 33764FFF 001d5000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 333F0000 33583FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 14490000 1467AFFF 001eb000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 13D10000 13EFBFFF 001ec000
04/25/2007 08:20:12,spid108,Unknown,* OLEDB32R 13770000 13780FFF 00011000
04/25/2007 08:20:12,spid108,Unknown,* MSDART 133D0000 133E9FFF 0001a000
04/25/2007 08:20:12,spid108,Unknown,* oledb32 13350000 133C8FFF 00079000
04/25/2007 08:20:12,spid108,Unknown,* msxml3 11BD0000 11CE1FFF 00112000
04/25/2007 08:20:12,spid108,Unknown,* msxmlsql 11AF0000 11BC5FFF 000d6000
04/25/2007 08:20:12,spid108,Unknown,* System.Xml 10FA0000 11193FFF 001f4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security 10F20000 10F61FFF 00042000
04/25/2007 08:20:12,spid108,Unknown,* System 10C10000 10EF3FFF 002e4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security.ni 10A90000 10B45FFF 000b6000
04/25/2007 08:20:12,spid108,Unknown,* System.Transactions 0FAD0000 0FB12FFF 00043000
04/25/2007 08:20:12,spid108,Unknown,* System.ni 7A440000 7ABFDFFF 007be000
04/25/2007 08:20:12,spid108,Unknown,* System.Data 102D0000 10596FFF 002c7000
04/25/2007 08:20:12,spid108,Unknown,* mscorjit 0F910000 0F962FFF 00053000
04/25/2007 08:20:12,spid108,Unknown,* SqlAccess 0F8A0000 0F8F5FFF 00056000
04/25/2007 08:20:12,spid108,Unknown,* SensApi 0F880000 0F884FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* cryptnet 0F680000 0F691FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* SOFTPUB 0F670000 0F674FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* mscorsec 0F640000 0F652FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* mscorlib.ni 0EAC0000 0F5A7FFF 00ae8000
04/25/2007 08:20:12,spid108,Unknown,* mscorwks 080E0000 08640FFF 00561000
04/25/2007 08:20:12,spid108,Unknown,* xplog70 07CA0000 07CA2FFF 00003000
04/25/2007 08:20:12,spid108,Unknown,* xplog70 07C80000 07C8BFFF 0000c000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90 07C50000 07C75FFF 00026000
04/25/2007 08:20:12,spid108,Unknown,* odbcint 07C30000 07C46FFF 00017000
04/25/2007 08:20:12,spid108,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
04/25/2007 08:20:12,spid108,Unknown,* BatchParser90 07A40000 07A5EFFF 0001f000
04/25/2007 08:20:12,spid108,Unknown,* ODBC32 07A00000 07A3CFFF 0003d000
04/25/2007 08:20:12,spid108,Unknown,* SQLSCM90 079E0000 079E8FFF 00009000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90 07980000 079C7FFF 00048000
04/25/2007 08:20:12,spid108,Unknown,* xpsqlbot 07960000 07965FFF 00006000
04/25/2007 08:20:12,spid108,Unknown,* msftepxy 07490000 074A4FFF 00015000
04/25/2007 08:20:12,spid108,Unknown,* SQLNCLIR 007A0000 007D2FFF 00033000
04/25/2007 08:20:12,spid108,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
04/25/2007 08:20:12,spid108,Unknown,* COMCTL32 77530000 775C6FFF 00097000
04/25/2007 08:20:12,spid108,Unknown,* sqlncli 337A0000 339C1FFF 00222000
04/25/2007 08:20:12,spid108,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
04/25/2007 08:20:12,spid108,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
04/25/2007 08:20:12,spid108,Unknown,* ntdsapi 766F0000 76704FFF 00015000
04/25/2007 08:20:12,spid108,Unknown,* wshtcpip 070B0000 070B7FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* hnetcfg 071F0000 07248FFF 00059000
04/25/2007 08:20:12,spid108,Unknown,* dssenh 070C0000 070E3FFF 00024000
04/25/2007 08:20:12,spid108,Unknown,* imagehlp 76C10000 76C38FFF 00029000
04/25/2007 08:20:12,spid108,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
04/25/2007 08:20:12,spid108,Unknown,* dbghelp 06C10000 06D22FFF 00113000
04/25/2007 08:20:12,spid108,Unknown,* msfte 069B0000 06C08FFF 00259000
04/25/2007 08:20:12,spid108,Unknown,* security 06190000 06193FFF 00004000
04/25/2007 08:20:12,spid108,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* winrnr 76F70000 76F76FFF 00007000
04/25/2007 08:20:12,spid108,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000
04/25/2007 08:20:12,spid108,Unknown,* RESUTILS 05D50000 05D62FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* CLUSAPI 05D30000 05D41FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
04/25/2007 08:20:12,spid108,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
04/25/2007 08:20:12,spid108,Unknown,* VERSION 77B90000 77B97FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* MTXCLU 05D10000 05D28FFF 00019000
04/25/2007 08:20:12,spid108,Unknown,* msvcp60 780C0000 78120FFF 00061000
04/25/2007 08:20:12,spid108,Unknown,* MSDTCPRX 05C90000 05D07FFF 00078000
04/25/2007 08:20:12,spid108,Unknown,* XOLEHLP 05C80000 05C85FFF 00006000
04/25/2007 08:20:12,spid108,Unknown,* COMRES 77010000 770D5FFF 000c6000
04/25/2007 08:20:12,spid108,Unknown,* schannel 76750000 76776FFF 00027000
04/25/2007 08:20:12,spid108,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
04/25/2007 08:20:12,spid108,Unknown,* kerberos 05BC0000 05C17FFF 00058000
04/25/2007 08:20:12,spid108,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
04/25/2007 08:20:12,spid108,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
04/25/2007 08:20:12,spid108,Unknown,* MSCOREE 05950000 05994FFF 00045000
04/25/2007 08:20:12,spid108,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
04/25/2007 08:20:12,spid108,Unknown,* rsaenh 04E90000 04EBEFFF 0002f000
04/25/2007 08:20:12,spid108,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
04/25/2007 08:20:12,spid108,Unknown,* SAMLIB 5CCF0000 5CCFEFFF 0000f000
04/25/2007 08:20:12,spid108,Unknown,* ole32 77670000 777A3FFF 00134000
04/25/2007 08:20:12,spid108,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
04/25/2007 08:20:12,spid108,Unknown,* SQLOS 344D0000 344D4FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 4F610000 4F7A3FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* instapi 48060000 48069FFF 0000a000
04/25/2007 08:20:12,spid108,Unknown,* psapi 76B70000 76B7AFFF 0000b000
04/25/2007 08:20:12,spid108,Unknown,* comctl32 77420000 77522FFF 00103000
04/25/2007 08:20:12,spid108,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
04/25/2007 08:20:12,spid108,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000
04/25/2007 08:20:12,spid108,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
04/25/2007 08:20:12,spid108,Unknown,* opends60 333E0000 333E6FFF 00007000
04/25/2007 08:20:12,spid108,Unknown,* USERENV 76920000 769E3FFF 000c4000
04/25/2007 08:20:12,spid108,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* WS2_32 71C00000 71C16FFF 00017000
04/25/2007 08:20:12,spid108,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
04/25/2007 08:20:12,spid108,Unknown,* Secur32 76F50000 76F62FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* MSASN1 76190000 761A1FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* CRYPT32 761B0000 76242FFF 00093000
04/25/2007 08:20:12,spid108,Unknown,* GDI32 77C00000 77C47FFF 00048000
04/25/2007 08:20:12,spid108,Unknown,* USER32 77380000 77411FFF 00092000
04/25/2007 08:20:12,spid108,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
04/25/2007 08:20:12,spid108,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
04/25/2007 08:20:12,spid108,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
04/25/2007 08:20:12,spid108,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
04/25/2007 08:20:12,spid108,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
04/25/2007 08:20:12,spid108,Unknown,* kernel32 77E40000 77F41FFF 00102000
04/25/2007 08:20:12,spid108,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
04/25/2007 08:20:12,spid108,Unknown,* sqlservr 01000000 02BCEFFF 01bcf000
04/25/2007 08:20:12,spid108,Unknown,* MODULE BASE END SIZE
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* Access Violation occurred reading address 00000000
04/25/2007 08:20:12,spid108,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:12,spid108,Unknown,* Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* 04/25/07 08:20:12 spid 108
04/25/2007 08:20:12,spid108,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,SqlDumpExceptionHandler: Process 108 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:12,spid108,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0007.txt
04/25/2007 08:20:12,spid108,Unknown,Using 'dbghelp.dll' version '4.0.5'
04/25/2007 08:20:12,spid60,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid60,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:10,spid60,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:10,spid60,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:10,spid60,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:10,spid60,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:10,spid60,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:10,spid60,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:10,spid60,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:10,spid60,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:10,spid60,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:10,spid60,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:10,spid60,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:10,spid60,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:10,spid60,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:10,spid60,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:10,spid60,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:10,spid60,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:10,spid60,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:10,spid60,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:10,spid60,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:10,spid60,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:10,spid60,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:10,spid60,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:10,spid60,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:10,spid60,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:10,spid60,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,* Short Stack Dump
04/25/2007 08:20:10,spid60,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,* SegSs: 00000023:
04/25/2007 08:20:10,spid60,Unknown,* Esp: 1189E584: 11895387 80C87378 80C872F0 00000000 03E90001 00087C2D
04/25/2007 08:20:10,spid60,Unknown,* EFlags: 00010202: 00610067 00650074 0049003B 0076006E 006C0061 00640069
04/25/2007 08:20:10,spid60,Unknown,* SegCs: 0000001B:
04/25/2007 08:20:10,spid60,Unknown,* Ebp: 1189F67C: 1189F788 01793310 11895373 80C872F0 7093AB12 801E8B38
04/25/2007 08:20:10,spid60,Unknown,* Eip: 0179438B: 828B118B 000000E0 C085D0FF 00B9850F 9D890000 FFFFEF8C
04/25/2007 08:20:10,spid60,Unknown,* Edx: 00000E38:
04/25/2007 08:20:10,spid60,Unknown,* Ecx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Ebx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Eax: 5ADE8598: 00000000 00000000 5ADE85B0 00000000 00000000 00000000
04/25/2007 08:20:10,spid60,Unknown,* Esi: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Edi: 80C872F0: 7093AB12 80C87FF0 00000007 B8A20008 7093AB15 00000000
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* dbghelp 14200000 14312FFF 00113000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 76780000 76913FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 764A0000 76633FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 76300000 76493FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 341D0000 343AFFFF 001e0000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 33590000 33764FFF 001d5000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 333F0000 33583FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 14490000 1467AFFF 001eb000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 13D10000 13EFBFFF 001ec000
04/25/2007 08:20:10,spid60,Unknown,* OLEDB32R 13770000 13780FFF 00011000
04/25/2007 08:20:10,spid60,Unknown,* MSDART 133D0000 133E9FFF 0001a000
04/25/2007 08:20:10,spid60,Unknown,* oledb32 13350000 133C8FFF 00079000
04/25/2007 08:20:10,spid60,Unknown,* msxml3 11BD0000 11CE1FFF 00112000
04/25/2007 08:20:10,spid60,Unknown,* msxmlsql 11AF0000 11BC5FFF 000d6000
04/25/2007 08:20:10,spid60,Unknown,* System.Xml 10FA0000 11193FFF 001f4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security 10F20000 10F61FFF 00042000
04/25/2007 08:20:10,spid60,Unknown,* System 10C10000 10EF3FFF 002e4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security.ni 10A90000 10B45FFF 000b6000
04/25/2007 08:20:10,spid60,Unknown,* System.Transactions 0FAD0000 0FB12FFF 00043000
04/25/2007 08:20:10,spid60,Unknown,* System.ni 7A440000 7ABFDFFF 007be000
04/25/2007 08:20:10,spid60,Unknown,* System.Data 102D0000 10596FFF 002c7000
04/25/2007 08:20:10,spid60,Unknown,* mscorjit 0F910000 0F962FFF 00053000
04/25/2007 08:20:10,spid60,Unknown,* SqlAccess 0F8A0000 0F8F5FFF 00056000
04/25/2007 08:20:10,spid60,Unknown,* SensApi 0F880000 0F884FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* cryptnet 0F680000 0F691FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* SOFTPUB 0F670000 0F674FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* mscorsec 0F640000 0F652FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* mscorlib.ni 0EAC0000 0F5A7FFF 00ae8000
04/25/2007 08:20:10,spid60,Unknown,* mscorwks 080E0000 08640FFF 00561000
04/25/2007 08:20:10,spid60,Unknown,* xplog70 07CA0000 07CA2FFF 00003000
04/25/2007 08:20:10,spid60,Unknown,* xplog70 07C80000 07C8BFFF 0000c000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90 07C50000 07C75FFF 00026000
04/25/2007 08:20:10,spid60,Unknown,* odbcint 07C30000 07C46FFF 00017000
04/25/2007 08:20:10,spid60,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
04/25/2007 08:20:10,spid60,Unknown,* BatchParser90 07A40000 07A5EFFF 0001f000
04/25/2007 08:20:10,spid60,Unknown,* ODBC32 07A00000 07A3CFFF 0003d000
04/25/2007 08:20:10,spid60,Unknown,* SQLSCM90 079E0000 079E8FFF 00009000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90 07980000 079C7FFF 00048000
04/25/2007 08:20:10,spid60,Unknown,* xpsqlbot 07960000 07965FFF 00006000
04/25/2007 08:20:10,spid60,Unknown,* msftepxy 07490000 074A4FFF 00015000
04/25/2007 08:20:10,spid60,Unknown,* SQLNCLIR 007A0000 007D2FFF 00033000
04/25/2007 08:20:10,spid60,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
04/25/2007 08:20:10,spid60,Unknown,* COMCTL32 77530000 775C6FFF 00097000
04/25/2007 08:20:10,spid60,Unknown,* sqlncli 337A0000 339C1FFF 00222000
04/25/2007 08:20:10,spid60,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
04/25/2007 08:20:10,spid60,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
04/25/2007 08:20:10,spid60,Unknown,* ntdsapi 766F0000 76704FFF 00015000
04/25/2007 08:20:10,spid60,Unknown,* wshtcpip 070B0000 070B7FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* hnetcfg 071F0000 07248FFF 00059000
04/25/2007 08:20:10,spid60,Unknown,* dssenh 070C0000 070E3FFF 00024000
04/25/2007 08:20:10,spid60,Unknown,* imagehlp 76C10000 76C38FFF 00029000
04/25/2007 08:20:10,spid60,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
04/25/2007 08:20:10,spid60,Unknown,* dbghelp 06C10000 06D22FFF 00113000
04/25/2007 08:20:10,spid60,Unknown,* msfte 069B0000 06C08FFF 00259000
04/25/2007 08:20:10,spid60,Unknown,* security 06190000 06193FFF 00004000
04/25/2007 08:20:10,spid60,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* winrnr 76F70000 76F76FFF 00007000
04/25/2007 08:20:10,spid60,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000
04/25/2007 08:20:10,spid60,Unknown,* RESUTILS 05D50000 05D62FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* CLUSAPI 05D30000 05D41FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
04/25/2007 08:20:10,spid60,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
04/25/2007 08:20:10,spid60,Unknown,* VERSION 77B90000 77B97FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* MTXCLU 05D10000 05D28FFF 00019000
04/25/2007 08:20:10,spid60,Unknown,* msvcp60 780C0000 78120FFF 00061000
04/25/2007 08:20:10,spid60,Unknown,* MSDTCPRX 05C90000 05D07FFF 00078000
04/25/2007 08:20:10,spid60,Unknown,* XOLEHLP 05C80000 05C85FFF 00006000
04/25/2007 08:20:10,spid60,Unknown,* COMRES 77010000 770D5FFF 000c6000
04/25/2007 08:20:10,spid60,Unknown,* schannel 76750000 76776FFF 00027000
04/25/2007 08:20:10,spid60,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
04/25/2007 08:20:10,spid60,Unknown,* kerberos 05BC0000 05C17FFF 00058000
04/25/2007 08:20:10,spid60,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
04/25/2007 08:20:10,spid60,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
04/25/2007 08:20:10,spid60,Unknown,* MSCOREE 05950000 05994FFF 00045000
04/25/2007 08:20:10,spid60,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
04/25/2007 08:20:10,spid60,Unknown,* rsaenh 04E90000 04EBEFFF 0002f000
04/25/2007 08:20:10,spid60,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
04/25/2007 08:20:10,spid60,Unknown,* SAMLIB 5CCF0000 5CCFEFFF 0000f000
04/25/2007 08:20:10,spid60,Unknown,* ole32 77670000 777A3FFF 00134000
04/25/2007 08:20:10,spid60,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
04/25/2007 08:20:10,spid60,Unknown,* SQLOS 344D0000 344D4FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 4F610000 4F7A3FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* instapi 48060000 48069FFF 0000a000
04/25/2007 08:20:10,spid60,Unknown,* psapi 76B70000 76B7AFFF 0000b000
04/25/2007 08:20:10,spid60,Unknown,* comctl32 77420000 77522FFF 00103000
04/25/2007 08:20:10,spid60,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
04/25/2007 08:20:10,spid60,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000
04/25/2007 08:20:10,spid60,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
04/25/2007 08:20:10,spid60,Unknown,* opends60 333E0000 333E6FFF 00007000
04/25/2007 08:20:10,spid60,Unknown,* USERENV 76920000 769E3FFF 000c4000
04/25/2007 08:20:10,spid60,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* WS2_32 71C00000 71C16FFF 00017000
04/25/2007 08:20:10,spid60,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
04/25/2007 08:20:10,spid60,Unknown,* Secur32 76F50000 76F62FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* MSASN1 76190000 761A1FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* CRYPT32 761B0000 76242FFF 00093000
04/25/2007 08:20:10,spid60,Unknown,* GDI32 77C00000 77C47FFF 00048000
04/25/2007 08:20:10,spid60,Unknown,* USER32 77380000 77411FFF 00092000
04/25/2007 08:20:10,spid60,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
04/25/2007 08:20:10,spid60,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
04/25/2007 08:20:10,spid60,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
04/25/2007 08:20:10,spid60,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
04/25/2007 08:20:10,spid60,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
04/25/2007 08:20:10,spid60,Unknown,* kernel32 77E40000 77F41FFF 00102000
04/25/2007 08:20:10,spid60,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
04/25/2007 08:20:10,spid60,Unknown,* sqlservr 01000000 02BCEFFF 01bcf000
04/25/2007 08:20:10,spid60,Unknown,* MODULE BASE END SIZE
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* Access Violation occurred reading address 00000000
04/25/2007 08:20:10,spid60,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:10,spid60,Unknown,* Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* 04/25/07 08:20:10 spid 60
04/25/2007 08:20:10,spid60,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:10,spid60,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0006.txt
04/25/2007 08:20:10,spid60,Unknown,Using 'dbghelp.dll' version '4.0.5'
Hi guys,
We've had Reporting Services running in a production environ. for 6 months fine, but from Saturday every report now causes the following error (in both the Report Manager and Soap calls):
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Specified argument was out of the range of valid values. Parameter name: date
Now, before you jump to conclusions - this error is occurring on reports with both parameters and no parameters (ie in reports that have no "date" parameter in the report).
The next bit of info is the weird bit...
It was working on Friday (25/March/2006) - so as a test, i switched the servers clock back to Friday - and BINGO... it worked. Then I changed it to Saturday (26th March) and it doesnt work. In fact for the next 7 days - the service will not work until April 2nd 2006 - (when I changed the systems date to the 2nd it worked again.) Moving forward, it looks like its working fine.
Does anyone have any suggestions? This is in a production environment, so obviously changing the sytsem date as a quick fix workaround wont suffice.
Thanks in advance.
Grey
I have a pretty complicated report (lots of subreports, tables, etc) that can be well over a few hundred pages long. I can generate the report just fine, but I cannot seem to export it to anything other than an html archive. I need to export to PDF. Every time I try to export it get an error that says:
An internal error occurred on the report server. See the error log for more details.
I don't get any more information than that. Is there a way that I can figure out what the actual error is, or any other way I can go about troubleshooting this? Thanks.
Jeff
Hi,
I've read already every thread in this forum regarding this topic with no results.
SQLServer and the corresponding services are at actual update level. The reporting services worked for 4 months without this problem. Suddenly, most of the time all reports return an internal error (it is like 70-30 for internal error) not depending which render format is used.
The system logs (eventlog, iis) show no errors. The ExecutionLog of RS show rsInternalError.
Looking in the log files in RS log directory, there is following stacktrace:
w3wp!processing!1!05/11/2007-10:40:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.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)
I don't see any hint in stack trace, Maybe one of yours.
As it seems, after an iisreset the first rendering always works perfect. HD space is enough.
Any ideas?
I have the error above, but no error log. I can preview the sub report - but this main report fails after working this morning. This is for internal company reports and I rebuilt this one after converting from access.
I have looked where the error logs should be, but there are no error logs.
I rebuilt the query as I needed to change this, but this did not help.
Is there someone who could point me in the correct direction.
Thanks!
Terry
Hi
I have execute a script on my SQL Db (script to create indexes and views) and got the following error
Server: Msg 823, Level 24, State 2, Line 1
I/O error (bad page ID) detected during read at offset 0x000000232fe000 in file 'D:...filename.mdf'
ODBC: Msg 0, Level 16, STate 1
Communication link failure
DBCC CHECKDB returned
Database '' consistency errors in sysobjects, syscolumns, or systtypes prevent further CHECKDB processing..........
dbcc checktable ('syscolumns') returned
Server: Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID 0, page ID (1:86382). The PageId in the page header = (0:0).
Server: Msg 8909, Level 16, State 1, Line 2
Table error: Object ID 0, index ID 0, page ID (1:86383). The PageId in the page header = (0:0).
Server: Msg 8928, Level 16, State 1, Line 2
Object ID 3, index ID 0: Page (1:86382) could not be processed. See other errors for details.
Server: Msg 8928, Level 16, State 1, Line 2
Object ID 3, index ID 0: Page (1:86383) could not be processed. See other errors for details.
CHECKTABLE found 0 allocation errors and 2 consistency errors not associated with any single object.
DBCC results for 'syscolumns'.
There are 2059 rows in 133 pages for object 'syscolumns'.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'syscolumns' (object ID 3).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (databasename.dbo.syscolumns ).
Please help to solve this issue
Thanks & regards,
Eldho
OS & SQL Version:
SELECT @@VERSION
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
It's a working database. It's set up to make a backup every night at 4:15 AM when the load is minimal. When making a backup it should run DBCC CHECKDB without any repair option on. One day i got a notification that backup didn't completed. I checked the errorlogs for the day between last successful backup and the next one failed. Logs are clean.
Here is the result of "DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS":
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'Sessions' (ID 398624463). Missing or invalid key in index 'PK_Sessions' (ID 2) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:7420:37) identified by (RID = (1:7420:37) ) has index values (SessionId = 3539435).
CHECKDB found 0 allocation errors and 1 consistency errors in table 'Sessions' (object ID 398624463).
CHECKDB found 0 allocation errors and 1 consistency errors in database 'Accounting'.
repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (Accounting ).
Not sure if sp_helpindex results are necessary, but may be it will help:
IX_Sessions_LoginTimenonclustered located on PRIMARYLoginTime
IX_Sessions_NasIpnonclustered located on PRIMARYNasIp
IX_Sessions_NasSessionIdnonclustered located on PRIMARYNasSessionId
IX_Sessions_Usernonclustered located on PRIMARYUserId
PK_Sessionsnonclustered, unique, primary key located on PRIMARYSessionId
Sessions0nonclustered located on PRIMARYLoginTime, BytesIn
REPAIR_FAST does not help. The error isn't cleared.
I have two questions about that issue.
1) How i can dig into that problem? For example i would like to simply look at the row causing problems, but i just don't know how to select rows referencing them by RID. Is it piossible? Actually i don't quite understand what DBCC output means. :(
2) Second question is of course how to correct that problem. :)
Of course i can restore from backup, but i'd like to know if there are other ways? Maybe without loosing all the information which was entered during the day? I can afford loosing several rows from that table, but loosing all info entered is not very good solution. No, i don't need backup strategy involving several DB backup during the day. :) Just don't want to reenter all the info, but it can be done if there are no other ways. :)
Hi -
I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:
[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".
Where do I change the security settings?
Thanks - Grace
I cannot execute a package by using Execute Package task.
I supplied sa credentials to connection manager, and it shows the list of Packages on SQL Server but when running the task it says
Error 0xC0202009 while preparing to load the package. An OLE DB error has occurred. Error code: 0x%1!8.8X!.
Any clue ?
Thanks,
Fahad
I have a database that has a consistency error. When I run a DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS I get the following.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 72205074432 owned by data record identified by RID = (1:1944:23) id = 1216723387 and indid = 6.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:62963), slot 49, text ID 72188297216 does not match its reference from page (1:1944), slot 23.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'sysindexes' (object ID 2).
CHECKDB found 0 allocation errors and 2 consistency errors in database 'JDE_PDBANDIT_TEST'.
If I run a DBCC CHECKDB ('JDE_PDBANDIT_TEST', REPAIR_ALLOW_DATA_LOSS)I get the following
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 72205074432 owned by data record identified by RID = (1:1944:23) id = 1216723387 and indid = 6.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:62963), slot 49, text ID 72188297216 does not match its reference from page (1:1944), slot 23.
DBCC results for 'JDE_PDBANDIT_TEST'.
DBCC results for 'sysobjects'.
There are 4707 rows in 64 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
The repair level on the DBCC statement caused this repair to be bypassed.
The repair level on the DBCC statement caused this repair to be bypassed.
There are 6811 rows in 477 pages for object 'sysindexes'.
Can anyone provide any other avenues to try and resolve this issue.
I'm trying to use an XML Task to do a simple XSLT operation, but it fails with this error message:
[XML Task] Error: An error occurred with the following error message: "There are multiple root elements. Line 5, position 2.".
The source XML file validates fine and I've successfully used it as the XML Source in a data flow task to load some SQL Server tables. It has very few line breaks, so the first 5 lines are pretty long: almost 4000 characters, including 34 start-tags, 19 end-tags, and 2 empty element tags. Here's the very beginning of it:
<?xml version="1.0" encoding="UTF-8"?>
<ESDU releaselevel="2006-02" createdate="26 May 2006"><package id="1" title="_standard" shorttitle="_standard" filename="pk_stan" supplementdate="01/05/2005" supplementlevel="1"><abstract><![CDATA[This package contains the standard ESDU Series.]]></abstract>
There is only 1 ESDU root element and only 1 package element.
Of course, the XSLT stylesheet is also an XML document in its own right. I specify it directly in the XML Task:
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"/>
<xsl:template name="identity" match="@*|node()">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:template>
<xsl:template match="kw">
<xsl:copy>
<xsl:apply-templates select="@*"/>
<xsl:attribute name="ihs_cats_seq" select="position()"/>
<xsl:apply-templates select="node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
Its 5th line is the first xsl:template element.
What is going on here? I do not see multiple root elements in either the XML document or the XSLT stylesheet.
Thanks!
I'm getting the following output from dbcc checktable(sysdtssteplog):
Msg 8928, Level 16, State 1, Line 2
Object ID 594101157, index ID 0: Page (1:744) could not be processed. See other errors for details.
Msg 8939, Level 16, State 98, Line 2
Table error: Object ID 594101157, index ID 0, page (1:744). Test (IS_ON (BUF_IOERR, bp->bstat) &&bp->berrcode) failed. Values are 2057 and -1.
Msg 8976, Level 16, State 1, Line 2
Table error: Object ID 594101157, index ID 1. Page (1:744) was not seen in the scan although its parent (1:4660) and previous (1:607) refer to it. Check any previous errors.
Msg 8978, Level 16, State 1, Line 2
Table error: Object ID 594101157, index ID 1. Page (1:745) is missing a reference from previous page (1:744). Possible chain linkage problem.
CHECKTABLE found 0 allocation errors and 4 consistency errors in table 'sysdtssteplog' (object ID 594101157).
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKTABLE (msdb.dbo.sysdtssteplog ).
Is this a DTS package or log file I can just remove, or can I just somehow remove that data from the table? I ask this because all the DTS packages seem to be running (and logging) fine.
Or will this involve restore and replace? What direction should I go from here?
I have not seen any hardware errors on this machine. Yet.
Thanks for any and all help.
Hi,
In my database, when I try to start sql service, I got following message in event view.
SQL server is sql express version
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
10/09/2007 10:48:47,spid5s,Unknown,Recovery is complete. This is an informational message only. No user action is required.
10/09/2007 10:48:47,spid15s,Unknown,SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:9; actual 0:0). It occurred during a read of page (1:9) in database ID 8 at offset 0x00000000012000 in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmagirisilica_s24.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.
10/09/2007 10:48:47,spid15s,Unknown,Error: 824<c/> Severity: 24<c/> State: 2.
When I try to make
dbcc dbcheckdb ...
I got this.
Msg 945, Level 14, State 2, Line 1
Database 'magirisilica_s24' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
Any suggest.
Thanks in advance
Radovan
When my production server processing some queries suddenly the SQL Server service crashed and following error was in the error log:
SQL Server Internal Error. Text manager cannot continue with current statement.
The server is running SQL Server 2000 with SP4.
I am really concerned because this is a production sever and there are over 300 users access concurrently.
Please help me to find a solution.
Thanks,
Roshan.
I have a SProc that runs across many clients without any problems. Every now and then, though, I get the following error:
Internal Query Processor Error: The query processor encountered an unexpected error during execution. [SQLSTATE 42000] (Error 8630).
All I am doing is populating Temp tables with some data and then joining them together to create a Global Temp table that is being BCP'd to a network share.
Has anyone come across this error in SQL Server 2005? I cannot find anything on Google or Microcsoft.
Thanks,
Robert
I'm getting the following error on our merge contents table in one of our DBs:
Msg 8952, Level 16, State 1, Line 1
Table error: Database 'ks241', index 'MSmerge_contents.nc3MSmerge_contents' (ID 1950682047) (index ID 3). Extra or invalid key for the keys:
Msg 8956, Level 16, State 1, Line 1
Index row (1:1893:42) with values (partchangegen = NULL and tablenick = 17665001 and rowguid = AEAE7256-F571-478E-B2B4-D142B47C38C1) points to the data row identified by ().
Msg 8952, Level 16, State 1, Line 1
Table error: Database 'ks241', index 'MSmerge_contents.nc3MSmerge_contents' (ID 1950682047) (index ID 3). Extra or invalid key for the keys:
Msg 8956, Level 16, State 1, Line 1
Index row (1:1893:66) with values (partchangegen = NULL and tablenick = 17665001 and rowguid = B94F1591-33B0-4625-A269-DB9B8B05BCCE) points to the data row identified by ().
CHECKTABLE found 0 allocation errors and 2 consistency errors in table 'MSmerge_contents' (object ID 1950682047).
repair_fast is the minimum repair level for the errors found by DBCC CHECKTABLE (ks241.dbo.MSmerge_contents ).
There are no other corruption issues on the server that I can find. I do not believe there are any current hardware issues, though I am not on site.
What would be the best way to resolve this? Is recreating or defrag/rebuild the index an option, here? Or can I just run a repair on this? Since it's a merge table, I'm a little gun shy, having limited experience with replication.
Thanks.
____________________________________________________________________________________
"Believe in those who are seeking the truth. Doubt those who say they have found it." -Andre Gide