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]
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 | Linux for x64 | 3.5 | 3.5 | 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.