LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (June 2008, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 10 Jun 2008 14:41:31 -0400
Reply-To:     SUBSCRIBE SAS-L Tom Smith <tomquin99@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SUBSCRIBE SAS-L Tom Smith <tomquin99@GMAIL.COM>
Subject:      sas Fast Export facility failed

I use dbsliceparm=all in libname to triger FastExport utility, and use sleep & tenacity options to keep SAS retrying the process if fastExport fails because the maximum number of allowed load operations are already running. Can somebody figure out what is the possible reason that made the utility fail ? Here is the log, 1 LIBNAME outlib '/abc/def/ghi/'; NOTE: Libref FILEOUT was successfully assigned as follows: Engine: V9 Physical Name: /abc/def/ghi/ 2 LIBNAME US100 teradata server=TERA01 user=myusrid password=XXXXXXXX 3 schema=US100 logdb=US100 dbsliceparm=all; NOTE: Libref US100 was successfully assigned as follows: Engine: TERADATA Physical Name: TERA01 4 %macro mymacro; 5 %if %sysfunc(exist(US100.myfile))=1 6 %then %do; 7 data outlib.myfile; 8 set US100.myfile (sleep=5 tenacity=2); 9 run; 10 %end; 11 %mend;

ERROR: FastExport either failed before connecting to SAS or timed out before invoking the access module.

Thanks a lot!

Back to: Top of message | Previous page | Main SAS-L page