HI All, my users were reporting that performance had slowed down yesterday. It had been a while since we had installed updates so I stopped LASR servers, stopped the SAS servers, and ran the updates and rebooted. Now this morning I restarted all the sas server tiers, but I cannot start any of the LASR servers.
I have a ticket open and I'm waiting for a response from SAS, in the meantime I was hoping someone might have some idea what might have happened.
A few months back we redirected the WORK directory to a larger drive - I mention this because the WORK tag is referenced in the error.
-------------- LOG: Start Server -------------- 4 The SAS System 10:09 Thursday, October 18, 2018 63 %statuscheckpoint; 64 /* Skip Next Step If We Have a Bad Status Code */ 65 %macro codeBody; 66 %GLOBAL LASTSTEPRC; 67 %if %symexist(LASTSTEPRC) %then %do; 68 %if %eval(&LASTSTEPRC. <= 4) %then %do; 69 70 /* Start the single-machine LASR server process */ 71 libname ml sasiola startserver= 72 ( 73 PATH="/sas/config/Lev1/AppData/SASVisualAnalytics/VisualAnalyticsAdministrator/sigfiles" 74 ) 75 76 host="<host>" port=<LASR Server Port> 77 signer="https://<host>:<ssl port>/SASLASRAuthorization" 78 ; 79 80 %end; 81 %end; 82 %mend; 83 %codeBody; NOTE: No tag was specified in the LIBNAME statement. The default tag (WORK) is used to name and identify tables in the LASR Analytic Server. You can specify a tag as a data set option. ERROR: Unable to register LASR server with authentication service. ERROR: Libref ML is not assigned. ERROR: Error in the LIBNAME statement.
Does anyone have any ideas?
When did you configure HTTPS/TLS on the middle tier? Please start the workspace server directly from the Linux console (/<SASConfig>/Lev<X>/SASApp/WorkspaceServer/WorkspaceServer.sh -nodms) and show me an output from a program below:
libname ml sasiola startserver=( PATH="/sas/config/Lev1/AppData/SASVisualAnalytics/VisualAnalyticsAdministrator/sigfiles" ) host="<host>" port=<LASR Server Port> signer="https://<host>:<ssl port>/SASLASRAuthorization";
TLS was configured earlier this year. No problems for months until now, but running that like you asked throws an SSL error:
NOTE: No tag was specified in the LIBNAME statement. The default tag (WORK) is used to name and identify tables in the LASR Analytic Server. You can specify a tag as a data set option. ERROR: Unable to register LASR server with authentication service. ERROR: Libref ML is not assigned. ERROR: Error in the LIBNAME statement. 3? ERROR: OpenSSL error 336134278 (0x14090086) occurred in SSL_connect/accept at line 6039, the error message is "error:14090086:SSL routines:ssl3_get_server_certificate:certificate verify failed". ERROR: Encryption run-time execution error
I looked that error:14090086 error up and it led me here: http://support.sas.com/documentation/cdl/en/secref/69831/HTML/default/viewer.htm#p1xeu488m00x85n16g3...
ERROR:14090086:SSL routines: SSL3_GET_SERVER_CERTIFICATE: certificate verify failedThis message is displayed when certificates cannot be verified. If the directory where the certificates are located is specified using the SSLCACERTDIR environment variable, and the certificate names in the directory are not named using the value of a hash that OpenSSL generates, this message is generated. For more information, see SSLCACERTDIR Environment Variable.
That doesn't really make sense to me, why would this suddenly go awry?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.