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

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

india2016 — Thu, 29 Jun 2017 06:09:09 GMT

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;

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

india2016 — Thu, 29 Jun 2017 07:44:39 GMT

I am getting this as error

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

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

pcapazzi — Thu, 29 Jun 2017 14:14:54 GMT

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

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

pcapazzi — Thu, 29 Jun 2017 14:46:42 GMT

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?

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

Dmitry_Alergant — Sat, 08 Jul 2017 00:36:39 GMT

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.