Plan, execute, measure and optimize customer experiences

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

Reply
Contributor
Posts: 60

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

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;

 

Contributor
Posts: 60

Re: SAS CI Studio: The stored procedure must check for errors with the macro call %mastatus(&_st

Posted in reply to india2016

I am getting this as error 

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

Contributor
Posts: 67

Re: SAS CI Studio: The stored procedure must check for errors with the macro call %mastatus(&_st

Posted in reply to india2016

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

Contributor
Posts: 67

Re: SAS CI Studio: The stored procedure must check for errors with the macro call %mastatus(&_st

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?

Contributor
Posts: 55

Re: SAS CI Studio: The stored procedure must check for errors with the macro call %mastatus(&_st

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.

-------
Dmitriy Alergant, Tier One Analytics
Ask a Question
Discussion stats
  • 4 replies
  • 313 views
  • 0 likes
  • 3 in conversation