An Unexpected Error Occured In Report Processing. (rsInternalError)
Apr 11, 2008
Hi all,
Our application that uses Reporting Services for it's Reports.
On one customers build it appears to keep falling over.
Restarting the server seems to resolve the problem for a short period
and then it happens again.
The exception that is returned to our application is
"An unexpected error occured in report processing. (rsInternalError)"
The customer has sent me the log files from
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataReporting ServicesLogs
I've tied the time that the issue occurs to this section
w3wp!chunks!1!04/11/2008-10:27:35:: e ERROR: GetChunkPointerAndLength: System.Data.SqlClient.SqlException: Database 'ReportServerTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
and
w3wp!processing!1!04/11/2008-10:27:35:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.Data.SqlClient.SqlException: Database 'ReportServerTempDB' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
I doubt that the disk is full as our database is sitting on the same drive and presumably the whole system would have stopped working by now.
Any thoughts as to what the problem might be?
We've not seen this before.
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 ---
Hiwhen i right click table and click design table then error occured(an unexpected error occured during this operation)If any one knows please let let me know your help would be appreciated .thankspardhi--Message posted via http://www.sqlmonster.com
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.
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 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 SQL Server RS integrated with SharePoint. I created two reports pointed to the same data source and both worked great when launching from SharePoint. After making a title change in Visual Studio, I uploaded both reports, overwriting the old ones. One works and the other doesn't. The one that does not allows me to put in the parameters and then runs for about two minutes with the "Report is Being Generated" page. It then seems to time-out:
An unexpected error has occurred.
Troubleshoot issues with Windows SharePoint Services.
I checked the SharePoint log and did not see any errors. I also checked the logs in the SQL ServerMSSQL.1Reporting Services folder and did not see anything that indicated my report being executed at all. I'm at a loss, and have no idea how to troublehoot this effectively. Any help is appreciated. Thanks!
I have a distributed environment with SQL Server 2005 SP2 (RTM) running on one server. This server holds the databases for SharePoint and Reporting Services. I then have SharePoint 3.0 (32-bit version) with the reporting services add-in installed on a second server. I installed the sharepoint object model (64-bit version) on the database server as suggested and have configured Reporting Services to use domain user accounts. The Reporting Services configuration tool is reporting that integration has been successfully set up but I am unable to access the "Set Server Defaults" page without an error. This is the error I receive:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode.
I am extracting RS reports through a WebService: report = execService.Render("EXCEL", null, out extension, out mimeType, out encoding, out warnings, out streamIds);
Some works fine but some are generating the following SoapException:
Error during processing of €˜ReportParameterTime€™ report parameter. ---> Error during processing of €˜ReportParameterTime€™ report parameter. ---> Error during processing of €˜ReportParameterTime€™ report parameter. I set required parameters to their default values. In this specific report I have two required parameters: 1: ReportParameterTime, String 2: ReportParameter1, String
I set them to their default values (ReportParameterTime to "[Czas].[Kalendarzowy].[Rok].&[2007]" - means Time Calendar Year 2007) but I am getting the exception above. I set parameters using this code:
Where parameterValues is a List<ReportExecution2005.ParameterValue>.
When I am using Microsoft.Reporting.WinForms.ReportViewer the report is generated without any problems. I can see one parameter to choose: "Kalendarzowy" (means adj. Calendar) and can select years, the default value is "2007".
What am I doing wrong and how can I fix this error ? Does anybody know ?
I have two reports. They both work fine when loaded individually. I am loading them directly from a stream. I am also loading the subreport definition using LoadSubreportDefinitio(). Neither of them have parameters
I receive the following error message when trying to load the sub report.
An error occurred while executing the subreport €˜Subreport€™: An error has occurred during report processing. (rsErrorExecutingSubreport).
For a long time I've had SQL Server 2000 with RS on a Server2003 machine. When I want to publish a report from my Dev box, I remove anon. access on the Production machine, deploy the report, then go into report manager to tweak a couple of parameters. I then re-enable anon. access so users can continue.
Yesterday, I removed anon. access and deployed the report but when I went into Report Manager I received the above error message... "The underlying connection was closed: An unexpected error occurred on a receive."
I can get into report manager with anonymous access enabled, but I don't have authority to do anything.
What's happened!!!? More importantly, how do I fix it?
Hi all, I have created a report on the client and want to deploy it on the server. I am able to deploy the report on the Server but whern i am trying to see that report from the server i am getting error.
The Error Is : -
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
I have created several reports and deployed them successfully. However, when I return to view the reports some time later I receive the following error message:
An error has occurred during report processing.
Query execution failed for data set 'DataSet1'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors The only way I have been able to get round the issue is to re-deploy the reports. All reports are executed from Stored Procedures.
Created Report using SQL Server Business Intelligence 2005 using Visual studio 2005 MSSQL Server 2005 datasource is a filteredAppointment dbo from MS CRM 3 Shared Datasource Report runs in visual studio 2005
deployed to ReportServer no errors Report showing on home page in Report Server Data source folder also on report server page
go to run report on the report server via internet explorer
getting following message
An error has occurred during report processing.
Cannot create a connection to data source 'FilteredAppointments'.
For more information about this error navigate to the report server on the local server machine, or enable remote errorsPlease can any one help!!!!!!
I am a novice to reporting services, can any one recommend a good basic to intermediate book. have been on the Microsoft 2030A MSSQL server 2000 reporting services 4 months ago and not had a chance to use it until know
I get this error for all but one of the reports in a solution when trying to preview the reports. The query behind the reports work, and the published side of things works fine. I blew away all the rdl.data files in the directory (found that tip in another forum) -- the working report rebuilds the rdl.data file, but the rest continue to fail with the same error. Everything worked fine before the weekend, and I'm the only one who works on the application. The extracted SQL tables which are input to the reports have had data added to them, but I've not requested reporting that would have hit the new data (except for the one report that still works). Any ideas would be greatly welcome. Thanks in advance.
I created a 2005 SSRS SP2 report (.rdl) last week. Today I installed the SQL 2005 SP2 tools on three of my co-workers' computers. Two can access the Solution/Project/Report in BIDS without issue. The last can open the Solution/Project/Report and can run see both the data and layout tabs. When she attempts to click the preview tab, however, the following error occurs:
An error occurred during local report processing. The definition of the report '/ReportName' is invalid. An unexpected error occurred in the Report Processing. Cannot execute a program. The command being executed was "C:WINNTMicrosoft.NETFrameworkv2.0.50727vbc.exe" /noconfig @"C:Documents and SettingsuserLocal SettingsTempwnlnvzev.cmdline".
The portion in blue changes each time we attempt to access the preview pane. I have removed the .data file suggested in other threads, but that did not work. I also ran iisreset.exe as posted in another thread and that did not work either.
All versions of BIDS/SQL were installed from the same media in the same manner. Please help.
My report worked fine for a while, but suddenly I started getting the following errors for Preview:
An error occurred during local report processing.
An error has occurred during report processing.
Index was outside the bounds of the array.
I restarted VS, then rebooted my machine and the problem persists. Everything including the report posted to the server works fine. It is just the Preview of this report does not work any more. Preview of other reports work fine.
Any tip to resolve this problem would be greatly appreciated.
I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003 64bit SP1 Enterprise Edition.
Reporting Services Configuration Manager indicate that everything is ok, green checks except Encryption Keys and Execution Account.
Reporting Services databases, ReportServer and ReportServerTempDB, is not "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in the same domain.
I get following error:
http://localhost/reportserver:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Object reference not set to an instance of an object.
Process information: Process ID: 1900 Process name: w3wp.exe Account name: NT AUTHORITYNETWORK SERVICE
Exception information: Exception type: NullReferenceException Exception message: Object reference not set to an instance of an object.
Request information: Request URL: http://localhost/reportserver Request path: /reportserver User host address: 127.0.0.1 User: DOMAINUSERID Is authenticated: True Authentication Type: Negotiate Thread account name: NT AUTHORITYNETWORK SERVICE
Thread information: Thread ID: 1 Thread account name: NT AUTHORITYNETWORK SERVICE Is impersonating: True Stack trace: at Microsoft.ReportingServices.Diagnostics.Globals.EndRequestContext() at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e) at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Custom event details:
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Reporting Services LogFiles:
w3wp!library!8!02/24/2006-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage() w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Library.ConnectionManager.OpenConnection() at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs() --- End of inner exception stack trace --- w3wp!library!1!2006-02-24-10:11:35:: e ERROR: Connection close failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage() w3wp!runningjobs!1!2006-02-24-10:11:35:: e ERROR: Error in timer Running Requests DB : System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Library.ConnectionManager.DisconnectStorage() at Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs() at Microsoft.ReportingServices.Library.RunningJobDbTimer.DoTimerAction() at Microsoft.ReportingServices.Diagnostics.TimerActionBase.TimerAction(Object unused) Thankful for solution or any idea! Regards, Jonas
I have SQL Server Reporting services on Windows 2000.
The reports seem to be working well, but I cannot get a subscription to work. The error I get is the one in the subject line.
I look into my log files and see these lines.
ReportingServicesService!emailextension!ab0!12/07/2007-15:02:07:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
Salam, I get this error, if any one can help me An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get For more information about this error navigate to the report server on the local server machine, or enable remote errors
But I could solve the problem by restarting the IIS , so each time this message appear I restart the IIS and the ReportServer's will work but after some time the problem again will appear . I think the problem with cache in IIS because the session still opened and not closed so how I can solve this
I got rid of the .rdl.data files, which apparently has been a successful fix for this problem in the past. Everything worked fine Thursday when I left (I was off Friday - Saturday), but today I get this error for all but one of the reports in the solution when I try to preview the report. BTW, the published stuff works fine. Thanks in advance for any help.
I'm facing a strange problem.. I've developed few reports. they are working fine in develop environment. after successfull testing they were published on web. in web version, all reports are executing for first time.. if I change any of parameters values or without chaning also.. if I press "View Report" following error occurs..
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'dsMLGDB2Odbc'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors
please suggest any alternative ways to overcome this issue thanks in adv.
I am sync. for the first time (Merge Replication using SQL 2005 and Mobile) and this error keeps poping up on the emulator. I am tring out the tutorial. :) boss on my butt.
Does anyone have any ideas or a solution to this...your help is WELL APPRECIATED ...
