472,783 Members | 976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,783 software developers and data experts.

text/xml reporting service error

RdS
Hello,

I use sourcesafe and vb 2003 for my dev environment. on the sourcesafe
server I also have sql2005 and reporting services installed. The web app
references this sql server for db. When I compile the app on my local
machine which is used for development I am able to lauch application with no
problem. When I run my web app on my local machine which uses my IIS 5
(WinXP Pro) the application runs fine. But if I connect to server where
code is actually stored and run from that machine I receive the following
error. The error is with the reportingservice.asmx proxy I have in my code.
what is the problem and how do I correct? thanks.

Client found response content type of '', but expected 'text/xml'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Client found response
content type of '', but expected 'text/xml'.

Source Error:

Line 554: "",
RequestNamespace:="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices",
ResponseNamespace:="http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices",
Use:=System.Web.Services.Description.SoapBindingUs e.Literal,
ParameterStyle:=System.Web.Services.Protocols.Soap ParameterStyle.Wrapped)_
Line 555: Public Function Render(ByVal Report As String, ByVal Format
As String, ByVal HistoryID As String, ByVal DeviceInfo As String, ByVal
Parameters() As ParameterValue, ByVal Credentials() As
DataSourceCredentials, ByVal ShowHideToggle As String, ByRef Encoding As
String, ByRef MimeType As String, ByRef ParametersUsed() As ParameterValue,
ByRef Warnings() As Warning, ByRef StreamIds() As String) As
<System.Xml.Serialization.XmlElementAttribute("Res ult",
DataType:="base64Binary")Byte()
Line 556: Dim results() As Object = Me.Invoke("Render", New
Object() {Report, Format, HistoryID, DeviceInfo, Parameters, Credentials,
ShowHideToggle})
Line 557: Encoding = CType(results(1), String)
Line 558: MimeType = CType(results(2), String)

Source File: C:\Inetpub\wwwroot\AIL_2003\Framework\ReportingSer vice.vb
Line: 556
Jul 3 '06 #1
2 5238
Hello RdS,

Welcome to the MSDN newsgroup.

From your description, I understand you have a web application(ASP.NET)
which will connect to a remote SQL Server 2005database. The SQL Server 2005
instance also has reporting service installed and your web application will
use webservice SOAP api to query report from the SQL 2005 reporting
service. However, you found the web application run well on some machines,
but failed with a

"System.InvalidOperationException: Client found response content type of
'', but expected 'text/xml'."

error on some others, correct?

As for this issue, I'm still having some unclear points on your
application's environment. Currently how many machines are there involved
in this application. ( I assume that there is only two, the web
application's server and the SQL Server 2005 server, right?). Also, as
you mentioned:

==============
When I run my web app on my local machine which uses my IIS 5
(WinXP Pro) the application runs fine. But if I connect to server where
code is actually stored and run from that machine I receive the following
error.
==================

I'd appreciate if you can provide some further description on the two
condition(one works and the other fails). Especially the " if I connect to
server where code is actually stored and run from that machine", what does
the "connect to server" mean, are you connecting the IIS virtual directory
to the remote server(through file share) or is the "connect" just means
data access connection to a remote server?

Generally, as for such "System.InvalidOperationException: Client found
response content type of '', but expected 'text/xml'." exception, it is
likely caused by the remote webservice didn't return the expected response
content (SOAP response message of text/xml format). Therefore, for generic
troubleshooting, you can consider using some http/tcp trace tools to
capture the webservcie request/response message to see whether they're of
the correct format or content. There are some well-known trace tools such
as tcpTrace or the trace utility in the soap toolkit 3.0(you can get it
through the following link):

http://www.microsoft.com/downloads/d...0DD-CEEC-4088-
9753-86F052EC8450&displaylang=en
In addition, based on my research over the web, there has been some
similiar issues with the same error you encountered and most of them are
caused by the webservice client proxy is pointing to an incorrect service
endpoint( the target servcie Url). So you can also check your webservcie
client proxy's "Url" property to see whether it points to the correct
service endpoint. For your scenario, since your reporting service proxy is
calling the "Render" method, it should belongs to the execution Service ,
its end point should be something like:

http://server/reportserver/ReportExecution2005.asmx

rather than the

http://server/reportserver/ReportService2005.asmx

which is mainly for management webservice apis.

Please have a look at the above items. If there is anything unclear on
this, please feel free to post here. Hope this helps you some.

Regards,

Steven Cheng
Microsoft MSDN Online Support Lead
==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)



Jul 4 '06 #2
Hello RdS,

How are you doing on this issue? Have you got any progress or does my last
reply helps you a little on this? If there is anything else we can help,
please feel free to post here.

Regards,

Steven Cheng
Microsoft MSDN Online Support Lead
==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Jul 7 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: ferit meftun harmankaya | last post by:
I have some report which are designed in "Crystal Report". I want to run these reports in "Reporting Service" My aim is to convert from extension of Crystal Report (rpt) to extension of reporting...
4
by: Fabian von Romberg | last post by:
Hi, I have installed Sql Reporting Services on 2 machines, one is WIN 2000 PRO and the other one is WIN 2000 ADV. SERVER. When I try to access a report using the webbrowser, I get the following...
1
by: hotice3100 | last post by:
I have created an interface for a SQL Reporting Service report. SQL Reporting Service makes a virutal directly in IIS called ReportServer. There are various buttons on the form I created and one...
7
by: ad | last post by:
I found that there is reporting service bundle with SQLSever 2005 express. Can VS2005 express can use the reporting service in SQLSever 2005 express?
8
by: Woody Splawn | last post by:
I am asking this question here because I asked this question in the Reporting Services Newsgroup and did not get an answer. Does anyone know if Reporting Services is intended to work in a...
6
by: Joe | last post by:
C# .NET 2.0 I've got a Windows Service that works exactly as I expect it to. However, it does rely on a few Configuration settings. If the customer doesn't configure it correctly, the service...
0
by: rmk | last post by:
How can I get the 2000 and 2005 versions of SQL Server Reporting Services both working on my development laptop ????? I have ASP.NET 1.1 and 2.0 installed on my laptop. I have Visual Studio...
1
by: adrock | last post by:
I'm using a Reporting Services web service in a web application built in VB.net. When I run the app in Visual Studio it works fine and I'm able to use the methods in the Reporting Services class,...
0
by: fperri | last post by:
Hi, I am trying to configure reporting services which I just added to an already existing installation of SQL Server 2005. When I am in the reporting services configuration manager and I am trying...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.