Excellent, thanks! I am planning on testing all the options and figure out the differences, especially in basic performance 😉 I am curious about your progress too! ... View more

Great article @jarno , thanks! Any experiences in SAS 9.4? And with multi-database support (https://duckdb.org/2024/01/26/multi-database-support-in-duckdb.html) queried from SAS? ... View more

Hi,   yes, you will need SPNs and a UPN, and to enable (contrained) Keberos delegation. Again, it is all well documented by SAS: https://documentation.sas.com/doc/en/bicdc/9.4/bisecag/n1d1zo1jsf2o0en1ehu4c4simfky.htm   If what you need is an overview, you can find a nice one provided by @PaulHomes here: https://platformadmin.com/blogs/paul/2015/01/iwa-sas-94m2-linux/ It is based on an old maintenance (2), but I am sure that, by reading the documentation provided by SAS, you can make the adjustments required for your actual SAS environment. Kind regards, Juan ... View more

Hi @siddhu1 ,   since your servers are on Linux, you are bound to set up Kerberos IWA system between the servers and your clients (and, preferably, between your SAS servers and your DBMS).  IWA with Kerberos is described in the SAS documentation. If you have any more specific question, please feel free to raise those questions!   Best , Juan   ... View more

Hi there, The reason is that the Web App Servers can be started/operated in several ways: with the windows service, with the individual command, etc. That's the reason why both confit files exist and why both should be maintained keeping always the same configurations. The best practice is of course the wrapper.conf, however, as far as I know, due to some traditional scripting and operations it has been decided that both need to remain. But probably its best if someone from SAS answers you that one. I hope this answers your questions? ... View more

Hi there, You have 2 options (more, but I’ll simplify): The code approach and the configuration approach. In the code approach, and since your SAS session run on wlatin, you would need to use the transcoding facilities SAS provides, quite intensive, for all the activities related to snowflake/Unicode/UTF8. On the configuration approach you could have an extra SASApp, but running SAS on UTF8, for those operations. As side option, you could just call SAS executable, but passing a sas9.cfg file defining UTF8 encoding, just for that migration. ... View more

Hi @Universe ,   perhaps I am not understanding you, as you are requesting help with code, however it seems to me as your issue is with permissions. If the user that is owner of the SAS process does not have the right permissions, it won't be able to perform certain actions. You probably should align with our Unix admin.   This being said, I can see your code is quite elaborate for the required listing for which I commend you for. However, since you are already using linux commands, perhaps you could use linux commands to do that job, much more simpler and with less lines of code.  Some examples: tree -nf | awk '{printf $0} {system("stat -c \" [ %y ]\" " $NF )}'| sed -e 's#\([0-9][0-9]:[0-9][0-9]:[0-9][0-9]\).*#\1 ]#g' 2>/dev/null ls -Rl --time-style=long-iso /path/to/directory tree -D   ... View more

Hi @Jed_Klei ,   you might want to look into the sas-admin CLI https://documentation.sas.com/doc/en/calcdc/3.4/calcli/n01xwtcatlinzrn1gztsglukb34a.htm   You can also query, programatically, through the RestAPIs SAS VIya offers:  https://developer.sas.com/rest-apis   ... View more

Hi there, Considering the fact that 2 of your 3 options are related to Python and not to SAS, I would start at looking what exact system processes and or services are the ones going up in cpu. There’s also the aspect of coincidence. Several things happening at the same time: try to filter them down and observe which one in fact causes the pattern of the problem. In any case, do align with your SAS and system admins, and feel free to share (with us and/or SAS tech support) your further observations when you are still unable to get a conclusion on your own. ... View more

Hi there, In these cases I like to understand what’s going on behind the scenes, so I can pinpoint exactly the issue, instead of going through trial and error. For that I always refer to the logs on the client side (ODBC client) and the database server logs (audit). You clearly have an issue with permissions, as you have been told. There is no mistake there. Whether it’s a wrong schema or username or something else, we need to figure it out, thanks to those logs. The server logs should already tell you a lot. Have you asked your DBAs what do they see when you connect with SAS? From the client side, you either use STRACE or enable the client logs (ODBC ini for ODBC connections). My personal thought, but this is without knowing more of your setup and design, is that either your connection to the schema is different from SAS to Java, or you are connecting with your OS user on top of the user in the lib name statement. Would you mind sharing as well your exact code used in Java? ... View more

Hello @CCC1492_ME , Mark,   several questions come to my mind, of the kind of: - what could force you to have to delete this DB to be able to continue the deployment - or, why are you not reaching out to SAS Technical Support, as already advised?   It is a bit mind boggling to me so I cannot give you much more advise. My reasons:   - EVManager database is integral part of your deployment, plus part of the Environment Manager product. You really don't want to mess up with that and you want to do what is supported. Right? - What is supported is documented, and what SAS Technical Support or professional services provide, period. Even SAS partners have to adhere to those aspects, and what does not adhere, is not officially supported.  - It is a normal database: undeploying the Environment Manager products or just deleting the database with the admin account would achieve exactly what you indicate... BUT, is it supported? If you still find issues, who will lend you a hand? You would be basically on your own and up to your own talents.     ... View more

@Key123 : yes, I mean that you can redeploy and reschedule manually (that would be my approach) in SMC after the metadata migration (which you can automate with the SAS Platform Object Framework).   While it is possible to reschedule with any metadata account for as long as the Outbound login has the right permissions in LSF, the OS folders and the metadata user has the right permissions over the metadata you could potentially use any account to redeploy the jobs, and to schedule them.   However, you are going to need to look into the implications of using an elevated account, and to ensure that the scheduled jobs will use the right credentials for the execution, file ownership, connection to databases, etc. That is for you to evaluate and decide.   This being said, I do not know how your users schedule and deploy jobs and flows (it depends on the design), which what user, if there is a common user for them, etc etc.   I say this because Batch Jobs are supposed to be controlled workflows. All what is controlled, there should be just one or a limit amount of privileged accounts to deploy and schedule, in the end. However, if your users are using Batch as self service, that is a different story, and, indeed, the implications on security vs investment of work are much different.   Let me add: in the communities there is a limit as to how much we can help you without knowing details on design and security of your environment. When they get complicated, I would encourage you then to reach out to SAS Professional Services or a trusted SAS Partner, specialised on this area. ... View more

@Bogdan_Teleuca excellent article, thanks!   ... View more