SAS Stored Process

[vkrishna]

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.

[Quentin]

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.

[nhvdwalt]

What does the Object Spawner log say ?

[BrunoMueller]

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

[vkrishna]

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.