BookmarkSubscribeRSS Feed
brunolimaq
Calcite | Level 5
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:
Spoiler
[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
1 REPLY 1
Anand_V
Ammonite | Level 13
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&docse...

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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 397 views
  • 0 likes
  • 2 in conversation