REQEXHAUST error mesage in proc sql

Reply
Occasional Learner
Posts: 1

REQEXHAUST error mesage in proc sql

I am using proc sql to pull records from Teradata into a SAS data set.  Sometimes, I get this error, sometimes, I do not.  What does the following message mean?

 

ERROR: Teradata row not delivered (trget): CLI2: REQEXHAUST(307): Request data exhausted. .
NOTE: Compressing data set MYTESTDATASET decreased size by 30.91 percent.
      Compressed is 1817527 pages; un-compressed would require 2630728 pages.

ERROR: ERROR: Commit: Session forced off by PMPC or gtwglobal or security violation.
    ROLLBACK has been issued (Any rows processed after the last COMMIT are lost).

 

Here is a snippet of the code:

 

proc sql;
connect to TERADATA (user = "XXXXXXX" password = "&password" server=XXXX mode=teradata);

create table MYTESTDATASET as

select patron_id,
       ,join_date format=monyy7. as membership_date
       ,(case when member_age LE 18 then 1 else 0 end) as youth_discount
from abcd.GYM_MEMBERSHIP
where join_date between '01jan2010'd and '30jun2010'd
;

disconnect from TERADATA;

 

Even with the error message, a data set is created, with approximately 1.5 billion records.

 

I am using SAS v9.3.

 

Please advise.  Thank you.

 

Respected Advisor
Posts: 4,173

Re: REQEXHAUST error mesage in proc sql

Looks to me like you best raise a SAS Tech Support track for this one.

https://support.sas.com/techsup/contact/ 

 

Let us know how you go.

 

Valued Guide
Posts: 2,177

Re: REQEXHAUST error mesage in proc sql

In the code provided I don't see where the connection is used (I see only where it is made)
Ask a Question
Discussion stats
  • 2 replies
  • 290 views
  • 0 likes
  • 3 in conversation