"Sort has no Space in the Work Directory"

Question

Hi all,

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

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?

rmoff · Answer

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.