SSRS step template error - Cannot find LoadReportDefinition method about library HOT 6 CLOSED

@twerthi is this something you know how to solve quickly?

If not, I'll get an environment setup and figure out what's happening here.

from library.

What version of PowerShell are they using? What version of SQL Server Reporting Services?

Does the $ReportExecutionProxy have a value? What does $ReportExecutionProxy.GetType() return?

from library.

@twerthi please see the answers to your questions below. Please let me know if you need anymore information?

Powershell Version:
PSVersion 3.0
WSManStackVersion 3.0
SerializationVersion 1.1.0.1
CLRVersion 4.0.30319.18449
BuildVersion 6.2.9200.16628
PSCompatibleVersions {1.0, 2.0, 3.0}
PSRemotingProtocolVersion 2.2

SQL Server Reporting Services Version:
Microsoft SQL Server Reporting Services Version 11.0.3000.0

$ReportExecutionProxy:
Yes $ReportExecutionProxy has a value. In the template it is initiated like so:
$ReportExecutionProxy = New-WebServiceProxy -Uri $ReportExecutionUrl -UseDefaultCredential

Where $ReportExecutionUrl = "http://xxxxx/ReportServer/ReportService2005.asmx?wsdl" via the template parameter

We actually get autocomplete on $ReportExecutionProxy through the Powershell ISE, however the method LoadReportDefinition does not seem to be there?

$ReportExecutionProxy.GetType() returns Microsoft.PowerShell.Commands.NewWebserviceProxy.AutogeneratedTypes.WebServiceProxy1er_ReportService2005_asmx_wsdl.ReportingService2005

from library.

@jeremyhoughton

The value for $ReportExecutionUrl should look like this:

http://xxxxx/reportserver/ReportExecution2005.asmx?wsdl

The value you've supplied here is what would be for the $ReportServiceUrl, which I would recommend changing to http://xxxxx/ReportServer/ReportService2010.asmx?wsdl

from library.

Thanks @twerthi. It works fine now! Maybe it might be worth while putting some error checking in the code to either check for the text "ReportExecution" in the input execution report url or to check whether that url has access to the LoadReportDefinition method? If there is an error raise an exception early suggesting that the input url is invalid?

from library.

Not a bad idea, I'll look into that.

from library.