Problem Note 69638: An "Access violation" occurs when using an alterTable CAS action and specifying a variable name twice in a DROP= statement
In the following code snippet, the DROP= statement contains two instances of the make variable:
cas mySession sessopts=(caslib=casuser timeout=1800 locale="en_US");
libname mycas cas caslib=casuser;
data mycas.cars;
set sashelp.cars;
run;
proc casutil sessref=mySession;
altertable casdata="cars" incaslib="casuser"
rename="cars_2drop"
drop={"make","make","type"};
quit;
cas mySession terminate;
When you execute the code above, it generates an Access violation exception similar to the following in the SAS® Cloud Analytic Services (CAS) log:
022-06-29T14:06:46,288 INFO [00000007] 25029 irchum 19 [tkcasaimp.c:4504] - ++ action table.alterTable / name=' cars', caslib='CASUSER(userxyz)', rename='cars_2drop', label='Aletered CARS Table', drop={'make', 'make', 'type'};
2022-06-29T14:06:46,295 FATAL [00000007] 25029 irchum 19 [cas.c:161] - Exception in action.
2022-06-29T14:06:46,295 FATAL [00000007] 25029 irchum 19 [cas.c:163] - Access violation
2022-06-29T14:06:46,295 FATAL [00000007] 25029 irchum 19 [cas.c:188] - /opt/sas/viya/home/SASFoundation/sasexe/tk casdrv.so(tktracex+0x42) [0x7fa05fcb0612]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(exceptionHandler+0x266) [0x7fa05fc43f46]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bktExcept+0x51) [0x7fa06b6cb671]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bkt_signal_handler+0x154) [0x7fa06b6cbd14]
/lib64/libpthread.so.0(+0xf630) [0x7fa06cedd630]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasvar.so(+0x79f0) [0x7fa0572fb9f0]
/opt/sas/viya/home/SASFoundation/sasexe/tkcastab.so(DoAlterTable+0x2bc) [0x7fa05cd0cd8c]
/opt/sas/viya/home/SASFoundation/sasexe/tkcastab.so(AlterTable+0x532) [0x7fa05cd0b202]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasa.so(casaInvoke+0x2edf) [0x7fa0560a845f]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(HandleActionControllerThread+0xa75) [0x7fa05fc51f65]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(sktMain+0xf7) [0x7fa06b6c9527]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bktMain+0x78) [0x7fa06b6cb498]
/lib64/libpthread.so.0(+0x7ea5) [0x7fa06ced5ea5]
/lib64/libc.so.6(clone+0x6d) [0x7fa06c4c1b0d]
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
SAS System | SAS Viya | Microsoft® Windows® for x64 | 3.5 | Stable 2022.10 | Viya | Viya |
Linux for x64 | 3.5 | Stable 2022.10 | Viya | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2022-10-26 13:05:40 |
Date Created: | 2022-10-24 05:29:56 |