After installing SP1, reports fails to render to PDF, with the following
error from IE:
"Internet Explorer cannot download Format=PDF from myserver.
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or cannot be found. Please try again later."
Before installing SP1 there were no problems rendering to PDF. Export to
EXCEL and other formats works just fine.
The installation is configured like this:
WEBSERVER:
Windows Sever 2003
Reporting Services Standard Edition + SP1 (Microsoft SQL Server Reporting
Services Version 8.00.878.00)
DBSERVER:
Windows Sever 2003
SQL Server 2000 SP3
The ReportServer, MSSQLSERVER services uses the same Domain account.
I've also seen this problem posted on
http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/710/Error-rendering-to-PDF-after-installing-SP1
However there is no solution posted.
Any suggestions on how to resolve this problem would be appreciated
Regards,After hours of testing, i found <Language>no</Language> in the <Style> tag in
one of my textbox... I removed the whole tag and everything works fine. You
need the whole language kode us-en, nb-no etc. search for language in your
xml code
"Jögren Wendel" wrote:
> After installing SP1, reports fails to render to PDF, with the following
> error from IE:
> "Internet Explorer cannot download Format=PDF from myserver.
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or cannot be found. Please try again later."
> Before installing SP1 there were no problems rendering to PDF. Export to
> EXCEL and other formats works just fine.
> The installation is configured like this:
> WEBSERVER:
> Windows Sever 2003
> Reporting Services Standard Edition + SP1 (Microsoft SQL Server Reporting
> Services Version 8.00.878.00)
> DBSERVER:
> Windows Sever 2003
> SQL Server 2000 SP3
> The ReportServer, MSSQLSERVER services uses the same Domain account.
> I've also seen this problem posted on
> http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-reporting/710/Error-rendering-to-PDF-after-installing-SP1
> However there is no solution posted.
> Any suggestions on how to resolve this problem would be appreciated
> Regards,
>
Showing posts with label sp1. Show all posts
Showing posts with label sp1. Show all posts
Thursday, March 29, 2012
Error rendering to PDF, after installing SP1
After installing SP1, a report failed to render to PDF, with the following
error from IE:
"Internet Explorer cannot download Format=PDF from myserver.
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or canot be found. Please try again later."
This happened for this specific report only, 10 others rendered to PDF just
as they did before. The mentioned report renders well in all other formats,
including HTML and Excel. And it renders fine on another Reporting Services
server (without SP1).
SQL server has SP3a. Servers do not have _ in their names.
Regards,
Marko PrsicCan you send your rdl and the .rdl.data file for us to investigate?
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marko Prsic" <marko.prsic...kset.org> wrote in message
news:eSwk7U1YEHA.1000@.TK2MSFTNGP12.phx.gbl...
> After installing SP1, a report failed to render to PDF, with the following
> error from IE:
> "Internet Explorer cannot download Format=PDF from myserver.
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or canot be found. Please try again later."
>
> This happened for this specific report only, 10 others rendered to PDF
just
> as they did before. The mentioned report renders well in all other
formats,
> including HTML and Excel. And it renders fine on another Reporting
Services
> server (without SP1).
> SQL server has SP3a. Servers do not have _ in their names.
> Regards,
> Marko Prsic
>
error from IE:
"Internet Explorer cannot download Format=PDF from myserver.
Internet Explorer was not able to open this Internet site. The requested
site is either unavailable or canot be found. Please try again later."
This happened for this specific report only, 10 others rendered to PDF just
as they did before. The mentioned report renders well in all other formats,
including HTML and Excel. And it renders fine on another Reporting Services
server (without SP1).
SQL server has SP3a. Servers do not have _ in their names.
Regards,
Marko PrsicCan you send your rdl and the .rdl.data file for us to investigate?
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marko Prsic" <marko.prsic...kset.org> wrote in message
news:eSwk7U1YEHA.1000@.TK2MSFTNGP12.phx.gbl...
> After installing SP1, a report failed to render to PDF, with the following
> error from IE:
> "Internet Explorer cannot download Format=PDF from myserver.
> Internet Explorer was not able to open this Internet site. The requested
> site is either unavailable or canot be found. Please try again later."
>
> This happened for this specific report only, 10 others rendered to PDF
just
> as they did before. The mentioned report renders well in all other
formats,
> including HTML and Excel. And it renders fine on another Reporting
Services
> server (without SP1).
> SQL server has SP3a. Servers do not have _ in their names.
> Regards,
> Marko Prsic
>
Error renaming analysis services project
After renaming an analysis services project in bi development studio I receive the following error when deploying the project to SQL2005 AS (SP1):
Error 1 The 'Database' with 'ID' = 'AS UPC Chain Sales ' doesn't exist in the collection. 0 0
However the database is available on the server and can be processed and used. Any ideas how to fix this error?
Try to rename your live database on the Analysis Server using SQL Management Studio.
Then create a new project in BI Dev Studio. Select a project type as "Import Analysis Services 9.0 Database...". Follow the steps and get your project re-created based on the live version of the database.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Tuesday, March 27, 2012
Error programaticaly rendering a report using Reporting Services Web Services
I'm using Reporting Services 2005 SP1 and wrote some code to render reports server-side.
My sample report has few parameters that must be passed so I pass these parameters with code.
My sample report has few parameters that must be passed so I pass these parameters with code.
<My code>
ReportServiceExecution.ReportExecutionService rs = new ReportServiceExecution.ReportExecutionService();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string extension, mimeType, encoding;
ReportServiceExecution.Warning[] warnings;
string[] streamID;
ParameterValue[] parameters = new ParameterValue[2];
parameters[0] = new ParameterValue();
parameters[0].Name = "pID";
parameters[0].Value = "6548747";
parameters[1] = new ParameterValue();
parameters[1].Name = "pClass";
parameters[1].Value = "8";
ExecutionHeader header = new ExecutionHeader();
ExecutionInfo executionInfo = rs.LoadReport(reportPayslip.Name, null);
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
rs.ExecutionHeaderValue = header;
rs.ExecutionHeaderValue.ExecutionID = executionInfo.ExecutionID;
byte[] report = rs.Render("PDF", "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>", out extension, out mimeType, out encoding, out warnings, out streamID);
</My code>
Actually, I have several more parameters but I've checked the collection and all the parameters I want are there and have values. Their names match those found in executionInfo.Parameters. But when I run my code I get the following error on Render():
<Error>
"This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value. > This report requires a default or user-defined value for the report parameter 'pClass'. To run or subscribe to this report, you must provide a parameter value."
</Error>
I've double-checked and my parameter array does have the problematic parameter, I passed it a value but when I check executionInfo.Parameters I see that it's the only parameter that hasn't been give a default value after calling SetExecutionParameters(). So my parameters do seem to be passed but one seems to refuse getting a value. If I comment out the SetExecutionParameters() line I get, as expected a similar error but on another parameter (first one in the executionInfo.Parameters collection). So I'm left to beleive that the SetExecutionParameters() has some kind of bug as it works for all but one parameter. I've checked casing, spelling, tried passing phony parameters and from what I've seen I should be getting an error when I pass the parameters if I got something wrong.
Any help would be much appreciated.
I've done some (desperate) tests and changed the following line:
executionInfo = rs.SetExecutionParameters(parameters, "en-us");
to
executionInfo = rs.SetExecutionParameters(parameters, "fr-ch");
I'm currently based in French Switzerland but our reports are written in english, besides, the documentation about this parameter is basically "A .Net language" which is not very helpful. So now it works but I'm afraid if I have to access a server that is of another culture it will fail.
Friday, March 9, 2012
Error Msg 7355 While using OPENROWSET in SQL Server 2005 SP1
I run the following statement:
SELECT a.*
FROM OPENROWSET
('SQLNCLI', 'Server=MyServer;Trusted_Connection=yes;',
'exec distribution..sp_replmonitorhelpsubscription
@.publisher = MyServer,
@.publication_type = 0,
@.mode = 1') AS a;
and I get the following error:
Msg 7355, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "(null)" supplied
inconsistent metadata for a column. The name was changed at execution time.
My research tells me that this issue was resovled in SQL 2000 SP2. What am I
doing wrong?
This error happens if the result set metadata depends on the parameters and/or can be different at execution time. This is typically the case for results that are constucted dynamically and if columns can change between executions or for different parameter invocations. The OPENROWSET, OPENQUERY calls determine the shape and metadata of the result set by using SET FMTONLY ON setting (this is for SQL Server data sources). With this setting ON, the server will execute the SP but it will not generate results or execute all branches of if..else logic or initialize variables etc. So it is possible that the result set is generated with defaults and contains different set of columns/names. Then when the actual execution of the SP happens, the result set could be different and this will throw the error.
Below are the reasons why you will get the error:
1. If different names were returned for a particular column (based on the ordinal position in the result set)
2. If extra column(s) were returned at execution time than what was determined using SET FMTONLY ON
3. Metadata of the column was different (float changed to decimal or int to bigint and so on)
To resolve the error, you should either correct the SP or use a wrapper SP that can handle the different result sets and provide consistent output. Optionally, you can execute the SP using 4-part names directly or use the EXECUTE AT (new in SQL Server 2005). Both these modifications will will require a linked server setup.
Wednesday, March 7, 2012
Error Messages in Log
I found the following message in my current SQL Server
log. Can anyone tell me what they mean? I'm using 2000
8.00.194 on NT 5.0 SP1. There were 16 of each message and
like message were grouped together.
DATE SOURCE MESSAGE
410735 D0 Module(UMS+000035D0)
(ProcessWorkRequests(class UmsWorkQueue *)+00000264)
4107382 C Module(UMS+0000382C)
(ThreadStartRoutine(void *)+000000BC)
77 E837CD Module(KERNEL32+000037CD)
(TlsSetValue+000000F0)
7800 BEA1 Module(MSVCRT+0000BEA1)
(_beginthread+000000CE)
The databases are poorly designed and are accessed by
several applications, some ColdFusion and others Java.Hi PJ,
Have you considered applying latest service pack to SQL Server 2000? There seems to be a number of known issues fixed in later service pack.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--
| Content-Class: urn:content-classes:message
| From: "PJ" <pdudeck@.rewardsplus.com>
| Sender: "PJ" <pdudeck@.rewardsplus.com>
| Subject: Error Messages in Log
| Date: Thu, 25 Sep 2003 10:16:45 -0700
| Lines: 18
| Message-ID: <044901c38388$cc095360$a301280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcODiMwHKmS2Tz9qQViEMomO8fYbzQ==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308348
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I found the following message in my current SQL Server
| log. Can anyone tell me what they mean? I'm using 2000
| 8.00.194 on NT 5.0 SP1. There were 16 of each message and
| like message were grouped together.
|
| DATE SOURCE MESSAGE
| 410735 D0 Module(UMS+000035D0)
| (ProcessWorkRequests(class UmsWorkQueue *)+00000264)
| 4107382 C Module(UMS+0000382C)
| (ThreadStartRoutine(void *)+000000BC)
| 77 E837CD Module(KERNEL32+000037CD)
| (TlsSetValue+000000F0)
| 7800 BEA1 Module(MSVCRT+0000BEA1)
| (_beginthread+000000CE)
|
| The databases are poorly designed and are accessed by
| several applications, some ColdFusion and others Java.
|
|
log. Can anyone tell me what they mean? I'm using 2000
8.00.194 on NT 5.0 SP1. There were 16 of each message and
like message were grouped together.
DATE SOURCE MESSAGE
410735 D0 Module(UMS+000035D0)
(ProcessWorkRequests(class UmsWorkQueue *)+00000264)
4107382 C Module(UMS+0000382C)
(ThreadStartRoutine(void *)+000000BC)
77 E837CD Module(KERNEL32+000037CD)
(TlsSetValue+000000F0)
7800 BEA1 Module(MSVCRT+0000BEA1)
(_beginthread+000000CE)
The databases are poorly designed and are accessed by
several applications, some ColdFusion and others Java.Hi PJ,
Have you considered applying latest service pack to SQL Server 2000? There seems to be a number of known issues fixed in later service pack.
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights. Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
--
| Content-Class: urn:content-classes:message
| From: "PJ" <pdudeck@.rewardsplus.com>
| Sender: "PJ" <pdudeck@.rewardsplus.com>
| Subject: Error Messages in Log
| Date: Thu, 25 Sep 2003 10:16:45 -0700
| Lines: 18
| Message-ID: <044901c38388$cc095360$a301280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcODiMwHKmS2Tz9qQViEMomO8fYbzQ==| Newsgroups: microsoft.public.sqlserver.server
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.server:308348
| NNTP-Posting-Host: TK2MSFTNGXA11 10.40.1.163
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I found the following message in my current SQL Server
| log. Can anyone tell me what they mean? I'm using 2000
| 8.00.194 on NT 5.0 SP1. There were 16 of each message and
| like message were grouped together.
|
| DATE SOURCE MESSAGE
| 410735 D0 Module(UMS+000035D0)
| (ProcessWorkRequests(class UmsWorkQueue *)+00000264)
| 4107382 C Module(UMS+0000382C)
| (ThreadStartRoutine(void *)+000000BC)
| 77 E837CD Module(KERNEL32+000037CD)
| (TlsSetValue+000000F0)
| 7800 BEA1 Module(MSVCRT+0000BEA1)
| (_beginthread+000000CE)
|
| The databases are poorly designed and are accessed by
| several applications, some ColdFusion and others Java.
|
|
Friday, February 24, 2012
error message on publisher
SQL 2005 sp1 merge replication. 1 publisher/distributor. 20 SQL
Express(SP1) subscriptions.
Working OK since we set up about 7 weeks ago, today we recieved the
following error when attempting an update on the publisher. The table
is bidirectional, auto identity range mgmt, column level tracking.
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]UPDATECOLVBM: The parameter 'colv' is not valid.
The error occurred on line 311.
Can anyone shed any light on this? Where to begin looking? Hopefully
there is a way to correct without losing data at the existing
subscriptions.
TIA,
John G.
Can you enable logging so we can determine which proc this is failing on?
Here is a kbarticle which describes how to do this.
http://support.microsoft.com/default.aspx/kb/312292
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<jgmeinder@.gmail.com> wrote in message
news:1169493886.403936.320150@.38g2000cwa.googlegro ups.com...
> SQL 2005 sp1 merge replication. 1 publisher/distributor. 20 SQL
> Express(SP1) subscriptions.
> Working OK since we set up about 7 weeks ago, today we recieved the
> following error when attempting an update on the publisher. The table
> is bidirectional, auto identity range mgmt, column level tracking.
> Error Executing Database Query. [Macromedia][SQLServer JDBC
> Driver][SQLServer]UPDATECOLVBM: The parameter 'colv' is not valid.
> The error occurred on line 311.
> Can anyone shed any light on this? Where to begin looking? Hopefully
> there is a way to correct without losing data at the existing
> subscriptions.
> TIA,
> John G.
>
|||Sorry, I wasn't very clear, the error occurs when running a T-SQL
update statement on the publisher database, not when an agent is
running. I executed the SQL outside of our app and got the following
error from the merge upd trigger.
Msg 18750, Level 16, State 1, Procedure
MSmerge_upd_6F87E78AF9BA4EC881AD11085DED1A80, Line 100
UPDATECOLVBM: The parameter 'colv' is not valid.
Msg 3621, Level 16, State 1, Procedure
MSmerge_upd_6F87E78AF9BA4EC881AD11085DED1A80, Line 100
The statement has been terminated.
The SQL:
UPDATE tblAlaska_Facility_Manager SET [organization_establishment] =
'Absolute Fresh Seafoods Inc'
WHERE facilityID = 2732
In the app they updated more columns, but otherwise is exactly the
same.
I can see the line it is referring to in the trigger, but do not
understand the syntax.
Also, I have found rows that the update completes correctly, and some
that error with the same exact error. I am going to try see if there
is anything common between the rows that error and the rows that do
not.
Thanks,
jg
Hilary Cotter wrote:[vbcol=seagreen]
> Can you enable logging so we can determine which proc this is failing on?
> Here is a kbarticle which describes how to do this.
> http://support.microsoft.com/default.aspx/kb/312292
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <jgmeinder@.gmail.com> wrote in message
> news:1169493886.403936.320150@.38g2000cwa.googlegro ups.com...
|||I could not discover any commonalities between the rows that returned
the error. So we did a simple update at a subscriber, and it worked,
while the same update at the publisher would error. We then did a
sync, and the rows at the publisher 'freed up', so that updates to the
rows work now.
We see this behavior once in a while, and until this time we would drop
the article and re-create it. But in this case our customers with
subscribers could not afford to lose any data that changed at any
subscription.
At least we have a work around, but I wouldn't mind getting an
understanding of what is causing this behavior.
Thanks,
jg
Express(SP1) subscriptions.
Working OK since we set up about 7 weeks ago, today we recieved the
following error when attempting an update on the publisher. The table
is bidirectional, auto identity range mgmt, column level tracking.
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver][SQLServer]UPDATECOLVBM: The parameter 'colv' is not valid.
The error occurred on line 311.
Can anyone shed any light on this? Where to begin looking? Hopefully
there is a way to correct without losing data at the existing
subscriptions.
TIA,
John G.
Can you enable logging so we can determine which proc this is failing on?
Here is a kbarticle which describes how to do this.
http://support.microsoft.com/default.aspx/kb/312292
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<jgmeinder@.gmail.com> wrote in message
news:1169493886.403936.320150@.38g2000cwa.googlegro ups.com...
> SQL 2005 sp1 merge replication. 1 publisher/distributor. 20 SQL
> Express(SP1) subscriptions.
> Working OK since we set up about 7 weeks ago, today we recieved the
> following error when attempting an update on the publisher. The table
> is bidirectional, auto identity range mgmt, column level tracking.
> Error Executing Database Query. [Macromedia][SQLServer JDBC
> Driver][SQLServer]UPDATECOLVBM: The parameter 'colv' is not valid.
> The error occurred on line 311.
> Can anyone shed any light on this? Where to begin looking? Hopefully
> there is a way to correct without losing data at the existing
> subscriptions.
> TIA,
> John G.
>
|||Sorry, I wasn't very clear, the error occurs when running a T-SQL
update statement on the publisher database, not when an agent is
running. I executed the SQL outside of our app and got the following
error from the merge upd trigger.
Msg 18750, Level 16, State 1, Procedure
MSmerge_upd_6F87E78AF9BA4EC881AD11085DED1A80, Line 100
UPDATECOLVBM: The parameter 'colv' is not valid.
Msg 3621, Level 16, State 1, Procedure
MSmerge_upd_6F87E78AF9BA4EC881AD11085DED1A80, Line 100
The statement has been terminated.
The SQL:
UPDATE tblAlaska_Facility_Manager SET [organization_establishment] =
'Absolute Fresh Seafoods Inc'
WHERE facilityID = 2732
In the app they updated more columns, but otherwise is exactly the
same.
I can see the line it is referring to in the trigger, but do not
understand the syntax.
Also, I have found rows that the update completes correctly, and some
that error with the same exact error. I am going to try see if there
is anything common between the rows that error and the rows that do
not.
Thanks,
jg
Hilary Cotter wrote:[vbcol=seagreen]
> Can you enable logging so we can determine which proc this is failing on?
> Here is a kbarticle which describes how to do this.
> http://support.microsoft.com/default.aspx/kb/312292
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <jgmeinder@.gmail.com> wrote in message
> news:1169493886.403936.320150@.38g2000cwa.googlegro ups.com...
|||I could not discover any commonalities between the rows that returned
the error. So we did a simple update at a subscriber, and it worked,
while the same update at the publisher would error. We then did a
sync, and the rows at the publisher 'freed up', so that updates to the
rows work now.
We see this behavior once in a while, and until this time we would drop
the article and re-create it. But in this case our customers with
subscribers could not afford to lose any data that changed at any
subscription.
At least we have a work around, but I wouldn't mind getting an
understanding of what is causing this behavior.
Thanks,
jg
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)