SAS Enterprise Guide Oracle Error

[Shwoozy]

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!

[TomKari]

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

[Shwoozy]

I had a feeling it would likely be out of my control. I have contacted the database admin and we will go from there, thanks for the input!

[ballardw]

Some other comments on this Oracle error:

https://communities.sas.com/t5/SAS-Enterprise-Guide/Query-Error/m-p/56183/highlight/true#M5886