Solved: An issue in triggering the stored process

herbman · Posted 08-21-2015 05:10 PM

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

herbman · Posted 08-26-2015 04:17 PM

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

View solution in original post

Kurt_Bremser · Posted 08-24-2015 03:40 AM

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

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

herbman · Posted 08-26-2015 04:17 PM

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

An issue in triggering the stored process

Re: An issue in triggering the stored process

Re: An issue in triggering the stored process

Re: An issue in triggering the stored process

Registration is open

Call for Content EXTENDED

An issue in triggering the stored process

Re: An issue in triggering the stored process

Re: An issue in triggering the stored process

Re: An issue in triggering the stored process

Registration is open

Call for Content EXTENDED

SAS Training: Just a Click Away