03-15-2024
shekhar_chavan
SAS Employee
Member since
02-05-2016
- 7 Posts
- 0 Likes Given
- 2 Solutions
- 6 Likes Received
-
Latest posts by shekhar_chavan
Subject Views Posted 2025 03-15-2024 02:02 AM 1929 12-21-2023 12:17 AM 1174 08-31-2023 07:20 AM 1431 04-05-2023 12:10 AM 3307 03-31-2023 12:27 AM 2422 02-07-2023 01:18 AM 3337 11-10-2022 03:50 AM -
Activity Feed for shekhar_chavan
- Posted Re: Get a list of all tables loaded in SAS Visual Analytics LASR memory on SAS Visual Analytics. 03-15-2024 02:02 AM
- Posted Re: How to install the azure Synapse analytics odbc driver in Sas Viya pay as you go in Azure? on SAS Viya on Microsoft Azure. 12-21-2023 12:17 AM
- Got a Like for Re: How to know when cronjobs/sas-start-all finished to start SAS Viya?. 08-31-2023 09:04 AM
- Posted Re: How to know when cronjobs/sas-start-all finished to start SAS Viya? on SAS Viya on Microsoft Azure. 08-31-2023 07:20 AM
- Posted Re: Connecting to in premise databases to SAS Viya on Azure marketplace. on SAS Viya on Microsoft Azure. 04-05-2023 12:10 AM
- Got a Like for Re: Not able to deploy SAS Viya using Azure marketplace offering. 04-03-2023 03:24 AM
- Posted Re: Not able to deploy SAS Viya using Azure marketplace offering on SAS Viya on Microsoft Azure. 03-31-2023 12:27 AM
- Got a Like for Re: unable to load external plugin 'PersistentVolumeClaim'. 02-07-2023 03:22 AM
- Posted Re: unable to load external plugin 'PersistentVolumeClaim' on SAS Viya on Microsoft Azure. 02-07-2023 01:18 AM
- Got a Like for Re: Deployment failed. 11-15-2022 10:36 AM
- Got a Like for Re: Deployment failed. 11-14-2022 06:04 PM
- Got a Like for Re: Deployment failed. 11-14-2022 03:34 AM
- Posted Re: Deployment failed on SAS Viya on Microsoft Azure. 11-10-2022 03:50 AM
-
My Liked Posts
Subject Likes Posted 1 08-31-2023 07:20 AM 1 03-31-2023 12:27 AM 1 02-07-2023 01:18 AM 3 11-10-2022 03:50 AM
03-15-2024
02:02 AM
Below code can be used to get the list of tables loaded on the LASR: LIBNAME LASRLIB SASIOLA TAG=VAPUBLIC PORT=10031 HOST=<HOSTNAME> SIGNER="http://<hostname>:<port_no>/SASLASRAuthorization" ; %let sizecols = InMemorySize UncompressedSize CompressedSize TableAllocatedMemory InMemoryMappedSize ChildSMPTableMemory VirtualMemory ResidentMemory AllocatedMemory; %let countcols = NumberRecords UseCount RecordLength ComputedColLength; data tablemem; set lasrlib._T_TABLEMEMORY; run; data lasrmem; set lasrlib._T_LASRMEMORY; run; proc print data=lasrmem; title "LASR Server Memory Usage"; format &sizecols. sizekmg9.2; format &countcols. 8.; sum _numeric_; run; proc print data=tablemem; title "LASR Server Table Memory Usage"; format &sizecols. sizekmg9.2; format &countcols. 8.; sum _numeric_; run;
... View more
12-21-2023
12:17 AM
Please check below document for the Viya Azure Marketplace place, the document which you are referring is for full Viya license which is not applicable for 'Viya Azure Marketplace'
SAS Viya on Microsoft Azure: Configuration Tasks
pg#17 has example for Oracle connectivity example.
... View more
08-31-2023
07:20 AM
1 Like
@EyalGonen this does not looks to be a SAS® Viya® on Microsoft Azure Marketplace Subscription because there is no way to stop and restart Viya on Microsoft Azure Marketplace Subscription and Users can start only an instance or delete an instance.
If the query is for the Viya environment which is installed/deployed on Kubernetes by you or your team, you can raise a support track/case to support@sas.com .
Having said that you need to monitor the pod status to check if all the pods are up and running to know if the Viya services are started or not, below are couple of approaches you can go with.
1. Check pod status:
kubectl get pods -o wide
2. Alternately Readiness service checks the status of the SAS Viya deployment to determine whether it is ready for use , below command can be used for the same: kubectl wait \ --for=condition=ready pod \ --selector="app.kubernetes.io/name=sas-readiness" \ --timeout=30s
0 = Ready, 1= Error
... View more
04-05-2023
12:10 AM
@thesasuser
Below document has the details of how you can configure your database with SAS
SAS Viya on Microsoft Azure: Configuration Tasks
check section ' Configure Data Access: Oracle Example .' pg#17
... View more
03-31-2023
12:27 AM
1 Like
In addition to above suggestions also check the Event logs, you should be able to get more details on the error.
Home > Resource groups > Viya4 > deployments > related events
... View more
02-07-2023
01:18 AM
1 Like
This looks to be standard Viya 4 order deployment, and also seems you have raised a support track for the same with track #7613735072,
The Support team should get back to you on your query/concern you raised at the earliest.
... View more
11-10-2022
03:50 AM
3 Likes
Hi @JduPisanie , Thanks for using SAS Communities.
The error indicates there is some Resource quota issue, can you check https://aka.ms/DeployOperations to see if there is any recourse concern? check 'SASViyaExploreApp' under resource group. If this relates to resource quota kindly check
https://learn.microsoft.com/en-us/azure/azure-resource-manager/troubleshooting/error-resource-quota?tabs=azure-cli and let us know if it helps.
... View more