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
Hi,
If you haven't already, you might get a better response from Technical Support, as mentioned in the log.
Regards,
Amir.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.