SAS CI Studio: The stored procedure must check for errors with the macro call %mastatus(&_stpwork.st

[india2016]

Hello I am trying to run a stored process in a process node but I am getting below error:

SAS CI Studio: The stored procedure must check for errors with the macro call %mastatus(&_stpwork.status.txt);.

The code is:

%stpbegin;
%maspinit;

/*Import login csv into Workspace*/

proc import datafile="/opt/database/survey_details/export_data.csv" replace
out=work.export_data; run;

proc sql;
create table login2
as select _SURVEY_ID, TIME format=datetime20.,_USERNAME
from work.export_data
having TIME=max(TIME) and _USERNAME="&_metauser.";
quit;
/*Import macro for survey_id*/
proc sql;
select max(_SURVEY_ID) into: sid from login2;
quit;

%MAStatus(&_stpwork.status.txt);
%stpend;

[india2016]

I am getting this as error 

ERROR: Insufficient authorization to access /sasdata/sasconf/config/Lev1/SASApp/&_stpwork.counts.txt.

[pcapazzi]

Does this run properly in Enterprise Guide and you only receive this error in CI Studio?

[pcapazzi]

Another thought:

What are the permissions of /sasdata/sasconf/config/Lev1/SASApp/  ?

Does it allow for group level write access for the SAS group?

For Linux:

ls -la /sasdata/sasconf/config/Lev1/

Look for SASApp

drwxrwxr-x 13 sas sas   4096 Jun 28 13:06 SASApp

Is that w highlighted in red there?

Also is the service account that CIS is using in the SAS group?

[Dmitry_Alergant]

Hi, were you able to resolve the issue?

I'd check whether you have checked the "Package" output type checkbox for your Stored Process execution.

It should help.

Also it's a good idea to add the %macount execution (before %mastatus call)

Best regards, Dmitriy.