Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2040
  • Last Modified:

SSIS 2005 - WebServiceTask throws error when trying to call web service over SSL

Hello,

I have deleloped a SSIS 2005 package which calls several web methods of an internally accessed web service, over SSL.

The test version of the web service is accessed over HTTP, and the web methods are called with no problems, from the WebServiceTasks in the package.

In the production version's HTTP connection manager, I specify the uri as:

https://mycompany.subdomain.com/mywebservice.asmx?wsdl

same as in test (except test is at http).

Testing the connection works, and I can navigate to the url in the browser as well.

When the package executes, the webservicetask throws the following error:

Error Code: -1073548540
Error Message: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: The request failed with an empty response..
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)
   at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

Error Source: task_MyWebServiceTask

What's making this so difficult to figure out is the fact that the error is non-descriptive, and gives no indication of what the issue is.

Any and all help is greatly appreciated.
0
ibcmis
Asked:
ibcmis
1 Solution
 
ibcmisAuthor Commented:
Wow!

This was a tough nut to crack, but after hours and hours of searching, I found the answer here:
Web Service -The request failed with an empty response

Which states:

"...but rather a solution for anyone encountering this generic error when attempting to consume a web service.

In some server configurations, requests to port 443 (https) are resolved to port 80 (http) by an ISA server. Web services on virtual directories that are set to listen for port 80 will generate .wsdl files with http addresses, even though the correct service address is https.

When consuming such a service, this requires either: specify the webservice.URL value to the correct https address, or correcting the .disco, .wsdl and Reference.map file address values to be https rather than the http values they will pull down from the server.

The second scenario (bolded) turned out to be my problem. In the WSDL file, the address was specified as "http://...", rather than "https://...".

I NEVER would have thought to look there for the problem.

Hopefully, this will help someone having a similar issue in the future.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now