I get the following error on the report that I am working on, as soon as I added a new item to my dataset.
The error is: An internal error occured on the report server. See the error log for detail.
I added a new item to the dataset with the following expression:
=iif(Fields!Posting_Date.Value>=Fields!monthstartdate.Value and Fields!Posting_Date.Value <= Fields!monthenddate.Value,COUNTdistinct(Fields!Document_No_.Value),0)
I noticed some posts in regars to the count issue that has to do with system resources. I followed all the instructions, but no luck.
Has anyone else experienced the same issue with the Count function and how were you able to resolve it ??
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.
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?
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.
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.
Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer If reset offset = pagenumber - 1 End If Return pagenumber - offset End Function
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.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--------
I was created report with 9 sub reports , with multiple column driildown for based on client requirement, iam displying the correct data and in database server data is availabel between 11/01/2007 to 11/30/2007, iam applying the input parameters are begin date, end date, region(defaultly ALL), Department(defaulty ALL), site(defaulty ALL).
my problem is while selecting the default dates (minum and maximum dateranges) with selecting ALL regions, ALL departments, ALL sites iam not getting the output. it showing error like
" An error occur on local report processing, an internal error occur on report server, see error log for more details"
but iam selecting the date as 11/01/2007 to 11/02/2007( that is not large records, between two dates only) it shows correct output.
while applying the default ranges that is 11/01/2007 to 11/30/2007 report shows above mentioned error.
problem with 9 sub reports ? or any thying
please help me how to solve my problem next coming two days i have to deploy my report to client, at the time it will show data between default date ranges.
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.
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
<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 all we applied Hotfix #931821 to a 64 bit machine and now we get a random Internal Report Error. Once this error occurs it usually only requires a refresh to have the report successfully execute. Has anyone else had this experience or know what I can do to fix it. The message below comes from the log file created by the error.
w3wp!library!b!09/21/2007-17:01:07:: 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!7!9/21/2007-17:01:13:: i INFO: Cleaned 0 batch records, 0 policies, 8 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
I have enabled custom authorization in SQL server 2005 reporting services. If i try to view the reports thru report manager by using the url http://localhost/reports then i'm getting the error message as
"An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Get Online Help
The event log file is full"
If i try to view the reports by using reportserver url http://localhost/reportserver then its working fine. Please help me in resolving this issue.
The log file is as follows
<Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product> <Locale>en-US</Locale> <TimeZone>India Standard Time</TimeZone> <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__02_06_2007_13_59_07.log</Path> <SystemName>BLRKEC21139D</SystemName> <OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName> <OSVersion>5.1.2600.131072</OSVersion> </Header> aspnet_wp!webserver!1!2/6/2007-13:59:07:: i INFO: Reporting Web Server started aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. aspnet_wp!configmanager!1!2/6/2007-13:59:08:: w WARN: WebServiceAccount is not specified in the config file. Using default: BLRKEC21139DASPNET aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. aspnet_wp!library!1!2/6/2007-13:59:08:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. aspnet_wp!resourceutilities!1!2/6/2007-13:59:08:: i INFO: Reporting Services starting SKU: Developer aspnet_wp!resourceutilities!1!2/6/2007-13:59:08:: i INFO: Evaluation copy: 0 days left aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds aspnet_wp!runningjobs!1!2/6/2007-13:59:08:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds aspnet_wp!library!1!02/06/2007-13:59:08:: i INFO: Catalog SQL Server Edition = Developer aspnet_wp!webserver!1!02/06/2007-13:59:09:: i INFO: Processed folder '/' aspnet_wp!library!6!02/06/2007-14:00:02:: i INFO: Call to GetPermissions:/ aspnet_wp!library!6!02/06/2007-14:00:03:: 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. ---> System.ComponentModel.Win32Exception: The event log file is full at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type) at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.WriteToLog(String entry, EventLogEntryType type) at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.Publish(Exception exception, NameValueCollection additionalInfo, NameValueCollection configSettings) at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.PublishInternalException(Exception exception, NameValueCollection additionalInfo) at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception, NameValueCollection additionalInfo) at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception) at Infosys.ReportingServices.CustomAuthorization.Authorization.DeserializeAcl(Byte[] secDesc) at Infosys.ReportingServices.CustomAuthorization.Authorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc) at Microsoft.ReportingServices.Library.Security.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc) at Microsoft.ReportingServices.Library.GetPermissionsAction.GetPermissions(String item, StringCollection& Operations) --- End of inner exception stack trace --- aspnet_wp!library!6!02/06/2007-14:00:12:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson aspnet_wp!library!1!02/06/2007-14:03:53:: i INFO: Call to GetPermissions:/ aspnet_wp!library!1!02/06/2007-14:03:53:: 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. ---> System.ComponentModel.Win32Exception: The event log file is full at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName) at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData) at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type) at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.WriteToLog(String entry, EventLogEntryType type) at Microsoft.ApplicationBlocks.ExceptionManagement.DefaultPublisher.Publish(Exception exception, NameValueCollection additionalInfo, NameValueCollection configSettings) at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.PublishInternalException(Exception exception, NameValueCollection additionalInfo) at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception, NameValueCollection additionalInfo) at Microsoft.ApplicationBlocks.ExceptionManagement.ExceptionManager.Publish(Exception exception) at Infosys.ReportingServices.CustomAuthorization.Authorization.DeserializeAcl(Byte[] secDesc) at Infosys.ReportingServices.CustomAuthorization.Authorization.GetPermissions(String userName, IntPtr userToken, SecurityItemType itemType, Byte[] secDesc) at Microsoft.ReportingServices.Library.Security.GetCatalogItemPermissions(ItemType catItemType, Byte[] secDesc) at Microsoft.ReportingServices.Library.GetPermissionsAction.GetPermissions(String item, StringCollection& Operations) --- End of inner exception stack trace ---
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.
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:
I've been unsuccessful getting Reporting Services 2005 to work after reinstalling SQL 2005. The RS service cannot connect to its database, as reported in the Event Log. If I visit http://localhost/Reports, I get the error "Key not valid for use in specified state. (Exception from HRESULT: 0x8009000B) (rsRPCError)"
I've used the RS Config Mgr to create a fresh database for it named SSRS (and SSRSTembDB), and it is set to use Service Credentials in the db connection. The RS service is running using the same admin account as MSSQL, .SQLExec. I have confirmed that .SQLExec is in the RSExecRole role in the SSRS database.
When I created the SSRS database, the Config Mgr had a green check for every step except the last. For "Setting Connection Info for the Reporting Server" there was a yellow '!', with the explanation, "Although saving the database connection succeeded, the report server cannot access internal information about this deployment to determine if the current configuration is valid for this edition. ..."
I examined rsreportserver.config to look for any issues. The <dsn> element has an encrypted string, the <ConnectionType> element says "Default", and the logon elements are empty. I could not find the db names, SSRS and SSRSTempDB, anywhere in the file. Where are these kept? I don't know what else to look for.
Also, in RS Config Mgr, the 'Encryption Keys' page has a blue '!', and only the 'Restore' and 'Delete' buttons are enabled. The 'Initialization' page has a red 'X'. The local RS is not listed (the grid is empty), and clicking the 'Initialize' button does nothing.
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.
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.
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.
Has anyone come across error 8630 "Internal Query Processor Error: The query processor encountered an unexpected error during execution." with SQL Server 7 with SP4 installed?
There are microsoft articles on the error, but the errors are suposidly fixed in SQL Server 7 SP2 and SP3.
We are selecting from one view left outer joined with another, but no unions are involved.
This is not a problem in SQL Server 2000, but unfortunatlely Microsoft are supporting SQL Server 7 until 2005 and so we have to do the same...
I get this after dumping about 2GB and 885800 rows X 2 columns from a simple query to a file.
The command line is simple:
sqlcmd -b -h -1 -S "sindb05" -d ACT -E -Q "select date, data from data_strings with (nolock) where date > '2008-01-20 12:00:00' and date < dateadd(hour, +1, '2008-01-20 12:00:00')" -o out.txt
I have the following code and I keep on getting the following error: Internal SQL Server error. Line 160: da.Fill(dtStudent) <code> Private Function CreateStudentDT() As DataTable
Dim cmdStudent As SqlCommand = New SqlCommand Dim strSPName As String Dim strSQL As String Dim dtStudent As New DataTable cmdStudent.Connection = objConn cmdStudent.CommandType = CommandType.StoredProcedure cmdStudent.Parameters.Add("@ParamYear", mprmYear.Code) cmdStudent.Parameters.Add("@paramDate", mstrParamToDate) cmdStudent.Parameters.Add("@ParamMonth", mprmMonth.Code) cmdStudent.CommandText = "AmountMarkedMosad" objConn.Open() Dim da As SqlDataAdapter = New SqlClient.SqlDataAdapter(cmdStudent) da.Fill(dtStudent) objConn.Close() Return dtStudent End Function
HELP! I ran a script that performed a rather large (and lengthy) update and alter with the result being correct however, now a number of stored procedures return an "Internal SQL Server Error" containing joins to the above altered tables? Has anyone hit this before? Does the error really mean a SQL Server problem or database specific problem? Does anyone know how to remidy the situation?
Can someone pleplease run the script below in SQL2K environment with SP3+ applied and see if you get the same error:create view dbo.vw_INTERNAL_ERROR asselect top 100 percent * from( select [DateField]=getdate()) x1 order by x1.[DateField]goif exists(select 1 from dbo.vw_INTERNAL_ERROR)print 'Exists'elseprint 'Doesn''t Exist'godrop view dbo.vw_INTERNAL_ERRORgo I am getting this: Msg 8624, Level 16, State 23, Line 1Internal SQL Server error. But in SQL2K5 it prints 'Exists' correctly. Thanks in advance.
Server: Msg 8624, Level 16, State 1, Procedure SiteProdRatesCalc, Line 890 Internal SQL Server error. DELETING ANY SITEPRODUCTRATES ENTERED TODAY FOR FC, OT, NT BY SITE GROUP CALCULATING RATES FROM ONE RATE SOURCE.
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?
Hi, Im getting a strange error, in some cases when using a table in reporting services, if I delete some columns however, the error disapears, bellow is the error string, How can I increase the lenght of the LOB data?
thank you
----------------------------------------------------- w3wp!library!7!09/21/2007-08:51: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. ---> System.Data.SqlClient.SqlException: Length of LOB data (97840) to be replicated exceeds configured maximum 65536. The statement has been terminated.
Here's a quick and dirty example of a legitimate bug in SQL Server.I've seen other examples, but they were all very complex, some eveninvolving cursors and such. This one will produce the error with just13 lines.A police department has a database that contains, among other things,information about parking tickets given out by the officers. Here isthe database and some sample data:create table ParkingTickets (TicketDate datetime,IssuingOfficer int)insert into ParkingTickets values ('1/2/2005 12:31',1)insert into ParkingTickets values ('1/2/2005 14:20',1)insert into ParkingTickets values ('1/3/2005 12:05',1)insert into ParkingTickets values ('1/3/2005 12:22',2)insert into ParkingTickets values ('1/3/2005 14:01',2)insert into ParkingTickets values ('1/4/2005 10:12',2)insert into ParkingTickets values ('1/2/2005 12:10',3)insert into ParkingTickets values ('1/4/2005 12:36',3)So, as you can see, officer 1 gave out three tickets. Officer 2 gaveout three, etc. Management wants a report containing the followinginformation;the Hour of Day,the ID of the Issuing Officer,the number of tickets issued by the officer during this hour during theweek,and the average number of tickets issued by all officers during thishour during the weekSo, if the report is to cover 1/2/2005 through 1/5/2005, the reportwould look like this:selectdatepart(hh,TicketDate) as HourOfDay,IssuingOfficer,count(*) as TicketsIssuedByThisOfficer,TotalTicketsForThisHour_AllOfficers = (select convert(real, count(*))/3from ParkingTicketswhere datepart(hh,TicketDate) = datepart(hh,PT.TicketDate)and TicketDate between '1/2/2005' and '1/5/2005')from ParkingTickets PTwhere TicketDate between '1/2/2005' and '1/5/2005'group by IssuingOfficer, datepart(hh,TicketDate)order by HourOfDay, IssuingOfficerdrop table ParkingTicketsif you'll run that in Query Analyzer, you'll see that it works justfine and produces the expected output. However, if you delete thisline:count(*) as TicketsIssuedByThisOfficer,the query errors out. It's almost like magic. With the count(*)there, the query runs. Without it, the query fails. I can't see anyreason why deleting that line would produce an error. There aremultiple references to this on the microsoft kb, and many of them havehotfixes. But none of them seems to fix this particular instance ofthe bug - and like I said, this is the simplest incarnation that I'veseen.Christopher Secord
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?
We have a website which uses an embedded ReportViewer two 3 distinct reports on a W2k3 server running SQL Server 2005 with Reporting Services installed (Machine is: 4 Proc Dual Core Opteron 64).
When a user first hits the report everything loads fine, however, after you click on the "Next Page" arrow several times the user gets an "occurred on the report server. See the error log for more details. " error message. It is random, sometime it happens after two pages, sometimes it happens after 6. This happens on all three reports we have on our system.
All three reports use parameters, I am not sure what is going on. Included below is a copy of our log
<Header> <Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product> <Locale>en-US</Locale> <TimeZone>Pacific Daylight Time</TimeZone> <Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServer__03_21_2007_09_10_24.log</Path> <SystemName>XXX-CCDIVAR</SystemName> <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName> <OSVersion>5.2.3790.65536</OSVersion> </Header> w3wp!webserver!a!3/21/2007-09:10:24:: i INFO: Reporting Web Server started w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file. w3wp!library!a!3/21/2007-09:10:25:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file. w3wp!resourceutilities!a!3/21/2007-09:10:25:: i INFO: Reporting Services starting SKU: Standard w3wp!resourceutilities!a!3/21/2007-09:10:25:: i INFO: Evaluation copy: 0 days left w3wp!resourceutilities!a!3/21/2007-09:10:25:: i INFO: Running on 4 physical processors, 8 logical processors w3wp!runningjobs!a!3/21/2007-09:10:25:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds w3wp!runningjobs!a!3/21/2007-09:10:25:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!a!3/21/2007-09:10:25:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!runningjobs!a!3/21/2007-09:10:25:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds w3wp!library!5!03/21/2007-09:10:25:: i INFO: Catalog SQL Server Edition = Standard w3wp!library!1!03/21/2007-09:10:30:: i INFO: Call to RenderFirst( '/xxx Divested AR/Aging Report' ) w3wp!runningjobs!1!3/21/2007-09:10:30:: w WARN: Thread pool pressure. Using current thread for a work item.
w3wp!processing!6!3/21/2007-09:10:31:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1.
w3wp!library!1!03/21/2007-09:10:32:: Using folder C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesRSTempFiles for temporary files. w3wp!webserver!1!03/21/2007-09:10:33:: i INFO: Processed report. Report='/xxx Divested AR/Aging Report', Stream='' w3wp!library!1!03/21/2007-09:10:35:: i INFO: Call to RenderNext( '/xxx Divested AR/Aging Report' ) w3wp!cache!1!03/21/2007-09:10:35:: i INFO: Session live: /xxx Divested AR/Aging Report w3wp!webserver!1!03/21/2007-09:10:35:: i INFO: Processed report. Report='/xxx Divested AR/Aging Report', Stream='' w3wp!library!7!03/21/2007-09:10:37:: i INFO: Call to RenderNext( '/xxx Divested AR/Aging Report' ) w3wp!cache!7!03/21/2007-09:10:37:: i INFO: Session live: /xxx Divested AR/Aging Report w3wp!webserver!7!03/21/2007-09:10:37:: i INFO: Processed report. Report='/xxx Divested AR/Aging Report', Stream='' w3wp!library!9!03/21/2007-09:10:38:: i INFO: Call to RenderNext( '/xxx Divested AR/Aging Report' )
w3wp!library!9!03/21/2007-09:10:38:: 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!9!03/21/2007-09:10:40:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson w3wp!webserver!9!03/21/2007-09:10:40:: 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. w3wp!library!5!03/21/2007-09:15:20:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!5!03/21/2007-09:15:21:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!6!03/21/2007-09:15:30:: i INFO: Call to RenderNext( '/xxx Divested AR/Statements Report' ) w3wp!cache!6!03/21/2007-09:15:31:: i INFO: Session live: /xxx Divested AR/Statements Report w3wp!webserver!8!03/21/2007-09:15:31:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!b!03/21/2007-09:15:56:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!b!03/21/2007-09:15:57:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!6!03/21/2007-09:16:04:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!6!03/21/2007-09:16:05:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!b!03/21/2007-09:16:14:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!processing!b!03/21/2007-09:16:15:: 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)
w3wp!library!b!03/21/2007-09:16:15:: 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!b!03/21/2007-09:16:47:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson w3wp!webserver!b!03/21/2007-09:16:47:: 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. w3wp!library!9!03/21/2007-09:16:50:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!9!03/21/2007-09:16:51:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!8!03/21/2007-09:17:00:: i INFO: Call to RenderNext( '/xxx Divested AR/Statements Report' ) w3wp!cache!8!03/21/2007-09:17:00:: i INFO: Session live: /xxx Divested AR/Statements Report w3wp!webserver!a!03/21/2007-09:17:00:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!b!03/21/2007-09:17:20:: i INFO: Call to RenderFirst( '/xxx Divested AR/Adjustments And Receipts Report' ) w3wp!runningjobs!b!3/21/2007-09:17:22:: w WARN: Thread pool pressure. Using current thread for a work item. w3wp!runningjobs!b!3/21/2007-09:17:26:: w WARN: Thread pool pressure. Using current thread for a work item. w3wp!processing!b!3/21/2007-09:17:26:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1. w3wp!runningjobs!b!3/21/2007-09:17:26:: w WARN: Thread pool pressure. Using current thread for a work item. w3wp!processing!5!3/21/2007-09:17:26:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 1. w3wp!webserver!b!03/21/2007-09:17:31:: i INFO: Processed report. Report='/xxx Divested AR/Adjustments And Receipts Report', Stream='' w3wp!library!9!03/21/2007-09:17:38:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!9!03/21/2007-09:17:39:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!9!03/21/2007-09:17:46:: i INFO: Call to RenderNext( '/xxx Divested AR/Adjustments And Receipts Report' ) w3wp!cache!9!03/21/2007-09:17:47:: i INFO: Session live: /xxx Divested AR/Adjustments And Receipts Report w3wp!webserver!9!03/21/2007-09:17:47:: i INFO: Processed report. Report='/xxx Divested AR/Adjustments And Receipts Report', Stream='' w3wp!library!6!03/21/2007-09:17:48:: i INFO: Call to RenderNext( '/xxx Divested AR/Adjustments And Receipts Report' ) w3wp!cache!6!03/21/2007-09:17:49:: i INFO: Session live: /xxx Divested AR/Adjustments And Receipts Report w3wp!webserver!6!03/21/2007-09:17:49:: i INFO: Processed report. Report='/xxx Divested AR/Adjustments And Receipts Report', Stream='' w3wp!library!a!03/21/2007-09:17:50:: i INFO: Call to RenderNext( '/xxx Divested AR/Adjustments And Receipts Report' ) w3wp!processing!a!03/21/2007-09:17:50:: 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!a!03/21/2007-09:17:50:: 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/21/2007-09:18:00:: i INFO: Call to RenderNext( '/xxx Divested AR/Statements Report' ) w3wp!webserver!7!03/21/2007-09:18:01:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!cache!1!03/21/2007-09:18:01:: i INFO: Session live: /xxx Divested AR/Statements Report w3wp!library!a!03/21/2007-09:18:22:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson w3wp!webserver!a!03/21/2007-09:18:22:: 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. w3wp!library!5!03/21/2007-09:18:50:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!processing!5!03/21/2007-09:18:50:: 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)
w3wp!library!5!03/21/2007-09:18:50:: 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/21/2007-09:19:22:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson w3wp!webserver!5!03/21/2007-09:19:22:: 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. w3wp!library!b!03/21/2007-09:19:28:: i INFO: Call to RenderFirst( '/xxx Divested AR/Statements Report' ) w3wp!webserver!b!03/21/2007-09:19:29:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!6!03/21/2007-09:19:43:: i INFO: Call to RenderNext( '/xxx Divested AR/Statements Report' ) w3wp!cache!6!03/21/2007-09:19:43:: i INFO: Session live: /xxx Divested AR/Statements Report w3wp!webserver!7!03/21/2007-09:19:43:: i INFO: Processed report. Report='/xxx Divested AR/Statements Report', Stream='' w3wp!library!5!3/21/2007-09:20:25:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 10 chunks, 0 running jobs, 0 persisted streams
Revenue 4 GB (4086 MB) Partitioned into 12 partitions (about 340 MB each) The count of records : almost 16.8 millions Each partition has approximately 1.4 million records
Algorithm chosen : TimeSeries Time Key : Period (6 digits integer with values range from 200501 to 200512, integer values) (Non-time) Key : Telephone number, variable-length string/text, max 15 char Input-and-predicted column1 : SLI007 Input-and-predicted column2 : SLI008
I have set the value for PERIODICITY_HINT to {12}. I created the project 3 times in 3 machines. All fail. The error message is the same :
Internal error : An unexpected exception occured. Internal error: An unexpected error occurred (file 'dmtimeseries.cpp', line 646, function 'DMTimeSeries::ProcessCaseTS3and4').
I searched for the file in C:Program FilesMicrosoft SQL Server and its subfolders. I didn't find it.
What causes the error?
I tested 3 machines to check whether the performance of the machine is the culprit.
Single processor Pentium M 2.0 GHz with 2 GB Memory Double processor Xeon 2.4 GHz with 3 GB Memory Double processor Xeon 3.4 GHz with 4 GB Memory
But the project in all those machines return the same error. Any idea?
