ERROR: CLI open cursor error: ERROR: reserve exceeded : Out of memory

[SPR]

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

[ChrisHemedinger]

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