Help using Base SAS procedures

Multiload error in teradata

Reply
Contributor
Posts: 72

Multiload error in teradata

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

Super Contributor
Posts: 282

Re: Multiload error in teradata

Hi,

If you haven't already, you might get a better response from Technical Support, as mentioned in the log.

Regards,

Amir.

Ask a Question
Discussion stats
  • 1 reply
  • 481 views
  • 0 likes
  • 2 in conversation