The exception follows: SAS completed with n onzero SYSCC '1,012'. SYSMSG:

SAS_LuisBolivar — Mon, 23 Mar 2020 17:35:00 GMT

Good afternoon.

I need the help of you experts.

I have built a Job in Data Integration which I want to deploy as an SP, said SP then I must deploy it as a Web Services to consume it within SAS RTDM.

The steps I am applying are the following:

Job DI:

User Written Code:

DATA WORK.DATOS;

attrib to Length=$150;

attrib from Length=$150;

attrib asunto Length=$150;

attrib mensaje Length=$500;

to="&vto";

from="&vfrom";

asunto="&vasunto";

mensaje="&vmensaje";

RUN;

Data &_INPUT1;

attrib to Length=$150;

attrib from Length=$150;

attrib asunto Length=$150;

attrib mensaje Length=$500;

set work.DATOS;

run;

OPTIONS EMAILHOST='none.sas.com'

emailport=25;

Filename Mailbox

Email to="&vto" from="&vfrom"

Subject="&vasunto"

;

DATA _NULL_;

file Mailbox;

put "&vmensaje";

RUN;

%let vstatus=&syserr;

DATA RESPUESTA;

attrib to Length=$150;

attrib from Length=$150;

attrib asunto Length=$150;

attrib mensaje Length=$500;

attrib status length=8;

to="&vto";

from="&vfrom";

asunto="&vasunto";

mensaje="&vmensaje";

status=&vstatus;

RUN;

Data &_OUTPUT1;

attrib to Length=$150;

attrib from Length=$150;

attrib asunto Length=$150;

attrib mensaje Length=$500;

attrib status length=8;

set work.RESPUESTA;

run;

SP deployment

Deploya as Web Services

ERROR IN CI

com.sas.analytics.ph.RTDMException: <?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><soapenv:Fault><faultcode

>soapenv:Server</faultcode><faultstring xml:lang="en">A 'Server Execution' type of exception occurred during execution of 'EnviarEmail' service. The exception follows: SAS completed with n

onzero SYSCC '1,012'. SYSMSG: ''.</faultstring>

I need your support to solve this problem.

Thank you.

Re: The exception follows: SAS completed with n onzero SYSCC '1,012'. SYSMSG:

s_lassen — Thu, 27 May 2021 06:14:26 GMT

The SYSCC variable is set when there is a warning or an error. It seems something went wrong with your mail step (probably the server none.sas.com does not exist). You are using the following data step to catch the error, so I assume that you can reset the SYSCC automatic variable after that.

But take a look at the log first, and see if that is really the case.

If you are handling errors elsewhere, you can simply put

%let syscc=0;

at the end of the program. But you may want to check it after each step, if this is production code.

topic The exception follows: SAS completed with n onzero SYSCC '1,012'. SYSMSG: in SAS Procedures

The exception follows: SAS completed with n onzero SYSCC '1,012'. SYSMSG:

Re: The exception follows: SAS completed with n onzero SYSCC '1,012'. SYSMSG: