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: 
SAS_LuisBolivar
‎10-25-2023
  • 61 Posts
  • 9 Likes Given
  • 2 Solutions
  • 8 Likes Received

Re: Logical Pooled Workspace Server and Logical Stored Process Server ...

by Quartz | Level 8 in Administration and Deployment
‎03-28-2022 03:40 PM
‎03-28-2022 03:40 PM
I have managed to overcome the error.   Thanks to each of your comments.   He had a group with sasadministrator and sasusers roles.   But now I have the following error:   2022-03-28T12:17:35,568 ERROR [00000148] :sasadm - Objspawn was unable to launch the server SASApp - Stored Process Server (A5NQO0H3.AY000009) due to the server launch exceeding the specified wait time. 2022-03-28T12:17:35,568 ERROR [00000148] :sasadm - An error occurred while server (A5NQO0H3.AZ00000C_!A5NQO0H3.AY000004_@xxxxxxxxxxx) was starting. Now attempting a different server. 2022-03-28T12:17:35,568 ERROR [00000148] :sasadm - The Balance algorithm timed out before a server could be found. 2022-03-28T12:17:35,568 INFO [00000148] :sasadm - Failed to redirect client to available server in cluster SASApp - Logical Stored Process Server (A5NQO0H3.AW000006). Can you help me, please. Thanks. ... View more

Re: Logical Pooled Workspace Server and Logical Stored Process Server ...

by Quartz | Level 8 in Administration and Deployment
‎03-27-2022 05:37 PM
‎03-27-2022 05:37 PM
Greetings, good afternoon. I need to validate the permissions on Linux, the user is part of the sas group. What are the correct permissions? Thanks ... View more

Re: Logical Pooled Workspace Server and Logical Stored Process Server ...

by Quartz | Level 8 in Administration and Deployment
‎03-27-2022 03:54 PM
‎03-27-2022 03:54 PM
Good afternoon. It is an initial configuration. Thanks. ... View more

Re: Logical Pooled Workspace Server and Logical Stored Process Server ...

by Quartz | Level 8 in Administration and Deployment
‎03-27-2022 10:39 AM
‎03-27-2022 10:39 AM
Hello.   Validate the services with the sasdemo user and the same error is presented.   Verify that user the sastrust user does not have the admin role.   Validate by logging in to sas mc with the sassrv user that I have not been assigned any special permission. Everything is in order.   But the error still occurs.   It seems strange to me that the SAS object spawner can be validated without problems for two of the three Application servers.   On the third server it gives me the following error:   The service is up and is listening.     Thanks. ... View more

Logical Pooled Workspace Server and Logical Stored Process Server vali...

by Quartz | Level 8 in Administration and Deployment
‎03-26-2022 09:46 AM
‎03-26-2022 09:46 AM
Good morning community. I would like your help with the following problem. In a sas environment composed of 1 Metadata server, 3 applications and 1 web, the following problem occurs: Error when validating the Logical Pooled Workspace Server:     Error when validating the Logical Stored Process Server:     In the Objspawn log file we see the following:   2022-03-26T09:09:28,664 INFO [00000031] :sas - Processing parsed configuration results. 2022-03-26T09:09:28,664 INFO [00000031] :sas - Objspawn is proceeding with the configuration results processing utilizing the A5NQO0H3.AY000004 spawner definition. 2022-03-26T09:09:28,665 INFO [00000031] :sas - Reserved IPv6 port 8581 for administrator listen (connection 2). 2022-03-26T09:09:28,665 INFO [00000031] :sas - Reserved IPv6 port 8451 for server listen (connection 3). 2022-03-26T09:09:28,665 INFO [00000031] :sas - Reserved IPv6 port 8701 for server listen (connection 4). 2022-03-26T09:09:30,865 INFO [00000031] :sas - Access denied. 2022-03-26T09:09:30,865 WARN [00000031] :sas - The credentials specified for the SASApp - Pooled Workspace Server (A5NQO0H3.AY000008) server definition failed to authenticate. Therefore this server definition will not be included. 2022-03-26T09:09:30,865 WARN [00000031] :sas - The password obtained from the metadata indicates that it was obtained by a user that has unrestricted access. Please check your configuration. 2022-03-26T09:09:30,866 WARN [00000031] :sas - Unrestricted access can include being an unrestricted user, or being a member of the SAS Administrators group, or being a member of any group that has the role Metadata Server: User Administration. 2022-03-26T09:09:30,866 INFO [00000031] :sas - Reserved IPv6 port 8601 for server listen (connection 5). 2022-03-26T09:09:30,866 INFO [00000031] :sas - Reserved IPv6 port 8611 for server listen (connection 6). 2022-03-26T09:09:30,866 INFO [00000031] :sas - Reserved IPv6 port 8621 for server listen (connection 7). 2022-03-26T09:09:30,866 INFO [00000031] :sas - Reserved IPv6 port 8631 for server listen (connection 8). 2022-03-26T09:09:32,990 INFO [00000031] :sas - Access denied. 2022-03-26T09:09:32,990 WARN [00000031] :sas - The credentials specified for the SASApp - Stored Process Server (A5NQO0H3.AY000009) server definition failed to authenticate. Therefore this server definition will not be included. 2022-03-26T09:09:32,990 WARN [00000031] :sas - The password obtained from the metadata indicates that it was obtained by a user that has unrestricted access. Please check your configuration. 2022-03-26T09:09:32,990 WARN [00000031] :sas - Unrestricted access can include being an unrestricted user, or being a member of the SAS Administrators group, or being a member of any group that has the role Metadata Server: User Administration. 2022-03-26T09:09:32,991 INFO [00000031] :sas - Reserved IPv6 port 8591 for server listen (connection 9). 2022-03-26T09:09:32,991 INFO [00000031] :sas - Reserved IPv6 port 37179 for launched server connect back listen (connection 10). 2022-03-26T09:09:32,991 INFO [00000031] :sas - Activated listen on IPv6 port 37179 (connection 10). 2022-03-26T09:09:32,991 WARN [00000031] :sas - The SASApp - Logical Pooled Workspace Server (A5NQO0H3.AW000005) cluster does not contain any valid server definitions. Therefore this cluster definition will not be included. 2022-03-26T09:09:32,991 WARN [00000031] :sas - The SASApp - Logical Stored Process Server (A5NQO0H3.AW000006) cluster does not contain any valid server definitions. Therefore this cluster definition will not be included. 2022-03-26T09:09:32,991 INFO [00000031] :sas - Activated listen on IPv6 port 8591 (connection 9). 2022-03-26T09:09:32,991 INFO [00000031] :sas - Activated listen on IPv6 port 8451 (connection 3). 2022-03-26T09:09:32,991 INFO [00000031] :sas - Activated listen on IPv6 port 8581 (connection 2). 2022-03-26T09:09:33,001 INFO [00000005] :sas - SAS Object Spawner Daemon III is running under the user identity sas. 2022-03-26T09:09:33,001 INFO [00000005] :sas - SAS Object Spawner Daemon III has completed initialization. 2022-03-26T09:09:33,001 INFO [00000005] :sas - SAH021999I Server SAS Object Spawner Daemon III (8581), State, running     When validating the PoolerWorkSpace from the terminal with the sassrv user, it enters without problem.   Can you help me locate the problem, thank you very much. ... View more

Re: experience working odbc library for dbf sources

by Quartz | Level 8 in SAS Enterprise Guide
‎10-30-2021 09:27 AM
‎10-30-2021 09:27 AM
Good Morning. Thanks for the comments from him. What happens in this case. The client was working with a very old version of SAS, with the version of SAS Enterprise Guide they were using it was possible to export to this file.     When performing the new installation of SAS 9.4 M7, the SAS Enterprise Guide version does not have this format available within the Step Export.   We have offered the option to append the SAS Access to PC File component to the license, but due to budget issues, it is currently not possible to append the component.   Reading a little SAS documentation I found this information:   "Open database connectivity (ODBC) standards provide a common interface to a variety of databases, including AS / 400, dBASE, Microsoft Access, Oracle, Paradox, and Microsoft SQL Server databases"   In my case, I have never had the need to establish a library of this type of DBF file, so I see the need to consult the community. I did some tests in a non-productive environment, performing the following steps:   1. the driver download from the following link: https://www.microsoft.com/en-us/download/details.aspx?id=54920    2. configure the odbc at the operating system level     3. work with the library, using querys en guide.   4. I generate the dbf by query instead of an export     It is a solution that does not give the user total autonomy, since the user will need the data and the path established in the library configuration, but I understand this solution can solve the situation we are presenting. It's just generating two dbf's.   I would like your comments on what I am raising.   I understand that the correct solution is to append the SAS Access to PC Files component.   Thanks.   ... View more

experience working odbc library for dbf sources

by Quartz | Level 8 in SAS Enterprise Guide
‎10-29-2021 10:33 PM
‎10-29-2021 10:33 PM
Greetings community. I have a case where it is necessary to generate and read dbf files from SAS Enterprise Guide. Due to not having the SAS component Access to pc file licensed, I must look for an alternative. In the licensed components there is the SAS connect to odbc so I have thought about solving the situation by configuring a library of this type. I had not worked a similar case, whenever I have worked with dbf files I have used the proc export. I would like to know if any expert colleague from the community has worked on these files via odbc library. Thanks. ... View more

SAS Business Data Network

by Quartz | Level 8 in Administration and Deployment
‎10-15-2021 08:54 PM
‎10-15-2021 08:54 PM
Good evening.   Can I from SAS Business Data Network control structure changes made to a metadata column associated with a term?   Example: if you make a change in the structure, the tool will detect it and generate an alert.   Thank you. ... View more

Re: Integrate SAS ESP (Viya) with authentication via PAM

by Quartz | Level 8 in Administration and Deployment
‎10-07-2021 11:00 AM
‎10-07-2021 11:00 AM
Hello.   It is the host where I have SAS Viya installed.   This installation is a single machine.   Thanks. ... View more

Re: Integrate SAS ESP (Viya) with authentication via PAM

by Quartz | Level 8 in Administration and Deployment
‎10-06-2021 09:56 PM
‎10-06-2021 09:56 PM
Hi Alexal.   I work with TMoisés.   The pam.d directory. we do not have it available.     Should that directory be created?   Thanks. ... View more

Re: Install SAS Analytics Pro with Standard Plan (SAS AppDev Studio)

by Quartz | Level 8 in Administration and Deployment
‎10-03-2021 06:31 PM
‎10-03-2021 06:31 PM
Hi. In this case, the license is for a single machine and the client does not have client licenses. SAS users must connect to the server to use EG. They only make use of the SASUser library. But I have the doubt without installing with Plan or without Plan due to how the client works. Thanks. ... View more

Install SAS Analytics Pro with Standard Plan (SAS AppDev Studio)

by Quartz | Level 8 in Administration and Deployment
‎10-03-2021 08:44 AM
‎10-03-2021 08:44 AM
Good afternoon community.   I have the following question: Can I install SAS Analytics pro using the standard SAS AppDev Studio plan?   The components of the licenses are the following:   $_Stream=-------------------- BEGIN -------------------- Microsoft Windows Server for x64 Base SAS  SAS Analytics Pro  SAS Enterprise Guide  SAS Studio  SAS/ACCESS Interface to ODBC  SAS/GRAPH  SAS/STAT  $_Stream=--------------------- END ---------------------   The details of the plan are:   Thank you all for your support.   ... View more

Re: Problem accessing the web applications

by Quartz | Level 8 in Administration and Deployment
‎09-23-2021 11:16 AM
1 Like
‎09-23-2021 11:16 AM
1 Like
Hi.   The SAS Support department told me to follow the steps in this note:    64488 - Updating to Red Hat Enterprise Linux 6.x, 7.x, 8.x kernel 3.10.0-957.21.3.el7.x86_64 causes SAS® web applications to stop responding   After applying Workaround 1 the problem was solved.   Thanks. ... View more

Re: Problem accessing the web applications

by Quartz | Level 8 in Administration and Deployment
‎09-20-2021 03:19 PM
‎09-20-2021 03:19 PM
Buenas tardes. I send you the log of the metadata server. Thanks for the support. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-25-2023 10:43 PM
Likes given to
Likes from
Quick links