cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
jmehul
‎09-09-2019
  • 54 Posts
  • 12 Likes Given
  • 1 Solutions
  • 2 Likes Received

Re: Running Oracle Procedures using SAS DI

by Quartz | Level 8 in New SAS User
‎09-09-2019 12:59 AM
‎09-09-2019 12:59 AM
@JosvanderVelden    I have followed the same link. Still facing an issue. ... View more

Running Oracle Procedures using SAS DI

by Quartz | Level 8 in New SAS User
‎09-06-2019 09:49 AM
‎09-06-2019 09:49 AM
Hi All,   We have created a code in SAS DI using user code transformation but we are unable to trigger the procedure in oracle We have a stored procedure named AA_TEST_PROC_DI in oracle. Below is the code. Pls, suggest us the right path.   proc sql; connect to oracle (user=xxx password="{SAS002}xxx" path=xxx); execute (execute xxx.AA_TEST_PROC_DI) by oracle; disconnect from oracle; quit; quit;   ... View more

Sub total in WRS

by Quartz | Level 8 in New SAS User
‎08-22-2019 02:42 AM
‎08-22-2019 02:42 AM
Hi experts,   I want to know- Is there any way where we can achieve the subtotal for only one category and not for other sub-categories? I also can't use drill-downs within the report   I am using SAS cube studio 9.2, Information map studio 9.2 and Web report studio.   I have tried many workarounds but nothing is working.      ... View more

Re: Backup SAS VA

by Quartz | Level 8 in Administration and Deployment
‎02-26-2019 01:52 AM
‎02-26-2019 01:52 AM
@SASKiwi ,   We want to replicate the SAS 9.4 environment and wanted to shift our all resources to the new server. Yes, it's a new installation but we want to migrate all the resources.  How to export users and Libraries which we have created in the SMC. How to load the tables on the new Lasr Server which are uploaded on the old SAS Lasr server.  ... View more

Backup SAS VA

by Quartz | Level 8 in Administration and Deployment
‎02-20-2019 06:00 AM
1 Like
‎02-20-2019 06:00 AM
1 Like
Hi All,   I have an existing SAS VA 9.4 environment, we have to take the backup of this environment and reinstall it due to some reason. I have Exported the SAS folders and copied the SAS config file. 1. How to take the backup of existing libraries? 2. Do I need to create the same server and libraries again on SMC after the new installation?  3. Do I need to take back up of any other folder? ... View more

Re: SAS Access for R3 to be licensed on work space server

by Quartz | Level 8 in New SAS User
‎02-11-2019 07:45 AM
‎02-11-2019 07:45 AM
So, As I don't have the license of SAS access to R3 on the workspace server but have it on another server, It should work, Right?  ... View more

SAS Access for R3 to be licensed on work space server

by Quartz | Level 8 in New SAS User
‎02-11-2019 06:15 AM
‎02-11-2019 06:15 AM
Hi All,   I have two servers A and B,   On A, I have work Space server (EBI Server) and on B I have DI, Data surveyor and SAS Access to R3 (Server for client Apps) As A has the workspace server so I had to create a profile for Di which is pointing to Server A, But when I am testing my connection in DI through Data surveyor plug-in - it is giving me an error that SAS access to R3 is no licensed.   So My question is: I need to have theSAS access to R3 licence on the Server A or Server B.  ... View more

Re: Error in creating the reports using cubes

by Quartz | Level 8 in SAS Web Report Studio
‎02-04-2019 04:25 AM
‎02-04-2019 04:25 AM
For building a cube we are using SAS cube studio,   Is there anything that I have to change in the permission side?  Because when loading that table from Oracle to some general library in SMC using base sas code and doing the whole process, then it is showing no issues.     ... View more

Error in creating the reports using cubes

by Quartz | Level 8 in SAS Web Report Studio
‎02-04-2019 01:16 AM
‎02-04-2019 01:16 AM
Hi everyone,   We are using SAS 9.2 and we are facing an issue in the lib name. We are using Oracle as our data source.    We have created a library in SMC and we are able to register a table then we are making cubes in cube studio, filters in information map studio and reports in the Web report studio. Everything is perfect.   But if we are choosing the option 'Do not create N-way aggregation' during the cube creation and specifying our own level of aggregation then we are getting a below error.   ... View more

SAS Viya dashboard not opening (Urgent)

by Quartz | Level 8 in New SAS User
‎01-18-2019 07:34 AM
‎01-18-2019 07:34 AM
Hi All,   I am making a Dashboard on SAS Viya and when I am viewing it, I am getting the below error. Unresolvable entities for scope: "SASReport" { Could not resolve entity: {name:"bi8263", type:"DataItem", tid:40109} }   How can I resolve this error? Also, I can see that in my XML code of the report it is some RelationalDataItem name.   ... View more

Autotuning in E miner

by Quartz | Level 8 in New SAS User
‎01-11-2019 06:14 AM
‎01-11-2019 06:14 AM
Hi All, I am using SAS E miner 14.3. There are some predefined parameters for any model like depth = 6 Max Branch=2 etc.   Is there any way in which I can perform the grid search to find the best parameters. I want to know how can I autotune the parameters for the model on the basis of cross-validation error or any other method.     ... View more

Re: ESRI web maps in SAS Visual Analytics 7.4

by Quartz | Level 8 in SAS Visual Analytics
‎12-21-2018 02:38 AM
‎12-21-2018 02:38 AM
  Hi @FalkoSchulz,   I have configured property sas.web.cdps.knownHosts as  http://opnsta.sas.com/,http://opnstb.sas.com/,http://opnstc.sas.com/,http://services.arcgisonline.com/ArcGIS/rest/services But Still getting the same error. Can you figure out my mistake?   ... View more

ESRI web maps in SAS Visual Analytics 7.4

by Quartz | Level 8 in SAS Visual Analytics
‎12-14-2018 01:13 AM
‎12-14-2018 01:13 AM
Hi All, I have added ESRi web map link in my SMC, Still getting the below error, When I am opening preferences in VA.   Error: [IOErrorEvent type="ioError" bubbles=false cancelable=false eventPhase=2 text="Error #2032"]. URL: http://sas.example.com/SASVisualAnalyticsDesigner/CrossDomainProxyServlet?destUrl=%7Bsasenc%7DCDF82C0A2DD8D7732E2D955D18E5C72544490B260415D37A426D65F848EAF5FE158260B423E1E3E92EC53B6F114364B2272919713C1601B1339073441A29A4250457422302C94D870F343F7C15BB24F52B21A9EE   How to get the third party maps on VA  ... View more

Re: Scheduling and mailing in SAS VA 7.4

by Quartz | Level 8 in New SAS User
‎12-07-2018 01:05 AM
‎12-07-2018 01:05 AM
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 ... View more

Re: Star schema in sas viya 3.3

by Quartz | Level 8 in New SAS User
‎12-06-2018 07:34 AM
‎12-06-2018 07:34 AM
@LinusH   I can't find any option in Data preparation, which can make star schema model (View). P.s. I am not talking about joining the table.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-09-2019 04:44 AM
Likes given to
Likes from
View All
Quick links