Hi All,
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.
Any suggestions?
Any suggestions!
Thanks in advance.
Do you have any UTF-8 characters in the stored process source code? I googled a bit, came up with:
http://support.sas.com/kb/42/803.html
http://support.sas.com/kb/50/028.html
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.
What does the Object Spawner log say ?
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
Thanks @BrunoMueller.
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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.