Short dump due to extract statement

[Former Member]

Hello friends,

I'm using EXTRACT statement in program to store the data.

It is working fine in Development server.But,it's giving short dump in Quality server.

The short dump msg is "Error writing the extracts to the temporary file."

Kindly sugggest on this issue.

Thank you.

[Former Member]

Hello friends,

I'm using EXTRACT statement in program to store the data.

It is working fine in Development server.But,it's giving short dump in Quality server.

The short dump msg is "Error writing the extracts to the temporary file."

Kindly sugggest on this issue.

Thank you.

[Former Member]

analyze the dump more carefully. it will tell you (i think) something about not enough space (left on device). obviously you have a lot more data in your QAS system. Two solutions: have your Basis adjust the space needed or refrain from using 'extract' as a method.

[Former Member]

Hi Friend,

Yes, you are right. here is detail abt error message.

The current ABAP/4 program was meant to sort a dataset (internal table or extract). For reasons of capacity, this was not possible due to insufficient main storage space. Therefore, the external sort was called and resulted in the following error:

The sytsem could not write the sorted file to the temporary file "/usr/sap/SQ4/DVEBMGS00/data/S00007KQ" (file size 16542818 bytes).

Error number: 28

Error text: "No space left on device"

Thank you.

Bharat.

[Former Member]

read my first answer please. it contains both: analysis and solution.

[Former Member]

Hi, could you pls suggest, For which file we need to ask to increase the size?

[Former Member]

space used here: usr/sap/SQ4/DVEBMGS00/data/

aks your basis guys for it. but careful. if your extract gets big enough they might not be able to help you any further.

[Former Member]

Hi,

Goto ST22 and analyze the dump.

It will surely give you some insights into the cause of error.

Thanks,

Sandeep.

[Former Member]

..