Hi all,   SAS Viya 3.3 SAS VA 8.2 Browser - GoogleChrome v.68.0   We have a performance issue with one of the reports in SAS VA in Viya Report contains :     one data source table - 18GB . This table was loaded to CAS server      5 aggregated functions/measures -without aggregate functions report working faster less than 10 seconds   It takes more than 30 seconds to load reports measures and graphics, should be faster   Can somebody help understand which logs or configuration in Viya should I look through to understand why aggregate functions work so slow ( I suppose all calculation performs in CAS server) ? ... View more

Hi all!   I'm new in using SAS Viya and I have the following case:   I  need to load/append the same table  to CAS every day This table then used in SAS Viya 3.3 (actually in SAS VA) report.   The table 1. must be accessible to other users in SAS Viya - so I assume it should be in the Public library      because when user create report based on a cas table from his own library this report is not working for other users       They see error : The data source used by object failed to load 2. need to have the same name because it's used in daily reports   By this moment I came to this approach:   1. drop table from CAS lib 2. load data with the same name to  Public caslib with PROMOTE option   But it takes time to load the whole table every time, so may be it's possible to make append? We used append in LASR but I searched documentation I didn't find any solution to append existing global table.   This article describes only how to append table in your casuser library not to the Public one https://blogs.sas.com/content/sgf/2017/11/15/concurrent-data-append-and-update-to-a-global-cas-table/       ... View more

 Hi,   I have a problem with starting SAS Viya 3.3. We installed it from quickstart ( https://aws-quickstart.s3.amazonaws.com/quickstart-sas-viya/templates/sas-viya-master.template.yaml)   Step to reproduce:  1. Stop aws instances (visual.viya.sas, prog.viya.sas, stateful.viya.sas, controller.viya.sas and ansible)  2. Start all aws instances  3. Try to connect to SAS Viya through https://<DOMEN>/SASHome getting 404 error: The requested URL /SASHome was not found on this server.  4. login to visual.viya:  sudo /etc/init.d/sas-viya-all-services status see that some of the services didn't start properly 5. trying to restart sas-viya-all-services see log Service start time summary: SERVICE ELAPSED (+/-10) sas-viya-consul-default 00:00:20 sas-viya-sasdatasvrc-postgres-node2-ct-pg_hba 00:00:20 sas-viya-sasdatasvrc-postgres-node2-ct-postgresql 00:00:20 sas-viya-vault-default 00:00:20 sas-viya-sasdatasvrc-postgres-node2 00:00:20 sas-viya-httpproxy-default 00:00:21 sas-viya-alert-track-default 00:00:21 sas-viya-authorization-default Failed! sas-viya-cachelocator-default 00:00:44 sas-viya-cacheserver-default 00:01:07 sas-viya-identities-default Failed! sas-viya-ops-agent-default 00:00:22 sas-viya-saslogon-default Failed! sas-viya-watch-log-default 00:00:23 sas-viya-cas-management-default 00:01:14 sas-viya-files-default Failed! sas-viya-folders-default Failed! sas-viya-preferences-default Failed! sas-viya-relationships-default Failed! sas-viya-transformations-default Failed! sas-viya-types-default Failed! sas-viya-appregistry-default Failed! sas-viya-audit-default Failed! sas-viya-cas-access-management-default 00:01:41 sas-viya-cas-formats-default 00:01:14 sas-viya-cas-license-default 00:01:41 sas-viya-casproxy-default 00:01:41 sas-viya-casrowsets-default 00:01:15 sas-viya-collections-default Failed! sas-viya-comments-default Failed! sas-viya-credentials-default Failed! sas-viya-crossdomainproxy-default 00:00:58 sas-viya-dataflowexecutionprovider-default 00:00:58 sas-viya-dataplans-default Failed! sas-viya-datasources-default Failed! sas-viya-datatables-default 00:00:57 sas-viya-deploymentBackup-default Failed! sas-viya-analytics-components-default Failed! sas-viya-analytics-flows-default Failed! sas-viya-analytics-gateway-default 00:01:06 sas-viya-analytics-localization-default Failed! sas-viya-analytics-pipelines-default Failed! sas-viya-analytics-validation-default Failed! sas-viya-annotations-default Failed! sas-viya-backup-agent-default Failed! sas-viya-backupmanager-default 00:01:02 sas-viya-businessrules-default Failed!     The timeout period expired with services remaining to be started: sas-viya-authorization-default sas-viya-identities-default sas-viya-saslogon-default sas-viya-files-default sas-viya-folders-default sas-viya-preferences-default sas-viya-relationships-default sas-viya-transformations-default sas-viya-types-default sas-viya-appregistry-default sas-viya-audit-default sas-viya-collections-default sas-viya-comments-default sas-viya-credentials-default sas-viya-dataplans-default sas-viya-datasources-default sas-viya-deploymentBackup-defaul   also I see this message in log: The timeout period expired with services remaining to be started: sas-viya-authorization-default sas-viya-identities-default sas-viya-saslogon-default sas-viya-files-default sas-viya-folders-default sas-viya-preferences-default sas-viya-relationships-default sas-viya-transformations-default sas-viya-types-default sas-viya-appregistry-default sas-viya-audit-default sas-viya-collections-default sas-viya-comments-default sas-viya-credentials-default sas-viya-dataplans-default sas-viya-datasources-default sas-viya-deploymentBackup-default sas-viya-analytics-components-default sas-viya-analytics-flows-default sas-viya-analytics-localization-default sas-viya-analytics-pipelines-default sas-viya-analytics-validation-default sas-viya-annotations-default sas-viya-backup-agent-default sas-viya-businessrules-default   The same situation . with services  on another the servers - prog.viya.sas, stateful.viya.sas, controller.viya.sas   p.s  systemctl show sas-viya-all-services.service | grep ^Timeout TimeoutStartUSec=1h TimeoutStopUSec=1h ... View more

Hi, I am unable to start a new cas session in SASStudio Steps to reproduce the issue: 1.In the navigation pane, open the Snippets section. 2.Select Snippetsthen selectCloud Analytic Services. 3.Right-click New CAS Session and select Open. The snippet opens in the code editor. 4.In the toolbar, click the submit icon to run the New CAS Session code. ERROR: Connection failed. Server returned: Failed to launch session controller.: Failed to launch session controller. ERROR: Unable to connect to Cloud Analytic Services <cas-control server hostname> on port 5570. Verify connection parameters and retry.   Log /opt/sas/viya/config/var/log/cas/default/ on cas-control server shows the following error: see in screnshot     In this log I also can see that default system users such as sas.ops-agentsrv or sas.SASReportViewer can launch sessions  User that I am using exist in LDAP and I can log into cas-controller server as this user ... View more