topic Re: SAS Stored Process in Developers

SAS Stored Process

vkrishna — Mon, 02 Oct 2017 23:41:26 GMT

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 — Tue, 03 Oct 2017 00:40:35 GMT

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.

nhvdwalt — Tue, 03 Oct 2017 04:11:32 GMT

What does the Object Spawner log say ?

BrunoMueller — Tue, 03 Oct 2017 08:57:04 GMT

Have you specified any init and term programs for your SAS Stored Process Server?

Check that the code you specified runs correctly.

Provide the log of the Stored Process server

vkrishna — Wed, 11 Oct 2017 20:46:35 GMT

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.