topic Re: An issue in triggering the stored process in Developers

An issue in triggering the stored process

herbman — Fri, 21 Aug 2015 21:10:11 GMT

Hello,

I would like to check a problem in triggering the next stored process:

When we run this stored process from the very beginning, it successfully active the following stored process 'upload' (activate the Test1file stored process) :

(upload stored process:)

data form;

file _webout;

put "HTML";

put "<Body>";

put "<H3> Please choose a file to upload</H3>;

put "<Form Action='&_URL'>";

put "<Input TYPE='Hidden' Name='_program' value='Shared data/SAS Testing/ABC/Test1file'>";

put "<Input TYPE='Hidden' Name='submit' value='submited'>";

put "<table border='0' cellpadding='5'>";

put "<tr><td>";

put "<input Type='file' Name='attach1' />";

put "</td></tr>";

put "</table>";

put "</form>";

put "</body>";

put "</HTML>";

run;

When I insert a 'selection' store process (below) to trigger above upload stored process (the Data_resource macrovarible was successfully given value 1 from previous home stored process), the log showed that it goes to the above test1file stored process), However, an error message showed:

ERROR: Insufficient authorization to access /sas/sas93/compute_config/Lev1/SASApp/_webout.dat

Appreciate if you can help to provide a solution to trigger the test1file, thank you!

(Selection stored process:)

%global Data_Resource _URL _Username;

%macro checking;

%if &data_resource=1 %then %do;

proc stp program ='shared data/SAS testing/ABC/Test1file';

run;

%end;

%if &data_resource=2 %then %do;

proc step program='shared data/SAS testing/ABC/Test2file';

run;

%end;

%mend checking;

%checking

Re: An issue in triggering the stored process

Kurt_Bremser — Mon, 24 Aug 2015 07:40:56 GMT

ERROR: Insufficient authorization to access /sas/sas93/compute_config/Lev1/SASApp/_webout.dat

indicates that the STP tries to write to a file instead of the HTML output stream. Might be a problem with the STP definition.

This could help:

17316 - Enterprise Guide 4 forces Stored Process "Streaming" output to"Transient" output

Re: An issue in triggering the stored process

herbman — Wed, 26 Aug 2015 20:17:10 GMT

Hi KurtBremser,

The Enterprise 5 did not show exact guidance in the list 17316. It did seem to be the problem with STP. When replaced <Form Action='&URL'> with <Form action='Http://server/sasstoredprocess/do?_action=execute%_program=/path../Test1" method="post"> </Form>, it functions well now. Thank very much!

Limin