saspert Tracker

Microsoft PowerBI Connection to SAS Libname

saspert — Wed, 20 Sep 2023 16:30:03 GMT

Hello,
I already reviewed the following threads:

Reading SAS Data in Microsoft Power BI (Help Please) - SAS Support Communities

The above thread seemed more appropriate to my scenario than below one.

Solved: Reading Sas datasets in PowerBI - SAS Support Communities

I was able to find 2 additional links that talk about a similar thing.

oledb - SAS OLE DB connection in Power BI - Stack Overflow

Solved: Connecting PowerBI to SAS server through OLEDB - Microsoft Fabric Community

I have tried many different permutations and combinations to get the correct connection string to OLE DB connection via PowerBI but not able to make it work. Appreciate any suggestions.

Re: SAS Studio login errors with Chrome/Edge

saspert — Wed, 05 Jan 2022 16:03:53 GMT

@SASKiwi My client still has this issue. Now the client's IT team might do away with IE completely (without giving us enough time to upgrade to the latest version of SAS 9.4M7). Any other ideas that I can try (besides checking the metadata logs)? I have attached a screenshot now.

Re: SAS Studio login errors with Chrome/Edge

saspert — Wed, 05 Jan 2022 16:00:58 GMT

@sandeeppajni2 I dont think the issue you mentioned and the issue I am talking about are the same. I am facing the same issue with both chrome/edge browsers.

Re: SAS Metadata Errors

saspert — Thu, 22 Jul 2021 09:20:47 GMT

@SSmanjunath Not a user setup issue. But thanks for offering a response.

Re: SAS Metadata Errors

saspert — Thu, 22 Jul 2021 09:19:59 GMT

@SASKiwi Yes. We did open a track with SAS Technical Support. They responded back with this article https://support.sas.com/kb/64/673.html. The other administrative issue is I am a contractor who joined the client recently. When I ran the Hotfix Report, I see a large number of hotfixes as not installed. I informed the same to the client. We are hoping that an upgrade to the newer version will mitigate the issue. In the interim, all I am doing is login to the SAS metadata server and restart the service.
We put in the keep_alive to fix some other SAS EG 7.1 issue. The actual location is - \<SASconfig>\LevN\SASMeta\MetadataServer\sasv9.cfg (doc is here -http://go.documentation.sas.com/doc/en/bicdc/9.4/biasag/n16001intelplatform00srvradm.htm#n16030intelplatform00srvradm). Thanks!

SAS Metadata Errors

saspert — Mon, 12 Jul 2021 09:43:41 GMT

Hello,

We have been experiencing occasional SAS metadata errors ever since we put in a KEEP_ALIVE setting.

The SAS documentation talks about trying different interval settings (example 30 seconds) in order to avoid the metadata errors. The problem is this solution is too subjective and not 100% effective either. Just wondering if anyone else has faced a similar issue and was able to resolve it.
We are currently running sas 9.4M4 on Windows NT Server 2012 R2. All the 3 tiers (metadata, compute, middle-tier) are on separate servers. SAS EG is 7.13 HF5.

Thanks in advance!

Re: SAS Global Forum 2021 SWAG!

saspert — Thu, 11 Feb 2021 12:05:09 GMT

Macbook. Lol.

Re: Cannot execute viewregistry utility

saspert — Mon, 04 Jan 2021 14:54:46 GMT

@AnandVyas Thanks for sharing the article. I navigate to the deploymentreg folder using CMD on the windows NT server and run the following command.

E:\>cd E:\SASHome\deploymntreg

E:\SASHome\deploymntreg>java -jar sas.tools.viewregistry.jar
'java' is not recognized as an internal or external command,
operable program or batch file.

Cannot execute viewregistry utility

saspert — Mon, 04 Jan 2021 13:18:26 GMT

Hello,

We have SAS9.4M4 on Windows NT 2012 servers. Midtier, compute and metadata are all on separate servers. I tried to look up the past hotfixes but cannot run viewregistry utility in the /deploymentreg/ folder (either manually or from command line). Any suggestions on how to fix this? I tried lookup for the Junit Jar file but not too sure if it is related or needed.

Thanks,

saspert

Re: SAS Studio login errors with Chrome/Edge

saspert — Mon, 04 Jan 2021 12:28:11 GMT

@SASKiwi Thank you for your inputs. Could you tell me if the internal SAS account (sassvcs) also need to have 'Logon as a batch job' privileges? I was told so at a previous engagement that both the users and the internal account need to have 'logon as a batch job' privilege.

I shared the middle-tier logs and object spawner logs with SAS support. We were able to identify atleast within the object spawner log the records for the error-

2020-MM-DDT08:21:20,536 INFO [01044752] : (USERID) - New client connection (98361) accepted from server port 8591 for SAS token user (USERID). Encryption level is Everything using encryption algorithm RC2. Peer IP address and port are [someipaddress]:someipaddress for APPNAME=Web Infra Platform Services 9.4 - SAS Studio Mid-Tier 3.6.
2020-MM-DDT08:21:20,536 ERROR [01044752] :(userid) - No host credentials exist to start this server. Either the client needs to send in host credentials, or credentials need to be specified for the server.
2020-MM-DDT08:21:20,536 INFO [01044752] :SYSTEM@myserver - Client connection 98361 for user USERID closed.
2020-MM-DDT08:21:20,536 INFO [00000009] :SYSTEM@myserver - Client connection 97113 for user USERID closed.

How do I check the metadata logs?

SAS Studio login errors with Chrome/Edge

saspert — Sun, 03 Jan 2021 12:09:55 GMT

Hello SAS folks,

A few customers at my client location are experiencing issues while logging into SAS Studio. The way it works is, if the user logs first into IE (after desktop bootup) and then Chrome/Edge, the experience is seamless. But if the user logs first into Chrome/Edge (after desktop bootup), then he gets this error:

"Connection Error to Workspace: Unable to connect to the current workspace server. Select a different workspace error. org.springframework.web.client. Http client error exception: 400 bad request."

and sometimes this error:

"Connection Error to Workspace: the native implementation for the security package could not be found in this path".

Even after logging using the correct sequence, the user is complaining of involuntary timeout sessions after 4-5 hours.

Troubleshooting done so far -

1. Clear the browser cache and reattempt to login to SAS Studio

2. Clear the browse cache, reboot desktop and reattempt to login to SAS Studio

3. Add registry entries for Chrome/Edge to delegate user authentication and authorize SPNEGO as per this SAS article

https://documentation.sas.com/?cdcId=bicdc&cdcVersion=9.4&docsetId=bimtag&docsetTarget=p1871e69gmwdr0n1o182krslc10p.htm&locale=en

4. Change settings for firefox browser as per the article mentioned in #3.

5. Uninstall chrome/edge and reinstall browsers

did not help.

These steps were also done in order to ensure metadata privileges were correct

6. User was added to 2 SAS Studio related groups (SAS Studio usage and SAS report consumer roles).

These steps were also done as mentioned in the article in #3.

7. Verify that there is a mapping already configured:

setspn -F -Q HTTP/hostname.example.com

8.Verify that Kerberos authentication succeeds. Use the kinit command that is provided in the SASHOME\SASPrivateJavaRuntimeEnvironment\9.4\jre\bin directory on Windows and in the /usr/bin directory on UNIX systems.

kinit -k —t keytab-filename-and-path.keytab 
  user-principal-name -J-Djava.security.krb5.conf=
path-to-Kerberos-file.conf

We opened a SAS support ticket but they kept going back to the link in #3.

i also tried to 1) restart object spawner and 2) clear spawner credentials cache using SAS MC but to no avail

I wanted to see if my client already installed hotfixes A4R004pt but the viewregistry file (in deploymentreg folder) will not run (for some reason) either from the command prompt or manually.

I ran the code (shared by @kalindpatel) from this thread https://communities.sas.com/t5/Administration-and-Deployment/Find-all-User-Accounts-with-an-Internal-Account-Defined/td-p/316867

but it did not return any internal services account (sassvcs@saspw). I only saw sastrust@saspw, webanon@saspw, sasadm@saspw,sasevs@saspw among others . I am scratching my head as to how the existing users were using SAS Studio previously.

The OS is Windows NT 2012 R2 Standard. Metadata, compute and midtier are on 3 separate servers. SAS is v9.4m3 and sas studio is v3.6.
When I peeked under the hood on the Windows servers,I did check for two things -

1. Which of the groups/accounts/users need to be allowed to 'log on as a batch user' privileges?

2. Which of the groups/accounts/users need to be listed in the Windows NT Users?

Could someone list the correct scheme for the above 2 questions regarding user privileges?

Re: Synchronize users between SAS Metadata and LDAP

saspert — Fri, 02 Oct 2020 16:24:23 GMT

1) Any update/resolution on this issue. From my past experience,

2) In the past, I found myself deleting SAS users manually in metadata who are no longer on the payroll. Would this fix automate this process?

3) What kind of backups do I need to do before trying this?

PS: Can we move this thread to SAS Administrators group from the programming group for more visibility ?

Thanks,

Re: Share Your Certification Story with Us

saspert — Sat, 11 Jul 2020 11:34:21 GMT

Hello SAS Folks! After 12+ years of experience as a SAS programmer, I took not having even a single certification as a personal challenge and an opportunity to grow. I took the old Base SAS Certification a few years back without any preparation and obviously failed it. Now after several weeks of preparation, I took both the foundation and Base SAS Performance exam and cleared both of them. Thank you to the SAS/Pearsonvue team to allow certification at home during this pandemic. Now I am working on the Advanced Performance test and borrowing a windows laptop since my macbook does not like the software that is used to run the new performance exams.

Re: sas connect remote submit test

saspert — Mon, 12 Mar 2018 17:16:46 GMT

http://support.sas.com/kb/36/029.html . Is that any helpful?

Re: Sas stored process output empty on SOAP html

saspert — Wed, 07 Mar 2018 22:40:42 GMT

Can you share your code and URL and other details?

Re: Case Study to indicate the importance of Credit Management in Financial Institutions

saspert — Wed, 07 Mar 2018 22:36:10 GMT

If you have SAS EG, it is quite easy to bring in your data from excel to sas using a wizard.

Re: Running Stored Process using VBA - Facing issues in passing prompt values

saspert — Wed, 07 Mar 2018 19:58:25 GMT

any errors/notes/warnings from the sas log? did you check this sample note out - http://support.sas.com/kb/42/983.html ?

there is a sugi paper too http://support.sas.com/resources/papers/proceedings11/012-2011.pdf

Re: join two dataset

saspert — Wed, 07 Mar 2018 19:11:37 GMT

proc sort data=p1;

by COW_ID PR;

run;

proc sort data=p2;

by COW_ID PR;

run;

proc sort data=p3;

by COW_ID PR;

run;

proc sort data=p4;

by COW_ID PR;

run;

data mrgall;

merge p1(in=a) p2(in=b) p3(in=c) p4 (in=d);

by COW_ID PR;

if a and b and c and d then output;

run;

Re: Connecting to Microsoft Azure HDInsights DataLake using SAS

saspert — Tue, 06 Mar 2018 17:32:43 GMT

this is the general programming community. you might find an answer in a different community.

Re: Delete LASR Table with Special Character

saspert — Tue, 06 Mar 2018 17:31:37 GMT

Try moving your post to the correct community. this is general programming stuff.