10-02-2017 07:41 PM
I'm trying to run the Stored process by selecting the server type as "Stored process server only" in Execution options. I got the following error:
An error occurred executing the stored process job "<stored process name>".
The stored process library failed to retrieve the log. [Error] STP: The Request Init stored process failed.
Thanks in advance.
10-02-2017 08:40 PM
Do you have any UTF-8 characters in the stored process source code? I googled a bit, came up with:
As a test, try commenting out all the stored process code, and replace it with something simple like:
%let _odsdest=html; %stpbegin() proc print data=sashelp.class; run; %stpend()
See if something minimal like that will work.
10-03-2017 04:57 AM
Have you specified any init and term programs for your SAS Stored Process Server?
See http://support.sas.com/kb/39/250.html for more Information.
Check that the code you specified runs correctly.
Provide the log of the Stored Process server
10-11-2017 04:09 PM - edited 10-11-2017 04:46 PM
I specified the Init and term programs.
Path for Init and term programs is wrong. Its a relative path now I changed the path to "Fully qualified path". It's working now.