SAS Viya MQ Configuration

brunolimaq — Fri, 29 Nov 2019 18:50:13 GMT

I am trying to send/receive messages to a row MQ using SAS Studio

Configure in SASStudio JVM CLASSPATH an ActiveMQ library, however, when executing error code "ERROR 23-2: Invalid option name URL", which appears to be pq or SASStudio does not describe JMS.

CODE:

data _null_;
    file 'myqueue' activemq url='http://localhost:8161/api/message'
        user=admin pass=admin;
    format a datetime21.1;
    a = datetime(); put a ' Testing: 1 2';
    a = datetime(); put a +1 'This is a test. 3 4';
    a = datetime();
    put a @22 'This is only a test. 5 6';
run;

ERROR:

 1          OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 72         
 73         data _null_;
 74             file 'myqueue' activemq url='http://localhost:8161/api/message'
                                        ___
                                        23
 ERROR 23-2: Invalid option name URL.

 75                 user=admin pass=admin;
                    ____
                    23
 ERROR 23-2: Invalid option name USER.

 75       !         user=admin pass=admin;
                               ____
                               23
 ERROR 23-2: Invalid option name PASS.

 76             format a datetime21.1;
 77             a = datetime(); put a ' Testing: 1 2';
 78             a = datetime(); put a +1 'This is a test. 3 4';
 79             a = datetime();
 80             put a @22 'This is only a test. 5 6';
 81         run;

 NOTE: The SAS System stopped processing this step because of errors.
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds
       cpu time            0.01 seconds
       

 82         
 83         
 84         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
 97

Configuration:

[root@a-dtes-pvx06 viya]# ps auxww | grep sasstudio | grep -i mq

sas 25439 6.7 0.2 2856704 614476 ? Sl 16:20 1:22 /usr/lib/jvm/jre-1.8.0/bin/java -Xms256M -Xmx1024M -Dsasstudio.home=/opt/sas/viya/home/SASStudio -Dsasstudio.appserver.logdir=/opt/sas/viya/config/var/log/sasstudio/default -Dsasstudio.appserver.confdir=/opt/sas/viya/config/etc/sasstudio/default -Dsasstudio.deployment.deployid=viya -Dsasstudio.deployment.productid=sasstudio -Dsasstudio.deployment.instanceid=default -Djava.io.tmpdir=/opt/sas/viya/config/var/tmp/sasstudio/default -Dcertframe.home=/opt/sas/viya/home/SASSecurityCertificateFramework -Dcertframe.confdir=/opt/sas/viya/config/etc/SASSecurityCertificateFramework -Dsasstudio.appserver.consul.baseurl=https://localhost:8501 -Djava.security.egd=file:/dev/urandom -Djava.library.path=/opt/sas/activemq/apache-activemq-5.15.10/lib -classpath /opt/sas/viya/home/SASStudio/lib/sas.sasstudio.host.jar:/opt/sas/viya/home/SASStudio/lib/sas.sasstudio.viya.jar:/opt/sas/viya/home/SASStudio/lib/spring-web-4.3.16.RELEASE.jar:/opt/sas/viya/home/SASStudio/lib/jackson-databind-2.8.11.1.jar:/opt/sas/viya/home/SASStudio/lib/jackson-annotations-2.8.0.jar:/opt/sas/viya/home/SASStudio/lib/tomcat-embed-jasper-8.5.29.jar:/opt/sas/viya/home/SASStudio/lib/tomcat-embed-core-8.5.29.jar:/opt/sas/viya/home/SASStudio/lib/spring-context-4.3.16.RELEASE.jar:/opt/sas/viya/home/SASStudio/lib/spring-aop-4.3.16.RELEASE.jar:/opt/sas/viya/home/SASStudio/lib/spring-beans-4.3.16.RELEASE.jar:/opt/sas/viya/home/SASStudio/lib/spring-expression-4.3.16.RELEASE.jar:/opt/sas/viya/home/SASStudio/lib/spring-core-4.3.16.RELEASE.jar:/opt/sas/viya/home/SASStudio/lib/jackson-core-2.8.10.jar:/opt/sas/viya/home/SASStudio/lib/tomcat-annotations-api-8.5.29.jar:/opt/sas/viya/home/SASStudio/lib/javax.servlet-api-3.1.0.jar:/opt/sas/viya/home/SASStudio/lib/log4j-1.2-api-2.8.2.jar:/opt/sas/viya/home/SASStudio/lib/tomcat-embed-el-8.5.29.jar:/opt/sas/viya/home/SASStudio/lib/ecj-3.12.3.jar:/opt/sas/viya/home/SASStudio/lib/commons-logging-1.2.jar:/opt/sas/viya/home/SASStudio/lib/log4j-core-2.8.2.jar:/opt/sas/viya/home/SASStudio/lib/log4j-api-2.8.2.jar:/opt/sas/activemq/apache-activemq-5.15.10/activemq-all-5.15.10.jar com.sas.studio.host.SASStudioApplication

Where do I have to configure ActiveMQ LIB to be recognized by SASStudio?

VERSION : SAS Viya® 3.4

Thank you,

Bruno Queiroz

Re: SAS Viya MQ Configuration

AnandVyas — Tue, 03 Dec 2019 13:58:01 GMT

Hi @brunolimaq,

I can see that the code you are referencing in your post is part of the examples present in this link - https://documentation.sas.com/?docsetId=appmsgdg&docsetTarget=p0scb9ccs24n7ln187f8bu64crpl.htm&docsetVersion=9.4&locale=en#n1nqgbkkivsq2xn15nhwvk37jae2

Kindly note this example is for 9.4 platform which is based on Apache ActiveMQ. However Viya uses RabbitMQ. I am sure there would be differences between the two.

I would suggest you to raise a TS track to get idea on how to do the same for Viya.

topic Re: SAS Viya MQ Configuration in SAS Programming

SAS Viya MQ Configuration

Re: SAS Viya MQ Configuration