SAS Support Communities

MariaD · ‎09-23-2024

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,

MariaD · ‎06-26-2024

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,

MariaD · ‎06-24-2024

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,

MariaD · ‎05-14-2024

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,

MariaD · ‎03-08-2024

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)

MariaD · ‎03-08-2024

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.

MariaD · ‎03-08-2024

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?

MariaD · ‎03-08-2024

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;

MariaD · ‎01-22-2024

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,

MariaD · ‎12-04-2023

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,

MariaD · ‎10-18-2023

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,

MariaD · ‎10-17-2023

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,

MariaD · ‎08-25-2023

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,

MariaD · ‎08-24-2023

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,

MariaD · ‎08-24-2023

Thanks! Added the WORK as indicated and now works fine. Regards,

Online Status	Offline
Date Last Visited	‎09-23-2024 06:47 PM

SAS Support Communities

SAS Access to Postgres | Error

SAS Studio Login

SAS EG License - How it works

SAS Horizontal Web Cluster: disable or remove a cluster

Re: Access to BigQuery | Disconnect when execute query

Re: Access to BigQuery | Disconnect when execute query

Re: Access to BigQuery | Disconnect when execute query

Access to BigQuery | Disconnect when execute query

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

Access to BigQuery | Token

Re: SAS EG License - How it works

Re: SAS Web App Server unable to start

Re: SAS Web App Server unable to start

Re: Import XML file

Re: Integration with FICO Falcon

Unable to update SID on MetadataServer

Re: saspy - Execute SAS from Python

Re: Unable to update SID on MetadataServer

Re: SAS Web App Server unable to start

Re: ERROR: Expecting page, got page -1 instead

SAS Access to Postgres | Error

SAS Studio Login

SAS EG License - How it works

SAS Horizontal Web Cluster: disable or remove a cluster

Re: Access to BigQuery | Disconnect when execute query

Re: Access to BigQuery | Disconnect when execute query

Re: Access to BigQuery | Disconnect when execute query

Access to BigQuery | Disconnect when execute query

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

Access to BigQuery | Token

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

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

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

Error adding SAS Access to Big Query to existing installation

Re: saspy - Execute SAS from Python

Risk & Finance Analytics

Follow Us

What is...