BookmarkSubscribeRSS Feed
SPR
Quartz | Level 8 SPR
Quartz | Level 8
Hello,

This morning I've got the following error in EG 4.3. Yesterday the same code did not produce any errors. I put the trouble code into separate project with the same error result. The LOG and error is below:

17 proc SQL;
18 create table d_MTR as
19 select a.*,
20 case
21 when a.DR_InsuranceType in (0,1) then "Ins "
22 when a.DR_InsuranceType in (2) then "UnIns"
23 else "Unk "
24 end as Ins,
25 case
26 when a.DR_ProductID in (18411,18412,18413,18421,18422,
27 18423,18431,18432) then 0 /* Nonconfirming */
28 else 1 /* Confirming */
29 end as conf label="1-Conf, 0-NonConf"
30 from _l.LGD_MTR_SEP00_NOV10_N_SZ_110211_ as a
31 left join _b.uvw_OrigBeacon_MTR as b on a.AccountID=b.AccountID
32 where a.YearMonth=a.DISC_YYYYMM
33 ;
ERROR: CLI open cursor error: ERROR: reserve exceeded : Out of memory

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
33 ! quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.65 seconds
cpu time 0.01 seconds

Sincerely,
SPR
1 REPLY 1
ChrisHemedinger
Community Manager
This error is coming from SAS/ACCESS, perhaps via your ODBC driver to the database you are using.

I'm not sure what would cause it to suddenly stop working, but you might try adding an OBS limit on the table references to see if you can get it to work with a smaller set...to help debug it.

Chris
Check out SAS Innovate on-demand content! Watch the main stage sessions, keynotes, and over 20 technical breakout sessions!

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 3660 views
  • 0 likes
  • 2 in conversation