Hello,
I'm trying to perform multiload in teradata but I'm getting some error in it.
The program I'm writing is very simple.
PROC SQL;
INSERT INTO TERA.TEST1 (FASTLOAD=YES)
SELECT * FROM ORA.TEST
WHERE YEAR(DATEPART(RCRE_TIME))=2002;
QUIT;
This part is working just fine. Because of the fast load. But when I'm writing this program for multiload I'm getting the following error.
PROC SQL;
INSERT INTO TERA.TEST1 (MULTILOAD=YES)
SELECT * FROM ORA.TEST
WHERE YEAR(DATEPART(RCRE_TIME))=2003;
QUIT;
ERROR: Create semaphore failed with return code 28.
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback information:
The SAS task name is [SQL (2) ]
Segmentation Violation
Traceback of the Exception:
/sasinst/SASHome/SASFoundation/9.3/sasexe/sas() [0x5165ad]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sas() [0x41e9f8]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sas() [0x41e6cf]
/sasinst/SASHome/SASFoundation/9.3/sasexe/tkmk.so(bkt_signal_handler+0x144) [0x7f011dd066e4]
/lib64/libpthread.so.0() [0x3c6b80f710]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sasiotra(trclose+0x1724) [0x7f00f0757e04]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sasxdbi(dbiclos+0x48) [0x7f00f122b878]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sasxdbi(yoeclos+0x18c) [0x7f00f11fc11c]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sasyoio(yoclose+0x9c6) [0x7f00deb441c6]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(+0x2be01) [0x7f00de744e01]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(+0x2b93b) [0x7f00de74493b]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(+0x2dc50) [0x7f00de746c50]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(sqxexec+0x5a0) [0x7f00de762210]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sassqx(sqlloop+0xf8a) [0x7f00de75af2a]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sassql(sassql+0x276) [0x7f00cf229e66]
/sasinst/SASHome/SASFoundation/9.3/sasexe/sas(vvtentr+0x104) [0x41e614]
/lib64/libpthread.so.0() [0x3c6b8079d1]
/lib64/libc.so.6(clone+0x6d) [0x3c6b4e8b6d]
SAS WTABORT (SQL (2)) The SAS System has detected an abort condition. An Exception occurred during wthtrm().
Please Contact Technical Support.
Tasks
[MAIN ] [WAITING ] pri[ 5] reb[14B315C0] WC[0] WN[1]
2 The SAS System 13:04 Tuesday, February 24, 2015
[IDLETASK] [READY ] pri[ 9] reb[14B315C0]
[EVENTTSK] [WAITING ] pri[ 0] reb[14B315C0] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[14B315C0] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[0E5FB0E0] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[0E5FB6A0] WC[0] WN[1]
[Object S] [WAITING ] pri[ 7] reb[0E5FBF90] WC[0] WN[1]
[DOSSCHT ] [WAITING ] pri[ 7] reb[0E5FBF90] WC[0] WN[1]
[OBJECT_E] [WAITING ] pri[ 7] reb[E409D260] WC[0] WN[1]
[DOSSCHT ] [WAITING ] pri[ 7] reb[0E5FBF90] WC[0] WN[1]
[ODX Moni] [WAITING ] pri[ 7] reb[E409D260] WC[0] WN[1]
[SASODR ] [WAITING ] pri[ 3] reb[DF212190] WC[0] WN[1]
[SQL (2) ] [RUNNING ] pri[ 7] reb[DF1685A0]
Traceback
No Traceback Available
ERROR: User asked for termination
