The MS SQL ODBC driver should be present by default, and can use DSN-less connections so you wouldn't need an ODBC file but you could put one in the mount you're adding with the data-mounts sample transformers. If you are setting a DSN when configuring the the connection in Viya, you'd probably need to provide the odbc file. For connections from CAS, there would need to be a network path from the CAS node to the MS SQL server, so if that port is not opened it would need to be. Verify SAS/ACCESS Interface to Microsoft SQL Server https://go.documentation.sas.com/doc/en/sasadmincdc/v_055/calvalid/p0455nqweukxh3n1gommqk2sdpaf.htm ... View more

@EyalGonen I tested running with the --remove-old option and received this message: Flag --remove-old has been deprecated, please use --remove-after-upload, and that option would only remove from the local repo after they've been uploaded, so I don't think that would do what you want. It looks like ECR has lifecycle options you can configure: https://docs.aws.amazon.com/AmazonECR/latest/userguide/LifecyclePolicies.html It looks like one way you could do this is with the tagStatus of "tagged" and "imageCountMoreThan" countType, which sounds like it would tell the ECR to remove all tagged images older than the last n images pushed. ... View more

@EyalGonen I don't believe SAS Mirror Manager has such a function. ... View more

Have you engaged SAS Technical Support? Looks like your code isn't calling the Connect Spawner but using SASCMD to fork an MP CONNECT session off of the Workspace Server. I wonder if adding user=_sspi_ to your rsubmit would help. ... View more

You would use DAVTree to navigate the SAS Content Server in SAS 9.4 (<SASConfig>/Lev1/Web/Utilities/DAVTree.sh) Use the DAVTree Utility to Manage WebDAV Content https://go.documentation.sas.com/doc/en/bicdc/9.4/bimtag/p1pxveukfyuahgn19he3ib4i0o9s.htm ... View more

What is the name of the pod that is throwing these messages? ... View more

That is the output I would expect, so I'm wondering if the issue is still occurring or if casManagement was not accessible when the message occurred. ... View more

Yes, if you aren't running as root or the "sas" user you'd need to sudo the cat command because of the permissions on the file "client.token" ... View more

This message occurs when the function to retrieve the CAS server and caslib from the casManagement/commons/settings endpoint fails. I would expect this to be accompanied by other messages about the issue. Are you able to hit that endpoint from a browser and get a result? (https://viya.example.com/casManagement/commons/settings) ... View more

It sounds like a problem in the SAS Stored Process web application, so I would start with looking at it's log file (<SASConfig>/Levn/Web/Logs/SASServer1_1/SASStoredProcess9.4.log) as well as the log files for the web application server (<SASConfig>/Levn/Web/WebAppServer/SASServer1_1/logs/server.log). ... View more

Here is the documentation for configuring SAS Studio Basic in Viya 3.5: https://go.documentation.sas.com/doc/en/calcdc/3.5/calconfig/n03003sasconfiguration0admin.htm The section "Set File Navigation Options" is applicable to your question. So I think you'd need to (assuming you're on Linux) create or edit the file /opt/sas/viya/config/sysconfig/sasstudio.conf and add something like: export java_global_option_sas_studio_filenavroot="-Dsas.studio.fileNavigationRoot=SYSTEM" and this would tell Studio to provide access to the full file system instead of just your home directory. ... View more

Can you add the "wait" to your _ACTION in the job definition parameters, and leave your HTML as just "execute"? ... View more

The components at work here are SAS Management Console, Process Manager (jfd) and LSF. SMC is a Process Manager client, telling Process Manager to run the flow. Process Manager does this by submitting the job(s) in the flow to LSF. From the error the failure is occurring outside of SAS Management Console, when Process Manager is submitting the job to LSF. Process Manager (jfd) is running the bsub command which is returning an exit code of 32256. When you say you can schedule on LSF in Linux, are you saying it works when running SMC from the Linux host, or when instructing the flow to run in Flow Manager, or are you submitting the same bsub command to LSF from the command line? ... View more

I would recommend engaging SAS Technical Support on this. Usually when we see hangs in the visual interface it means the application running in the browser is getting something it doesn't expect back from some service. The browser console and network trace usually need to be analyzed to identify which object is at fault. Using the web browser developer tools to investigate issues in SAS® Web Applications https://sas.service-now.com/csm?id=kb_article_view&sysparm_article=KB0036430 ... View more