Problem Note 68026: The addTable actions that append data for CAS tables might produce an exception in the CAS server log
 |  |  |  |  |
The addTable actions that append data to SAS® Cloud Analytic Services (CAS) tables might produce an exception in the CAS server log. The problem can be observed more frequently with SAS® Viya® extract, transform, load (ETL) jobs that append data to tables in the SystemData caslib.
Here is an example of an addTable action executing on a SystemData table and its resulting error:
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcasaimp.c:4504] - ++ action table.addTable / table='postgres_table_size', caslib='SYSTEMDATA', vars={{name='datetime', length=8, rType='NUMERIC', offset=0, formattedLength=22, format='DATETIME', nfl=22, nfd=0}, {name='shift', label='Work Shift (based on local time)', length=8, rType='NUMERIC', offset=8, formattedLength=9, format='SHIFTTXT', nfl=0, nfd=0}, {name='tzoneoff', length=8, rType='NUMERIC', offset=16, formattedLength=12, nfl=0, nfd=0}, {name='deploymentid', length=255, rType='CHAR', offset=24, formattedLength=255, nfl=0, nfd=0}, {name='tenantid', length=255, rType='CHAR', offset=280, formattedLength=255, nfl=0, nfd=0}, {name='machine', length=256, rType='CHAR', offset=536, formattedLength=256, nfl=0, nfd=0}, {name='consulnodename', length=256, rType='CHAR', offset=792, formattedLength=256, nfl=0, nfd=0}, {name='resourcetype', length=32, rType='CHAR', offset=1048, formattedLength=32, nfl=0, nfd=0}, {name='resourceid', length=500, rType='CHAR', offset=1080, formattedLength=500, nfl=0, nfd=0}, {name='IndexSize', length=...
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcastaba.c:4258] - Accessed global table POSTGRES_TABLE_SIZE loaded in caslib SystemData.
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcastabi.c:12145] - Created session table POSTGRES_TABLE_SIZE in caslib SystemData.
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcastaba.c:10887] - Appending global table POSTGRES_TABLE_SIZE loaded in caslib SystemData.
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcasaimp.c:6460] - -- 'table.addTable' SUCCESSFUL.
FATAL [00023751] MAIN sas.ops-agentsrv 2132 [cas.c:161] - Exception in action.
FATAL [00023751] MAIN sas.ops-agentsrv 2132 [cas.c:163] - Access violation
FATAL [00023751] MAIN sas.ops-agentsrv 2132 [cas.c:188] - /opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(tktracex+0x42) [0x7f48145ca612]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(exceptionHandler+0x266) [0x7f481455df46]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bktExcept+0x51) [0x7f4820973671]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bkt_signal_handler+0x154) [0x7f4820973d14]
/usr/lib64/libpthread.so.0(+0xf5e0) [0x7f482217a5e0]
/opt/sas/viya/home/SASFoundation/sasexe/tkcastab.so(MakeMappedLargeBlockIndexDesc+0xe7) [0x7f480f99e0b7]
/opt/sas/viya/home/SASFoundation/sasexe/tkcastab.so(+0x5de27) [0x7f480f86ae27]
/opt/sas/viya/home/SASFoundation/sasexe/tkcastab.so(+0x5847b) [0x7f480f86547b]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(+0x2d5e8) [0x7f48145795e8]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(+0x39329) [0x7f4814585329]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(+0x36638) [0x7f4814582638]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(sktMain+0xf7) [0x7f4820971527]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bktMain+0x78) [0x7f4820973498]
/usr/lib64/libpthread.so.0(+0x7e25) [0x7f4822172e25]
/usr/lib64/libc.so.6(clone+0x6d) [0x7f482176334d]
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcastaba.c:4258] - Accessed global table POSTGRES_TABLE_SIZE loaded in caslib SystemData.
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcastabi.c:12145] - Created session table POSTGRES_TABLE_SIZE in caslib SystemData.
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcastaba.c:10887] - Appending global table POSTGRES_TABLE_SIZE loaded in caslib SystemData.
INFO [00000007] 39698 sas.ops-agentsrv 2132 [tkcasaimp.c:6460] - -- 'table.addTable' SUCCESSFUL.
FATAL [00023751] MAIN sas.ops-agentsrv 2132 [cas.c:161] - Exception in action.
FATAL [00023751] MAIN sas.ops-agentsrv 2132 [cas.c:163] - Access violation
FATAL [00023751] MAIN sas.ops-agentsrv 2132 [cas.c:188] - /opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(tktracex+0x42) [0x7f48145ca612]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(exceptionHandler+0x266) [0x7f481455df46]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bktExcept+0x51) [0x7f4820973671]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bkt_signal_handler+0x154) [0x7f4820973d14]
/usr/lib64/libpthread.so.0(+0xf5e0) [0x7f482217a5e0]
/opt/sas/viya/home/SASFoundation/sasexe/tkcastab.so(MakeMappedLargeBlockIndexDesc+0xe7) [0x7f480f99e0b7]
/opt/sas/viya/home/SASFoundation/sasexe/tkcastab.so(+0x5de27) [0x7f480f86ae27]
/opt/sas/viya/home/SASFoundation/sasexe/tkcastab.so(+0x5847b) [0x7f480f86547b]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(+0x2d5e8) [0x7f48145795e8]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(+0x39329) [0x7f4814585329]
/opt/sas/viya/home/SASFoundation/sasexe/tkcasdrv.so(+0x36638) [0x7f4814582638]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(sktMain+0xf7) [0x7f4820971527]
/opt/sas/viya/home/SASFoundation/sasexe/tkmk.so(bktMain+0x78) [0x7f4820973498]
/usr/lib64/libpthread.so.0(+0x7e25) [0x7f4822172e25]
/usr/lib64/libc.so.6(clone+0x6d) [0x7f482176334d]
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 | 3.5 | Viya | 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: | 2021-06-08 14:34:41 |
| Date Created: | 2021-06-08 10:11:02 |