Administration and Deployment topics

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.

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!

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?

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,

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.

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.

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!

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.

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.

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

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

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

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.

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

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

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,

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

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.

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

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.

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

SAS AML 7.1 User login problem

kranthi214 — Sat, 25 Jul 2020 13:02:02 GMT

Dear Team,

We have encountered a strange issue in SAS AML 7.1 environment.

Whenever a user login into the application the details are displaying of another user.

Whenever the user claims the alert from triage or any action taken, it is going into another user queue.

When we recreate the user through SAS Management console issue will get resolved.

Does anyone encountered such issues? Have reported to global SAS support team however not received supportive solution for it and going into a loop.

SAS AML 7.1 logging details information

kranthi214 — Thu, 23 Jul 2020 16:04:51 GMT

Hi Team,

We are using SAS AML 7.1 in our organization and i am new to this product. Need an expert help on the below query.

We are looking for some audit events in a real time manner or through a batch such as whenever a user/group/role added/deleted/modified in the SAS management console and login and logout time of the user.

Can you please let me know is there any way to get the information?

When we check in Metadata server logs we are getting a basic information of login and logout events.

/sas/SASConfig/Lev1/SASMeta/MetadataServer/Logs

Regards,

Kranthi

Is it possible to limit xcmd to certain users?

gothaggis — Thu, 23 Jul 2020 15:13:27 GMT

I'm running SAS Studio on Linux - is it possible to turn on xcmd only for certain users instead of system-wide? If so, how is that done?

Happy #SysAdminDay and Happy #SASAdminDay!

MichelleHomes — Thu, 23 Jul 2020 07:09:47 GMT

Hi everyone!

July 31 is recognized as System Administrators Appreciation Day and our Metacoda koalas are so grateful to SAS administrators around the world that they reckon we should add SAS Admins to SysAdminDay.

Wishing you a very ‘Happy #SysAdminDay’ AND ‘Happy #SASAdminDay’!

Recognizing your SAS Admin on #SysAdminDay!

Kind Regards,

Michelle

Enabling SAS Environment Manager Architecture Framework

RupaJ — Tue, 21 Jul 2020 18:36:54 GMT

Hello,

I am trying to enable the SAS Environment Manager Architecture Framework and running the first step and getting errors. I tried the steps in the link https://support.sas.com/kb/59/970.html and still get the same error. Any direction here pls?

./validate.sh --level 2
Service Architecture Validation - Tue Jul 21 13:18:25 CDT 2020
Starting level 1 validation...
Level 1 validation completed with 0 error(s)
Starting extended level 2 validation (this could take a while)...

Service Architecture validation completed with 1 error(s)
Errors:
1) The SAS Environment Manager Server is unable to process additional tasks at this time. This may be due to high change request volume. If the server has recently been (re)started, it may be synchronizing with its Agents. This process could take up to an hour.
Please try again at a later time to validate your environment.

We are on SAS 9.4 M5. And SAS EVM version is 2.5 M2

Thanks

The SAS/Access interface to oracle cannot be loaded. ERROR

Mastanvali — Tue, 21 Jul 2020 11:39:19 GMT

Hi Team,

Few are able to access and few or not able to access. While trying to connect to db by using SAS

SAS Viya Installation on Windows server

shrikantpwc — Tue, 21 Jul 2020 06:24:32 GMT

Hi,

I am trying to install SAS Viya 3.5 on Windows 2012 R2 standalone server for learning purpose. As it is a standalone server (Not required any network authentication) How can I perform installation without configuring kerberos. I did the LDAP configuration using Apache DS.

Requesting help.

Thanks and Regards,

Shrikant Suvarnkar

How to switch port of existing SAS Metadata server to new port 8563 or something else

Asif4862 — Tue, 21 Jul 2020 14:27:31 GMT

Hello All, This is Asif

Background:

1) In a parallel install situation Lev1 and Lev2 of two different SAS software stack

2) We've successfully deployed Lev1 (SAS Metadata port 8561) and Lev2 (SAS Metadata port 8562) on the same server

3) Now we want to switch Lev1 SAS Metadata port from existing 8561 to 8563 or 8564

What is the best way to change only port number of Lev1 SAS Metadata server?

Thank you in advance

Thanks,
Asif

Publishing functionality in SAS Viya 3.5

sounak93 — Mon, 20 Jul 2020 07:27:00 GMT

Hi All

I am using SAS Intelligent Decisioning 5.4. I want to disable the option to publish Decision flows for a group of users, which rule should it be that I need to exclude for this group of users.

I checked the following link but didnot find related rule.

https://go.documentation.sas.com/?cdcId=calcdc&cdcVersion=3.5&docsetId=calatf&docsetTarget=n0o6xx292jn2jmn1pnj3s3oqcebw.htm&locale=en

thanks

Sounak

Provisioning SAS GRID on AWS

prashantprash17 — Fri, 17 Jul 2020 11:26:30 GMT

Greetings to Everyone!

I have been assigned a task to provision SAS grid configuration on AWS.

Can someone please help me on Pre-requisites and implication plans?

Adobe Flash reminder

ShelleySessoms — Thu, 16 Jul 2020 17:58:17 GMT

Reminder: Some of your SAS products may be affected by the End-of-Life of Adobe Flash Player. More information can be found in this Adobe Flash EOL statement. Please contact your SAS Account Executive if you have questions.

SAS Distributed In-Process services Scheduling - update the scheduler account

njnar — Thu, 16 Jul 2020 03:53:29 GMT

Hi I'm using SAS 9.04.01M6P111518.

I'm using "SAS Distributed In-Process services Scheduling" to schedule my reporting jobs.

I used a service account to schedule my jobs. But I see jobs are getting triggered with "Administrator" id.

I want to use service account because Administrator doesn't have access to all datasets.

How can I force scheduler to use this service account?

Task registered without some trigger

njnar — Thu, 16 Jul 2020 03:40:28 GMT

Hi,

Recently we have migrated to a new SAS sever 9.04.01M6P111518.

I'm using SAS Management console to schedule jobs on this server. I picked "Operating System Services" from drop down list to schedule my job in OS scheduler.

I see my jobs are listed under OS scheduler task list. I can trigger them manually. But those are not getting triggered on schedule.

Here I have attached images of my task scheduler and warning message that it shows.

Please let me know if anyone faced this issue or has any suggestion.

Thanks in advance

How do others maintain their DR SAS environment?

matthewmeserve — Wed, 15 Jul 2020 23:06:26 GMT

We have a SAS deployment at our DR site. It is not licensed since it's only use is in the event of a disaster. I'm told by SAS that, once a disaster occurs, they will issue a temporary license for the environment so it may be used until production is back up. My question is, how do others manage the installation of hotfixes/updates to their DR environments without, at least, a temporary license so that SAS could be launched and tested briefly post hotfix installation? Are others simply leveraging the built in OQ/IQ utilities and calling it good?

Curious to know.

Thanks!

SAS Authentication using PAM_LDAP

Madhan_cog1 — Wed, 15 Jul 2020 10:07:54 GMT

Hi All,

We have installed and configured SAS 9.4 M5 Grid version in Linux Environment.

So far we have used PAM Authentication and its working fine.

As part of RFC 2307 implememtation we had to use the LDAP authentication and after SAS is not able to connect Application Server. It is not able to authenticate the user.

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

As per the above link

The sas-services-daemon utility does not directly support LDAP. If LDAP is a
requirement, SAS recommends that you use the PAM LDAP module.

Could you please suggest the way to configure the PAM LDAP Module.

Thanks,

Madhan M

Ambari Credentials

titan31 — Wed, 15 Jul 2020 07:58:46 GMT

Hi,

Systems team were on to me there and the Apache Ambari environment still has default credentials enabled in our environment. We think it was installed as a component of HDFS/Hadoop (distributed VA) but unsure what it's used for.

Anyone know what Ambari is used for in SAS and if we changed the default credentials, do we need to update any config files anywhere to keep it working?

Thanks

Need help with CASLIB and permissions

epower — Tue, 14 Jul 2020 21:26:21 GMT

We have a new SAS Viya environment and when defining a connection I am getting PERM_DIR_CREATE_FAILURE.

This makes me think there is a permissions within SAS not able to create an entry. I have permissions to create CASLIB and have also tried using elevated rights being a SAS Admin.

On the file system my used ID has read write to the directory being used.

Any help!! Below is a screenshot

SAS Deployment Manager Error

David_paul — Tue, 14 Jul 2020 01:32:58 GMT

Folks,

We are unable to launch SAS deployment manager in SAS 9.2 on AIX server. I can open the sasmc without any issue. I have activated the x11 on the putty.

However when we open the sdm its throws the below error.

Error: Missing /opt/SAS/SAS92/SASDeploymentManager/9.2/products/xxxxxxxx/../../setup.dat.

SAS Grid Automated Installation

gra_in_aus — Tue, 14 Jul 2020 00:09:16 GMT

Planning to install SAS Grid on AWS FSx on Lustre (Linux) and wanted to know if the installation of the grid could be automated to replicate the environment in case of failure. Otherwise, there is alot of hours would be lost if a manual installation is required.

Getting my program files back for SAS University Edition

GenDemo — Mon, 13 Jul 2020 23:02:29 GMT

Hi All

So I just went through the first instance or updating my SAS University Edition.

The instructions were very poor... so in Virtual Box, I deleted the old machine, and re-imported the newly downloaded one. Only to find that all my library links, programs and data is gone!!!

Is there anyway to get this back?

Process Manager: Flow Editor

FK1 — Mon, 13 Jul 2020 13:11:22 GMT

Hi Everyone,

can someone enlighten me, as of why the Flow Editor is not being installed, when setting up Platform Suite for SAS including SAS Process Manager?

Reading the PM User's Guide from IBM,

it states, that there are THREE applications:

I know, that flows are created by using the Schedule Manager Tab in SMC. But why can I not alternatively choose LSF Flow Editor?

Cheers,

FK1

How to keep the LSF flow on wait which is scheduled on file based events.

rabindrakumar1 — Mon, 13 Jul 2020 11:13:13 GMT

Hi All,

I have deploy and scheduled a flow which is file based event and also the scheduled time to run the flow is daily at 13:00 hours. The flow gets triggered at 13:00 hours but the flow sometimes fails due to non-availability of required file.

Is there a way to put the flow on wait for 10 mins or 30 mins, if the file is not found and then again re-run automatically after waiting time. For example sleep for 10 mins or 30 mins.

Kind regards,

Rabi.

Metadata scripts for SAS Viya

JM7 — Mon, 13 Jul 2020 07:33:20 GMT

Hi all,

Is it possible to use scripts like this https://support.sas.com/documentation/cdl/en/lrmeta/63180/HTML/default/viewer.htm#p1k9zipe59ha2an1pq34gu143lay.htm to export metadata information in SAS Viya?

Thank you in advance!

Enterprise Miner 15.1 Windows 10 Screen Resolution Issue

auddata — Sun, 12 Jul 2020 20:36:50 GMT

I am running Enterprise Miner 15.1 with jre 8_73 on Windows 10. The resolution when launched is so bad I can't view or use the software. I have tried changing the resolution to 1920 x 1200 , and about 15 others, no resolution is very adequate in my opinion. Is this a java version problem? Anyone else have a configuration of software that allows you to properly view Enterprise Miner? I can't find any guides with a recommend resolution size.

Deny Concurrent SAS Stored Process Web Application Sessions

rssb — Fri, 10 Jul 2020 17:26:42 GMT

I would like to Deny concurrent SAS Stored Process Web Application Login Sessions for a single user in the SAS 9.4 M4 Linux Platform. Since when a user logged in to multiple times into a same Stored Process concurrently, the data being not saved properly causing the data loss. I tried to mitigate this issue by setting 'Policy.ConcurrentLoginUsers' to 'deny' in the SMC>Application Management>SAS Application Infrastructure>Stored Process Web App 9.4>Properties>Advanced tab whereas 'Policy.ConcurrentLoginUsers' to 'logoff' in the SMC>Application Management>SAS Application Infrastructure>Properties>Advanced tab. My assumption is to allow concurrent SAS applications with valid credentials and deny concurrent Stored Process Web App. However, it's still allowing concurrent logins for the same user to the Stored Process Web Application. The Authentication method being used is 'Logon Manger'. If I set 'Policy.ConcurrentLoginUsers' to 'deny' in the SMC>Application Management>SAS Application Infrastructure>Properties>Advanced tab then the user can login to only Web Application, which is not the requirement as the same user will have access to several individual Stored Process Web Applications in the same environment. I restarted Mid-Tier every time whenever I made these changes in the SMC to make it effective but no luck.

I would really appreciate your valuable inputs here.

SAS Viya LOGS

JM7 — Fri, 10 Jul 2020 11:48:19 GMT

Hi everyone!

Exist in SAS Viya logs as detailed as those of SAS 9.4?
if yes, where could i find them?

Thank you in advanced

SAS batch job are long running

naveenraj — Fri, 10 Jul 2020 04:45:07 GMT

We have batch jobs that were running fine without any issue for a long time. From last week onwards we are seeing that the jobs are long running. Our's is a sas environment hosted on linux machine. We have not made any changes to the code recently. The only thing i can see within the logs is that the real time of the procedure or data step has increased. We have checked wih Unix admins and they have told that no other process is running on the server. We have also run the jobs at different times to see if its a timing isue. But did not get any difference. Only thing we can notice is high i/o utilization on sas work library mount which was not there previously. Have anyone faced this issue or guide me on what to check further to imprve the performance

now:

real time 37:04.73
user cpu time 9:49.74
system cpu time 5:39.84
memory 2110359.71k
OS Memory 2120860.00k
Timestamp 07/06/2020 09:43:48 PM
Page Faults 31
Page Reclaims 2235141
Page Swaps 0
Voluntary Context Switches 8831289
Involuntary Context Switches 1730716
Block Input Operations 335352296
Block Output Operations 722203936

before :

real time 9:30.78
user cpu time 8:15.08
system cpu time 5:14.26
memory 2110359.71k
OS Memory 2120860.00k
Timestamp 06/30/2020 08:40:02 PM
Page Faults 33
Page Reclaims 2068727
Page Swaps 0
Voluntary Context Switches 8136300
Involuntary Context Switches 897939
Block Input Operations 332189320
Block Output Operations 727054200

Service down in Data tier

SudTR — Thu, 09 Jul 2020 11:24:18 GMT

The Service "SAS Config Level 1 - SAS Enviornment manager " is in stopped data in the Production Data tier server due to which users are not able to login to SAS FM Financial Addins .

Please let me know if i can start the service or is thee any particular process to start the service .

How do I assig Notepad++ to be the default program for *.sas files in Windows10 Explorer?

bbenbaruch — Wed, 08 Jul 2020 22:00:28 GMT

I have EG installed on my Windows10 computer. When I want to open a *.sas file, Windows wants to open an instance of EG. The only options Windows gives me are EG or "search the web for apps" and then it only gives me 2 free options neither of which open *.sas files without upgrading to the paid version. (Earlier versions of Windows allowed me to browse my hard drive to choose the default program.)

I want to change the default program for opening *.sas files to Notepad++. This is what I use for a lot of my program editing.

Does anyone know how to do this in Windows10?

SAS Access to Hadoop

fahadali — Wed, 08 Jul 2020 11:30:29 GMT

I am trying to configure SAS Access to Hadoop on VIYA 3.5. Hadoop Cluster is CDH 6.3.3. VIYA is on Linux machine and hadoop is kerberized. I am able to assign a libname without hdfs_tempdir options and can read data also but cannot write data back to hive and getting below error.

ERROR: java.io.IOException: Failed on local exception: java.io.IOException:
org.apache.hadoop.security.AccessControlException: Client cannot
authenticate via:[TOKEN, KERBEROS]; Host Details : local host is:

When I am trying to add hdfs_tempdir option in the libname, the libname also not getting assigned successfully.

User session (through EG or DI) logs to be saved in a central location along with their log window

sathya66 — Wed, 08 Jul 2020 10:36:38 GMT

all,

Enabled user workspace logs for the users but in the logs, it is not capturing the actual code when they run. It is capturing only when they connected/opened a session and if they have any ERRORs in their code/session.

How to capture all session logs along with user submitted code.

Thanks

Read Metadata objects/permissions from one environment to another environment.

sathya66 — Wed, 08 Jul 2020 07:23:25 GMT

All,

Have dev , test and prod environments. By using below macro we can get the metadata objects from a specified folder.

%mdsecds(folder="/Shared data", includesubfolders=yes);

is it possible to get the metadata object lists from dev ENV by specifying test credentials in options.

ex:if I run below code which uses test metadata host names and credentials from DEV.

I know, it will give bridge protocol ERROR. is it possible actually by opening ports/config changes in meta/in compute,etc.

Off course we can run the above macro in different envs but we want to run from one environment that pulls data about all environments (dev,test and prod)

is there any way we can do.

%let metaserver = %str(testmeta.company.com);
options metaserver="&metaserver"
metaport=<port>
metauser="ID"
metapass="XXXXXXX"
metarepository="Foundation"
metaprotocol=BRIDGE;

%mdsecds(folder="/Shared data", includesubfolders=yes);

SAS Enterprise Miner model performances

AshokD — Mon, 06 Jul 2020 12:06:16 GMT

Hi,

SAS model is currently running in the business(Monthly) successfully for the past 4 months in SAS Enterprise miner.

The model will generate the scores for the customers based on the selection.

Can someone share on, how to track their performances like predicted score vs what happened ?

I am new to the SAS EM tool, It would be great if someone help me on this.

Thanks,

Ashok

Unable to execute stored process.

rabindrakumar — Tue, 07 Jul 2020 10:48:22 GMT

Unable to execute stored process.
A connection could not be obtained.
Logical Server A5D0MDAI.AW00000P must be associated with at least one Server Component through the "Using Components" association.

Metadata table registered twice

sathya66 — Sat, 04 Jul 2020 19:17:43 GMT

All,
If a table registered twice in metadata libraray In different locations. how would it know which one to reference through libname statement? Proper DI job works fine as we drag and drop the tables.
Ex:If table registered twice, say initial one with 5 columns, new one (metadata table updated) with 7
how would it know which one to reference?

libname Test meta library=Test;
proc sql ;
select * from Test.table ;
quit;

Thanks,
SS

Refresh token Validity in Viya 3.5

sounak93 — Fri, 03 Jul 2020 13:19:53 GMT

I registered a client ID and Client secret in Viya. The validity of my refresh token is 30days. Is there a way I can extend it? Can I set the validity of the refresh token to never expire?

sas viya enviroeemnt manager tabs disable/hide for specific users

sathya66 — Fri, 03 Jul 2020 11:03:59 GMT

Hi All,

we can control the content tab by defining the user groups.how to hide/disable the SAS viya environment manager tabs to specif users.I want to hide server and jobs tabs/plugins to specif users or groups (just like how we control plugins in sas 9.4 SMC). and also only specific users should have access to scheduling access in viya world. see below.

MariaDB ODBC connectivity .so file name

ksuman — Fri, 03 Jul 2020 09:55:25 GMT

Hi Tech Experts,

We would like to setup connectivity to MariaDB from SAS using SAS Access,
can any one help us to identify what is the .so file name to make entry on ODBC.ini Driver parameter (Linux),
and configuration steps

Thanks,
Reddy

SAS Web Server Settings

shoin — Thu, 02 Jul 2020 19:00:34 GMT

This link https://go.documentation.sas.com/?docsetId=appsrvtuning&docsetTarget=n0h4b6qexwe5h1n1v9xisqfxl84v.htm&docsetVersion=9.4&locale=en provides SAS web server tuning parms.

The entries are somewhat different than what one finds in their install (Linux/WIN). See below.

Question: In doc and in install which value is which? (Assume medium size install (9.4TS1M6) The values shown in yellow were they correctly interpreted?

SAS WS Tuning ParametersDefault values Linux SAS WS server

To list all the sas metadata objects from a specific folder

sathya66 — Thu, 02 Jul 2020 13:10:28 GMT

All,

MDSECGO macro will return all metadata content to a SAS dataset ,can we extract , who created that object too.

%mdsecgo(folder="/",
includesubfolders=YES,
memberfilter="",
objdata=my_objects);

SAS Data Connector to ODBC

kcoley — Thu, 02 Jul 2020 01:00:46 GMT

I am having problems configuring my ODBC connection for my sas viya CAS server. I keep getting datasource name not found when i run my caslib. I configured the cas_usermods.settings on all cas servers (i have a cas controller and 2 workers). My isql works from all three servers to the database. I did a strace on the launchsvc service and its showing that the processes are looking at the correct odbc.ini and odbcinst.ini file. Any ideas?

renew license

JL7 — Wed, 01 Jul 2020 21:22:55 GMT

hi there,

I got this message below recently and have asked our institution and they don't know either. I don't know to whom I should ask to obtain the SID.

thanks in advance!

Jason

WARNING: Your system is scheduled to expire on August 1, 2020 which is 32 days from now. The SAS System will no longer function on or after that date. Please contact your SAS Installation Representative to obtain your updated SAS Installation Data (SID) file,which includes SETINIT information.

SAS 9.4 M5 - IWA - unable to start workspace for users authenticated via IWA

nirolf — Wed, 01 Jul 2020 20:40:07 GMT

HI,

I face an issue trying to set IWA auth for users. IWA is functional for the metadata server, but I am unable to start workspace via SAS EG.

My configuration :

- meta, compute on two separate Linux server (RH)

- Workspace server is bind to an LDAP directory via PAM.

- Kerberos binding to AD is functional: on metadata server and the app server - using SAS Integration Technologies Configuration tool I can conenct usink "Negociate" to Metadata, Object Spawner, but not to the Workspace Server

As you see below, the kerberos auth and delegation seems ok, but the workspace doesn't start.

I've tried all that I could find regarding this error (for example getent user.name@domain.com and getent USER.NAME@domain.com both work) to no avail.

2020-07-01T22:48:16,111 DEBUG [00000047] :user.name - IOM RETURN OMIProxy 0={compRef:7fba8520da20}->CompDtor()
2020-07-01T22:48:16,111 TRACE [00000047] :user.name - IOM LOGIC TKIOM: delete compRef=7fba8520da20 for OMIProxy
2020-07-01T22:48:16,111 DEBUG [00000047] :user.name - Application-specific option lookup skipped because no application name is provided for client 11.
2020-07-01T22:48:16,111 DEBUG [00000047] :user.name - Command being used is /sas/sasconfig/Lev1/SASAppOne/WorkspaceServer/WorkspaceServer.sh.
2020-07-01T22:48:16,111 DEBUG [00000047] :user.name -    >noterminal< (Standard options)
2020-07-01T22:48:16,111 DEBUG [00000047] :user.name -    >netencryptalgorithm< (Standard options)
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -       >SASProprietary<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -    >metaserver< (Standard options)
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -       >srvsasmetak01t.company.com<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -    >metaport< (Standard options)
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -       >8561<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -    >metarepository< (Standard options)
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -       >Foundation<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -    >locale< (Client requirement)
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -       >en_US<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -    >objectserver< (Standard options)
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -    >objectserverparms< (Standard options)
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -       >protocol=bridge spawned spp=39532 cid=0 dnsmatch=srvsasappk01t.company.com pb classfactory=440196D4-90F0-11D0-9F41-00A024BB830C server=OMSOBJ:SERVERCOMPONENT/A504E8PI.AY00000A cel=credentials recon<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -  Environment variables are:
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -    >METAUSER<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -       >user.name@!*(generatedpassworddomain)*!<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -    >METAPASS<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name -       >********<
2020-07-01T22:48:16,112 DEBUG [00000047] :user.name - Obtained krb5 ccache handle: 7fba8801b8f0
2020-07-01T22:48:16,113 WARN  [00000047] :user.name - The destination buffer size was not sufficient for the requested password.
2020-07-01T22:48:16,124 DEBUG [00000047] :user.name - Freed krb5 ccache handle: 7fba8801b8f0
2020-07-01T22:48:16,124 ERROR [00000047] :user.name - Access denied.
2020-07-01T22:48:16,124 ERROR [00000047] :user.name - The launch of server SASAppOne - Workspace Server for user user.name failed.
2020-07-01T22:48:16,124 TRACE [00000047] :user.name - IOM FIRE-EVENT {compRef:7fba8520d960}->ObjectSpawner::ServerFailed():
 logicalServer=SASAppOne - Logical Workspace Server
 serverComponent=SASAppOne - Workspace Server

Here is the sasauth-debug.log:

20200701-22:14:04 KRB5CCNAME was not set; we'll see if something happens later
[...]
20200701-22:48:16 Authenticating user user.name via GSS
20200701-22:48:16 Context username: user.name@company.com
20200701-22:48:16 Context username length: 21
20200701-22:48:16 Server Name: SAS/srvsasappK01t.company.com@company.com
20200701-22:48:16 Unknown user when getting user attributes.
20200701-22:48:16 User user.name did not authenticate. Reason: 'Unspecified reason.' (gss)
20200701-22:48:16 Request failed: 'User did not authenticate.'

I am not sure about that warning about KRB5CCNAME, what should I set it to? I've seen this, but I don't seem to find a file named "krb5cc_*". My krb5.conf has by default this option:

default_ccache_name = KEYRING:persistent:%{uid}

Any ideas?

location for cas memory data in sas viya

sathya66 — Wed, 01 Jul 2020 08:43:23 GMT

All,

I loaded a table into cas memory . Where can I see the path on the server.

ex: cars.sashbat is the original table (I ca see it on the server )

I loaded that table into cas memeory (cars)-- where can I see the path on the server(it is showing us, the location as physical one but I can't see it on the server. it should save somewhere in memory )

SAS Viya 3.4 and compsrv (compsrv spins when running a program until PID is killed)

Reggie1 — Tue, 30 Jun 2020 13:05:10 GMT

I am using SAS Viya 3.4. I am connecting to Amazon Redshift through an ODBC connection. When I attempt to run a SAS program within SAS Studio on Viya the program does not complete on its own. I have to go to the linux box and kill the compsrv.start.s and kill the PID in order for the program to complete. Has anyone else had an issue such as this? I only get this issue when trying to run it within SAS Studio on SAS VIYA.

Example of PIDS I would kill

rmjones@abcdefghighl:/opt/sas/spre/home/lib64/accessclients
$ ps -U rmjones
PID TTY TIME CMD
9271 pts/1 00:00:00 ps
14611 ? 00:00:00 compsrv_start.s
14631 ? 00:00:13 compsrv
14633 ? 00:00:00 elssrv
52233 pts/0 00:00:00 vim
101719 pts/0 00:00:00 bash
117970 pts/1 00:00:00 bash

I know the program run because, when I run the same program on SAS Studio on SAS 9.4, it runs as it should.

Please help!!

Thanks

Reggie

Set Default Program to SAS Enterprise Guide 8.1

dwrafter — Tue, 30 Jun 2020 09:17:21 GMT

I have upgraded SAS Enterprise Guide from 7.1 to SAS Enterprise Guide 8.1 on number of Windows 10 machines. When I go into default programs and try to change the .SAS files etc to launch from SAS Enterprise 8.1 I do not get the option to set SAS Enterprise 8.1 as the default program.

Assistance appreciated.

Scheduling of promoted job flows

frank_hack — Mon, 29 Jun 2020 11:54:11 GMT

Greetings,

When promoting DI jobs between environments (dev/test/prod), will the job need to be re-scheduled in each environment?

Using SAS Management Console in 9.4M4. Scheduling server options are Operating Systems Services, SAS Distributed In-process Services Scheduling Server, and SAS In-process Services.

Thanks,

Frank

Compute platform Availability alert

sathya66 — Mon, 29 Jun 2020 10:49:56 GMT

We are getting alerts for compute platform availability but all looks fine and working.

It is showing us the availability as 83.5% (alert set to <100%).how can We over come this and what EVM will trigger/search to get these alerts?

Using AD-user for database connection in batch triggered by LSF.

nilshermann_wiggen_knowit_se — Fri, 26 Jun 2020 13:05:46 GMT

Hi!

We are using LSF for batch scheduling, with the lsfadm user. When running jobs that connects to databases (MSsql, Oracle) we want to use Active Directory users for access to the databases. What we have done till now:

Created local database users and registered these in SAS metadata.
We have made authentication domains for each user login (to source databases).
We made a metadata user group with the database user account with the correct authentication domain
Then we have placed the lsfadm user in this goup.

This works, but when we want to use AD-users for accessing databases we can’t get it to work. When trying to use AD users instead of local database users the batch is not using the database user, but instead uses the lsfadm user in the connection string/libname. We then get errors in the libname statement. We have also tried to put the AD-users account directly on the lsfadm user, but no luck.

Share Server and user permissions

JMS — Fri, 26 Jun 2020 11:11:45 GMT

I want to set a up a share server in linux. I want that the users need userid and password to use the share server, but the files should be accessed with the user rights of the share server.

Running the share server with AUTHENTICATE=OPTIONAL, everybody can use the share server and access all files available to the share server. Running it with AUTHENTICATE=REQ, only users known to the system can use the share server and access the files the users are allowed to access.

What I want is a mix:

only users known to the system can use the share server (i.e. they have to use userid+apsswd), and they can access all files available to the share server.

I.e. accessing the files, the share server does not check against the user rights.

Is this possible?

SAS Environment Manager ".DCOM: application-specific!

FK1 — Fri, 26 Jun 2020 08:47:01 GMT

Hello Everyone,

I an completely new to the handling of the SAS Environment Manager. I do have the following problem:

I can see from our SQL Database log, which runs on server X, that there are regular unsuccessful attempts of the SASDEMO-User to log onto our database, which originate from our SAS compute server, which runs on server Y. I know, that they originate from server Y, because the database log shows the "CLIENT: IP-Adress" , which is the one from server Y.

When checking the times in the SQL Server Log, I can see that they exactly correlate to ERROR-Events in the Environment Manager:

My question is: how can I turn of these attempts?
How are they generated in the first place?

Any help would be very much appreciated.

Cheers,

how to get user login history in sas 9.4

vivinkumar — Fri, 26 Jun 2020 07:52:43 GMT

I got a task to get report of SAS users login history for past 3 to 6 months and activities of all users (like access the dataset, library, etc.,). I am using SAS 9.4M5.

Let me know if there any option using SAS environment manager also.

I had a look in to this documents which helps me to get the last login information - https://communities.sas.com/t5/SAS-Communities-Library/Get-last-SAS-logins-of-users-and-clients/ta-p/352727

Best regards,

Vivin

How to start SAS services on shared file system from Grid nodes

Madhan_cog1 — Fri, 26 Jun 2020 07:38:30 GMT

Hi All,

We have multi machine architecture plan file (SAS 9.5 M5 Grid) and we have installed metadata server and nodes on the local instance.

We have installed and configured Grid control server on the shared directory . When we try to start the services from the grid nodes we are facing issues and the services are not started properly.

Could you please suggest here.

What are the steps to configure the grid nodes after installing the grid control server in shared directory

Thanks,

Madhan M

Installing Cost and Profit Management produts

ssagar1 — Fri, 26 Jun 2020 05:49:20 GMT

Hi All,

I need to deploy an environment with SAS Cost and Profitability Management Advanced Costing Server and SAS Cost and Profitability Management Data Integration and BI Server as primary products along with the SAS Visual Analytics suite of products.
Are there any precautions or other things which need to kept in mind while completing the deployment

CPORT | Estimate size

MariaD — Thu, 25 Jun 2020 22:44:23 GMT

Hi folks,

We are currently working on a migration of our SAS servers. There is any way to estimate the total size needed to CPORT files? We did some test and in some case we have a compression of 70 or 80% of the original file.

Regards,

RHEL 7 Baseline OS update – 7.x -> 7.7 on SAS servers

Viraaj — Wed, 24 Jun 2020 20:11:42 GMT

Our all SAS servers deployed on RHEL 7.7 platform and now our IT is patching the below OS updates on the SAS Servers and anyone can help me with these updates will affect our SAS 9.4 M6 Servers (SAS App, Meta, and middle-tier).

RHEL 7 Baseline update – 7.x -> 7.7. Servers will receive the latest patches.
- Includes:
  - RHEL 7.7 (kernel-3.10.0-1062.18.1)
    - kernel: Count overflow in FUSE request leading to use-after-free issues. (CVE-2019-11487).
    - kernel: rtl_p2p_noa_ie in drivers/net/wireless/realtek/rtlwifi/ps.c in the Linux kernel lacks a certain upper-bound check, leading to a buffer overflow (CVE-2019-17666).
    - Kernel: KVM: export MSR_IA32_TSX_CTRL to guest – incomplete fix for TAA (CVE-2019-11135) (CVE-2019-19338).
  - New kernel notes: https://access.redhat.com/errata/RHSA-2020:0834
  - JAVA Security Update (OpenJDK)
    - OpenJDK: Use of unsafe RSA-MD5 checkum in Kerberos TGS (Security, 8229951) (CVE-2020-2601).
    - OpenJDK: Serialization filter changes via jdk.serialFilter property modification (Serialization, 8231422) (CVE-2020-2604).
    - OpenJDK: Improper checks of SASL message properties in GssKrb5Base (Security, 8226352) (CVE-2020-2590).
    - OpenJDK: Incorrect isBuiltinStreamHandler causing URL normalization issues (Networking, 8228548) (CVE-2020-2593).
    - OpenJDK: Excessive memory usage in OID processing in X.509 certificate parsing (Libraries, 8234037) (CVE-2020-2654).
    - OpenJDK: Incorrect exception processing during deserialization in BeanContextSupport (Serialization, 8224909) (CVE-2020-2583).
    - OpenJDK: Incomplete enforcement of maxDatagramSockets limit in DatagramChannelImpl (Networking, 8231795) (CVE-2020-2659).

Java notes: https://access.redhat.com/errata/RHSA-2020:0196

Azure Data Lake | How to access

MariaD — Wed, 24 Jun 2020 16:31:05 GMT

Hi folks,

I understand the only way to access / work with Azure Data Lake is using Viya. Does it correct? Or there is any way to connect using SAS 9.4?

Which are the prerequisite (version, components, etc) for Viya/SAS 9.4 in order to use Azure Data Lake?

Regards,

SAS Viya Model Manager Alter Score Code

Kyle4 — Wed, 24 Jun 2020 12:53:07 GMT

Hi,

I am trying to add two new variable and basic logic to the score code of a model registered in SAS Viya's (v3.5) Model Manager (v15.3). I need to publish the model to both CAS and MAS. The logic has worked for the CAS deployment, but not MAS. The model was registered in Model Studio and only the default files are contained in the model project.

I am trying to add these two variable: 'Score' and 'Band'

The logic for the variables are:

      Score = round("P_EFT1", 0.01);
      
      if "P_EFT1" > 0.3 then Band = 1;
      else if "P_EFT1" > 0.15 then Band = 2;
      else Band = 3;

The variable 'P_EFT1' is a default output variable from Model Studio.

I have altered the dmcas_epscorecode.sas file, which resulted in the publish to CAS working, but not MAS. I flagged the changes I made with '/*Added Manually*/'.

data sasep.out;
   dcl package score _BE9FNU0BR6ETZUH403ZIEWDLI();
   dcl double "P_EFT1" having label n'Predicted: EFT=1';
   dcl double "P_EFT0" having label n'Predicted: EFT=0';
   dcl nchar(32) "I_EFT" having label n'Into: EFT';
   dcl nchar(4) "_WARN_" having label n'Warnings';
   dcl double EM_EVENTPROBABILITY;
   dcl nchar(8) EM_CLASSIFICATION;
   dcl double EM_PROBABILITY;
   dcl double Score;/*Added Manually*/
   dcl double Band;/*Added Manually*/
   
   varlist allvars [_all_];
 
    
   method init();
      _BE9FNU0BR6ETZUH403ZIEWDLI.setvars(allvars);
      _BE9FNU0BR6ETZUH403ZIEWDLI.setkey(n'58025805849178A085AE9D34B421C2D28FD2300D');
   end;
    
   method post_BE9FNU0BR6ETZUH403ZIEWDLI();
      dcl double _P_;
       
      if "P_EFT0" = . then "P_EFT0" = 0.7148;
      if "P_EFT1" = . then "P_EFT1" = 0.2852;
      if MISSING("I_EFT") then do ;
      _P_ = 0.0;
      if "P_EFT1" > _P_ then do ;
      _P_ = "P_EFT1";
      "I_EFT" = '1';
      end;
      if "P_EFT0" > _P_ then do ;
      _P_ = "P_EFT0";
      "I_EFT" = '0';
      end;
      end;
      EM_EVENTPROBABILITY = "P_EFT1";
      EM_CLASSIFICATION = "I_EFT";
      EM_PROBABILITY = MAX("P_EFT1", "P_EFT0");
      
      Score = round("P_EFT1", 0.01);/*Added Manually*/
      
      if "P_EFT1" > 0.3 then Band = 1;/*Added Manually*/
      else if "P_EFT1" > 0.15 then Band = 2;/*Added Manually*/
      else Band = 3;/*Added Manually*/
      
   end;
    
 
   method run();
      set SASEP.IN;
      _BE9FNU0BR6ETZUH403ZIEWDLI.scoreRecord();
      post_BE9FNU0BR6ETZUH403ZIEWDLI();
   end;
 
   method term();
   end;
 
enddata;

Furthermore, I added the two variables in the 'Variables' tab. The files available in Model Manager are shown below.

Can someone please assist with how I can change the code to work for MAS publishing as well? Or maybe even point me to the relevant documentation.

Kind Regards,

Kyle

SAS 9.4M6 with Oracle 12c and 19c

titan31 — Tue, 23 Jun 2020 10:50:37 GMT

Hi,

Company are upgrading database from oracle 12c to 19c so I need to test on SAS. We're using redhat.

We don't have a test environment, so need to work off the production environment. Is it possible to install Oracle 19c for tests and still have 12c working as normal. Idea would be we'd have odbc connection to a 19c DB and the rest are as normal on 12c version.

Is there anything I'd need to take into account so instantclient or odbc drivers aren't clashing?

Regards,

Craig

SAS version 5.18

rlmacdonald — Mon, 22 Jun 2020 17:59:35 GMT

Does anyone have a version of SAS that will read files created in SAS version 5.16 on a VAX VMS system? Thanks.

SAS/SECURE SSL

rvsidhu035 — Sat, 20 Jun 2020 23:05:35 GMT

ERROR: Could not find extension: (tkessl)
Missing above dll file in core folder of sas foundation v9.4 level 1M1

Uninstall old versions after maintenance release upgrade-in-place

Timmy2383 — Fri, 19 Jun 2020 12:26:31 GMT

Anyone know if using SAS Deployment Manager to uninstall old versions of products after they've been upgraded with a maintenance release would have any negative impact?

I've gone through several upgrades in my current environment, and I would like to conserve disk space. I see things like:

<sas home>/SASStudioMidtier/3.2

<sas home>/SASStudioMidtier/3.4

<sas home>/SASStudioMidtier/3.5

<sas home>/SASStudioMidtier/3.6

<sas home>/SASStudioMidtier/3.7

Since we're currently on 3.7, I would think I can use Deployment Manager to uninstall all the other versions

$LSF_CONFDIR & %LSF_ENVDIR%\

senu188 — Thu, 18 Jun 2020 09:11:33 GMT

Hi,

i want to just clarify both $LSF_CONFDIR & %LSF_ENVDIR% are same path?

can you give default path for $LSF_CONFDIR if both are different?

can you guide how to the below activities?

As to the issue of "imSetPasswd: savePassword() failed", could you ask the client to check the permission of the parent directory of $LSF_CONFDIR.

Please ensure "Everyone" has "Full Control" permission in "Sharing" and "Security" tab in the directory property dialog window."

SAS Object spawner throws an error when the user home directory created using PAM modules(automatic)

anguraj1 — Wed, 17 Jun 2020 13:52:19 GMT

Hi All,

Used the below link posted by Paul for automatic creation of home directory for New users.

https://platformadmin.com/blogs/paul/2017/04/sas-user-linux-home-dir-auto-creation/#comment-14502

After creating the pam module for auto creation /home/directory - when i login to the SAS EG i am getting the below error

Objspawn was unable to launch the server SASApp – Workspace Server because the Grid provider has exceeded the specified wait time.

Please find below the object spawner error message:
2020-06-17T13:28:29,525 ERROR [00008418] :azsj – The specified uuid DA816073-34D2-5F4E-B85A-EFDD03AC30F6 did not match any process managed by this spawner.
2020-06-17T13:28:29,526 ERROR [00008418] :azsj – Objspawn was unable to launch the server SASApp – Workspace Server (A5NYPY3W.AY00000C) because the Grid provider has exceeded the specified wait time.

Note: Other users who logged in the server directly not thru PAM Automatic home directory is not facing any issue.
Thanks,
Anguraj S

Integrate AD users/groups into SAS Management console

Madhan_cog1 — Wed, 17 Jun 2020 09:18:12 GMT

Hi All,

We have installed and configured SAS 9.4 M5 Grid in a Linux Environment.

We would like to know how to integrate AD users/groups into Management console instaed of adding the users manually.

We have enabled PAM Authentication already.

Kindly suggest.

Thanks,

Madhan M.

Configuration path | change

MariaD — Tue, 16 Jun 2020 22:21:02 GMT

Hi folks,

One quickly question, is it possible to change the configuration path after completed the configuration step?

Considering we have the following configuration path /sas/sasconfig/config/Lev1/.... , is it possible to change to /sas/config/Lev1... for example?

Regards,

Z/OS DB2 V12 AND SAS STUDIO

GOLDY58 — Tue, 16 Jun 2020 15:02:06 GMT

I am very new to SAS, all the courses I see are using SAS studio, can this be used to connect to Z/os?

Also is Sas Studio free of charge ? I see a reference to an academic version, is this free of charge. There is a length process to get software approved in my show, since it is not used currently it has to go through the approval process. Maybe if we have a SAS license on the host, we have the usage of SAS studio. It seems all the classes point to using this tool.

I am trying to use the tool to access SMF data for performance tunung.

Thank you in advance,

Carol

Moving from HP-UX to Linux

MariaD — Mon, 15 Jun 2020 23:06:36 GMT

Hi folks,

We are moving our SAS server from HP-UX to Linux. Unfortunately, we don't have space to work with CPORT/CIMPORT.

So, we understand we need to recreate all index on Linux in order to work with the SAS datasets.

We prepare a test and copy, through FTP, some files to the Linux server. In Linux we created a LIBNAME pointed to this copied files. The LIBNAME under SAS EG doesn't shows the tables with index but we could execute PROC CONTENTS on it without any problem.

We tried to execute PROC DATASETS to recreate the index for this tables, but an error appears because the procedure can't locate the table.

So, we execute DATA / SET recreating the table on WORK. After that, we execute again DATA / SET copying from WORK to the LIBNAME. The process executes fine but we still can't see the table on the LIBNAME.

We also tried to execute PROC COPY to WORK libname but the same error as we encounter on PROC DATASETS appears.

Any suggestion?

Regards,

How to identify who Removed SAS metadata table

JJP1 — Mon, 15 Jun 2020 07:27:49 GMT

Hello All,

Some one has removed metadata table from SAS environment. i would want to know know how can i identify who has removed this please. i know who has SAS admnistartor access can remove. but no one has any clue who removed. any option to identify this case please

bi viwer

senu188 — Fri, 12 Jun 2020 12:27:33 GMT

Hi,

What is difference between BI dashboard,BI designer , WRS(web report Studio)? I am new to sas admin role in the company,how and where can we find the BI dashboard,BI designer , WRS(web report Studio) is installed or not ?

EM 14.2 and EM 15.1 clients on the same machine

MariaD — Thu, 11 Jun 2020 23:21:58 GMT

Hi folks,

Currently we have 2 SAS Servers. One is Unix and has SAS 9.4M4 with Miner 14.2 and the other one has SAS 9.4 M6 with EM 15.1.

The problem is we need to maintain the access to the different EM version on the same client machine. So, in some case the user will use EM 14.2 connected to Unix and in other case, he use EM 15.1 connect to the new server.

After installed the SAS EM 15.1 client, we duplicate the sassw.config file, so now we have one pointed to SAS EM 15.1 and other one pointed to EM 14.2. After that, we edited the "em.ini" inside EM 14.2 client folder and change the location of the master properties.

When we tried to open SAS EM 14.2, the following error appears. We opened the SASENVIRONMENTURL link on browser on the client machine and it's open fine.

Any better idea to maintain the two access in the same client machine?

Regards,

JFD and lSF Logs

senu188 — Thu, 11 Jun 2020 08:36:16 GMT

Hi,

please correct i am wrong in finding out logs :

JFD Log: D:\Program Files (x86)\IBM\Platform Process Manager\log\jfd.log

LSF Log: D:\LSF_9.1\log (vemd,lim,res,sbatchd etc)

What is can you run jfd -V from the directory where jfd is installed?

Enabling and Initializing the APM ETL

sathya66 — Thu, 11 Jun 2020 07:24:34 GMT

Hi all,

We are looking to enable APM. see below link

https://documentation.sas.com/?docsetId=evug&docsetTarget=n0y0zbl7hnj8yhn1thh01vbag2mq.htm&docsetVersion=2.5&locale=en

We need to understand 1 & 3 point in the heading section APM ETL Enablement and Initialization Steps.

how to enable 1& 3 points and also will these logs monitor who edited which metadata object and when in a separate user logs/session logs (ex: jobs,tables,etc we can see this info also in metadata logs). can we see this information(ie:who, updated metadata objects and when) through SAS Environment manager.

is there any step by step example other the above link.

Thanks

Submitting jobs in Queues using SAS Enterprise GUIDE

Madhan_cog1 — Wed, 10 Jun 2020 14:03:18 GMT

Hi All,

We have installed and configured SAS 9.4 M5 Grid Version in a Linux environment.

We have configured four queues for job submission

1.Normal

2.Priority

3.Big

4.Big Priority.

We are trying a submit a job with priority queue through EG.

By default EG Job runs in normal queue.

We have set the options based on few support papers

https://support.sas.com/resources/papers/proceedings16/11100-2016.pdf

But still EG job always runs on normal by default.

Could you please suggest here.

Some screenshots attached in the document.

Thanks,

Madhan M.