SUPPORT / SAMPLES & SAS NOTES
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 | ||