08-28-2015 05:15 AM
I am trying to send a mail through SAS. This is the code I am using to send mail as a HTML from SAS. But when I run this code I am getting ERROR: Insufficient authorization to access PIPE error. I have enable XCMD option in SMC and tried to refresh Object_Spawner in SMC only. I am not sure which step is going wrong but this error keeps coming. Please help me in resolving this issue.
FILENAME mail EMAIL TO="firstname.lastname@example.org"
SUBJECT="HTML OUTPUT" CONTENT_TYPE="text/html";
ODS LISTING CLOSE;
ODS HTML BODY=mail;
PROC PRINT DATA= sample;
ODS HTML CLOSE;
08-28-2015 08:11 AM
Use PROC OPTIONS to verify that XCMD is set.
I also suggest you google for the
ERROR: Insufficient authorization to access PIPE
phrase and browse through the results, as those may reveal another reason for your problem
08-31-2015 05:24 AM
I have used Proc options to check the XCMD . It shows NXCMD only though I checked the option "Allow XCMD" in SAS Management Console. Is there any way to refresh the server. I tried all options which came by searching in Google.
08-31-2015 07:37 AM
After changing the value in SMC, you need to restart the object spawner, since this is the one that sets the option on the commandline.
08-31-2015 08:10 AM
I tried to restart using below instruction which was available in sas support:
|Modify an Object Spawner Definition|
To modify an object spawner definition by using the SAS Management Console, follow these steps:
But, looks like XCMD option is not getting set inspite of refreshing object spawner as instructed above
09-11-2015 07:35 AM
Slightly off on a tangent. Are you sure the noxcmd setting is what is preventing you sending email?
I can send email using the filename option in Enterprise Guide with noxcmd on. You can get some misleading errors from the email filename if the email options are not setup correctly.
Check the options with:
Proc options group=email; run;
09-13-2015 01:07 PM
The setting is a command-line option for the WS or SP after restarting the service.
I could be have set at a config file.
Needing to send email it is better the use to direct interface (smtp 25) unless you are blocked by outdated old SAS version and new very demanding mail-server. What is you SAS environment (server?) and waht versions are there arround?
09-14-2015 10:02 PM
This blog post from Paul Homes, https://platformadmin.com/blogs/paul/2011/06/noxcmd/, might help providing additional instructions for diagnosing and enabling/disabling the XCMD functionality…if indeed the xcmd is what holding you off from sending HTML-format email.
The blog mentions the possible multiple NOXCMD location settings on different server instances (workspace, pooled workspace, STP, SASMeta), so you just want to be sure the specific NOXCMD setting you made earlier reflect the way how the code is called.
Hope this helps!