Hello All,
All of my users that I support have reported that they cannot access one of their tables in SAS Enterprise Guide 7.2. They all appear to get a stack overflow error when trying to open the table. The program will freeze up for awhile and eventually spit out the error message
"SAS Enterprise Guide cannot open the data file: "ods finance.TRANSACTION_HISTORY". [Error] ORACLE execute error: ORA-01652: unable to extend temp segment by 8192 in tablespace ODSTEMP."
Anyone have any idea what a solution for this would be? I have little experience using SAS, so any input would be appreciated, thank you!
I believe that SAS is passing back an error message it is receiving when it accesses Oracle. I'm pretty sure the part that begins "ORA-01652" is the message that Oracle is passing back to SAS. It seems to be saying that it can't get the space it needs.
First, you could start with your SAS administrator. But most likely this will need to go to the Oracle Database Administrator.
There's almost certainly nothing you can do to solve this problem.
Tom
Some other comments on this Oracle error:
https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Error/m-p/56183/highlight/true#M5886
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.