All Administration and Deployment posts

Re: SQL statements sent to unixODBC were coded?

masonluo — Tue, 11 Aug 2020 18:45:55 GMT

finally it seems to be encoding compatibility problem, the installation points !SASROOT/sas to bin/sas_u8, when we use bin/sas_en instead then there is no problem at all.

Ask the Expert webinar on top tips for SAS Viya administrators

ShelleySessoms — Tue, 11 Aug 2020 17:45:03 GMT

Join SAS' David Stern and learn:

What a SAS Viya administrator does
Which parts of SAS Viya administration are relevant to your role
How to use a checklist of SAS Viya administration tasks

August 27

11:00am ET

The webinar is free. Register for the live and on-demand links.

Re: SAS Viya 3.5 : Multi-tenancy

ShelleySessoms — Tue, 11 Aug 2020 17:32:09 GMT

This type of question is best answered by tech support: https://support.sas.com/en/technical-support/contact-sas.html

Best of luck to you,

Shelley

Re: SAS Studio is not displaying special characters

Ksharp — Tue, 11 Aug 2020 12:50:06 GMT

Your SAS 's encoding is UTF-8 ?
proc options option=encoding value;
run;

Re: Configuring SAS/ACCESS Interface to SAP R/3 to Use SNC

TBarker — Mon, 10 Aug 2020 21:04:01 GMT

We specify user ID & password.

Re: Configuring SAS/ACCESS Interface to SAP R/3 to Use SNC

SASKiwi — Mon, 10 Aug 2020 20:43:44 GMT

How do connect to your SAS metadata server from EG / SMC / DIS? Do you specify a user ID / Password or do you use IWA? If you use IWA, then I suggest you try a user ID and see if that helps. Using IWA causes delegation issues with external database connections unless you have Kerberos (or similar) configured correctly.

Configuring SAS/ACCESS Interface to SAP R/3 to Use SNC

TBarker — Mon, 10 Aug 2020 20:10:41 GMT

Hello SAS Admin Friends,

Do any of you have experience with configuring the SAS/ACCESS Interface to SAP R/3 to work with SNC (specifically: running SAS on UNIX, but ANY experience at all with this would be helpful)?

Our interface was working fine when we did NOT have SNC enabled in the SAP environment, but now we have moved to SNC and are struggling to get it working for SAS. We've been dealing with this since February and really need to get it working, as a) this has taken way too long and b) SNC just went live in our SAP production environment so now our SAS access to the SAP data is hosed.

Here's where we're at with it:

All other non-SAP environments have been successfully updated to work with SAP SNC, so we know the SAP configuration is correct.
With assistance from SAS Tech Support and a SAS dev, we have recently managed to successfully execute a libname statement and data step against our SNC-enabled SAP/BW QA server, but... only when directly logged onto the server and running the statements from the SAS program editor.
When we try to connect with a libname statement via the SAS desktop apps (EG, MC, DIS), we get errors.
The first error was basically that SAS couldn't locate the sapnwrfc.ini file, which at the suggestion of SAS Tech Support was resolved by placing a copy of the ini file in the startup path used by the desktop applications (which for some unknown annoying reason is not the same as that used by SAS on the server itself). The need for this duplication does not seem to be documented anywhere.
The current error is that now that SAS can locate the copy of the ini file, it still cannot acquire initiating credentials from the cred_v2 file (which we know is a valid and working file, because it works for SAS on the server).
The error is still on the SAS side of the interface, as our SAP environment shows no attempts at connection as it should (and as it does when we run the libname statement directly on the SAS server).
This is the current credentials error (server details snipped):
ERROR: RFC_COMMUNICATION_FAILURE

       LOCATION    CPIC (TCP/IP) on local host with Unicode

       ERROR       GSS-API(maj): No credentials were supplied

                   Could't acquire INITIATING credentials for

                   name="<snip>"

       TIME        Wed Aug 5 08:58:54 2020

       RELEASE     753

       COMPONENT   SNC (Secure Network Communication)

       VERSION     6RC          -4MODULE      /bas/753_REL/src/krn/snc/sncxxall.cLINE        1465DETAIL

       SncPAcquireCredSYSTEM CALL gss_acquire_credCOUNTER     6

If you have worked through this same issue, we'd love to hear from you as to how you resolved it. Thanks in advance!

Re: SAS Studio is not displaying special characters

Dharanendiran — Mon, 10 Aug 2020 14:56:14 GMT

Hello Kurt,
Hope you could figure out something here?!
Thanks in advance

Re: SAS Hot fix help

Anand_V — Mon, 10 Aug 2020 13:43:08 GMT

Deployment registry can help you figure out which components are installed on your SAS machines. If there are any dependent hot-fixes listed for products installed at your site, you should install them too.

Deployment registry has to be executed on all the machines as part of your environment.

Re: SAS Studio is not displaying special characters

alexal — Mon, 10 Aug 2020 12:55:19 GMT

As far as I know, there are no limitations. Also, I wasn't able to reproduce the problem on the Linux server, this is why I do recommend to contact Technical Support.

Re: SAS Studio is not displaying special characters

Dharanendiran — Mon, 10 Aug 2020 12:53:12 GMT

I agree, but is there any limitations with using these special characters in SAS Studio and not in EG?
Thank you

Re: SAS Studio is not displaying special characters

alexal — Mon, 10 Aug 2020 12:46:23 GMT

I would recommend creating a track with our Technical Support:

https://support.sas.com/ctx/supportform/createForm

Re: SAS Studio is not displaying special characters

Dharanendiran — Mon, 10 Aug 2020 12:42:25 GMT

We use windows server 2012 and the programs can be stored both locally and on NFS. It's up to the users.

Re: SAS Studio is not displaying special characters

alexal — Mon, 10 Aug 2020 12:31:16 GMT

I do not have version 3.71, however, I do not have such issues in version 3.8. I would like to learn more about your server, such as what kind of OS are you using? Where did you save the file? A local filesystem or NFS share?

Re: SAS Studio is not displaying special characters

Dharanendiran — Mon, 10 Aug 2020 12:23:38 GMT

SAS Studio 3.71 Enterprise Edition

Re: SAS Studio is not displaying special characters

alexal — Mon, 10 Aug 2020 12:21:08 GMT

What version of SAS Studio are you using?

SAS Studio is not displaying special characters

Dharanendiran — Mon, 10 Aug 2020 12:15:37 GMT

SAS studio is not displaying special characters like ©, ®, alpha, etc. used in programs after saving and re-opening them. The same special characters are shown properly in EG.
Could someone help me with this?

Re: SAS Viya CAS Worker nodes migration on AWS

alexal — Mon, 10 Aug 2020 11:56:53 GMT

Each target machine in your deployment must have a static IP address and hostname. There is constant communication among the CAS controller and the worker nodes, so you have to reduce delays in the communication as much as you can.

Re: SAS Hot fix help

sathya66 — Mon, 10 Aug 2020 11:48:49 GMT

Yes, I did and I ran SASHFADD.pl. When I was doing manual checks, I got to know about this.

do we need to install them?

especially with "If you install this hot fix and have SAS Data Loader Mid-Tier 3.1 installed, you must also install hot fix B3I004."

Re: SAS Hot fix help

Anand_V — Mon, 10 Aug 2020 11:17:56 GMT

Did you check the deployment registry report?
https://support.sas.com/kb/35/968.html

SAS Hot fix help

sathya66 — Mon, 10 Aug 2020 11:10:52 GMT

To install E4Y007 hotfix, we need to apply below hotfixes as well,

How can we know “SAS Data Loader Mid-Tier 3.1 installed” and “ SAS Threaded Kernel 9.4_M6 installed” on our machines?

proc product_status;

run;

proc setinit;

run;

above procedures didn’t help us. Please can you suggest how to check the them.

NOTE: If you install this hot fix you must also install hot fixes D9T039 and D9T084 for Base SAS 9.4_M6.
If you install this hot fix and have SAS Threaded Kernel 9.4_M6 installed, you must also install hot fix F8C003.
If you install this hot fix and have SAS Interface to Viya Model Publishing and Scoring 8.3 installed, you must also install hot fix F6M001.
If you install this hot fix and have SAS Data Loader Mid-Tier 3.1 installed, you must also install hot fix B3I004.

Thanks,

Re: Error in running Web Applications due to WIP Data Service which is not getting up

sandeeppajni1 — Mon, 10 Aug 2020 07:47:40 GMT

Hi All,

This is just to inform that the issue was resolved after repair/reset of pg_resetxlog in WIP Data Server. Below were the commands we ran after suggested by SAS Institute

B) First Approach "repair" with pg_resetxlog

pg_resetxlog can be found in : SASHOME/SASWebInfrastructurePlatformDataServer/9.4/bin/

Below to replace :

SASHOME = /sas/install/

SASCONFIG = /sas/config/Lev1/

export PATH=/sas/install/SASWebInfrastructurePlatformDataServer/9.4/bin:$PATH

export LD_LIBRARY_PATH=/sas/install/SASWebInfrastructurePlatformDataServer/9.4/lib:$LD_LIBRARY_PATH

/sas/install/SASWebInfrastructurePlatformDataServer/9.4/bin/pg_resetxlog /sas/config/Lev1/WebInfrastructurePlatformDataServer/data

### Note: If pg_resetxlog complains, you may be able to force it using the -f option:

/sas/install/SASWebInfrastructurePlatformDataServer/9.4/bin/pg_resetxlog -f /sas/config/Lev1/WebInfrastructurePlatformDataServer/data

/sas/config/Lev1/WebInfrastructurePlatformDataServer/webinfdsvrc.sh start

SAS Viya 3.5 : Multi-tenancy

anilawate — Mon, 10 Aug 2020 05:25:02 GMT

Hello,

For deployment of Viya 3.5 in multi-tenancy mode, the tenant onboarding got stuck for 2 or more services in the onboarding state

(a) tenant onboarding was successfully completed with any errors in the onboarding log.

(b) The error I see is "bootstrap error" for services stuck in their individual logs.

So, I proceeded for 2nd tenant onboarding to check if the same issue persists for it. But, 2nd tenant onboarded successfully without any error.

Has anyone came across a similar issue and resolved this would be a great help for their resolution.

Re: SQL statements sent to unixODBC were coded?

SASKiwi — Fri, 07 Aug 2020 23:05:10 GMT

Great. Unfortunately ODBC setup on Unix is way different than on Windows and always seems to be harder to troubleshoot.

Re: SQL statements sent to unixODBC were coded?

masonluo — Fri, 07 Aug 2020 22:37:56 GMT

Thanks SASKiwi. We did open a case to SAS tech support. Just wan to see if there is anyone has similar experience....

Re: SQL statements sent to unixODBC were coded?

SASKiwi — Fri, 07 Aug 2020 22:10:46 GMT

You would be best to open a track with SAS Tech Support if you haven't already as your setup isn't common.

SQL statements sent to unixODBC were coded?

masonluo — Fri, 07 Aug 2020 21:40:27 GMT

Hi everyone,

My name is Mason. I am a new admin for SAS, We just setup a SAS 9.4 on Linux server, we use unixODBC to connect to DB, the version 2.3.1 comes with RHEL7 didn’t work at all, so we downloaded and built unixODBC 2.3.7 on this server and modify LD_LIBARAY_PATH so sasodb will see it Eathan’s than the old 2.3.1, now we are able to connect to the ODBC data source which is a DB2 on AS/400. However when we started to run query, it won’t work at all. It prompted “token invalid”, but the SQL statement we entered was very simple and proved to be running well through query tool.

ERROR: CLI prepare error: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token was not valid. Valid tokens: ( CL END GET SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER BEGIN. : [IBM][System i Access ODBC Driver][DB2 for i5/OS]PWS0005 - Error
occurred in the database host server code.
SQL statement: SELECT * FROM TEST.QSRVSRC.

I checked with IBM support and we turned on ODBC trace to see what was fed to ODBC, it is strange that ODBC got a different meaningless string as SQL statement, which is for sure won’t be able to go through. Below is in ODBC trace log

ODBC][18654][1596812654.551234][SQLPrepareW.c][165]
Entry:
Statement = 0x7fea00000e60
SQL = [SLC RMUI00.N_PCNTSQFRRA NY][length = 54]
[ODBC][18654][1596812654.571800][SQLPrepareW.c][346]
Exit:[SQL_ERROR]
DIAG [42000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0104 - Token was not valid. Valid tokens: ( CL END GET SET CALL DROP FREE HOLD LOCK OPEN WITH ALTER BEGIN.
DIAG [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS]PWS0005 - Error occurred in the database host server code.

The SAS on PC(MS Windows) are working with the same DB (also through ODBC) without any problem.

Is there anything that can be configured wrong to cause this kind of issue? Any help is highly appreciated.

Re: VA 8.5 custom group

eabreu — Fri, 07 Aug 2020 12:31:04 GMT

Yes very helpful.
Thanks RickStyll_SAS!

Re: Acces a file server(hnas) behind a firewall from compute server - which port

andreas_lds — Fri, 07 Aug 2020 09:51:22 GMT

Interesting IT-department. If you say, that you need to access files via unc-path, they MUST know which port to open. It should be port 445.

Re: SAS EG server Build

andreas_lds — Fri, 07 Aug 2020 09:39:34 GMT

The hardware requirements depend on

number of concurrent sessions
the procedures used
size of the data

Without those information it is completely impossible to suggest something useful. And, btw. sas has experts that help you when designing a new system. Talking to sas is recommended, and contacting your sales/contracts person at sas is, of course, necessary, not optional.

Re: VA 8.5 custom group

RickStyll_SAS — Thu, 06 Aug 2020 23:42:56 GMT

Erik, the predefined groups for VA are Application Administrators, Data Builders, Esri Users, and SAS Administrators. You can find these predefined groups in the SAS Viya 3.5 Administration documentation here. I hope this helps.

Join SUGA for all things related to SAS admins

ShelleySessoms — Thu, 06 Aug 2020 18:11:20 GMT

SUGA (the SAS User Group for Administrators) has been around since 2016. It was unofficially part of this community, but it now has its own home right on SAS communities.

Go over to SUGA and click 'subscribe' under Options:

This group is where we'll discuss upcoming events and topic ideas. Speaking of events, have you registered for SUGA Live on September 23? You don't want to miss it!

SAS Viya CAS Worker nodes migration on AWS

nikhilreddy — Thu, 06 Aug 2020 17:40:17 GMT

We are planning to migrate our CAS Worker Nodes to larger instance, I have couple of questions

While spinning up new instance for cas worker nodes we will setup same hostname as before, do we also need to maintain same IP address or hostname should be good?
As of now all our servers – microservice, cas controller, worker1 and worker2 are on AWS cloud within same placement group and while migrating the cas worker to another instance family within the same placement group we don’t have the instance family we needed and facing capacity issue. So AWS is recommending to spin up the server outside of placement group.

How would be the impact if we spin up the cas workers away from placement group i.e away from cas controller and microservices ( controller and microservices are staying in same placement group). is that considerable ?

If we Spin up the workers outside of placement there would be some latency in communication when compared to servers within placement group but still we have the server. Not sure if we can go with this approach. Any suggestions would be helpful.

Thanks in advance,
Nikhil.

Registration open for SUGA Live, September 23

ShelleySessoms — Fri, 07 Aug 2020 16:51:16 GMT

If you've been around for a while, you know that SUGA (SAS User Group for Administrators) was created as a virtual user group. While we've had in-person meetings the past few years at SAS Global Forum, we've mostly held hour-long webinars for the past 4 years.

2020 is a bit different (to say the least). For the first time, we're having a 1/2 day virtual conference! It's free and open to everyone around the world. You'll get the chance to hear from SAS experts Margaret Crevar, Mark Schneider and Rob Collum. And it will truly be live, so you'll have the chance to ask these folks questions and chat with other attendees (text-based) during a break in the action.

I hope you'll join us on September 23, from noon to 4:00pm ET.

Registration is open!

Re: List of SAS Ports in Current Environment

SASKiwi — Wed, 05 Aug 2020 20:15:50 GMT

- I suggest you get a list of firewall rules that are applied to your SAS servers from your network guys. These will define the allowable traffic. If you really want to know where your SAS network traffic is going then using a network analysis tool is the only way.

VA 8.5 custom group

eabreu — Wed, 05 Aug 2020 17:28:16 GMT

Hi everyone,

I would like to know what the visual analytics 8.5 predefined custom groups are before it is actually install.

i've researched the following documents with no success:

https://documentation.sas.com/api/docsets/calauthmdl/3.5/content/calauthmdl.pdf?locale=en

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2130-2018.pdf

The idea is to know before hand what groups i'll have available and what those roles are and know if new groups will be needed or those will suffice my purpose.

I will appreciate your help.

Re: List of SAS Ports in Current Environment

Anand_V — Wed, 05 Aug 2020 14:26:10 GMT

Usually I don't see firewalls between server to server communication. For entry of user requests via SAS clients would be to metadata server default at 8561 and for web applications default at 8343.

In the instructions.html file you will find information only on the port used by particular server/service.

While the link I shared earlier do list the data direction for the default ports which can help you plan better.

Re: List of SAS Ports in Current Environment

David_paul — Wed, 05 Aug 2020 13:00:10 GMT

Thanks for reply.

One more question, how we can identified source and destination details of various ports defined in instruction.html?

Re: List of SAS Ports in Current Environment

Anand_V — Wed, 05 Aug 2020 02:52:01 GMT

AFAIK there is no OOTB script available to fetch this information. You can use the default list available in the install and config guide: https://documentation.sas.com/?docsetId=biig&docsetTarget=n02027intelplatform00install.htm&docsetVersion=9.4&locale=en#n02030intelplatform00install

If the ports at your site were customized during install and config then instructions.html is the best place to find this information.

Re: List of SAS Ports in Current Environment

SASKiwi — Wed, 05 Aug 2020 01:47:57 GMT

All recent SAS server builds I've been involved with have included a list of SAS-used ports as part of the design documentation. Was this not done in your case?

It would be worth asking SAS for a default port list for your particular design so you make sure nothing is missed.

Poking around in SAS Management Console for all defined port numbers would be a good starting point.

List of SAS Ports in Current Environment

David_paul — Wed, 05 Aug 2020 01:06:33 GMT

Dear All,

Could you please advise how to collect of list of ports which sas are using in current environment.

We are going to migrate the sas server into new location where we have to copy all the sas files/confg from old to new server.

If we have list of all the ports which are in old env than we are in position to send list of ports to network team to open in new env.

One simple method which I know, to get all these ports from instruction.html files but I need all the ports from source to destination details with ports. Is there any script to get all these details.

Re: How to change SAS installer account?

KurtBremser — Tue, 04 Aug 2020 16:30:49 GMT

Mind that the installer account is not used to run SAS software (with the exception of the metadata server and the web application infrastructure).

Workspace servers are run with the logged-in user's account, pooled servers (e.g. stored process servers) with sassrv. These are relevant security-wise.

Re: How to change SAS installer account?

KurtBremser — Tue, 04 Aug 2020 16:12:14 GMT

If your company requires this kind of (totally unnecessary, believe me) separation, you best run two separate servers.

Keep in mind that this would force you to have two installations in parallel, including the web application stack. How you keep those two running without interfering with each other (on Windows, to boot!), I have no idea.

Get some real IT people whose brains have not been burned through by prolonged exposure to crapware (Windows).

Re: How to change SAS installer account?

Dharanendiran — Tue, 04 Aug 2020 15:55:30 GMT

Thank you for your response Kurt.
I totally agree with you, but we require this change to comply with company IT policy.

Is there any work around possibly to do this?

Re: How to change SAS installer account?

KurtBremser — Tue, 04 Aug 2020 15:15:16 GMT

The SAS installer account is also used to start basic services, where it is often necessary to be the owner of certain files. Since the account was used during installation, this is guaranteed.

So, basically, one SAS installation -> one SAS installer account.

To separate between a test and prod environment, you do not need separate SAS installations (unless you also physically separate the SAS servers), but you use separate definitions of contexts in a single metadata environment.

Re: How to change SAS installer account?

Anand_V — Tue, 04 Aug 2020 14:44:22 GMT

Hi

I don’t think there is any documented approach to change the installer account. I would suggest you to check with SAS Technical support by emailing them to support@sas.com

How to change SAS installer account?

Dharanendiran — Tue, 04 Aug 2020 12:50:45 GMT

We have two SAS9.4M5 environments test and prod running on windows with same installer account sas-service.
Now we'd like to have two separate service accounts for test and prod called sas-servicetest and sas-serviceprod.
Could someone help me with the steps on changing the installer account?
TIA

Re: SAS Viya : Using Environment Manager, locate folder

Anand_V — Tue, 04 Aug 2020 04:57:41 GMT

You can try using SAS Admin CLI:

https://go.documentation.sas.com/?docsetId=calpromotion&docsetTarget=n0ihk3dsgoiqvtn15oce7kguif1s.htm&docsetVersion=3.5&locale=en#p15dq7dnzvnezhn15f56lk5fc14v

SAS Viya : Using Environment Manager, locate folder

johnfrytz — Tue, 04 Aug 2020 03:30:36 GMT

Hi,

I'm trying to import spk package from my /home/usrid folder or /data/package directory(linux) in SAS Environment Manager in Viya.

Is there another way of importing the package other than browse via your local machine (client)?

Currently the data file is in the server on the folders I've mentioned.
I'm trying to do a work around not having to download the file then importing it.

Thanks

Re: Error in running Web Applications due to WIP Data Service which is not getting up

Anand_V — Tue, 04 Aug 2020 01:44:02 GMT

Looks to be a case where the application services did not stop properly causing the DB transaction log to be corrupted. I would suggest to wait for advise from SAS Tech support on steps how to restore it.

Error in running Web Applications due to WIP Data Service which is not getting up

sandeeppajni1 — Mon, 03 Aug 2020 20:20:28 GMT

Hi,

We are using SAS 9.4M6 with having multiple tier architecture. We recently faced an issue where few of the services on compute nodes were not getting up automatically when we tried to start SAS Grid via sgmg.sh on those nodes. Later, it was figured out that the NTP services on the servers were not turned up after server patching activity was finished (Linux based servers), due to which the time on all the server was not matching. This happened in our Validation environment too. When the NTP services were turned on the VAL servers, we rebooted the SAS services and everything worked into VAL.

However, when we tried the same steps in Production environment (NTP turned on the PROD servers and then SAS services rebooted), though the spawner services were back on compute nodes but, the web services started showing problems as none of the web applications were accessible. Later on it was discovered that the WIP data service was not turning on. Although we did a complete reboot of SAS services, it did not help. We are receiving the below errors every time we go for WIP data services.

Any idea how to get rid of this issue? We have raised a call with SAS Institute on high priority, however, still waiting for their response. So, thought of getting ideas on the SAS community.

2020-08-03 06:35:12.376 UTCLOG: database system was interrupted; last known up at 2020-08-02 20:28:08 UTC

2020-08-03 06:35:20.907 UTCLOG: record with incorrect prev-link 4F94/740FE085 at 8C/CF9BD098

2020-08-03 06:35:20.907 UTCLOG: invalid primary checkpoint record

2020-08-03 06:35:20.908 UTCLOG: invalid xl_info in secondary checkpoint record

2020-08-03 06:35:20.908 UTCPANIC: could not locate a valid checkpoint record

2020-08-03 06:35:22.489 UTCLOG: startup process (PID 107579) was terminated by signal 6: Aborted

2020-08-03 06:35:22.489 UTCLOG: aborting startup due to startup process failure

2020-08-03 06:35:31.134 UTCLOG: incomplete startup packet

Re: Acces a file server(hnas) behind a firewall from compute server - which port

KurtBremser — Mon, 03 Aug 2020 17:51:35 GMT

wrote:

Hi,

I need to access files that are behind a firewall from my compute server(sasapp) which port do I need open to do this. IT dept is asking me which port to open, they won't open all the port, I browsed the documentation but didin't find anything on this.

Anybody have an idea ?

Thank!

Laurent

SAS uses the operating system to access files. It does not care if files are stored locally or on a network share.

The port(s) used to access a network share depends on the protocol being used (SMB, NFS, ...).

So you have to leave this to the system and network administrators, they will be able to determine which protocol is being used, and therefore what ports must be opened on the firewall.

I suggest you log on to the SAS server outside of SAS (via SSH) and determine from the commandline if the network share is accessible at all.

Re: Acces a file server(hnas) behind a firewall from compute server - which port

tlk — Mon, 03 Aug 2020 13:19:41 GMT

Kerberos is configured and the delegation on the file server is active. Stil I have I/O error when I attemp a Libname. So I return to the inital question which port SAS compute server(SASApp) uses to access a file server, I will have them open on the firewall.

Thanks!

Re: SAS EG server Build

KurtBremser — Sun, 02 Aug 2020 20:36:08 GMT

For #2: get a real operating system.

Re: SAS EG server Build

Anand_V — Sun, 02 Aug 2020 15:12:20 GMT

SAS EG is a client used to connect SAS installed on remote server machine or local. I assume you are planning to install SAS on a centralized server and let the users connect to it via the client. You will have to go for metadata based product stack in order for users to connect remotely.

If you are comfortable with SAS/Studio Basic is also a good option. Check more about SAS Studio deployments here

Hardware specs would base on how much the usage would be and its always best to take assistance from sizing offered by SAS. You can find the system requirements for installing on Windows platform here

SAS EG server Build

PrasannaKumar — Sun, 02 Aug 2020 13:42:28 GMT

Dear folks,

I want to build a SAS EG Server for 20 Clients can any one give suggestions in this.

1)Hardware requirement

2) Software requirement in windows platform.

Re: July 31: Happy Systems Administrators Appreciation Day

MichelleHomes — Sun, 02 Aug 2020 05:39:15 GMT

I hope SAS administrators and architects were recognized on #SysAdminDay and every other day too!

Thanks Shelley for sharing this practical collection of resources and announcing SAS Live virtual event! While it was a shame we're unable to meet in person on that date, it's fabulous the SUGA event is still going ahead. I can't wait and look forward to attending live at 2am local time in Australia 🙂

Cheers,

Michelle

Re: Log and config file

gwootton — Fri, 31 Jul 2020 15:52:52 GMT

Yes, Process Manager's log is in the Process Manager installation directory, e.g. C:\Program Files\IBM\IBM Spectrum LSF Process Manager\log.

Re: Log and config file

senu188 — Fri, 31 Jul 2020 15:09:02 GMT

Hi,

ok . so you are saying LSF log and JFD log is different ?

Re: Log and config file

gwootton — Fri, 31 Jul 2020 15:00:13 GMT

That's correct, note that for Windows the installation path (D:\LSF_9.1) is not shared so the log files are on each grid node.

Re: dataset corrupt

senu188 — Fri, 31 Jul 2020 14:56:39 GMT

Hi,

We got RFC error while pulling the data. After Rectification we ran it. But when user tried it from another program for reading the data, it was corrupted. so when user approcahed regarding this we deleted the corrupt file and rerun it was ok

Re: Log and config file

senu188 — Fri, 31 Jul 2020 14:52:21 GMT

Hi,

please correct if i am wrong . I found the logs and confir file following path
EGO Config : J:\SAS_App\SAS94m3\LSFShare\conf\ego\cluster1\kernel\ego.config
LSF config : J:\SAS_App\SAS94m3\LSFShare\conf\lsf.config
logs : D:\LSF_9.1\log\ . ( All logs like vemkd.log,res.log,sbatchd.log etc ) is there

Re: Log and config file

gwootton — Fri, 31 Jul 2020 14:32:42 GMT

Are you asking where these are located?

Typically the log files are in LSF_TOP/log on Linux, and C:\LSFX.y\log on Windows.
The lsf.conf file is in LSF_TOP/conf and ego.conf is in LSF_TOP/conf/ego/sas_cluster/kernel/, in Windows these would be in your shared configuration directory in those paths.

Log and config file

senu188 — Fri, 31 Jul 2020 14:25:37 GMT

Hi,

Can anyone help on the following the config and logs?

1) lsf logs and the ego logs.

2) lsf.conf file and the ego configuration file

Thanks & Regards

R. Sankar srinivasan

Re: SAS Studio processes not terminating

Nigel_Pain — Fri, 31 Jul 2020 14:20:24 GMT

Sounds interesting, I'll have to take a look when I have a moment.

Thanks so much for the suggestions.

Re: SAS Studio processes not terminating

gwootton — Fri, 31 Jul 2020 13:52:17 GMT

You might be interested in taking a look at this paper on the subject: https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2020/4764-2020.pdf
While it is geared towards a grid deployment, the program that reports on idle time by user might be helpful to address this with the users directly.

Re: SAS server with oracle interface

alexal — Fri, 31 Jul 2020 12:01:54 GMT

Please see the chapter "SAS/ACCESS Interface to Oracle" in the document below. Make sure you have set all of the environment variables:

https://support.sas.com/documentation/installcenter/en/ikfdtnunxcg/66380/PDF/default/config.pdf

SAS server with oracle interface

Ashee — Fri, 31 Jul 2020 11:49:00 GMT

Hi ,

I have got a error to connect oracle data base .

ERROR: ORACLE connection error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.

ERROR: Error in the LIBNAME statement

I am very new to SAS administration .So any one guide me how to resolve this error.

I need some knowledge how oracle database and SAS is connected .

Thanks ,

Ashee

Re: SAS Studio processes not terminating

Nigel_Pain — Fri, 31 Jul 2020 08:46:30 GMT

I'm still reluctant to implement something like that. I can't be absolutely sure but I think there are users who will run things, go and do something else, and then come back and expect the contents of their WORK library still to be there. Although I suppose I could just make the change and then sit back and see how many yells of anguish I get!

Thanks for your suggestions anyway

Re: SAS E miner projects list in a phyisical folder

KurtBremser — Thu, 30 Jul 2020 13:59:10 GMT

In order to scan a physical folder, you have to know the complete path to it. That is essential.

Once you know that, has a very nice method to traverse a whole directory tree in a single data step.

Re: SAS E miner projects list in a phyisical folder

sathya66 — Thu, 30 Jul 2020 13:46:58 GMT

Thanks for this,
Table has 0 records.
I think it is not checking the sub folders and also I need path for the "project.emp"

Re: dataset corrupt

KurtBremser — Thu, 30 Jul 2020 13:33:33 GMT

While a dataset is being written to, it is locked for any other access.

Re: SAS E miner projects list in a phyisical folder

KurtBremser — Thu, 30 Jul 2020 13:32:11 GMT

If your miner projects storage location is on the SAS server, you can use data step functions to retrieve your filenames:

data projectfiles;
length fref $8 pname $200;
did = filename(fref,"path_to_your_project_files");
did = dopen(fref);
if did
then do;
  do i = 1 to dnum(did);
    pname = dread(did,i);
    if scan(pname,-1,'.') = 'emp' then output;
  end;
  did = dclose(did);
end;
did = filename(fref);
run;

dataset corrupt

senu188 — Thu, 30 Jul 2020 13:29:00 GMT

Hi,

We are using IBM flow manger 9.1.3.0. We build the sas dataset with help on help SAP extract. After building SAS dataset, while running another program for pulling the particular dataset, it said the dataset is damaged. can i know what will be reason? i deleted the dataset and reran the program it is ok now.

SAS E miner projects list in a phyisical folder

sathya66 — Thu, 30 Jul 2020 13:22:54 GMT

Hi,

is there any way we can get the SAS E miner projects list from a Physical folder.

ex:if we use %mdsecgo, membertypes="MiningProject" then it will give all miner projects in metadata. but I am looking for Physical E miner projects list.

Thanks,

Re: SAS Studio processes not terminating

gwootton — Wed, 29 Jul 2020 13:55:07 GMT

Users who are not doing anything with their SAS session would have the session terminated. When they try to execute code, SAS Studio will try to start a new session. In my testing to confirm I logged in to SAS Studio which started two Workspace Server sessions. I terminated these with PROC IOMOPERATE's stop spawned server command and then tried to execute code and got a response. When I checked the spawned servers, two more had been started.

Re: Acces a file server(hnas) behind a firewall from compute server - which port

tlk — Wed, 29 Jul 2020 12:56:58 GMT

Thanks, That's exactly what I want to achieve, I want to acces via unc path. This morning I asked to add the file server to the delegation. Kerberos is already configured to acces other file servers that are not behind that firewall.

Re: SAS Studio processes not terminating

Nigel_Pain — Wed, 29 Jul 2020 08:30:53 GMT

Thanks . How would these settings affect people who are signed in but just not doing anything? A lot of our users start up SAS at the beginning of the day and just leave it idle for most of the time. I'd rather not have them being kicked out

Re: Acces a file server(hnas) behind a firewall from compute server - which port

SASKiwi — Tue, 28 Jul 2020 21:12:04 GMT

If you want to refer to your remote file server with a UNC path like \\MyFileServer\MyFileServerFolder1\MyFileServerFolder2 then you may need to configure Kerberos settings. This is something your IT department and / or SAS administrator should be familiar with.

Re: Does SAS office plugin gets impacted with MS office upgrade?

SASKiwi — Tue, 28 Jul 2020 21:00:29 GMT

I would say a lot depends on what version of the SAS Add-In for Microsoft Office you have. Recent versions like 7.x and 8.x are likely to be OK. However if you are switching from 32-bit to 64-bit MS Office you will definitely need to reinstall.

Does SAS office plugin gets impacted with MS office upgrade?

RupaJ — Tue, 28 Jul 2020 20:10:28 GMT

Hello,

We are planning to upgrade our MS office from 2013 to 2019. Would SAS plugin be impacted in any way? Should I uninstall and reinstall the SAS plugin too?

Thanks

Re: The launch of the server process failed because of a SAS kernel initialization failure

rabindrakumar1 — Tue, 28 Jul 2020 17:53:48 GMT

Hi Juan,

Thanks for the inputs, indded I should have validated this way as well. I found the bug, the entry inside this file /opt/sas/config/compute/Lev1/SASApp2/sasv9_usermods.cfg was incorrectly defined
-MSGLEVEL = I6

It should be

-MSGLEVEL = I

Re: The launch of the server process failed because of a SAS kernel initialization failure

alexal — Tue, 28 Jul 2020 17:34:38 GMT

Are you sure you can invoke the workspace server without problems? Run the following command in the Linux console:

/opt/sas/config/compute/Lev1/SASApp2/WorkspaceServer/WorkspaceServer.sh -nodms

Re: The launch of the server process failed because of a SAS kernel initialization failure

JuanS_OCS — Tue, 28 Jul 2020 17:33:53 GMT

Hi ,

I would ensure the permissions for some folders such as work and logs are set up correctly, for the users.

Have you tried to run /opt/sas/config/compute/Lev1/SASApp2/WorkspaceServer/WorkspaceServer.sh -nodms to check if this SAS session shows any oter more specific error?

Let us know, good luck

Best regards,

Juan

The launch of the server process failed because of a SAS kernel initialization failure

rabindrakumar1 — Tue, 28 Jul 2020 17:28:55 GMT

Hi,

When I am trying to validate the workspace sever from SMC, I am getting the below error:

The launch of the server process failed because of a SAS kernel initialization failure.

SEVERE: The launch of the server process failed because of a SAS kernel initialization failure.

I have done a diff between the correctly working SASApp1 and SASApp2, there is no difference in the files underlying in this path

"/opt/sas/config/compute/Lev1/SASApp1/" and "/opt/sas/config/compute/Lev1/SASApp2/"

The differneces are logical where it needs to have the server names are also correct. I have refresh the Object Swapner using Refersh of Application servers as well.

These basic troubleshooting didn't fix the issue.

Please help me to fix this issue.

Re: Acces a file server(hnas) behind a firewall from compute server - which port

alexal — Tue, 28 Jul 2020 17:00:30 GMT

It doesn't really matter what OS you are on. Either way, you have to mount the NFS disk on the compute server.

Re: Acces a file server(hnas) behind a firewall from compute server - which port

tlk — Tue, 28 Jul 2020 16:52:29 GMT

Thanks, I will look at it with IT dept, I have to mention that my compute server(SASApp) is on Windows.

Thanks, I will keep you posted

Re: Acces a file server(hnas) behind a firewall from compute server - which port

alexal — Tue, 28 Jul 2020 15:47:48 GMT

I assume you will be accessing those files via NFS? If yes, then read the following NFS security guide: http://tldp.org/HOWTO/NFS-HOWTO/security.html. Your Linux administrator can help you with that.

Acces a file server(hnas) behind a firewall from compute server - which port

tlk — Tue, 28 Jul 2020 15:30:17 GMT

Hi,

I need to access files that are behind a firewall from my compute server(sasapp) which port do I need open to do this. IT dept is asking me which port to open, they won't open all the port, I browsed the documentation but didin't find anything on this.

Anybody have an idea ?

Thank!

Laurent

Re: SAS Studio processes not terminating

gwootton — Tue, 28 Jul 2020 13:45:24 GMT

In SAS Management Console's Server Manager plug-in, under the properties for the Workspace Server's Options tab is an Advanced Options button. It has a Launch Properties tab with an "Inactive client timeout" setting. This will trigger the Object Spawner to terminate a Workspace Server session that has been idle (not running code) for that many minutes.

SAS Studio also has a session timeout setting:

https://go.documentation.sas.com/?docsetId=webeditorag&docsetTarget=n09papwvwhx611n1kfzggdyze5ag.htm&docsetVersion=3.6&locale=en

Re: How to I create a custom Identity-Based Substitution Variable in SAS Viya

gwootton — Tue, 28 Jul 2020 13:37:34 GMT

The only identity values available are SAS.IdentityGroups and SAS.Userid, so your table would need to include one of these values for row-level security. So if the table includes StateCd as your filtering value you would need a group for each StateCd, and grant memberships to those groups accordingly, then use SAS.IdentityGroups as the filter.

SAS Studio processes not terminating

Nigel_Pain — Tue, 28 Jul 2020 11:57:04 GMT

SAS 9.4M5 on Windows Server 2012R2, client access via EG 7.15 or SAS Studio 3.71 (mid-tier)

I've recently noticed old SAS processes remaining on our compute server and realised that this coincided with more people using SAS Studio. A bit of experimentation has got me thinking that this is because when users finish their sessions they are simply closing their browser session rather than logging off.

I can distribute a message asking people to remember to log off but chances are this will only be partly effective. Is there a way to ensure that these processes are terminated? I suppose I could run a daily search for SAS processes from earlier than the current day but that has the potential to kill bona fide long-running processes.

Re: How to increase limit of rows in list table on SAS Viya

alexal — Tue, 28 Jul 2020 11:04:24 GMT

Please see SAS Usage Note 62148: High cardinality thresholds in SAS® Visual Analytics 8.x.

How to increase limit of rows in list table on SAS Viya

sbhowmick — Tue, 28 Jul 2020 06:17:27 GMT

Hi folks,

I need one help regarding how to increase the limit of rows in the list table on SAS Viya?

July 31: Happy Systems Administrators Appreciation Day

ShelleySessoms — Fri, 31 Jul 2020 12:52:15 GMT

You’re the backbone of your organization, the ones who fix it all, are always on call and there to save (or start) the day! You’re appreciated more than you know, and we can't thank you enough. To celebrate Admins on this day, we’ve compiled a bunch of our free SAS Admin resources, and included a couple of extra limited-time offers:

Get the latest hot fixes, downloads, security bulletins & more on the SAS Administrators Customer Support page
Join the SAS Administration Community for quick answers to questions and ongoing support from like-minded individuals and SAS experts.
Check out the 2020 SAS Global Forum Administrator sessions on the SAS Users YouTube channel that cover topics like architecture, deployment, security and cloud.

Watch one of these Ask the Expert webinars:

What does it mean to administer SAS Visual Analytics?

What are the top 10 tips for a SAS Viya Administrator?

Stay informed on the best way to manage SAS programs and installations with the SAS Administrators blog.
Learn new skills with this free training course: SAS Platform Administration: Getting Started

Get 30 days free access to SAS Learning Subscription where you’ll find beginner- to advanced-level elearning courses.
On the path to certification? Check out several exam prep resources!
A Day in the Life of the SAS Platform Administrator (blog post)
Report Center: SAS SysAdmin’s secret weapon (blog post)

Limited time promotion for certification

Ready to get certified? Take 31% off the SAS Platform Administrator exam using code: SASADMIN31 from July 31 through August 31, 2020. You’ll be able to take the exam virtually with online proctoring.

Upcoming Virtual Event

SUGA Live

Presented by SAS and Metacoda

Wednesday, Sept 23 | Noon – 4 p.m. ET

Join your fellow administrators and hear from experts in SAS administration and analytics. With three expert presentations and an Ask Me Anything discussion it will be a ½ day full of learning.

Agenda

12:00 – 12:10 p.m.	Kickoff Shelley Sessoms, SUGA Chairperson and SAS Community Manager
12:10 – 12:15 p.m.	A Message from our sponsor – Metacoda
12:15 – 1:00 p.m.	Important Performance Considerations When Moving SAS to a Public Cloud Margaret Crevar, Senior Manager, Software Development
1:00 – 1:45 p.m.	Migrating from SAS 9.4 to SAS® Viya® 3.5 Mark Schneider, Advisory Product Manager
1:45 – 2:00 p.m.	Break
2:00 – 2:45 p.m.	Deployment Patterns for SAS Viya Rob Collum, Principal Technical Architect
2:45 – 3:30 p.m.	Ask Me Anything: Bring your administration questions, and our SAS experts will answer them
3:30 – 3:45 p.m.	Conclusion

Register now to join us!

How to I create a custom Identity-Based Substitution Variable in SAS Viya

sb_sas — Mon, 27 Jul 2020 15:00:46 GMT

Hello, I am new to SAS as well as SAS Viya. I am in the process of trying to add row-level security for a group of users. (SAS Viya

Scenario:

I have 50 different users within a group, and this group has access to a caslib that consists of 50 tables (within db).

I am trying to take advantage of the substitution variables within SAS, however, I need a variable called state_cd. (each user has access to 1 to many state_cds)

Question: Is it possible to create a metadata table with the needed data and utilize it to create a dynamic Identity Based Substitution filter?

Similar to this:

FacilityRegion In ('SUB::SAS.IdentityGroups')

(but instead of SAS.IdentityGroups, change it to METADATA_TBL.StateCd)

Below is a link to the sas documentation.

https://go.documentation.sas.com/?cdcId=calcdc&cdcVersion=3.4&docsetId=calauthzcas&docsetTarget=n1bf0cwn6ae85gn1b64x2j0czu24.htm&locale=en#p0typu0legb624n139nqaw1p19pt

Re: Provisioning SAS GRID on AWS

prashantprash17 — Sun, 26 Jul 2020 03:08:06 GMT

Thanks MargaretC, I will flag this to business.

But to proceed with ZFS using Quick start is now the challenge I am facing.

If it's not the quick start then how can I proceed.

Re: SAS AML 7.1 User login problem

Anand_V — Sat, 25 Jul 2020 15:16:06 GMT

What does the workspace server log say when this issue is reported?

Re: SAS AML 7.1 User login problem

kranthi214 — Sat, 25 Jul 2020 15:02:31 GMT

Hi ,

Thanks for your revert. User is created properly. No issues in it.

The problem over here was it works fine for 2-3 weeks and the user faces the problem again. We are recreating the user everytime whenever the problem is reported. Moreover it is happening only for couple of users regularly.

Re: SAS AML 7.1 User login problem

Anand_V — Sat, 25 Jul 2020 14:57:14 GMT

If the issue is resolved after recreating the user in SMC, its probably the initial user wasn't created right.