3 weeks ago - last edited 3 weeks ago
I m trying to set up a web service.
So for this is my code and it is working:
%Global g_Date; LIBNAME Star2 Meta Library = "Prod Starschema 2"; LIBNAME _XMLOut XML; DATA _Null_; CALL symputx('g_Date', put(today() - 1, 8.)); Run; PROC SQL OUTOBS=10; Create Table _XMLOut.test As Select * From star2.FACT_ORDER Where ShipmentDate EQ &g_Date.; quit;
Now I would like to use a parameter with the POST method, like this:
<fo> <parameters> <g_Date>'01Feb2018'd</g_Date> </parameters> </fo>
I added the parameter to the stored process and redeployed it as a web service, but it doesnt work.
This is the error I get:
<html><head><title>Error report</title></head><body><h1>HTTP Status 500 - Request processing failed; nested exception is com.sas.web.services.WSException: SAS completed with nonzero SYSCC '1.012'. SYSMSG: ''.</h1></body></html>
Can someone please give me a hint?