sas >> Thread creation failure?

by rong.guo » Sat, 23 Aug 2008 02:47:41 GMT

Hello,

I am running a very simple SAS program on unix and keep getting an
error message saying "Thread creation failure". I tested the same
program on Windows (on a data sample) and it worked fine. Has anyone
encountered the same error before?

I will greatly appreciate any help or suggestions on this issue!
Thanks!

For your reference, here is the SAS program i am running:

proc sql;
create table pos_sku as
select Xtra_card_nbr
,date_dt
,store_nbr
,visit_nbr
,a.sku_nbr
,sku_dsc
,subcat_dsc
,cat_dsc
,mdse_grp_dsc
from pos as a
left outer join sku as b
on a.sku_nbr=b.sku_nbr;
quit;


sas >> Thread creation failure?

by citam.sasl » Sat, 23 Aug 2008 05:57:08 GMT







Can you post the log please? I assume that will contain details, such as
whether you use SAS/Connect or have the Unix version of SAS.

-Kevin



Similar Threads

1. Error Message: Object creation failure & Thread execution failure

2. Error Message: Object creation failure & Thread execution fa ilure

Chank,

Did you search the SAS site, one hit was:

SN-009534
"Error: Object Creation Failure" message appears when running the SORT
procedure


----------------------------------------------------------------------------
----


   When you submit the SORT procedure in SAS 9, the following error
   message might appear:

       ERROR: Object Creation Failure.

   When someone logs into a machine and does not have write rights
   on the drive where the SAS Temporary files are written to, this error
   message appears.

   Have the administrator give write permissions for the user to that drive
   where the SAS Temporary files are being written to.


----------------------------------------------------------------------------
----
Product: Base SAS
Component: SORT procedure
Priority: N/A
Note Type: Usage Issue
Date: Wed, 16 Jul 2003
Release Reported v 9 TSM0

HTH

-----Original Message-----
From: chank [mailto: XXXX@XXXXX.COM ]
Sent: Monday, August 16, 2004 1:19 PM
To:  XXXX@XXXXX.COM 
Subject: Error Message: Object creation failure & Thread execution
failure


Hi,

I ran the same program and got two error messages. When I ran the
program today, I got an error message "Thread execution failure" and
in an earlier run, I got this error message "Object creation failure".
My program involves over 91,000 loops. The error occurs at the middle
of running the program. Both error occurs at the same location of the
program (after a proc means step) but in different loops. I use SAS
v9.0 in AIX 5.1 IBM UNIX. I wonder if someone have encountered these
two messages before. Does anyone knows what they mean?

Appreciate any help.

Thanks
--Kchan



NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements. This
may cause NOTE: No observations in data set.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.05 seconds
      cpu time            0.03 seconds


NOTE: There were 1 observations read from the data set WORK.PEST.
NOTE: The data set WORK.PEST has 1 observations and 18 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds


 9177 The SAS System
                          01:31 Monday, August 16, 2004


ERROR: Thread execution failure.
ERROR: Thread execution failure.
ERROR: Thread execution failure.



And earlier, I got this...

NOTE: There were 1 observations read from the data set WORK.PEST.
NOTE: The data set WORK.PEST has 1 observations and 18 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds



ERROR: Object creation failure.
ERROR: Object creation failure.
ERROR: Object creation failure.

3. Long running batch - ERROR, thread creation

4. Dr. Paul Allison to Present "Convergence Failures in Logistic Regression" May 14 via VirtualSUG

Dear Colleague:

I am pleased to invite you to the May 14 presentation by Dr. Paul
Allison of the University of Pennsylvania on "Convergence Failures in
Logistic Regression."  Dr. Allison is a noted expert in quantitative
research methods and the author of numerous books, including three
best-selling texts published by the SAS Press.

His 50-minute presentation will start at 10 am PST/1 pm EST on May 14.

Please visit the Virtual SAS(r) Users Group website at www.virtualsug.org
for more details about Dr. Allison's presentation as well as a link to
sign up to attend it.  Copies of both his paper and powerpoint
presentation slides are also available for free download from the
VirtualSUG web site.,

You may attend VirtualSUG presentations from any location where you
have access to a computer with high speed internet access and a
telephone line.  The audio portion of the presentation is accessed via
a telephone number that is supplied to you in your registration
confirmation email.  The cost for that phone call is whatever YOU pay
YOUR long distance provider for that service; VirtualSUG DOES NOT
charge any "extra fees" to attend our line presentations.

We don't yet have the ability to record VirtualSUG sessions for future
playback, so please join us for Dr. Allison's "live" presentation on
May 14!

And, check out the VirtualSUG web site often for updates to our
expanding roster of free, online, presentations for SAS Software
users!

Thanks,

Andrew Karp
Virtual SAS Users Group

5. Data type convertion failure

6. macro: implicit %eval failure?

Hi SAS-L,

Could someone tell me what might be the problem with

       %if &yymm not eq 197601 %then %do;

When I comment out this line (and corresponding %end), the macro runs
error free.

Thanks,

Michael Murff
Provo, UT


695  /* appends a zero to one digit months */
696  %macro twodgmn(month);
697
698      %if &month lt 10 %then 0&month;
699      %else &month;
700  %mend;
701
702  %let inIBESPath = c:\john\IBES\data\;
703  options symbolgen mlogic;
704  %macro RUreg(syr,eyr,smo,emo);
705
706      %do yr= &syr %to &eyr;
707          %do mm=&smo %to &emo;
708          %let yymm=&yr%twodgmn(&mm);
709              %do fpi=1 %to 2;
710                  %put FD&fpi&yymm;
711                  %put *&yymm*;
712                  %if &yymm not eq 197601 %then %do;
713                      %if &fpi eq 2 %then %do;
714                      %put PD&yymm;
715                      %end;
716                  %end;
717              %end;
718          %end;
719      %end;
720  %mend;
721
722  %RUreg(1976,1976,1,2);
MLOGIC(RUREG):  Beginning execution.
MLOGIC(RUREG):  Parameter SYR has value 1976
MLOGIC(RUREG):  Parameter EYR has value 1976
MLOGIC(RUREG):  Parameter SMO has value 1
MLOGIC(RUREG):  Parameter EMO has value 2
SYMBOLGEN:  Macro variable SYR resolves to 1976
SYMBOLGEN:  Macro variable EYR resolves to 1976
MLOGIC(RUREG):  %DO loop beginning; index variable YR; start value is
1976; stop value is 1976;
      by value is 1.
SYMBOLGEN:  Macro variable SMO resolves to 1
SYMBOLGEN:  Macro variable EMO resolves to 2
MLOGIC(RUREG):  %DO loop beginning; index variable MM; start value is 1;
stop value is 2; by
      value is 1.
MLOGIC(RUREG):  %LET (variable name is YYMM)
SYMBOLGEN:  Macro variable YR resolves to 1976
MLOGIC(TWODGMN):  Beginning execution.
SYMBOLGEN:  Macro variable MM resolves to 1
MLOGIC(TWODGMN):  Parameter MONTH has value 1
SYMBOLGEN:  Macro variable MONTH resolves to 1
MLOGIC(TWODGMN):  %IF condition &month lt 10 is TRUE
SYMBOLGEN:  Macro variable MONTH resolves to 1
MLOGIC(TWODGMN):  Ending execution.
MLOGIC(RUREG):  %DO loop beginning; index variable FPI; start value is
1; stop value is 2; by
      value is 1.
MLOGIC(RUREG):  %PUT FD&fpi&yymm
SYMBOLGEN:  Macro variable FPI resolves to 1
SYMBOLGEN:  Macro variable YYMM resolves to 197601
FD1197601
MLOGIC(RUREG):  %PUT *&yymm*
SYMBOLGEN:  Macro variable YYMM resolves to 197601
*197601*
SYMBOLGEN:  Macro variable YYMM resolves to 197601
ERROR: A character operand was found in the %EVAL function or %IF
condition where a numeric
       operand is required. The condition was: &yymm not eq 197601
ERROR: The macro RUREG will stop executing.
MLOGIC(RUREG):  Ending execution.

7. Rsubmit connection failure

8. PROC LIFEREG: Estimating Failure Time Distribution

Hi All,

The problem is as follows: I have a set of customers, who took their
first product on a particular month of a year. I have observed them over
a 12 month window to check if they have taken up a second product. My
problem is to find out, if the customer will take up a second product
and when.

While using PROC LIFEREG, the failure time distribution (Option DIST = blah
blah in PROC LIFEREG) I am estimating is not correct. Hence my predicted
survival probabilites are going haywire. I have tried out all the "DIST = "
options provided in SAS.

Is there anyway I can force fit the underlying failure time distribution
given that, I have the hazard function and survival function available to
me from the Life Tables using PROC LIFETEST.

Awaiting your answers.

Thanks
Nirmalya