Multiload error in teradata

Hercules — Tue, 24 Feb 2015 07:48:36 GMT

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

Re: Multiload error in teradata

Amir — Tue, 24 Feb 2015 12:54:15 GMT

Hi,

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

Regards,

Amir.

topic Multiload error in teradata in SAS Procedures

Multiload error in teradata

Re: Multiload error in teradata