Problem Note 69639: The SASFMT table property is not applied to all columns and a segmentation violation occurs when reading a Databricks table
 |  |  |  |  |
When a large number of SASFMT table properties are associated with a Spark table, some of these table properties are not applied when you read the table with SAS/ACCESS® Interface to Spark. Instead, the columns have the default length. You can see this by running PROC CONTENTS.
If a large number of SASFMT table properties are associated to a Spark view, an exception similar to the following is generated:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [CONTENTS]
Segmentation Violation
Traceback of the Exception:
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sas(+0x17d5fe) [0x5626057065fe]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sas(+0x503fe) [0x5626055d93fe]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x14b) [0x7fc4ddd012db]
/lib64/libpthread.so.0(+0x38f720f7e0) [0x7fc4df6227e0]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasiosk(__intel_avx_rep_memcpy+0x2b4) [0x7fc4826ac334]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasiosk(+0x76520) [0x7fc482690520]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasiosk(+0x72a86) [0x7fc48268ca86]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasiosk(hdprep+0xe4e) [0x7fc48268af8e]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxdbi(dbidsci+0xd9) [0x7fc49f461859]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxdbi(yoeopen+0x12d5) [0x7fc49f42e155]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasyoio(yyoopen+0x323d) [0x7fc48ddb207d]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasyoio(yoopen+0x212) [0x7fc48ddae9e2]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxshel(+0x707ee) [0x7fc4c8d487ee]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxshel(+0x68755) [0x7fc4c8d40755]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxshel(ysprstm+0xcb0) [0x7fc4c8d4c3d0]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxshel(yspproc+0x3d4) [0x7fc4c8d4cc74]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasqutil(sasqutil+0x3e9) [0x7fc47fb6c3b9]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sas(vvtentr+0x17f) [0x5626055d8fbf]
/lib64/libpthread.so.0(+0x38f7207aa1) [0x7fc4df61aaa1]
/lib64/libc.so.6(clone+0x6d) [0x7fc4deca8c4d]
SAS WTABORT (CONTENTS (2)) The SAS System has detected an abort condition. An Exception occurred during wthtrm().
Please Contact Technical Support.
Tasks
[MAIN ] [WAITING ] pri[ 5] reb[D3369320] WC[0] WN[1]
[IDLETASK] [READY ] pri[ 9] reb[D3369320]
[EVENTTSK] [WAITING ] pri[ 0] reb[D3369320] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[D3369320] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[C8061AA0] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[C8062140] WC[0] WN[1]
[Object S] [WAITING ] pri[ 7] reb[C8062BC0] WC[0] WN[1]
[DOSSCHT ] [WAITING ] pri[ 7] reb[C8062BC0] WC[0] WN[1]
[DOSSCHT ] [WAITING ] pri[ 7] reb[C8062BC0] WC[0] WN[1]
[OBJECT_E] [WAITING ] pri[ 7] reb[C80D3600] WC[0] WN[1]
[SASLPXAM] [READY ] pri[ 7] reb[C80D3600]
[SASODR ] [WAITING ] pri[ 3] reb[A8056DC0] WC[0] WN[1]
[ODX Mntr] [READY ] pri[ 7] reb[C80D3600]
[CONTENTS] [RUNNING ] pri[ 7] reb[8FC87580]
Traceback
No Traceback Available
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 2.70 seconds
cpu time 0.00 seconds
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [CONTENTS]
Segmentation Violation
Traceback of the Exception:
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sas(+0x17d5fe) [0x5626057065fe]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sas(+0x503fe) [0x5626055d93fe]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/tkmk.so(bkt_signal_handler+0x14b) [0x7fc4ddd012db]
/lib64/libpthread.so.0(+0x38f720f7e0) [0x7fc4df6227e0]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasiosk(__intel_avx_rep_memcpy+0x2b4) [0x7fc4826ac334]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasiosk(+0x76520) [0x7fc482690520]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasiosk(+0x72a86) [0x7fc48268ca86]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasiosk(hdprep+0xe4e) [0x7fc48268af8e]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxdbi(dbidsci+0xd9) [0x7fc49f461859]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxdbi(yoeopen+0x12d5) [0x7fc49f42e155]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasyoio(yyoopen+0x323d) [0x7fc48ddb207d]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasyoio(yoopen+0x212) [0x7fc48ddae9e2]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxshel(+0x707ee) [0x7fc4c8d487ee]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxshel(+0x68755) [0x7fc4c8d40755]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxshel(ysprstm+0xcb0) [0x7fc4c8d4c3d0]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasxshel(yspproc+0x3d4) [0x7fc4c8d4cc74]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sasqutil(sasqutil+0x3e9) [0x7fc47fb6c3b9]
/sas/software/SASHome94/SASFoundation/9.4/sasexe/sas(vvtentr+0x17f) [0x5626055d8fbf]
/lib64/libpthread.so.0(+0x38f7207aa1) [0x7fc4df61aaa1]
/lib64/libc.so.6(clone+0x6d) [0x7fc4deca8c4d]
SAS WTABORT (CONTENTS (2)) The SAS System has detected an abort condition. An Exception occurred during wthtrm().
Please Contact Technical Support.
Tasks
[MAIN ] [WAITING ] pri[ 5] reb[D3369320] WC[0] WN[1]
[IDLETASK] [READY ] pri[ 9] reb[D3369320]
[EVENTTSK] [WAITING ] pri[ 0] reb[D3369320] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[D3369320] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[C8061AA0] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[C8062140] WC[0] WN[1]
[Object S] [WAITING ] pri[ 7] reb[C8062BC0] WC[0] WN[1]
[DOSSCHT ] [WAITING ] pri[ 7] reb[C8062BC0] WC[0] WN[1]
[DOSSCHT ] [WAITING ] pri[ 7] reb[C8062BC0] WC[0] WN[1]
[OBJECT_E] [WAITING ] pri[ 7] reb[C80D3600] WC[0] WN[1]
[SASLPXAM] [READY ] pri[ 7] reb[C80D3600]
[SASODR ] [WAITING ] pri[ 3] reb[A8056DC0] WC[0] WN[1]
[ODX Mntr] [READY ] pri[ 7] reb[C80D3600]
[CONTENTS] [RUNNING ] pri[ 7] reb[8FC87580]
Traceback
No Traceback Available
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 2.70 seconds
cpu time 0.00 seconds
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Spark | Linux for x64 | 9.4 | 9.4 | 9.4 TS1M7 | 9.4 TS1M8 |
A fix for this issue for SAS/ACCESS Interface to Spark 9.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K4W.html#69639A fix for this issue for SAS/ACCESS Interface to Hadoop 9.47 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J8A.html#69639| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-10-25 15:39:32 |
| Date Created: | 2022-10-24 06:25:34 |