Skip navigation
Currently Being Moderated

Unable to read WSDL from URL: http://192.168.9.78/reportserver/ReportExecution2005.asmx?wsdl.

Feb 29, 2012 5:21 AM

Tags: #server #reporting #sql #coldfusion9 #ssrs

Hi All,

 

I am using SQL Server Reporting service in my application. I tried to access the report server by using web service.

 

When I opened the URL in browser, it asks for user name and password. After entering the correct user name and password I can able to view the wsdl.

 

But when I tried  to create a object of the wsdl using the user name and password. It throws an error message:

 

Message: "Unable to read WSDL from URL: http://192.168.9.78/reportserver/ReportExecution2005.asmx?wsdl."

Error Details: "401 Unauthorized"

Stack Strace:

______________________________________________________________________ ______________________________________________________________________ ____________________

coldfusion.xml.rpc.XmlRpcServiceImpl$CantFindWSDLException: Unable to read WSDL from URL: http://192.168.9.78/reportserver/ReportExecution2005.asmx?wsdl. at coldfusion.xml.rpc.XmlRpcServiceImpl.retrieveWSDL(XmlRpcServiceImpl.j ava:709)  at coldfusion.xml.rpc.XmlRpcServiceImpl.access$000(XmlRpcServiceImpl.jav a:53)  at coldfusion.xml.rpc.XmlRpcServiceImpl$1.run(XmlRpcServiceImpl.java:239 ) at java.security.AccessController.doPrivileged(Native Method) at coldfusion.xml.rpc.XmlRpcServiceImpl.registerWebService(XmlRpcService Impl.java:232)  at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebService(XmlRpcServiceImpl. java:496)  at coldfusion.xml.rpc.XmlRpcServiceImpl.getWebServiceProxy(XmlRpcService Impl.java:450)  at coldfusion.xml.rpc.WebServiceProxyFactory.getProxy(WebServiceProxyFac tory.java:22)  at coldfusion.runtime.ProxyFactory.getProxy(ProxyFactory.java:65) at coldfusion.runtime.CFPage.createObjectProxy(CFPage.java:5002) at coldfusion.tagext.lang.ObjectTag.doStartTag(ObjectTag.java:427) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfinc_Test2ecfm337234539.runPage(C:\inetpub\wwwroot\YMLSDP\RETSManage r\Includes\inc_Test.cfm:2)  at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfservlet2ecfm1704189116.runPage(C:\inetpub\wwwroot\YMLSDP\Shared\Inc ludes\servlet.cfm:33)  at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722) at cfApplicationSettings2ecfm1708384449$funcONREQUEST.runFunction(C:\ine tpub\wwwroot\YMLSDP\CONFIG\ApplicationSettings.cfm:91)  at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:4 05) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMetho d.java:368)  at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.ja va:55)  at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:491) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:337) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:88) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:280 ) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:356 ) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:7 9) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePers istenceFilter.java:28)  at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:8 9) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringS ervletFilter.java:42)  at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46 ) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java: 286)  at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java: 543)  at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.ja va:203)  at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPoo l.java:320)  at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.j ava:428)  at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool. java:266)  at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

---------------------------------------------------------------------- ---------------------------------------------------------------------- ---------------------------------------------------------------------- --------------------------------

I am using ColdFusion 9.0.1.

 

Thanks

 

Upen


 
Replies

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points