topic Re: problems with SOAP procedure in SAS Procedures

problems with SOAP procedure

deleted_user — Thu, 06 Aug 2009 15:27:00 GMT

i'm trying to use the SOAP procedure to pull data into SAS but i'm hitting a wall.

here's my code which is based on SAS documentation examples (http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a003176696.htm 😞
[pre]
FILENAME REQUEST "c:\temp\heartbeatrequest.xml";
data _null_;
file request;
input;
put _infile_;
datalines4;

xmlns:efm="http://desktop.vovici.com/EFMWebTopSvc/">

;;;;
run;
[/pre]

next, i call a public SOAP web service (http://desktop.vovici.com/EFMWebTopSvc.asmx?op=WSHeartbeat)
[pre]
FILENAME RESPONSE "c:\temp\heartbeatresponse.xml";
proc soap in=REQUEST
out=RESPONSE
url="http://desktop.vovici.com/EFMWebTopSvc.asmx"
soapaction="http://desktop.vovici.com/EFMWebTopSvc/WSHeartbeat";
run;
[/pre]

which is where SAS complains:
[pre]
NOTE: The SAS System stopped processing this step because of errors.

ERROR: java.lang.Exception: First Element must contain the local name, Envelope , but found html
[/pre]

that the error is java-related and that the SOAP request works fine in soapUI (http://www.soapui.org ), but not in SAS suggests to me that i've got an install problem, but i really don't know. fixed docs link
Message was edited by: RichardK

Re: problems with SOAP procedure

sbb — Thu, 06 Aug 2009 15:34:02 GMT

Contact SAS technical support for assistance. SAS PROC SOAP is very new, now available with SAS 9.2, and there are specific install considerations that must be setup correctly. I also had some challenges and the SAS admin worked them out with the keen guidance and direction from the primo SAS support staff.

Scott Barry
SBBWorks, Inc.

Re: problems with SOAP procedure

deleted_user — Thu, 06 Aug 2009 15:52:08 GMT

Scott-
what's most confusing is that the SOAP procedure appears to work for the weather.gov web service:
[pre]
FILENAME REQUEST "c:\temp\NDFDgenByDay_request.xml";
data _null_;
file request;
input;
put _infile_;
datalines4;

xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ndf="http://www.weather.gov/forecasts/xml/DWMLgen/wsdl/ndfdXML.wsdl">

"http://schemas.xmlsoap.org/soap/encoding/">
45
-93
2009-08-06
5

xmlns:dwml="http://www.weather.gov/forecasts/xml/DWMLgen/schema/DWML.xsd">24 hourly

;;;;

FILENAME RESPONSE "C:\temp\NDFDgenByDay_response.xml";
proc soap in=request
out=response
url="http://www.weather.gov/forecasts/xml/SOAP_server/ndfdXMLserver.php"
soapaction="http://www.weather.gov/forecasts/xml/DWMLgen/wsdl/ndfdXML.wsdl#NDFDgenByDay"
;
run;
[/pre]

looks like tech support is my next stop...

thanks

Re: problems with SOAP procedure

deleted_user — Tue, 11 Aug 2009 13:12:11 GMT

as it turns out, i'm behind a proxy, so i needed the proxy options:
[pre]
proxyhost="proxy-host"
proxyusername="my-username"
proxypassword="my-password"
proxyport=proxy-port
[/pre]

everything works fine now!

Re: problems with SOAP procedure

deleted_user — Sat, 03 Jul 2010 15:34:50 GMT

I ran the Heartbeat example and got the same error: "First Element must contain the local name, Envelope , but found html." But I'm not behind a proxy server! Also, the weather example does work. Have you researched this error further?