https://communities.sas.com/t5/SAS-Enterprise-Guide/ERROR-CLI-open-cursor-error-ERROR-reserve-exceeded-Out-of-memory/m-p/11097#M2654 This error is coming from SAS/ACCESS, perhaps via your ODBC driver to the database you are using.<BR /> <BR /> 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.<BR /> <BR /> Chris Wed, 16 Feb 2011 16:15:34 GMT ChrisHemedinger 2011-02-16T16:15:34Z https://communities.sas.com/t5/SAS-Enterprise-Guide/ERROR-CLI-open-cursor-error-ERROR-reserve-exceeded-Out-of-memory/m-p/11096#M2653 Hello,<BR /> <BR /> 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:<BR /> <BR /> 17 proc SQL;<BR /> 18 create table d_MTR as<BR /> 19 select a.*,<BR /> 20 case<BR /> 21 when a.DR_InsuranceType in (0,1) then "Ins "<BR /> 22 when a.DR_InsuranceType in (2) then "UnIns"<BR /> 23 else "Unk "<BR /> 24 end as Ins,<BR /> 25 case<BR /> 26 when a.DR_ProductID in (18411,18412,18413,18421,18422,<BR /> 27 18423,18431,18432) then 0 /* Nonconfirming */<BR /> 28 else 1 /* Confirming */<BR /> 29 end as conf label="1-Conf, 0-NonConf"<BR /> 30 from _l.LGD_MTR_SEP00_NOV10_N_SZ_110211_ as a<BR /> 31 left join _b.uvw_OrigBeacon_MTR as b on a.AccountID=b.AccountID<BR /> 32 where a.YearMonth=a.DISC_YYYYMM<BR /> 33 ;<BR /> ERROR: CLI open cursor error: ERROR: reserve exceeded : Out of memory <BR /> <BR /> NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.<BR /> 33 ! quit;<BR /> NOTE: The SAS System stopped processing this step because of errors.<BR /> NOTE: PROCEDURE SQL used (Total process time):<BR /> real time 0.65 seconds<BR /> cpu time 0.01 seconds<BR /> <BR /> Sincerely,<BR /> SPR Wed, 16 Feb 2011 15:01:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/ERROR-CLI-open-cursor-error-ERROR-reserve-exceeded-Out-of-memory/m-p/11096#M2653 SPR 2011-02-16T15:01:15Z https://communities.sas.com/t5/SAS-Enterprise-Guide/ERROR-CLI-open-cursor-error-ERROR-reserve-exceeded-Out-of-memory/m-p/11097#M2654 This error is coming from SAS/ACCESS, perhaps via your ODBC driver to the database you are using.<BR /> <BR /> 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.<BR /> <BR /> Chris Wed, 16 Feb 2011 16:15:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/ERROR-CLI-open-cursor-error-ERROR-reserve-exceeded-Out-of-memory/m-p/11097#M2654 ChrisHemedinger 2011-02-16T16:15:34Z