BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
swetha_kv
Calcite | Level 5

Hi,

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="abc@xyz.com"

SUBJECT="HTML OUTPUT" CONTENT_TYPE="text/html";

ODS LISTING CLOSE;

ODS HTML BODY=mail;

PROC PRINT DATA= sample;

RUN;

ODS HTML CLOSE;

ODS LISTING;

1 ACCEPTED SOLUTION

Accepted Solutions
Guest007
Calcite | Level 5

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!

View solution in original post

7 REPLIES 7
Kurt_Bremser
Super User

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

swetha_kv
Calcite | Level 5

Hi,

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.

Thanks

swetha_kv
Calcite | Level 5

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:

  1. Start SAS Management Console and connect to a metadata repository.
  2. In the SAS Management Console navigation tree, expand the Server Manager to find the object spawner that you want to modify.
  3. Right-click the icon for the object spawner and select Properties from the pop-up menu.
  4. Select the appropriate tabs, and enter the necessary changes.For more information, refer to SAS Management Console online Help.
  5. When you are finished, click OK to return to the SAS Management Console main window.
  6. Restart the object spawner.For more information, see "Operating Your Servers" in SAS Intelligence Platform: System Administration Guide.


But, looks like XCMD option is not getting set inspite of refreshing object spawner as instructed above

JonathanWill
Obsidian | Level 7

Hi,

 

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;

Particularly emailsys.

 

Jon

jakarman
Barite | Level 11

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?

---->-- ja karman --<-----
Guest007
Calcite | Level 5

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!

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 7 replies
  • 15918 views
  • 3 likes
  • 5 in conversation