Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

"Sort has no Space in the Work Directory"

Received Response
2
Views
1
Comments
3156138
3156138 Rank 1 - Community Starter
edited Aug 13, 2024 7:08PM in Oracle Analytics Cloud and Server

Hi all,

I am running a query when I came across this error (after a good 30 minutes)

ODBC Error.png

I understand from online sources that this boils down to a lack of memory issue. However, I have ample memory (and my system did not show any issues when I was running this query).


In addition, the file mentioned here is a temp. file which disappears, so fixing the file itself cannot be done.


Can anybody advise on how this problem may be mitigated?

Answers

  • rmoff
    rmoff Rank 6 - Analytics Lead

    OBIEE is pulling back a LOT of data from the database, and has to dump it to disk when it can't store it all in memory.

    Get a bigger disk, or preferably reduce the amount of data you're getting OBIEE to ship around. Look at the number of rows back from the DB vs what goes back to the end user report, see if there's a reason in your RPD model why OBIEE can't push down the full query to the database. If you are pulling lots of data back to the end user, and there is no way to avoid that ... buy a bigger disk.