BookmarkSubscribeRSS Feed
Hercules
Fluorite | Level 6

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

1 REPLY 1
Amir
PROC Star

Hi,

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

Regards,

Amir.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1254 views
  • 0 likes
  • 2 in conversation