Solved

SSRS Application Issues

Posted on 2015-01-14
4
106 Views
Last Modified: 2015-02-20
I am attempting to generate a report in SSRS 2008 R2, the problem that I am having seems to be in the service itself as I am attempting to retrieve information.  I get the following error when I attempt to run the reportingservice.createschedule() command:

Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
0
Comment
Question by:VBBRett
  • 3
4 Comments
 
LVL 11

Accepted Solution

by:
Nakul Vachhrajani earned 500 total points
ID: 40551698
Looks like the SSRS service is not responding with a proper XML.

What is the edition of SQL Server you are using (Developer/Standard/Enterprise, etc)?
Also, I am wondering if the firewall and/or proxy is blocking the communication between the SSRS service and the application?
0
 

Author Comment

by:VBBRett
ID: 40552148
SQL Server 2008 R2 so essentially SQL Reporting Service 2010.  Anything else you would like to know?
0
 

Author Comment

by:VBBRett
ID: 40552265
Here is the error that I received:

Server Error in '/' Application.
--------------------------------------------------------------------------------

Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.
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'.
The request failed with an empty response.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace:


[InvalidOperationException: Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response.]
   System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +734433
   System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +345
   reports.hillintl.com.ReportingServices2010.ReportingService2010.CreateSchedule(String Name, ScheduleDefinition ScheduleDefinition, String SiteUrl) in C:\Users\H34829\documents\visual studio 2013\Projects\reports.hillintl.com\reports.hillintl.com\Web References\ReportingServices2010\Reference.vb:2634
   reports.hillintl.com.hiReportScheduling.fnCreateRSSchedule(String sessionID) in C:\Users\H34829\documents\visual studio 2013\Projects\reports.hillintl.com\reports.hillintl.com\hiReportScheduling.aspx.vb:933
   reports.hillintl.com.hiReportScheduling.fnCreateSubscription(Int32 intProfileID) in C:\Users\H34829\documents\visual studio 2013\Projects\reports.hillintl.com\reports.hillintl.com\hiReportScheduling.aspx.vb:481
   reports.hillintl.com.hiReportScheduling.cmdProcessSelections_Click(Object sender, EventArgs e) in C:\Users\H34829\documents\visual studio 2013\Projects\reports.hillintl.com\reports.hillintl.com\hiReportScheduling.aspx.vb:185
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804
0
 

Author Comment

by:VBBRett
ID: 40571073
My latest error is the following: The required field Name is missing from the input structure
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now