Cannot write onto Disk for the file OS Error: <No space left on device>

[Former Member]

Hi,

Getting below error in a job in BODS 4.1 although the drive has 20 GB free space:
Cannot write onto Disk for the file <X:\DSLogs\pCache/repo_local/378121Sort28_11832_5>. OS Error:                                   <No space left on device>

The job has order by in Query transform and processes 70 million records. We have used Data_Transfer transform before order by to push down to DB but still we are getting the above error.
Earlier we have run this job successfully.

Can anyone please help on how to increase pCache size or anything else that should be checked for this error?

[former_member187605]

It might be the sort is not pushed to the db. Can you double-check the generated SQL?