Re: Long running batch - ERROR, thread creation

Richard,

Could it be a simple "permissions" related problem? See, e.g.,
http://listserv.uga.edu/cgi-bin/wa?A...L=sas-l&P=5256

Art
----------
On Sat, 15 Sep 2007 21:21:48 -0400, Richard A. DeVenezia
<rdevenezia@WILDBLUE.NET> wrote:

>HW is Pentium 4 3.06 ghz w/1G ram.
>OS is Windows 2000 SP4, all windows updates.
>SAS is 9.1.3 SP4 (E9BX01). Some command line options of impact are -
bufno
>10 -noterminal -errorabend. Rest of system uses stock config settings.
>
>In a system for building a data warehouse, a long running batch program
>error abends with a less than helpful log message
> ERROR: Thread creation failure.
>
>The thread creation failed with in Proc SQL.
> MPRINT(<hidden>): proc sql;
> MPRINT(<hidden>): reset noprint;
> MPRINT(<hidden>): select sum(choice2 ne ' ') into :doChoice2 from
Q;
> MPRINT(<hidden>): create TABLE fmtQ as select '$qmessag' as
fmtname ,
>varname as start , message as label , ' ' as HLO , seq from Q UNION
select
>'$qchoice' as fmtname , varname as start , choice as label , 'S' as HLO
> , seq from Q UNION select '$qchoicB' as fmtname , varname as start ,
>choice2 as label , 'S' as HLO , seq from Q order by fmtname, seq ;
> NOTE: SAS threaded sort was used.
> ERROR: Thread creation failure.
> NOTE: Table WORK.FMTQ created, with 0 rows and 5 columns.
>
>The final goodbye note was
>----
>ERROR: SAS ended due to errors.
> You specified: OPTIONS ERRORABEND;.
>ERROR: Errors printed on page 12790.
>
>NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
>NOTE: The SAS System used:
> real time 3:05:13.42
> user cpu time 39:16.90
> system cpu time 28:48.03
> Memory 1789151k
>----
>
>Any ideas how to prevent this error ?
>
>
>--
>Richard A. DeVenezia