SSIS Web服务任务错误 - “Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException：给定的服务当前不可用 [英] SSIS Web Service Task Error-"Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The given service is not currently available

问题描述

Hi All，< o：p>< / o：p>

我一直在尝试使用Web服务任务连接到BI发布者报告。我使用的oracle ERP Web服务链接如下，< o：p>< / o：p>

.asmx ？wsdl

font-size：9pt"> 顺便说一句，请在与我们分享之前屏蔽您的敏感数据。

问候，

Pirlo Zhang

Hi All,<o:p></o:p>

I have been trying to connect to a BI publisher report using the web service task. The oracle ERP web service link I am using is as follows,<o:p></o:p>

https://edqy-dev2.bi.em2.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSService?wsdl<o:p></o:p>

The wsdl is connecting fine in SOAP UI and providing me the report output when I am invoking the 'runreport' method,<o:p></o:p>



Fig1

Fig2

But, when I am trying the same through SSIS web service task, getting the following issues,<o:p></o:p>

 

1. Not able to find the parameter for report absolute path in the runreport method,<o:p></o:p>

after downloading the WSDL file from the web URL, when selecting the RunReport method underExternalReportWSSService, it is not providing me any option to pass the part of the report (i.e. reportabsolutepath parameter as in SOAP UI). <o:p></o:p>

Since I am pretty inexperienced in web services, not sure what changes need to be done in order to be able to pass the report path. Can anyone please help. The settings I have used so far is attached below,

<o:p>fig3</o:p>

<o:p>fig4</o:p>

<o:p>fig5</o:p>

2. Getting the following error,<o:p></o:p>

[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The given service is not currently available.<o:p></o:p>

   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()".<o:p></o:p>

 

Without selecting the parameters, if I am just clicking ok after the settings shown in issue 1 and trying to run the package, getting the above mentioned error. <o:p></o:p>

Can anyone please suggest where am I going wrong.<o:p></o:p>

<o:p></o:p>

---

Surendra Thota

解决方案

Hi Surendra_Thota,

In short, the server URL you typed in Http Connection Manager is not valid, even if you tested the connection successfully.

In general, the server URL is like:

 https://edqy-dev2.bi.em2.oraclecloud.com:443/xmlpserver/services/ExternalReportWSSService.asmx?wsdl

Just contact with your server administrator to get the exact server URL.

By the way, please mask your sensitive data before sharing with us.

Regards,

Pirlo Zhang

这篇关于SSIS Web服务任务错误 - “Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException：给定的服务当前不可用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！