Your SAS programs, embedded in web apps and elsewhere

An issue in triggering the stored process

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

An issue in triggering the stored process

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 processSmiley Happy

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 processSmiley Happy

%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


Accepted Solutions
Solution
‎07-12-2016 10:10 AM
Occasional Contributor
Posts: 16

Re: An issue in triggering the stored process

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


All Replies
Super User
Posts: 6,972

Re: An issue in triggering the stored process

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
Solution
‎07-12-2016 10:10 AM
Occasional Contributor
Posts: 16

Re: An issue in triggering the stored process

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 737 views
  • 0 likes
  • 2 in conversation