I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003
server. The configuration has been unchanged for approx. 3 weeks. Suddenly
over the last two days, reports being accessed via an ASP.NET 2.0 application
(on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
became inaccessable. End users received the following error:
********************************************************
Message: An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
An error occurred during rendering of the report. -->
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt.
Stack Trace: 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 IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
String Format, String HistoryID, String DeviceInfo, ParameterValue[]
Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
References\SQLReportingService\Reference.vb:line 1319
at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
Boolean isDraft, Boolean isCertified) in
C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
551
at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
********************************************************
A short term resolution has been to perform iisrest on the ReportServer.
However, the problem reappears later at random intervals.
This only seems to be an issue with reports being called using SOAP.
Reports being rendering in the .NET Report Viewer control appear unaffected.
Here is some sample code to illustrate how we call some of our reports from
ASP.NET through the SSRS web service:
************************************************************
Private callback As New
System.Net.Security.RemoteCertificateValidationCallback(AddressOf
RemoteCertificateValidationCallback)
Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
ByVal cert As
System.Security.Cryptography.X509Certificates.X509Certificate, _
ByVal chain As
System.Security.Cryptography.X509Certificates.X509Chain, _
ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
Return True
End Function
Sub RenderReport()
Dim rs As New SQLReportingService.ReportingService
Dim results As [Byte]() = Nothing
System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
rs.Credentials = New System.Net.NetworkCredential("User", "Password",
"Domain")
results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing)
Response.Clear()
Response.Buffer = True
Response.Expires = 0
Response.ContentType = "application/pdf"
Response.AppendHeader("Content-Disposition", "attachment;
filename=Report.pdf")
Response.BinaryWrite(results)
Response.End()
End Sub
************************************************************
Does anyone see a problem with the above code. It has been in production
for 3 weeks now and has been working fine until yesterday. Any help would be
greatly appreciated!Try running memtest: www.memtest.org. You may have bad memory.
"mjorangehawk" wrote:
> I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003
> server. The configuration has been unchanged for approx. 3 weeks. Suddenly
> over the last two days, reports being accessed via an ASP.NET 2.0 application
> (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
> became inaccessable. End users received the following error:
> ********************************************************
> Message: An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> An error occurred during rendering of the report. -->
> Attempted to read or write protected memory. This is often an indication
> that other memory is corrupt.
> Stack Trace: 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 IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
> String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
> References\SQLReportingService\Reference.vb:line 1319
> at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
> Boolean isDraft, Boolean isCertified) in
> C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
> 551
> at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
> in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
> ********************************************************
> A short term resolution has been to perform iisrest on the ReportServer.
> However, the problem reappears later at random intervals.
> This only seems to be an issue with reports being called using SOAP.
> Reports being rendering in the .NET Report Viewer control appear unaffected.
> Here is some sample code to illustrate how we call some of our reports from
> ASP.NET through the SSRS web service:
> ************************************************************
> Private callback As New
> System.Net.Security.RemoteCertificateValidationCallback(AddressOf
> RemoteCertificateValidationCallback)
> Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
> ByVal cert As
> System.Security.Cryptography.X509Certificates.X509Certificate, _
> ByVal chain As
> System.Security.Cryptography.X509Certificates.X509Chain, _
> ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
> Return True
> End Function
>
> Sub RenderReport()
> Dim rs As New SQLReportingService.ReportingService
> Dim results As [Byte]() = Nothing
> System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
> rs.Credentials = New System.Net.NetworkCredential("User", "Password",
> "Domain")
> results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
> Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> Nothing, Nothing)
>
> Response.Clear()
> Response.Buffer = True
> Response.Expires = 0
> Response.ContentType = "application/pdf"
> Response.AppendHeader("Content-Disposition", "attachment;
> filename=Report.pdf")
> Response.BinaryWrite(results)
> Response.End()
> End Sub
> ************************************************************
> Does anyone see a problem with the above code. It has been in production
> for 3 weeks now and has been working fine until yesterday. Any help would be
> greatly appreciated!
>|||Actually, it turns out the problem was related to a database image that was
being loaded into the report dynamically. The image control on the report
had a MIME type of jpg but we had a few cases of images that had been
inserted into the database as TIF's. Once we replaced those with JPG
versions the problem went away.
"breno" wrote:
> Try running memtest: www.memtest.org. You may have bad memory.
> "mjorangehawk" wrote:
> > I am running SQL Reporting Services and SQL Server 2005 on a Windows 2003
> > server. The configuration has been unchanged for approx. 3 weeks. Suddenly
> > over the last two days, reports being accessed via an ASP.NET 2.0 application
> > (on Windows 2003 Server with IIS 6) using a SOAP call to the reportserver
> > became inaccessable. End users received the following error:
> >
> > ********************************************************
> >
> > Message: An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > An error occurred during rendering of the report. -->
> > Attempted to read or write protected memory. This is often an indication
> > that other memory is corrupt.
> >
> > Stack Trace: 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 IFA.CAP.SQLReportingService.ReportingService.Render(String Report,
> > String Format, String HistoryID, String DeviceInfo, ParameterValue[]
> > Parameters, DataSourceCredentials[] Credentials, String ShowHideToggle,
> > String& Encoding, String& MimeType, ParameterValue[]& ParametersUsed,
> > Warning[]& Warnings, String[]& StreamIds) in C:\Applications\IFACAP\Web
> > References\SQLReportingService\Reference.vb:line 1319
> > at IFA.CAP.BusinessObjects.Reports.Certificate(Int32 certificateID,
> > Boolean isDraft, Boolean isCertified) in
> > C:\Applications\IFACAP\BusinessObjects\IFA.CAP.BusinessObjects.Report.vb:line
> > 551
> > at IFA.CAP.CertificateDetail.PrintCertificate(Object sender, EventArgs e)
> > in C:\Applications\IFACAP\Main\CertificateDetail.aspx.vb:line 2287
> >
> > ********************************************************
> >
> > A short term resolution has been to perform iisrest on the ReportServer.
> > However, the problem reappears later at random intervals.
> >
> > This only seems to be an issue with reports being called using SOAP.
> > Reports being rendering in the .NET Report Viewer control appear unaffected.
> >
> > Here is some sample code to illustrate how we call some of our reports from
> > ASP.NET through the SSRS web service:
> >
> > ************************************************************
> >
> > Private callback As New
> > System.Net.Security.RemoteCertificateValidationCallback(AddressOf
> > RemoteCertificateValidationCallback)
> >
> > Private Function RemoteCertificateValidationCallback(ByVal sender As Object, _
> > ByVal cert As
> > System.Security.Cryptography.X509Certificates.X509Certificate, _
> > ByVal chain As
> > System.Security.Cryptography.X509Certificates.X509Chain, _
> > ByVal sslPolicyErrors As System.Net.Security.SslPolicyErrors) As Boolean
> >
> > Return True
> >
> > End Function
> >
> >
> > Sub RenderReport()
> > Dim rs As New SQLReportingService.ReportingService
> > Dim results As [Byte]() = Nothing
> >
> > System.Net.ServicePointManager.ServerCertificateValidationCallback = callback
> >
> > rs.Credentials = New System.Net.NetworkCredential("User", "Password",
> > "Domain")
> >
> > results = rs.Render(String.Concat("TargerFolder", "ReportName"), "PDF",
> > Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > Nothing, Nothing)
> >
> >
> > Response.Clear()
> > Response.Buffer = True
> > Response.Expires = 0
> > Response.ContentType = "application/pdf"
> > Response.AppendHeader("Content-Disposition", "attachment;
> > filename=Report.pdf")
> > Response.BinaryWrite(results)
> > Response.End()
> > End Sub
> >
> > ************************************************************
> >
> > Does anyone see a problem with the above code. It has been in production
> > for 3 weeks now and has been working fine until yesterday. Any help would be
> > greatly appreciated!
> >
Showing posts with label ssrs. Show all posts
Showing posts with label ssrs. Show all posts
Thursday, March 29, 2012
Monday, March 12, 2012
Error occurred during rendering of the report. Stack Empty.
I have developed a report in SSRS 2005. When I try to export the output to Excel, it shows an error saying:
Error occurred during local report processing.
Error occurred during rendering of the report. Stack Empty.
Do anyone have any idea what this means and how to fix it?
I can render the report in other formats (Adobe, csv etc) without any problem. My other reports, under same project and using same dataset, are working fine.
Thanks in Advance.
Have you checked your log files for errors?
C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles
You may need to crank up the level of tracing to get anything interesting:
http://technet.microsoft.com/en-us/library/ms156500.aspx
Does the report render in Excel for a different dataset? Try faking a dataset using something like:
SELECT 1 AS Age, 'M' AS Sex
UNION
SELECT 7 AS Age, 'F' AS Sex
and see if you render correctly. Make sure you have 'alligned your edges' to reduce the complexity of the resulting Excel. If you want to (are willing/able to) send me your RDL, I will take a look and post the results of my analysis back here.
Friday, February 17, 2012
Error message "The report server is not responding" in SSRS - part 2
Hi,
RS 2005 (sql 2005 SP1) on Windows 2003 SP1
The report server was running ok until this morning. Its just giving a "The report server is not responding. Verify that the report server is running and can be accessed from this computer." message when trying to open the report manager.
Any ideas?
In the SQLDUMPER_ERRORLog.log file there is this..
05/22/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 328
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
05/22/06 12:53:36, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\SQLDmpr0001.mdmp
05/22/06 12:53:37, ACTION, w3wp.exe, Watson Invoke: No
I have the same problem now, but I am setting up a new deployment on another server, the original one can display the reports but it can not email out the reports.
Even though I am setting up a new report service on another server, I am encountering an error like the following:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://lasc06/reportserver.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK|||Hi,
first thing for me would be to install the latest service pack first (You are running on the RTM version whereas the version 9.0.00.2047 is the most current.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
I looked at the log file and I found the following error:
07/24/06 18:20:55, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
Can someone provide me some tips? I have changed the permissions over here and there, I still have the same error...
and that caused me not able to access http://myserver/reports nor http://myserver/reportserver
|||This is the same error I had, I spent 2 days looking for a resolution but couldn't find one. I ended up re-installing SQL 2005 which obviously fixed the problem.
You may want to consider paying for some Microsoft support as I dont think anyone here knows the answers to this.
|||Hi,
The thing is I got this error after I installed a brand new report service on a server. I have reinstalled SQL 2005 so many times to solve this problem, but I still have the same error.
I am thinking, there are places I probably did not configure right during the report service setup, and the problem is I don't even know what are the right configurations I need to setup for the new report service. The following shows the error I found in the log file, looks like something is wrong with the pooling:
--
ReportingServicesService!library!4!7/25/2006-05:04:48:: i INFO: Catalog SQL Server Edition = Standard
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Exporting public key
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Performing sku validation
ReportingServicesService!crypto!4!7/25/2006-05:04:49:: i INFO: Importing existing encryption key
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: EventPolling polling service started
ReportingServicesService!dbpolling!a!7/25/2006-05:04:49:: EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: NotificationPolling polling service started
ReportingServicesService!dbpolling!b!7/25/2006-05:04:49:: NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: SchedulePolling polling service started
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: UpgradePolling polling service started
ReportingServicesService!dbpolling!c!7/25/2006-05:04:49:: Polling started
ReportingServicesService!dbpolling!c!7/25/2006-05:04:49:: Polling caught an exception, restarting polling. Error Message System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_AuthenticationType()
at Microsoft.ReportingServices.Library.NotificationQueueWorker.get_PollCommand()
at Microsoft.ReportingServices.Library.DBPoll.PollingFunction()
at Microsoft.ReportingServices.Library.DBPoll.PollingStartFunction().
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=164895&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=463047&SiteID=1
|||I'm suffering from this problem but in my case sometimes the report works and sometimes not.
It's very strange.
The content of the Reporting Services' log file is:
08/25/06 14:22:49, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 4012
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x14DB9AF4
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles\SQLDmpr0119.mdmp
08/25/06 14:22:51, ACTION, w3wp.exe, Watson Invoke: No
Thanks since now for any help
Jo?o Talles Dantas Batista
jtdbf@.hotmail.com
Hi,
I solved my problem by going through the tips provided by someon else, it worked...
Beside the tips, you have to check IIS setting about the pooling...
I had a problem because I found out my report service was not with SQL 2005, it was the version before SQL 2005...
So, if you installed Report Service not along with SQL Server, you will have a lot of problems.
http://www.atrevido.net/blog/CategoryView.aspx?category=Security
|||Hello everyone,
I'm having at the present the same problem - my RS instance returns "The report server is not responding..."-message. Here is my scenario: 2 virtual PCs (VPC1 and VPC2). The SSRS is installed on both machines, and both instances configured to use one database, hosted on VPC2. VPC1 serves as Web-server.
I followed the hints listed in "How To: Configure a report server Scale-out deployment" from Books Online. I used "Reporting Services Configuration Manager" on both VPCs to set up the properties of the instances. I can see both instances from SQL Server Management Studio.
When I checked the log file, I saw the following message (among all INFOs):
Code Snippet
w3wp!ui!1!8/14/2007-14:34:17:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!1!8/14/2007-14:34:17:: e ERROR: HTTP status code --> 500
-Details--
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!8/14/2007-14:34:19:: 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)
Error 500 isn't really helpful.
Does anyone have further hints or ideas?
Thanks in advantage,
Andrey
|||Hello again,
today I reinstalled the instances of SQL server on both VPCs. At the present I have DB engine installed on VPC1 and reporting services installed on VPC2. I can access the DB engine from VPC2 using SQL Server Management Studio, but when I open browser, I get the same error.
I suspect, there is a problem with IIS configuration. I will try to find out what could be a reason for this behaviour.
Regards,
Andrey
|||I reinstalled the IIS on VPC2 and the reconfigured Reporting Services using "Rep. Services Configuration Manager". When I try to access http://localhost/reports on VPC2, I get the following error:
Server Error in '/Reports' Application.
--
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.
Source Error:
Line 162: </webParts>
Line 163: <machineKey validationKey="******" decryptionKey="***" validation="SHA1" />
Line 164: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
Line 165: </system.web>
Line 166: <runtime>
Source File: c:\inetpub\wwwroot\web.config Line: 164
--
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
Does anyone know, what that means?
Regards,
Andrey.
|||After re-installing IIS did you reconfigure ASP.net 2.0?If not run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -iru
gatharia
http://sharepointhacks.blogspot.com/
|||
Hello,
this is a nice point. I really forgott to register .NET 2.0 with new installation of IIS. :-( Additionally I removed Sharepoint Server 2007 from the VPC.
At the present I need to stop my experiments, but I will return to them soon. The latest step I did was to install the default configuration of RS on VPC2 - just to check, that everything works. Later on I want to change the DB used by the installtion.
Regards,
Andrey
Error message "The report server is not responding" in SSRS
Hi,
RS 2005 (sql 2005 SP1) on Windows 2003 SP1
The report server was running ok until this morning. Its just giving a "The report server is not responding. Verify that the report server is running and can be accessed from this computer." message when trying to open the report manager.
Any ideas?
In the SQLDUMPER_ERRORLog.log file there is this..
05/22/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 328
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
05/22/06 12:53:36, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\SQLDmpr0001.mdmp
05/22/06 12:53:37, ACTION, w3wp.exe, Watson Invoke: No
I have the same problem now, but I am setting up a new deployment on another server, the original one can display the reports but it can not email out the reports.
Even though I am setting up a new report service on another server, I am encountering an error like the following:
TITLE: Microsoft Report Designer
A connection could not be made to the report server http://lasc06/reportserver.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)
BUTTONS:
OK|||Hi,
first thing for me would be to install the latest service pack first (You are running on the RTM version whereas the version 9.0.00.2047 is the most current.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
I looked at the log file and I found the following error:
07/24/06 18:20:55, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
Can someone provide me some tips? I have changed the permissions over here and there, I still have the same error...
and that caused me not able to access http://myserver/reports nor http://myserver/reportserver
|||This is the same error I had, I spent 2 days looking for a resolution but couldn't find one. I ended up re-installing SQL 2005 which obviously fixed the problem.
You may want to consider paying for some Microsoft support as I dont think anyone here knows the answers to this.
|||Hi,
The thing is I got this error after I installed a brand new report service on a server. I have reinstalled SQL 2005 so many times to solve this problem, but I still have the same error.
I am thinking, there are places I probably did not configure right during the report service setup, and the problem is I don't even know what are the right configurations I need to setup for the new report service. The following shows the error I found in the log file, looks like something is wrong with the pooling:
--
ReportingServicesService!library!4!7/25/2006-05:04:48:: i INFO: Catalog SQL Server Edition = Standard
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Initializing crypto as user: NT AUTHORITY\NETWORK SERVICE
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Exporting public key
ReportingServicesService!crypto!4!7/25/2006-05:04:48:: i INFO: Performing sku validation
ReportingServicesService!crypto!4!7/25/2006-05:04:49:: i INFO: Importing existing encryption key
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: EventPolling polling service started
ReportingServicesService!dbpolling!a!7/25/2006-05:04:49:: EventPolling heartbeat thread started.
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: NotificationPolling polling service started
ReportingServicesService!dbpolling!b!7/25/2006-05:04:49:: NotificationPolling heartbeat thread started.
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: SchedulePolling polling service started
ReportingServicesService!dbpolling!4!07/25/2006-05:04:49:: UpgradePolling polling service started
ReportingServicesService!dbpolling!c!7/25/2006-05:04:49:: Polling started
ReportingServicesService!dbpolling!c!7/25/2006-05:04:49:: Polling caught an exception, restarting polling. Error Message System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_AuthenticationType()
at Microsoft.ReportingServices.Library.NotificationQueueWorker.get_PollCommand()
at Microsoft.ReportingServices.Library.DBPoll.PollingFunction()
at Microsoft.ReportingServices.Library.DBPoll.PollingStartFunction().
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=164895&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=463047&SiteID=1
|||I'm suffering from this problem but in my case sometimes the report works and sometimes not.
It's very strange.
The content of the Reporting Services' log file is:
08/25/06 14:22:49, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 4012
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x14DB9AF4
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
08/25/06 14:22:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
08/25/06 14:22:51, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.6\Reporting Services\LogFiles\SQLDmpr0119.mdmp
08/25/06 14:22:51, ACTION, w3wp.exe, Watson Invoke: No
Thanks since now for any help
Jo?o Talles Dantas Batista
jtdbf@.hotmail.com
Hi,
I solved my problem by going through the tips provided by someon else, it worked...
Beside the tips, you have to check IIS setting about the pooling...
I had a problem because I found out my report service was not with SQL 2005, it was the version before SQL 2005...
So, if you installed Report Service not along with SQL Server, you will have a lot of problems.
http://www.atrevido.net/blog/CategoryView.aspx?category=Security
|||Hello everyone,
I'm having at the present the same problem - my RS instance returns "The report server is not responding..."-message. Here is my scenario: 2 virtual PCs (VPC1 and VPC2). The SSRS is installed on both machines, and both instances configured to use one database, hosted on VPC2. VPC1 serves as Web-server.
I followed the hints listed in "How To: Configure a report server Scale-out deployment" from Books Online. I used "Reporting Services Configuration Manager" on both VPCs to set up the properties of the instances. I can see both instances from SQL Server Management Studio.
When I checked the log file, I saw the following message (among all INFOs):
Code Snippet
w3wp!ui!1!8/14/2007-14:34:17:: e ERROR: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
w3wp!ui!1!8/14/2007-14:34:17:: e ERROR: HTTP status code --> 500
-Details--
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!8/14/2007-14:34:19:: 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)
Error 500 isn't really helpful.
Does anyone have further hints or ideas?
Thanks in advantage,
Andrey
|||Hello again,
today I reinstalled the instances of SQL server on both VPCs. At the present I have DB engine installed on VPC1 and reporting services installed on VPC2. I can access the DB engine from VPC2 using SQL Server Management Studio, but when I open browser, I get the same error.
I suspect, there is a problem with IIS configuration. I will try to find out what could be a reason for this behaviour.
Regards,
Andrey
|||I reinstalled the IIS on VPC2 and the reconfigured Reporting Services using "Rep. Services Configuration Manager". When I try to access http://localhost/reports on VPC2, I get the following error:
Server Error in '/Reports' Application.
--
Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
Parser Error Message: Cannot use 'partitionResolver' unless the mode is 'StateServer' or 'SQLServer'.
Source Error:
Line 162: </webParts>
Line 163: <machineKey validationKey="******" decryptionKey="***" validation="SHA1" />
Line 164: <sessionState mode="SQLServer" timeout="60" allowCustomSqlDatabase="true" partitionResolverType="Microsoft.Office.Server.Administration.SqlSessionStateResolver, Microsoft.Office.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" />
Line 165: </system.web>
Line 166: <runtime>
Source File: c:\inetpub\wwwroot\web.config Line: 164
--
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
Does anyone know, what that means?
Regards,
Andrey.
|||After re-installing IIS did you reconfigure ASP.net 2.0?If not run C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -iru
gatharia
http://sharepointhacks.blogspot.com/
|||
Hello,
this is a nice point. I really forgott to register .NET 2.0 with new installation of IIS. :-( Additionally I removed Sharepoint Server 2007 from the VPC.
At the present I need to stop my experiments, but I will return to them soon. The latest step I did was to install the default configuration of RS on VPC2 - just to check, that everything works. Later on I want to change the DB used by the installtion.
Regards,
Andrey
Subscribe to:
Posts (Atom)