Scheduling and mailing in SAS VA 7.4

jmehul — Wed, 28 Nov 2018 13:17:59 GMT

Hi,

I am trying to schedule a data preparation job and created alerts on the report

also, I am trying to distribute report through email.

None of the above is working and I think they are linked with each other. (Some changes in SMC)

Can anyone guide me? I am doing it for the first time

Distribute report through email using "Distribute Reports" option available in SAS VA designer mode. I created a reporting job and tried to run the distribution in both ways using "Run Now" option as well as "Schedule" option. It is running and completes successful but the email is not getting delivered to the recipients. But in the show history, it shows start time, finish time, state as completed and status message as a success. It is not even giving any error.

Re: Scheduling and mailing in SAS VA 7.4

Madelyn_SAS — Thu, 06 Dec 2018 15:45:13 GMT

For the distribution issue, please locate these logs and see if there are any errors. SASServerX_Y will be either 1_1 or 12_1, depending on your environment.

/SAS-configuration-directory/Lev1/Web/Logs/SASServerX_Y/SASVisualAnalyticsHyperlink7.x.log
/SAS-configuration-directory/Lev1/Web/Logs/SASServerX_Y/SASVisualAnalyticsDesigner7.x.log

Re: Scheduling and mailing in SAS VA 7.4

jmehul — Fri, 07 Dec 2018 06:05:20 GMT

Below is the error @Madelyn_SAS:

SAS WARN [SchedPool 1] 2018-12-06 04:51:44,974 [ST-11338-G3gIdEvgecHrgzd7gjcX-cas:sasdemo] com.sas.bicommon.distribution.VADistributionJobRunner - Unexpected failure
org.springframework.mail.MailAuthenticationException: Authentication failed; nested exception is javax.mail.AuthenticationFailedException: failed to connect, no password specified?
at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:392)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:340)
at org.springframework.mail.javamail.JavaMailSenderImpl.send(JavaMailSenderImpl.java:336)
at com.sas.svcs.mail.impl.MailService.send(MailService.java:80)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.remoting.support.RemoteInvocationTraceInterceptor.invoke(RemoteInvocationTraceInterceptor.java:77)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy1297.send(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)
at org.springframework.remoting.support.DefaultRemoteInvocationExecutor.invoke(DefaultRemoteInvocationExecutor.java:38)
at sun.reflect.GeneratedMethodAccessor781.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
at com.sas.svcs.remoting.aspects.AbstractAspectJRemoteInvocationInterceptor.invoke(AbstractAspectJRemoteInvocationInterceptor.java:78)
at sun.reflect.GeneratedMethodAccessor780.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy1285.invoke(Unknown Source)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114)
at com.sas.svcs.remoting.httpinvoker.PostProcessingHttpInvokerServiceExporter.invokeAndCreateResult(PostProcessingHttpInvokerServiceExporter.java:94)
at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:90)
at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:677)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.java:45)
at org.springframework.remoting.support.RemoteInvocationResult.recreate(RemoteInvocationResult.java:115)
at com.sas.svcs.remoting.RemoteInvocationAttributeResult.recreate(RemoteInvocationAttributeResult.java:88)
at org.springframework.remoting.support.RemoteInvocationBasedAccessor.recreateRemoteInvocationResult(RemoteInvocationBasedAccessor.java:85)
at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:148)
at com.sas.svcs.cluster.httpinvoker.AutoDiscoveredHttpService.invoke(AutoDiscoveredHttpService.java:345)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy2066.send(Unknown Source)
at com.sas.bicommon.distribution.email.EmailMgr.sendText(EmailMgr.java:208)
at com.sas.bicommon.distribution.DistributionController.emailSummaryToOriginator(DistributionController.java:593)
at com.sas.bicommon.distribution.DistributionController.distribute(DistributionController.java:132)
at com.sas.bicommon.distribution.VADistributionJobRunner.runJob(VADistributionJobRunner.java:80)
at com.sas.scheduler.api.servers.ip.engine.mq.client.JMSClientSupport$4$2.run(JMSClientSupport.java:650)
at com.sas.scheduler.api.servers.ip.engine.threadpool.WorkerThread.doCurrentWorkNow(WorkerThread.java:151)
at com.sas.scheduler.api.servers.ip.engine.threadpool.WorkerThread.run(WorkerThread.java:195)
Caused by: javax.mail.AuthenticationFailedException: failed to connect, no password specified?
at javax.mail.Service.connect(Service.java:325)
at org.springframework.mail.javamail.JavaMailSenderImpl.doSend(JavaMailSenderImpl.java:389)
... 90 more

Re: Scheduling and mailing in SAS VA 7.4

Madelyn_SAS — Fri, 07 Dec 2018 16:11:45 GMT

Those errors would indicate that email is not correctly configured at your site. Are you using secure SMTP?

Please review this documentation in the SAS Intelligence Platform: Middle-Tier Administration Guide

SMTP Mail Server

topic Re: Scheduling and mailing in SAS VA 7.4 in New SAS User

Scheduling and mailing in SAS VA 7.4

Re: Scheduling and mailing in SAS VA 7.4

Re: Scheduling and mailing in SAS VA 7.4

Re: Scheduling and mailing in SAS VA 7.4