ERROR:Not enough memory to get/set instance attribute OA_ACRONYM(2985) for "SCRIPT.TCELL".

[siddhu1]

Hi,
I tried to run the same program in EG, SAS STUDIO and Viya using the Proc report..

I get an error if the number of records in the dataset is over 50000, in running the proc report.

Earlier it used to run properly, now it is getting error. Below are the errors got:
ERROR:Not enough memory to get/set instance attribute OA_ACRONYM(2985) for "SCRIPT.TCELL".
ERROR:Even Stack Underflow. This is probably caused by mis-matched begin and end event calls.
ERROR:Fatal ODS error has occured. Unable to continue processing this output destination.
ERROR:Fatal ODS error has occured. Unable to continue processing this output destination.
ERROR:Even Stack Underflow. This is probably caused by mis-matched begin and end event calls.
ERROR:Fatal ODS error has occured. Unable to continue processing this output destination.
ERROR:Even Stack Underflow. This is probably caused by mis-matched begin and end event calls.
ERROR:Fatal ODS error has occured. Unable to continue processing this output destination.
ERROR:Fatal ODS error has occured. Unable to continue processing this output destination.
ERROR:Fatal ODS error has occured. Unable to continue processing this output destination.
Note: The SAS System stopped processing this step because of errors.

Could someone help on this?

Thanks in Advance,
Siddhu1

[sbxkoenk]

What is your ODS output destination?
Are you exporting to Excel by using the ODS EXCEL output destination?
See here if that's the case:

KB0036290 (SAS Knowledge Base article number 0036290)
An out of memory condition might occur when you use the ODS destination for Excel with large tables
https://sas.service-now.com/csm?id=kb_article_view&sysparm_article=KB0036290

To know about your current MEMSIZE setting, submit:

proc options option=memsize value; run;

Are you using ODS GRAPHICS ON statement?
Usage Note 44053: "Fatal ODS error has occurred" and "Requested function is not supported" errors might occur with the ODS GRAPHICS ON statement
https://support.sas.com/kb/44/053.html

Are you using DDE (Dynamic Data Exchange)?
Why your DDE programs don't work anymore
By Chris Hemedinger on The SAS Dummy October 14, 2014
https://blogs.sas.com/content/sasdummy/2014/10/14/dde-is-doa/

BR, Koen

[siddhu1]

Hi Koen,

Thanks for your response.
Excel (.xlsx)  is the output destination and this program is used to run successfully till last week and this week only it is giving problems. No updates/hot-fixes/patches were installed during this week.

Quick response would be highly appreciated.

Kind Regards,

Siddhartha

[sbxkoenk]

I think you need to contact Technical Support.
SAS Technical Support:
Here is a link for your convenience: https://support.sas.com/en/technical-support.html#contact
Make sure you provide them with the full ODS statement (details) you have in your code. i.e. With all style-elements and formatting that you use.

Other things you could try:

• Make sure you have the statement "ods graphics off;"
• Make sure you have the statement "ods _all_ close;" before your ODS EXCEL statement.
• What if your destination is listing (use "ods listing;" statement)?
• What if your destination is HTML (use "ods html;" statement)? Maybe better not to try with 50k+ observations. 🤔😨

I'd like to believe that nothing has changed in the environment / server, but perhaps the data sets are larger, or maybe there are still options lingering from previously executed code (what if you run that PROC REPORT to Excel in a fresh, just-started SAS session?).

BR, Koen