Problem Note 69758: The error "Communication failure among CAS server nodes" occurs with PROC FEDSQL when you use the SELECT statement from an Impala data source
 |  |  |  |  |
If you execute the FEDSQL procedure with the SELECT * statement from an Impala data source in SAS® Cloud Analytic Services (CAS) on SAS® Viya® 3.5, error messages similar to the following can occur:
2022-09-23T17:22:25,395 ERROR [00000007] 7534 16885588212 51 [cassql.c:397] - A previous operation failed due to mismatched operations across the grid. Further operations can only be performed after the communicator is repaired.
2022-09-23T17:22:25,396 ERROR [00000007] 7534 16885588212 51 [cassql.c:398] - Communication failure among CAS server nodes.
2022-09-23T17:22:25,396 DEBUG [00000007] 7534 16885588212 51 [cassql.c:427] - CASSQL_CommFailure status 0x883ff027
2022-09-23T17:22:25,396 DEBUG [00000007] 7534 16885588212 51 [cassql.c:436] - CASSQL_CommFailure traceback:
/opt/sas/viya/home/SASFoundation/sasexe/casfedsql.so(tktraceback+0x47) [0x7fd4a9bfd217]
/opt/sas/viya/home/SASFoundation/sasexe/casfedsql.so(CASSQL_CommFailure+0x2a4) [0x7fd4a9bdf0a4]
2022-09-23T17:22:25,396 ERROR [00000007] 7534 16885588212 51 [cassql.c:398] - Communication failure among CAS server nodes.
2022-09-23T17:22:25,396 DEBUG [00000007] 7534 16885588212 51 [cassql.c:427] - CASSQL_CommFailure status 0x883ff027
2022-09-23T17:22:25,396 DEBUG [00000007] 7534 16885588212 51 [cassql.c:436] - CASSQL_CommFailure traceback:
/opt/sas/viya/home/SASFoundation/sasexe/casfedsql.so(tktraceback+0x47) [0x7fd4a9bfd217]
/opt/sas/viya/home/SASFoundation/sasexe/casfedsql.so(CASSQL_CommFailure+0x2a4) [0x7fd4a9bdf0a4]
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.5 | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-12-21 11:06:49 |
| Date Created: | 2022-12-13 03:10:02 |