Calling Web Service Using SSRS!!!
Feb 4, 2008Hi,
Is it possible to call a Web Service using SSRS and bind the dataset to the the table in the Report? Please share your views.
Thanks and Warm Regards
Saanj
ADVERTISEMENT
Does The SSRS Web Service And Windows Service Share A Common Engine?
Sep 27, 2007All,
I am looking at implementing some sort of throttling whereby "expensive" reports are setup as Subscriptions (and hence are run by the Windows Service), while all other requests go the Web Service.
My question is:
Do the two systems share any underlying systems? I understand (of course) that they use the same DB, etc. etc. However, I can't quite tell whether there is an underlying engine that is a common base or if they really just spin up different instances of the same objects and essentially each host the application separately?
Any help is greatly appreciated!
Mark
Calling BSM Web Service...
Apr 2, 2007I'm trying to return Annotations from a BSM scorecard by calling the PMService.asmx web service. I can successfully call operations like "GetScorecards" that require no parameters...but I keep getting the same error when trying to call "GetAllAnnotationsbyScorecardID"
Here is the Query:
<Query>
<SoapAction>http://www.microsoft.com/performancemanagement/scorecards/GetAllAnnotationsByScorecardID</SoapAction>
<Method Namespace="http://www.microsoft.com/performancemanagement/scorecards/" Name="GetAllAnnotationsByScorecardID">
<Parameters>
<Parameter Name="scorecardID">
<DefaultValue>7e3b541b-51db-4ded-b8f3-f7e8f6657c42</DefaultValue>
</Parameter>
</Parameters>
</Method>
</Query>
Here is the XML error returned:
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlnsoap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
<soap:Fault>
<faultcode>soaperver</faultcode>
<faultstring>Server was unable to process request. --> scorecardID</faultstring>
<detail />
</soap:Fault>
</soap:Body>
</soap:Envelope>
Am I structuring the Query the right way? Not sure if I'm a passing the guid correctly...I got the scorecard guid from the result set of calling "GetScorecards"
Calling WCF Service From SQL CLR
Mar 22, 2007Is it possible to call a WCF service from a SQL CLR.
We have had success calling standard web services by including a Proxy in the Assembly but I wondered if it's possible to call out to a WCF service as the enpoint configuraion is done with an external XML file and I don't know if this will work in the same way. We may want to alter the wcf configuration depending on where the service is sitting, same box or remote.
Please do not respond with 'why do you want to do this' the reson we want to do this is because we use Service broker to recieve incoming messages and want to trigger a stored procedure to do some work on an external service when it recives some data.
Cheers,
Darren
SSRS Calling SSIS Package
Feb 12, 2008
Hi All,
I'm trying to call a SSIS package as my data source for SQL reporting service but I keep getting the error "Cannot create a connection to data source 'DsSSIS'.
My DsSSIS consists of the following in the connection string.
="/file c:FarmBillTesting.dtsx /Set Package.Variables[User::FilterValue].Properties[Value];" & Parameters!FilterValue.Value.ToString()
I have tried everything that I know to make this work but I have been unable to do so. Any help from the group would be great.
Thanks
Ham
SQL 2012 :: Calling SSRS Reports Using Query?
Mar 3, 2014I have created testreport.rdl using SQL Server 2012 SSRS. How to execute/call this through SQL query analyser, so that this will be executed and display output.
View 2 Replies View RelatedForeach ADO Enumerator Calling Web Service Task?
Mar 1, 2008Hi: I a SSIS beginner and am hoping this is an easy one. I am using a Foreach loop container with an in-memory ADO recordset as the enumerator. The recordset has 3 columns and one of them I wish to fixup data in by calling a web service task that returns an integer. I see how to call the web service and return the integer into a variable but am unsure how to approach putting that variable back into the in-memory ADO recordset? Should I even be trying to do it this way?
thanks!
Henry
Lose DB Connection After Calling Reporting Service By URL
Jan 24, 2008I used the URL approach to call the reporting service. In the ASP page, I use javascript to open a new window to view the report. But when I close the new window and work on the original window. It seems that the DB connection to the SQL server is not working.
Calling Web Service In Stored Procedure (SQL 2005)
Aug 18, 2006I need to create a stored procedure (SQL 2005). I did it in C# (Visual Studio). The .dll file (inside) uses web services of Project Server 2007 (I just need to log on, create a project and log out). I prepared 2 files (exactly the same code): dll an exe. the .exe works fine. the problem is with .dll file (stored procedure in SQL)...
by the way: I created serialization file with sgen tool.
the problems start when I am trying to register these 2 .dlls in SQL server. I can do that in unsafe mode only. when I am trying to register them in externall access (normal dll) and safe mode (serialization .dll) I am getting errors:
CREATE ASSEMBLY failed because method "add_QueueCheckInProjectCompleted" on type "ConsoleApplication11.ProjectWebSvc.Project" in external_access assembly "ConsoleApplication11" has a synchronized attribute. Explicit synchronization is not allowed in external_access assemblies
thus I did it in unsafe mode (both of them). than I created the procedure.
Now, I tried to call that procedure. I am getting error:
A .NET Framework error occurred during execution of user defined routine or aggregate 'Main':
System.Net.WebException: The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="http://my_comp:22278/projectserver/_layouts/1033/error.aspx?ErrorText=Object%20reference%20not%20set%20to%20an%20instance%20of%20an%20object%2E">here</a>.</h2>
</body></html>
--.
System.Net.WebException:
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 ConsoleApplication11.ProjectWebSvc.Project.QueueCreateProject(Guid jobUid, ProjectDataSet dataset, Boolean validateOnly)
at ConsoleApplication11.Program.Main()
That means "Object reference not set to an instance of an object". the problem occurs when calling QueueCreateProject method
I dont understand that error. I wrote the same code for .dll and .exe. the .exe file is working ok (no errors) but .dll (as a stored procedure) shows this error
my code in C#:
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Net;
using PSLibrary = Microsoft.Office.Project.Server.Library;
namespace ConsoleApplication11
{
public class Program
{
public static void Main()
{
const string LOGINWINDOWS = "_vti_bin/PSI/LoginWindows.asmx";
string baseUrl = "http://localhost:22278/projectserver/";
CookieContainer cookies = new CookieContainer();
LoginWindowsWebSvc.LoginWindows loginWindows = new LoginWindowsWebSvc.LoginWindows();
loginWindows.Url = baseUrl + LOGINWINDOWS;
loginWindows.Credentials = CredentialCache.DefaultCredentials;
loginWindows.Login();
ProjectWebSvc.Project project = new ProjectWebSvc.Project();
project.Credentials = loginWindows.Credentials;
project.Url = baseUrl + "_vti_bin/psi/project.asmx";
ProjectWebSvc.ProjectDataSet dsProject = new ProjectWebSvc.ProjectDataSet();
ProjectWebSvc.ProjectDataSet.ProjectRow projectRow = dsProject.Project.NewProjectRow();
Guid projectGuid = Guid.NewGuid();
projectRow.PROJ_UID = projectGuid;
projectRow.PROJ_TYPE = 0;
projectRow.PROJ_NAME = "Jakis";
projectRow.PROJ_SESSION_UID = Guid.NewGuid();
dsProject.Project.AddProjectRow(projectRow);
Guid jobGuid = Guid.NewGuid();
project.QueueCreateProject(jobGuid, dsProject, false);
System.Threading.Thread.Sleep(5000);
loginWindows.Logoff();
project.Credentials = null;
}
}
}
any help will be appreciated. my email is: stro.na@interia.pl
Calling Asp.net Web Service From A Trigger Or Stored Procedure
May 6, 2008
Hi,
I need to call a webservice directly from a tigger or stored procedrue instead of creating a window service to read from a table then call the webservice .Is it possible ? if yes, please i need your support.
Thanks,
SSRS Calling SSIS Package As A Data Source
Feb 12, 2008Hi All,
It's been a while since I post here. Anyway, I'm trying to call a SSIS package as my data source for SQL reporting service but I keep getting the error "Cannot create a connection to data source 'DsSSIS'.
My DsSSIS consists of the following in the connection string.
="/file c:FarmBillTesting.dtsx /Set Package.Variables[User::FilterValue].Properties[Value];" & Parameters!FilterValue.Value.ToString()
I have tried everything that I know to make this work but I have been able to do so. Any help from the group would be great.
Thanks
Ham
Reporting Services :: Calling SSIS Package From SSRS
Jul 23, 2008Need some clarification on calling an SSIS package from SSRS. I have managed to get this to work, but only if I actually build the SSIS package on the report server machine.My SSIS package is very simple it. The control flow is a single data flow task. Within the data flow task is an ole db data source and a data reader destination. I verified that the package works in BIDS.
Â
If I build it and deploy it on the report server I can execute it just fine from integration services (using the dtexec UI panel) in SSMS, no validation errors and no execution errors.If I try to build a dataset (specifying SSIS as the data source type) then immediately on referencing the package I get a "Package failed to validate error". However, if I bring the whole project over to the report server and build it then I can reference it from my Report Services project.
Â
I'm using package deployment security of "Don't Save Sensitive" for the SSIS package with the 'sa' login. After the deployment package is built I edit the connection string to include the password.The remote execution account for the Report Server is set to the administrator of the box. I know these account permissions are overkill, but I'll iron all that out once I get the basic pieces in place and working.
SSIS Calling Web Service Task 401 Unauthorized Error
May 23, 2007Hello,
I'm pretty stuck on a security issue in SSIS. The web service works by itself, but I can't call it from SSIS, it gives me a 401 unauthorized error. The web service also uses impersonation of my domain admin account.
I have tried the following things:
Setting integrated windows authentication in IIS
Setting the NTFS permissions of those web site directories to EVERYONE
Using a credential / proxy in SSIS and running it from SQL Agent
Changing the log on services of MSSQLSERVER, SQLAGENT, and SQL Integration Services to my domain admin account
I can't get anything to work. What is wrong with this thing? Microsoft's security model has gotten completley out of of hand imo
Also in the security event log it shows all authentication as successful.
Calling A Web Service With Data From A SQL Server Table One Row At A Time
May 29, 2006Hello
I am trying to call a Web Servie within a SSIS package. I want to pull a row at a time from a SQL Server 2005 table and pass this data values onto the web service.
Any help is highly appreciated!
Kind Regards
Gayatri
MSXML6.dll Fails To Register When Calling SSIS From Win Service
Apr 19, 2007Has anyone encountered this error? I get it when I run the installer (c#). I have seen a few posts on google and msdn, but still can't get past the error. I have tried uninstall/resinstalling the parser, registering from the command line, setting the property of the interop to "donotregister" and others with no luck.
Any ideas?
Thanks,
Lee
Calling An SSIS Package From A Service Broker Queue
Feb 26, 2007Posted the same message to the Service Broker forum. But the board is neither responsive nor active. So I am trying this forum. Hope someone can help.
I would like to call an SSIS package from a Service Broker Queue.
There is one way that I am aware of -
Using xp_cmdshell from within an activation stored procedure and using DTEXEC.
Is there a more elegant way of executing an SSIS package from within SSB?
Also,
I am not interested in writing a .NET external activator to process my
messages in the queue. I would like this operation to be strictly
database oriented. Having said this, I am also trying to avoid triggers
processing the messages in the queue.
Thank you!
Problems In Calling SQL Server 2005 Web Service Asynchronouslly!
Jan 22, 2007
I have created a SOAP/HTTP end point which returns .NET DataSet ( ... FORMAT=ROWSETS_ONLY ... ). Then I created a proxy class using Visual Studio 2005 and wrote a cusumer .NET class in which I call that web service's method synchronously. Everything is Ok but when I call asynchronously "TargetInvocationException" is raised. I need urgent solution to this problem.
Thanks !
Calling SSIS Packages From A Service Broker Queue
Feb 26, 2007I would like to call an SSIS package from a Service Broker Queue.
There is one way that I am aware of -
Using xp_cmdshell from within an activation stored procedure and using DTEXEC.
Is there a more elegant way of executing an SSIS package from within SSB?
Also, I am not interested in writing a .NET external activator to process my messages in the queue. I would like this operation to be strictly database oriented. Having said this, I am also trying to avoid triggers processing the messages in the queue.
Thank you!
Web Service Task And Document/Literal Calling Convention
May 6, 2008The Web Service Task seems to support calling methods using parameters but not (as far as I can see) using the Document/Literal calling convention. Is this correct? Is this likely to change in the future?
Thanks
*** Campbell
Calling SSIS Package From Web Service - Security Issue
Nov 15, 2006I am trying to call a SSIS package from a web service hosted on the same machine as the package file is sitting. All that the package does is a simple Execute SQL task with one datasource connection.
I have set impersonation as true. When I run the package from the web service on the virual port (through Visual studio IDE) it runs fine.
http://localhost:4609/WebServiceRunSSIS/LaunchSSISPackageServiceCS.asmx
In the above case I don't think impersonation means anything coz it runs successfully even when there is no impersonation set!
I then run the same service (asmx page) from the browser after making it a web service on my machine
http://localhost/WebServiceRunSSIS/LaunchSSISPackageServiceCS.asmx
I get an error indicating package failure.
I have enabled logging in SSIS. The package log indicates the following:
Failed to acquire connection "APNetDS". Connection may not be configured correctly or you may not have the right permissions on this connection.
Effectively, my web service impersonated account (which is my admin account) is not being authenticated for any of the db connection (uses windows integrated authentication) and I find that odd. To impersonate, I have set the Impersonation to true in the web.config file. The authentication mode is windows.
Please tell me what bit of security I am missing? In case if it helps, the database connection is to my local database and hence should not deny access to my own account. And yes, I think my impoersonation is working because when I debug, the user.identity shows my user id.
Thank you,
Sumeet
Remoting Timeout When Calling SSIS Package Execute From A Windows Service
Sep 12, 2007When running an integration services package from a windows service I get the "Object ... has been disconnected or does not exist at the server." exception after aproximately six minutes of execution.
This is *not* my windows service failing. I can loop indefinately while tracing to a log file within the service and it will run forever. While calling the mypackage.execute(...) method however, after six minutes (give or take) the exception is thrown...
my code looks something like this:
<code>
dim foo as Microsoft.SqlServer.Dts.Runtime.Application
mypackage = foo..LoadPackage(strimportPkgFilename, pkgevents)
results = myPackage.Execute(Nothing, Nothing, pkgevents, Nothing, Nothing)
</code>
<error>
A first chance exception of type 'System.Runtime.Remoting.RemotingException' occurred in mscorlib.dll
Exception in: frmMyForm.DoImports
Message: Object '/b76f98a0_5bd9_49d8_a524_eeb49d55b303/bqbhkjnaofq_ifr_cwz+srid_1.rem' has been disconnected or does not exist at the server.
</error>
oddly, this same code works perfectly if I run it within a windows form application no matter how long it takes.
It also runs fine if the package can complete in under six minutes.
Any suggestions?
Mark
Calling A Custom Web Service From My Package To Perform Heavy-duty Tasks
Mar 20, 2007As part of my SSIS package, a list of sites is created that need to be created on a remote machine. let's say 1000 sites. I need to pass this list to a web service so web service sitting on that machine creates these sites for me. MY SSIS package does not run frequently so I can sacrifice time a little bit to get better functionality.
I need to move the sites that are not created (for any reasons) by web service to another table and successfully created sites to another table, so I need to get confirmation for each site from the web service.
Which option is better?
1) Calling web service for every single record (site) and get the confirmation and then based on the confirmation I move the records accordingly. I know this might be very time consuming, but as I said my SSIS package might only run every six months
OR
2) Sending records to a web service in a batch and get the result. I don€™t know how to do this though.
Any help or better solution is appreciated.
SSRS - Invalid Attempt To MetaData When Reader Is Closed On Render When Calling A Report From Asp.net
Sep 25, 2006I get the following error when generating a report. I use the "render" method in an asp.net page. I have also seen Timeout errors, which is the second error listed below.
Configuration
db-SQL Server 2000 on clustered windows 2003 server SP1, 5.5 GB RAM
SSRS 2005 and IIS 6.0 on 2nd windows 2003 server SP1, 3.75 GB RAM
generating SSRS Report using asp.net
Error is on large amounts of data, main source table has 11.2 Million records. The stored procedure returns
507,387 rows in approx. 25 minutes.
No problem with smaller amounts of data using the same source of 11.2 million records, but returning
much less.
Error 1: (from try/catch on render method)
System.Web.Services.Protocols.SoapException: An error has occurred during report processing. ---> An error has occurred during report processing. ---> An error has occurred during report processing. ---> The Group expression used in grouping €˜territory€™ references a data set field which contains an error: System.InvalidOperationException: Invalid attempt to MetaData when reader is closed. at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlDataReader.GetValue(Int32 i) at Microsoft.ReportingServices.DataExtensions.DataReaderWrapper.GetValue(Int32 fieldIndex) at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetFieldValue(Int32 aliasIndex) 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 rptsvc.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:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Filesswisherreports842e8e9d5ff5a831App_WebReferences.no0lpcgz.0.cs:line 1706 at ar_sum_aging.btnGenRpt_Click(Object sender, EventArgs e) in U:Visual Studio 2005ProjectsSwisherReportsar_sum_aging.aspx.vb:line 32
Error 2: (from ReportServer error log)
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: An exception has occurred in data source 'ar_sp'. Details: System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
w3wp!processing!1!9/25/2006-18:32:53:: i INFO: Merge abort handler called for ID=-1. Aborting data sources ...
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!processing!1!9/25/2006-18:32:53:: w WARN: Data source 'AR': Report processing has been aborted.
w3wp!processing!1!9/25/2006-18:32:53:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
--- End of inner exception stack trace ---
w3wp!library!1!09/25/2006-18:32:58:: e ERROR: Found System.OutOfMemoryException exception: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
w3wp!library!1!09/25/2006-18:32:58:: e ERROR: Terminating worker process
SetPolicy - Using SSRS Web Service
Mar 23, 2006Am using the Web service of SSRS to assign the roles for a user (which is already available in Report Manager).
Policy[] p = new Policy[1];
p[0] = new Policy();
Role[] R = new Role[1];
R[0]= new Role();
//RoleGroup Rg = new RoleGroup();
R[0].Name = "Report Builder";
p[0].GroupUserName = "MyMachineNamevikas";
rs.SetPolicies(@"/",p);
The same I have tried with SetSystemPolicy method also.
Policy[] p = new Policy[1];
p[0] = new Policy();
Role[] R = new Role[1];
R[0]= new Role();
//RoleGroup Rg = new RoleGroup();
R[0].Name = "Report Builder";
p[0].GroupUserName = "MyMachineNamevikas";
rs.SetSystemPolicies(p);
Where, MyMachineName - is the machine name where SSRS is residing.
bvikas - windows local machine user
I have used the above codes in achieving the mapping between the SSRS role and the windows local user. Getting error on this. I even thought of directly doing the mapping by putting entry in SSRS database. But found that few fields are encrypted and I would prefer to acheive it through API way.
-Muthu
Bug In SSRS SetItemDataSources Web Service Method
Dec 19, 2007Bug:
An existing SSRS 2005 data source at the root directory cannot be used by the SSRS SetItemDataSource web method.
Steps to reproduce:
1. On the machine running SSRS 2005, create a folder named Reports and upload an RDL file named "Existing.rdl" into that directory. For clarity the SSRS path to this report is /Reports
2. Set up a valid data source at the root directory (For illustrative purposes we'll name it DS).
3. Set up a web reference to a SQL Server Reporting Web Services 2005. e.g. http://localhost/reportserver/reportservice2005.asmx
3. Try to set the DS data source to the "Existing" report by calling the SetItemDataSource web method.
C# Code Excerpt:
...
try{
ReportingService2005 reprtSrvc = new ReportingService2005();
DataSource[] dsarray;
string reportName = "Existing"
string _selectedFolder = "/Reports/"
DataSourceReference reference = new DataSourceReference();
DataSource ds = new DataSource();
dsarray = new DataSource[1];
reference.Reference = "/";
ds.Item = reference;
ds.Name = "DS";
dsarray[0] = ds;
//Exception thown ...
_reprtSrvc.SetItemDataSources("/" + _selectedFolder + reportName , dsarray);
}
catch (SoapException ex)
{
//Exception
Message.displayMessage(ex.Detail["Message"].InnerXml, MessageType.Error);
}
...
Exception details...
ex {"System.Web.Services.Protocols.SoapException: The operation you are attempting on item "" is not allowed for this item type. ---> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item "" is not allowed for this item type. at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.ResolveNewDataSources(DataSourceInfoCollection newDataSources, Boolean forModel) at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.SetReportDataSources(CatalogItem item, DataSource[] dataSources) at Microsoft.ReportingServices.Library.SetItemDataSourcesAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute() at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemDataSources(String Item, DataSource[] DataSources) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.SetItemDataSources(String Item, DataSource[] DataSources) at Microsoft.ReportingServices.WebServer.ReportingService2005.SetItemDataSources(String Item, DataSource[] DataSources)"} System.Web.Services.Protocols.SoapException
SSRS WEB Farm ReportServer Service
Jun 28, 2007Server Software
SQL Server 2000 (all sps up to date)
SSRS 2000 (all sps up to date)
Scenario:
1 - SSRS + SQL2000 Database server
2 - Web servers
We have installed SSRS on 2 web servers that are acting as a web farm for a central Report Server.
After we installed SSRS on the 2 web servers the scheduled reports on the central Report Server stopped working.
We tried disabling the ReportServer service on the web servers and then the scheduled reports began to work again.
Why would the ReportServer service on the 2 web servers interfere with the central Report Server?
Can the web servers be used to load balance the scheduled reports?
Any advice would be appreciated.
Service Unavailable - SSRS 64bit
Sep 6, 2006We've recently attempted to get RS 2005 64bit up and running on MS Virtual Server and the installation seems to have worked properly (the RS Configuration all seemed fine also). However, when going to http://localhost/Reports or http://localhost/ReportsServer, it gives me the message "Service Unavailable". Everything looks good in IIS (using 2.0).
What else can I do to troubleshoot this issue?
SQL 2012 :: SSRS Report Deployment To Web Service?
Jun 12, 2014I created two reports in SSRS and have configured both the web service and report manager URLs in report services configuration manager.
whenever I try to open either one of the two reports from the manager or service I get the following error msg.
"An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.
(rsReportServerDatabaseError)
Invalid object name 'DataSets'. Could not use view or function 'ExtendedDataSets' because of binding errors."
I get a similar msg when I try to deploy the reports from VS 2010. Only the first 2 sentences are returned.
I'm mystified as to why DataSets is an invalid object name. It shows as the TargetDatasetFolder name WebsiteReports Property Page. I've looked around for the error source and can not find where this error is stemming from.
SSRS Web Service Render Method Documentation?
Dec 28, 2007Hi all does anyone know where I can find more information on the Render method of the Reporting Services WS?
Specifically there is a DeviceInfo parameter that you need to pass in and it is a string that is in an XML format but I cannot seem to find any documentation on the specifics of it. I have seen a few examples but no specifics.
Any help with this is greatly appreciated?
Thank you,
John
SQL Service Broker To Send Message To SSRS
Jan 23, 2008Hi All,
I want to send notification to SSRS on change in database for that I am using SSB to send message to SQL Server Reporting Services.
Can I use SSB and if yes, how? Please guide me I am new to this.
Thanks,
Omkar.
Is There A Separate SSRS 2005 Service Pack?
Apr 21, 2008Hi,
Is there a separate service pack 2 for SQL Server Reporting Services 2005? I know there is a SP2 for SQL Server 2005 that was just released. I'm asking because SRS 2000 had a service pack separate from the SQL Server service pack.
Thanks.
Sql Server 2005 Reporting Service (Chart) Help SSRS
Aug 6, 2007Hi frineds,
i created the 1 report with pie chart ,but i am unable to display the values in the pie chart region inside the each colors
i am displaying the marks of a studnet ,but here
just like for each region we need the value HOW TO SET please help me in the properties or else (WHERE ?)
-------------------------
10 (red color)
-------------------------
30 (green color)
--------------------------------
Return Dataset Field Collection With SSRS Web Service
Apr 15, 2008Is there a way to return the fields collection of a dataset using the Reporting services Web Service? I can get to the reports but not the datasets. Thank you in advance for any support you can provide.
View 1 Replies View Related