About epower

epower

Your issue is that you need to whitelist the passive port in your firewall.... comments like you have to use SFTP is incorrect.

epower

It's only Oracle , SQL Server runs have no issues. I'm thinking there is some sort of network issue but SAS doesn't handle it and hangs.

epower

Yes there many ways of interacting with GIT. Sadly SAS Studio with 9.4 does not.

epower

BTW We ended up giving up with SAS an Oracle. Full tickets through tech support ended up nowhere. Using the oracle client on the same server things could run fine and SAS would just continue to hang. We just ended up using different methods for Oracle execution of stored procedures.

epower

Thanks for this article. One fundamental issue is that SAS 9.4 SAS Studio will not work with local repositories. It requires that all GIT repositories have some sort of external repository associated. GIT functions in SAS make it optional to make a repository with a remote repository and SAS Viya SAS Studio honors local repositories without issue. People using local repositories in SAS 9.4 are forced to sit on the sidelines for this.

epower · ‎11-04-2024

We have a some jobs running Proc SQL where we execute Oracle Stored procedures but some jobs just hang. Has anyone seen this? Running the stored procedure from the same SQLPLUS client on the server shows a successful execution but when we run it from SAS we never get a response. SQLPLUS is giving this response Our SAS logs look this and never end until we force quit (I have turned on SASTRACE with d,,, to actually get a log otherwise a log file never gets populated)

epower · ‎04-08-2024

Turns out we needed a patch to get the update to work.

epower · ‎04-07-2024

Thanks for the update. I will reach out to SAS Support. I can verify that I have nothing blocking on our side.

epower · ‎04-07-2024

Any update on this? When trying to update 8.3 I keep getting it is up to date

epower · ‎02-20-2024

With a recent update for the extension of for VSC I am not getting an error message stating 'Failed to connect to agent" I have had this working in the past without issue. This is specific to SAS 9.4 SSH connections only. I can get the new IOM to work but our users do not like the SAS Workspace for various reasons. The new IOM also does not seem to support our load balanced configuration., Does anyone know how to get more information on what this error means or have seen this before? Thanks!

epower · ‎03-14-2023

Be cautious if you have customizations to your environment though like SAML, test thoroughly before running this against your production environment.

epower · ‎03-14-2023

You should be able to do it relatively quickly, We take less than half a day for this to run. This depends on complexity and might be different if you are running a huge grid. In a development environment you can definitely test though and ensure you're accounting for what you have in parallel. We are lucky to have a DEV and VAL environment where this is thoroughly tested. That effort takes weeks for us to really make sure we are ready for that switch. One thing to mention is for our installation for 9.4 M7, we have taken down the M7 Mid-Tier due to the huge number of security vulnerabilities associated with those components. We are glad M8 is out!

epower · ‎03-14-2023

While you can upgrade in place we found it easier for us to do a brand new installation in parallel to our current environment M7 for our M8 migration.

epower · ‎02-23-2023

Hi Everyone, Forgive my double posting ( I put this in admin area as well) Azure Managed Lustre is out for public preview. Public preview: Azure Managed Lustre Thanks, Emillio

epower · ‎02-23-2023

Hi Everyone, Just a heads up that Azure Managed Lustre is now in public preview. If you're in azure you should really check this out. Public preview: Azure Managed Lustre | Azure updates | Microsoft Azure

Online Status	Offline
Date Last Visited	2 weeks ago

Re: Connect to ftp using TLS and passive mode

Re: Executing Oracle Stored Procedures hanging?

Re: Demystifying Git – Using SAS Studio in SAS Viya with GitHub throug...

Re: Executing Oracle Stored Procedures hanging?

Re: Demystifying Git – Using SAS Studio in SAS Viya with GitHub throug...

Executing Oracle Stored Procedures hanging?

Re: Updating Enterprise Guide from 8.3 to 8.4

Re: Updating Enterprise Guide from 8.3 to 8.4

Re: Updating Enterprise Guide from 8.3 to 8.4

SAS Extension: Visual Studio Code SAS 9.4 SSH failing "Failed to conne...

Warning: Update to Azure Lustre CSI driver may result in group ownersh...

Add BATCH SUBMIT button to EG

Re: SAS 9.4 M8 being released soon?

Re: How to hide libraries in EG even I do not have access

Re: Azure L series Machines and SASWORK

Re: Updating Enterprise Guide from 8.3 to 8.4

Re: Upgrade from SAS9.4 M7 to M8 - Is SAS Migration Utility needed

Public preview: Azure Managed Lustre

SAS 9.4 M8 being released soon?

Re: SAS Explore

Re: Connect to ftp using TLS and passive mode

Re: Executing Oracle Stored Procedures hanging?

Re: Demystifying Git – Using SAS Studio in SAS Viya with GitHub throug...

Re: Executing Oracle Stored Procedures hanging?

Re: Demystifying Git – Using SAS Studio in SAS Viya with GitHub throug...

Executing Oracle Stored Procedures hanging?

Re: Updating Enterprise Guide from 8.3 to 8.4

Re: Updating Enterprise Guide from 8.3 to 8.4

Re: Updating Enterprise Guide from 8.3 to 8.4

SAS Extension: Visual Studio Code SAS 9.4 SSH failing "Failed to conne...

Re: Upgrade from SAS9.4 M7 to M8 - Is SAS Migration Utility needed

Re: Upgrade from SAS9.4 M7 to M8 - Is SAS Migration Utility needed

Re: Upgrade from SAS9.4 M7 to M8 - Is SAS Migration Utility needed

Azure Lustre

Public preview: Azure Managed Lustre

SAS Inner Circle Panel