Hi,   I am trying to create a Oracle connection in SAS Viya 3.4.    When I do a Test Connection, it tell me that "There was a problem testing the connection: An unexpected error has occurred"   I have tested the connection using sqlplus in the cas server and it is working fine.   Any help or pointer on how to resolve this error is very much appreciated. ... View more

Hi,   After deploying SAS Viya 3.4 and reset the password for sasboot, I encountered the following error:   The application is not authorized to use SAS Logon Manager.   I would appreciate any pointer or advice on how to resolve this issue.   Thanks in advance. ... View more

Hi,   I was trying to establish a connection to MS SQL Server 2014 in SAS Studio Release 4.4 (for SAS Viya 3.4) but encountered the following errors:    74         libname mslib odbc dsn="MyMSSQLServer" user="DataHub" password=XXXXXXXXXX;  ERROR: CLI error trying to establish connection: [unixODBC][Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired :         [unixODBC][Microsoft][ODBC Driver 13 for SQL Server]TCP Provider: Error code 0x102 : [unixODBC][Microsoft][ODBC Driver 13         for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server.         Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote         connections. For more information see SQL Server Books Online.  ERROR: Error in the LIBNAME statement.  75          76         OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;   I crosscheck by creating a ODBC connection to the same SQL Server on my desktop and the connection is tested successfully.   I  would appreciate any pointer or advice on how to resolve this error.   FYI, the followings are the content of the .ini files: [root@SASVIYA34 ~]# cat /opt/sas/spre/home/lib64/accessclients/odbcinst.ini [PostgreSQL] Description=ODBC for PostgreSQL Driver=/usr/lib/psqlodbcw.so Setup=/usr/lib/libodbcpsqlS.so Driver64=/usr/lib64/psqlodbcw.so Setup64=/usr/lib64/libodbcpsqlS.so FileUsage=1 [MySQL] Description=ODBC for MySQL Driver=/usr/lib/libmyodbc5.so Setup=/usr/lib/libodbcmyS.so Driver64=/usr/lib64/libmyodbc5.so Setup64=/usr/lib64/libodbcmyS.so FileUsage=1 [ODBC Driver 13 for SQL Server] Description=Microsoft ODBC Driver 13 for SQL Server Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2 UsageCount=1 [root@SASVIYA34 ~]# cat /opt/sas/spre/home/lib64/accessclients/odbc.ini [MyMSSQLServer] Driver=ODBC Driver 13 for SQL Server Description=My MS SQL Server Trace=No Server=192.168.1.111   Thanks in advance.   ... View more

Hi,   I have completed the SAS Viya 3.4 deployment and was trying to access SAS Environment Manager but encountered the Service Unavailable message.       I have listed out all the sas-viya services as follow.   [root@SASVIYA34 ~]# sudo /etc/init.d/sas-viya-all-services status Getting service info from consul...   Service                                            Status     Host               Port     PID   sas-viya-consul-default                            up         N/A                 N/A    5971   sas-viya-vault-default                             up         127.0.0.1          8200    6569   sas-viya-sasdatasvrc-postgres-node0-ct-pg_hba      up         N/A                 N/A    8587   sas-viya-sasdatasvrc-postgres-node0-ct-postgresql  up         N/A                 N/A    8583   sas-viya-sasdatasvrc-postgres-pgpool0-ct-pcp       up         N/A                 N/A    8626   sas-viya-sasdatasvrc-postgres-pgpool0-ct-pgpool    up         N/A                 N/A    8636   sas-viya-sasdatasvrc-postgres-pgpool0-ct-pool_hba  up         N/A                 N/A    8609   sas-viya-sasdatasvrc-postgres-node0                up         N/A                 N/A   16334   sas-viya-cascontroller-default                     up         N/A                 N/A   13056   sas-viya-httpproxy-default                         up         N/A                 N/A   10847   sas-viya-rabbitmq-server-default                   up         127.0.0.1          5671    None   sas-viya-sasdatasvrc-postgres                      up         N/A                 N/A   16978   sas-viya-sasstudio-default                         up         N/A                 N/A   12065   sas-viya-spawner-default                           up         N/A                 N/A   12723   sas-viya-runlauncher-default                       up         127.0.0.1         36726   20447   sas-viya-alert-track-default                       up         127.0.0.1             0   21833   sas-viya-authorization-default                     up         127.0.0.1         34638   22238   sas-viya-cachelocator-default                      up         127.0.0.1         38664   22278   sas-viya-cacheserver-default                       up         127.0.0.1         40912   22351   sas-viya-configuration-default                     up         127.0.0.1         41060   22382   sas-viya-identities-default                        up         127.0.0.1         33292   22323   sas-viya-ops-agent-default                         up         127.0.0.1             0   22661   sas-viya-ops-agentsrv-default                      up         127.0.0.1             0   22617   sas-viya-saslogon-default                          up         127.0.0.1         43682   22335   sas-viya-stream-evdm-default                       up         127.0.0.1             0   22163   sas-viya-watch-log-default                         up         127.0.0.1             0   22251   sas-viya-cas-management-default                    up         127.0.0.1         39124   37110   sas-viya-files-default                             up         127.0.0.1         43647   37036   sas-viya-folders-default                           up         127.0.0.1         34915   37059   sas-viya-preferences-default                       up         127.0.0.1         33616   37183   sas-viya-relationships-default                     up         127.0.0.1         35573   37122   sas-viya-transformations-default                   up         127.0.0.1         45789   37229   sas-viya-types-default                             up         127.0.0.1         41934   37209   sas-viya-appregistry-default                       up         127.0.0.1         40869   49784   sas-viya-audit-default                             up         127.0.0.1         40864   49834   sas-viya-cas-access-management-default             up         127.0.0.1         45944   50018   sas-viya-cas-formats-default                       up         127.0.0.1         43473   49850   sas-viya-cas-license-default                       up         127.0.0.1         36586   50007   sas-viya-casproxy-default                          up         127.0.0.1         40328   50032   sas-viya-casrowsets-default                        up         127.0.0.1         33986   49906   sas-viya-collections-default                       up         127.0.0.1         39995   50055   sas-viya-comments-default                          up         127.0.0.1         36133   50098   sas-viya-credentials-default                       up         127.0.0.1         39644   49845   sas-viya-crossdomainproxy-default                  up         127.0.0.1         35912   50126   sas-viya-dataflowexecutionprovider-default         up         127.0.0.1         37304   49967   sas-viya-dataplans-default                         up         127.0.0.1         43154   56198   sas-viya-datasources-default                       up         127.0.0.1         40718   63088   sas-viya-datatables-default                        up         127.0.0.1         37135   63086   sas-viya-deploymentBackup-default                  up         127.0.0.1         36923   63241   sas-viya-device-management-default                 up         127.0.0.1         45508   63159   sas-viya-fonts-default                             up         127.0.0.1         42333   63214   sas-viya-geo-enrichment-default                    up         127.0.0.1         38809   63038   sas-viya-graph-templates-default                   up         127.0.0.1         45198   63156   sas-viya-importvaspk-default                       up         127.0.0.1         35095   63257   sas-viya-jobdefinitions-default                    up         127.0.0.1         43186   63280   sas-viya-jobexecution-default                      up         127.0.0.1         34251   70838   sas-viya-links-default                             up         127.0.0.1         35963   70865   sas-viya-mail-default                              up         127.0.0.1         44174   70927   sas-viya-maps-default                              up         127.0.0.1         33511   70968   sas-viya-notifications-default                     up         127.0.0.1         39604   79565   sas-viya-projects-default                          up         127.0.0.1         46840   79508   sas-viya-reportalerts-default                      up         127.0.0.1         41708   79420   sas-viya-reportalertseval-default                  up         127.0.0.1         34429   79472   sas-viya-report-data-default                       up         127.0.0.1         34916   79533   sas-viya-reportdistribution-default                up         127.0.0.1         39742   79463   sas-viya-reportImages-default                      up         127.0.0.1         35005   79532   sas-viya-report-packages-default                   up         127.0.0.1         40165   79598   sas-viya-report-renderer-default                   up         127.0.0.1         37999   88676   sas-viya-reports-default                           up         127.0.0.1         39507   88714   sas-viya-reporttemplates-default                   up         127.0.0.1         43359   88672   sas-viya-reporttransforms-default                  up         127.0.0.1         45271   88804   sas-viya-reportviewernaturallanguageunderstanding-default up         127.0.0.1         37928   99340   sas-viya-restexecutionprovider-default             up         127.0.0.1         36921   99270   sas-viya-rowsets-default                           up         127.0.0.1         39477   99339   sas-viya-sasgraphbuilder-default                   up         127.0.0.1         40187   99352   sas-viya-scheduler-default                         up         127.0.0.1         36284   99402   sas-viya-search-default                            up         127.0.0.1         44377   99535   sas-viya-searchindex-default                       up         127.0.0.1         37375   99573   sas-viya-templates-default                         up         127.0.0.1         40710   99561   sas-viya-themes-default                            up         127.0.0.1         40939   99531   sas-viya-thumbnails-default                        down       127.0.0.1         34520     N/A   sas-viya-transfer-default                          down       127.0.0.1         46424     N/A   sas-viya-web-data-access-default                   down       127.0.0.1         39564     N/A   sas-viya-analytics-components-default              up         127.0.0.1         35351  114866   sas-viya-analytics-flows-default                   up         127.0.0.1         43079  114844   sas-viya-analytics-gateway-default                 up         127.0.0.1         43083  114904   sas-viya-analytics-localization-default            up         127.0.0.1         39953  115039   sas-viya-analytics-pipelines-default               up         127.0.0.1         37952  114900   sas-viya-analytics-validation-default              up         127.0.0.1         43675  115146   sas-viya-annotations-default                       up         127.0.0.1         39273  114999   sas-viya-backup-agent-default                      up         127.0.0.1         45669  115171   sas-viya-backupmanager-default                     up         127.0.0.1         34695  115101   sas-viya-categorization-default                    up         127.0.0.1         42505  115069   sas-viya-category-compile-default                  up         127.0.0.1         43042  115310   sas-viya-category-execution-provider-default       up         127.0.0.1         37831  115342   sas-viya-category-taxonomy-default                 down       127.0.0.1         39451     N/A   sas-viya-category-validate-default                 down       127.0.0.1         38014     N/A   sas-viya-compute-default                           down       127.0.0.1         35053     N/A   sas-viya-concept-compile-default                   down       127.0.0.1         38754     N/A   sas-viya-concept-execution-provider-default        down       127.0.0.1         43411     N/A   sas-viya-concepts-default                          down       127.0.0.1         38650     N/A   sas-viya-concept-taxonomy-service-default          down       127.0.0.1         39602     N/A   sas-viya-concept-validate-default                  down       127.0.0.1         37076     N/A   sas-viya-dataexplorer-default                      down       127.0.0.1         38687     N/A   sas-viya-datamining-default                        down       N/A                 N/A     N/A   sas-viya-data-mining-models-default                down       127.0.0.1         39907     N/A   sas-viya-dataminingwarehouse-default               down       127.0.0.1         42529     N/A   sas-viya-dataprofiles-default                      down       127.0.0.1         46459     N/A   sas-viya-datastudio-default                        down       127.0.0.1         38598     N/A   sas-viya-documents-default                         down       127.0.0.1         42840     N/A   sas-viya-drive-default                             down       N/A                 N/A     N/A   sas-viya-environmentmanager-default                down       127.0.0.1         38125     N/A   sas-viya-espvm-default                             down       127.0.0.1         36762     N/A   sas-viya-forecastingcomparison-default             down       127.0.0.1         43174     N/A   sas-viya-forecastingdatadefinition-default         down       127.0.0.1         38068     N/A   sas-viya-forecastingevents-default                 down       N/A                 N/A     N/A   sas-viya-forecastingfilters-default                down       127.0.0.1         44192     N/A   sas-viya-forecastinggateway-default                down       N/A                 N/A     N/A   sas-viya-forecastingoverrides-default              down       127.0.0.1         42261     N/A   sas-viya-forecastingpipelines-default              down       127.0.0.1         40174     N/A   sas-viya-forecastingstrategies-default             down       N/A                 N/A     N/A   sas-viya-jobexecapp-default                        down       127.0.0.1         46211     N/A   sas-viya-jobflowexecution-default                  down       127.0.0.1         35701     N/A   sas-viya-jobflowscheduling-default                 down       127.0.0.1         38842     N/A   sas-viya-launcher-default                          down       127.0.0.1         36550     N/A   sas-viya-lineage-default                           down       127.0.0.1         33699     N/A   sas-viya-mbagent-default                           down       N/A                 N/A     N/A   sas-viya-modelpublish-default                      down       127.0.0.1         43969     N/A   sas-viya-modelrepository-default                   down       127.0.0.1         39375     N/A   sas-viya-monitoring-default                        down       127.0.0.1         42232     N/A   sas-viya-naturalLanguageGeneration-default         down       127.0.0.1         45914     N/A   sas-viya-naturalLanguageUnderstanding-default      down       127.0.0.1         34388     N/A   sas-viya-parse-execution-provider-default          down       127.0.0.1         45911     N/A   sas-viya-parsing-default                           down       127.0.0.1         46414     N/A   sas-viya-results-default                           down       127.0.0.1         34997     N/A   sas-viya-sasreportviewer-default                   down       127.0.0.1         40099     N/A   sas-viya-sasthemedesigner-default                  down       127.0.0.1         41494     N/A   sas-viya-sasvisualanalytics-default                down       127.0.0.1         45683     N/A   sas-viya-scoredefinitions-default                  down       127.0.0.1         44186     N/A   sas-viya-scoreexecution-default                    down       127.0.0.1         38339     N/A   sas-viya-sentiment-default                         down       127.0.0.1         34773     N/A   sas-viya-sentiment-execution-provider-default      down       127.0.0.1         34833     N/A   sas-viya-studiov-default                           down       127.0.0.1         40102     N/A   sas-viya-tenant-default                            down       127.0.0.1         41919     N/A   sas-viya-terms-management-default                  down       127.0.0.1         46092     N/A   sas-viya-text-gateway-default                      down       127.0.0.1         46043     N/A   sas-viya-themecontent-default                      down       127.0.0.1         35855     N/A   sas-viya-topic-execution-provider-default          down       127.0.0.1         37248     N/A   sas-viya-topic-management-default                  down       127.0.0.1         44731     N/A   sas-viya-topics-service-default                    down       127.0.0.1         37794     N/A   sas-viya-visual-pipeline-default                   down       127.0.0.1         46390     N/A sas-services completed in 00:02:13   I would appreciate any advice or pointer on how to resolve the issue.   Thanks in advance. ... View more

Hi,   I encountered error on rabbit cluster setup (see deployment.log below).  I would appreciate any help or pointer on how to resolve the error.   "msg": "non-zero return code", "rc": 3, "start": "2018-10-13 00:50:43.602535", "stderr": "", "stderr_lines": [], "stdout": "Sat Oct 13 00:50:43 +08 2018 setup_rabbit_cluster *************\nSat Oct 13 00:50:44 +08 2018 setup_rabbit_cluster Beginning SAS RabbitMQ clustering setup\nSat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster SSL is true\nSat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster CHECK_PORT is 5671\nSat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster First host in list is SASVIYA34\nSat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster First host shortname is SASVIYA34\nSat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster Primary Host is SASVIYA34\nSat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster Primary Short Host is SASVIYA34\nSat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster My Host is SASVIYA34\nSat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster I am the primary host\nSat Oct 13 00:50:46 +08 2018 setup_rabbit_cluster Copy generated Erlang shared secret to Rabbit.\nSat Oct 13 00:50:57 +08 2018 setup_rabbit_cluster Copying generated Erlang shared secret to Rabbit.\nSat Oct 13 00:50:57 +08 2018 setup_rabbit_cluster Starting sas-viya-rabbitmq-server-default\nSat Oct 13 00:51:41 +08 2018 setup_rabbit_cluster The RabbitMQ service sas-viya-rabbitmq-server-default could not be started.\nSat Oct 13 00:51:41 +08 2018 setup_rabbit_cluster Returned status was 1\nSat Oct 13 00:51:41 +08 2018 setup_rabbit_cluster Setup failed. Beware of independent Rabbit hosts running with different shared secrets.", "stdout_lines": [ "Sat Oct 13 00:50:43 +08 2018 setup_rabbit_cluster *************", "Sat Oct 13 00:50:44 +08 2018 setup_rabbit_cluster Beginning SAS RabbitMQ clustering setup", "Sat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster SSL is true", "Sat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster CHECK_PORT is 5671", "Sat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster First host in list is SASVIYA34", "Sat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster First host shortname is SASVIYA34", "Sat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster Primary Host is SASVIYA34", "Sat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster Primary Short Host is SASVIYA34", "Sat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster My Host is SASVIYA34", "Sat Oct 13 00:50:46 +08 2018 (debug) setup_rabbit_cluster I am the primary host", "Sat Oct 13 00:50:46 +08 2018 setup_rabbit_cluster Copy generated Erlang shared secret to Rabbit.", "Sat Oct 13 00:50:57 +08 2018 setup_rabbit_cluster Copying generated Erlang shared secret to Rabbit.", "Sat Oct 13 00:50:57 +08 2018 setup_rabbit_cluster Starting sas-viya-rabbitmq-server-default", "Sat Oct 13 00:51:41 +08 2018 setup_rabbit_cluster The RabbitMQ service sas-viya-rabbitmq-server-default could not be started.", "Sat Oct 13 00:51:41 +08 2018 setup_rabbit_cluster Returned status was 1", "Sat Oct 13 00:51:41 +08 2018 setup_rabbit_cluster Setup failed. Beware of independent Rabbit hosts running with different shared secrets." ] } 2018-10-13 00:51:41,397 p=5697 u=root | PLAY RECAP ************************************************************************************************** 2018-10-13 00:51:41,397 p=5697 u=root | deployTarget : ok=328 changed=154 unreachable=0 failed=1 2018-10-13 00:51:41,397 p=5697 u=root | localhost : ok=14 changed=1 unreachable=0 failed=0   Thanks in advance. ... View more