69638 - An "Access violation" occurs when using an alterTable CAS action and specifying a variable name twice in a DROP= statement

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

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
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

Support

Problem Note 69638: An "Access violation" occurs when using an alterTable CAS action and specifying a variable name twice in a DROP= statement

Operating System and Release Information