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!