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: 
MariaD
‎09-23-2024
  • 483 Posts
  • 48 Likes Given
  • 20 Solutions
  • 55 Likes Received

SAS Access to Postgres | Error

by Barite | Level 11 in Administration and Deployment
‎09-23-2024 03:26 PM
‎09-23-2024 03:26 PM
Hi folks,    We have a SAS installed on Linux (9.4M7). Until last Friday we connected to postgres without any problem. After that, we received the following error:    CLI error trying to establish connection: FATAL: no pf_hba.conf entry for host x.x.x.x, user yyyy, database zzzz, no encryption.    We used other tools to connect to Postgres too, and on it the solution was add the following options on the connection string:   SSL=true SSLFACTORY= org.postgrsql.ssl.NonValidatingFactory   I tried to add it to the current connection but SSLFACTORY option was not recognized.   Our current connection string is:   proc sql;   connect to postgres (server=xxxx port=35432 database=xxx user=xxx password=xxx)   Any idea how to pass the SSLFACTORY option?   Regards,  ... View more

SAS Studio Login

by Barite | Level 11 in Administration and Deployment
‎06-26-2024 09:28 AM
‎06-26-2024 09:28 AM
Hi folks,    We have a SAS 9.4 M6 installed on a Linux server. Our users connect to MetadataServer through Active Directory. After, the user is validated on MetadataServer, they are associated to a group. Each group has a host user that is used to connect to workspace.    Having this login scenario, there is any problem to use SAS Studio? My understanding its the users needs to provide they Active Directory credentials on login page to logon on, and then, when they connect to workspace server to process, the host user for their group will be used. My understanding is correct?    Regards,  ... View more

SAS EG License - How it works

by Barite | Level 11 in SAS Enterprise Guide
‎06-24-2024 04:55 PM
‎06-24-2024 04:55 PM
Hi folks,    I have a doubt about how the SAS EG license works. We have a SAS Server (9.4) with XX cores licensed. In our setinit appears "SAS Enterprise Guide".   All our users execute exclusive on SAS Server (SASApp). There is any limitation for the number of SAS Enterprise Guide installed? Users use SAS Enterprise Guide exclusively to connect and run on the SAS Server (user interface).   Regards,  ... View more

SAS Horizontal Web Cluster: disable or remove a cluster

by Barite | Level 11 in Administration and Deployment
‎05-14-2024 07:08 AM
‎05-14-2024 07:08 AM
Hi folks,    We have 9.4 M6 installed on Linux server. We use a horizontal web cluster for the middle tier. We need to disable/remove two of the clusters. The main web cluster remains.    There is an easy way to disable or remove a web cluster?    Regards,  ... View more

Re: Access to BigQuery | Disconnect when execute query

by Barite | Level 11 in Administration and Deployment
‎03-08-2024 12:30 PM
‎03-08-2024 12:30 PM
I executed againg the query using the sastrace option. Follows the results: 024-03-08T14:06:39,961 INFO [00000009] :user - 27 options sastrace=',,,d' sastraceloc=saslog msglevel=i; 2024-03-08T14:06:39,961 INFO [00000009] : user - 28 2024-03-08T14:06:39,967 INFO [00000015] : user - 29 proc sql ; 2024-03-08T14:06:39,967 INFO [00000015] : user - 30 connect to bigquery as perm (project='aa-tedm-dtm' credfile='/files/access/bq/tedm-dtm.json' 2024-03-08T14:06:39,967 INFO [00000015] : user - 31 schema='aa-base-prd'); 2024-03-08T14:06:41,765 INFO [00000015] : user - 2024-03-08T14:06:41,766 INFO [00000015] : user - 32 Create table teste as 2024-03-08T14:06:41,766 INFO [00000015] : user - 33 select * from connection to perm 2024-03-08T14:06:41,766 INFO [00000015] : user - 34 (select * from aa-base-prd.analytics.table_2 ); 2024-03-08T14:06:42,412 INFO [00000015] : user - 0 1709917602 no_name 0 SQL (2) 2024-03-08T14:06:42,412 INFO [00000015] : user - SASGBQ_1: Prepared: on connection 0 1 1709917602 no_name 0 SQL (2) 2024-03-08T14:06:42,413 INFO [00000015] : user - select * from aa-base-prd.analytics.table_2 2 1709917602 no_name 0 SQL (2) 2024-03-08T14:06:42,413 INFO [00000015] : user - 3 1709917602 no_name 0 SQL (2) 2024-03-08T14:06:43,951 INFO [00000015] : user - 4 1709917603 no_name 0 SQL (2) 2024-03-08T14:06:43,951 INFO [00000015] : user - SASGBQ_2: Executed: on connection 0 5 1709917603 no_name 0 SQL (2) 2024-03-08T14:06:43,951 INFO [00000015] : user - Prepared statement SASGBQ_1 6 1709917603 no_name 0 SQL (2) 2024-03-08T14:06:43,951 INFO [00000015] : user - 7 1709917603 no_name 0 SQL (2) ... View more

Re: Access to BigQuery | Disconnect when execute query

by Barite | Level 11 in Administration and Deployment
‎03-08-2024 10:49 AM
‎03-08-2024 10:49 AM
Thanks, it’a because I access a project that it’s empty, it’s only for the connection (for billing purposes). After I connect in this first project, I need to access the table that is located in other project and schema. Do you know which Google permission the services account needs to query from SAS ? The user will not save anything in Google, only access the data. ... View more

Re: Access to BigQuery | Disconnect when execute query

by Barite | Level 11 in Administration and Deployment
‎03-08-2024 08:14 AM
‎03-08-2024 08:14 AM
So, I tríed to use libname instead of SQL pass-through but it’s not working for the structure inside GCP.    The user has access to a project id and once on it, he connect to other project id, schema and table. In SQL pass-through I can configure this type of access, defining the project  id and schema on the connection and then in the FROM I can use project_id2.schema2.table. There is any to use LIBNAME if I had this structure en GCP? ... View more

Access to BigQuery | Disconnect when execute query

by Barite | Level 11 in Administration and Deployment
‎03-08-2024 05:20 AM
‎03-08-2024 05:20 AM
Hi Folks,    We're recently installed a SAS Access to BigQuery on our Linux 9.4 M7 environment.    When we tried to execute the query below, the query executes (we verfied it on GCP) but instead of showing the results, the following error occurs. Any idea?   proc sql ; connect to bigquery as perm (project='xx-yyyy-mm' credfile='/aaaa/bq/access.json' schema='bb-yyyy-aa'); Create table teste as select * from connection to perm (select * from bb-yyyy-aa.schema.table_name ); ; quit;     ... View more

Add-in for Excel: Pivot table error when numeric variable has missing ...

by Barite | Level 11 in SAS Programming
‎01-22-2024 09:59 AM
‎01-22-2024 09:59 AM
Hi folks,    We have a table with 3M records on SAS. The table has numeric and character variables. Some of the records for the numeric variables are missing.    When tried to open the table, using Add-in, on Excel as PivotTable an error appear with messages about "Not is possible to define NumberFormat property from PivotField class". The pivot table loads but the link with SAS is disabled so I can't refresh the Pivot when SAS table is update.   I tried to use, options missing = 0; on a SAS program in Excel but the same erro occurs. Any idea?   Regards,  ... View more

Access to BigQuery | Token

by Barite | Level 11 in Administration and Deployment
‎12-04-2023 08:53 AM
‎12-04-2023 08:53 AM
Hi folks,    We're using SAS Access to BigQuery for the first time on our SAS 9.4M7 environment. As an authentication method, we use the service account. In this kind of connection, does SAS use any token to communicate with BQ, or token are used exclusively with OAuth authentication?   In case use a token, with a service account, where find information about the type of token used?    Regards,  ... View more

Re: Connect PowerBI with SAS: could not establish the connection to th...

by Barite | Level 11 in Administration and Deployment
‎10-18-2023 08:26 AM
‎10-18-2023 08:26 AM
Hi guys,    After some tries, we connected using PBI desktop but not PBI Gateway (personal mode). The string is the same, but in PBI gateway request again the credentials and timeout occur. We found this Microsoft note, but even when selecting anonymous authentication the error persists.    String:   provider=sas.IOMProvider.9.44;data source='iom-name://SASApp - Logical Workspace Server";sas cell cache size=10000;sas machine dns name=XXXXX;sas port=8591;sas protocol=2;sas server type=1;sas metadata user id=YYY;sas metadata password=ZZZZ;sas metatada location:RRRRRR:8561     Regards, ... View more

Connect PowerBI with SAS: could not establish the connection to the se...

by Barite | Level 11 in Administration and Deployment
‎10-17-2023 08:10 AM
‎10-17-2023 08:10 AM
Hi Guys,    We have SAS installed on Linux, 9.4M7 on a grid. We have some users that connected from PowerBI to SAS using OLE DB connection string for a while. Yesterday, without any change on the SAS server, the connection string started to fail to connect.    We tested the IOM Bridge connection using SAS Integration Technologie Wizard and the same error occurred.     We don't have any problem connecting using SAS EG. We tested in several users' machines with several logins and the same error appeared.   Any idea?   Regards,   ... View more

Re: Error adding SAS Access to Big Query to existing installation

by Barite | Level 11 in Administration and Deployment
‎08-25-2023 11:37 AM
‎08-25-2023 11:37 AM
Thanks @eddieleung305 . We finally found the error. I don't know why but after the installation the files sasauth, sasperm and elssr inside ..SASFoundation/utilities/bin changed from root owner to sas owner. So, we run the !SASROOT/utilities/bin/setuid.sh and now all it's working fine.    Regards,  ... View more

Error adding SAS Access to Big Query to existing installation

by Barite | Level 11 in Administration and Deployment
‎08-24-2023 10:01 AM
‎08-24-2023 10:01 AM
Hi Folks,    We have  SAS 9.4 M7 grid environment on Linux running. Recently we bought SAS Access to Big Query module. We tried to add it to our existing environment, but after installing it, SAS Metadata Server stopped working,    Basically, we installed first using the -nosasupdate parameter and selecting only SAS Access to Big Query. Even using it, the installation update/executes 230 steps. After the installation was completed, we started the SAS services. All services starting correctly but we can only connect on MetadataServer with sasadm@saspw account. If we use any other account, nothing happens, no messages in any log (even with trace enabled).    After the initial tentative, we restored the environment. The second time, we removed all the hotfixes available in the hot_fixes folder inside the depot. Again, we installed using -nosasupdate parameter and selecting only SAS Access to BQ. Now, the installation executes 109 steps. Again, everything finished ok and the SAS services started correctly but the same behavior occurred.    Now, we restored the environment. Any idea on how to proceed?    Regards,  ... View more

Re: saspy - Execute SAS from Python

by Barite | Level 11 in SAS Data Science
‎08-24-2023 09:48 AM
1 Like
‎08-24-2023 09:48 AM
1 Like
Thanks! Added the WORK as indicated and now works fine.    Regards,  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-23-2024 06:47 PM
Group Hubs for MariaD
View All
Likes given to
Likes from
Quick links