topic Re: Short dump due to extract statement in Application Development and Automation Discussions

Short dump due to extract statement

Former Member — Tue, 15 Jan 2008 09:02:59 GMT

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.

Re: Short dump due to extract statement

Former Member — Tue, 15 Jan 2008 10:00:05 GMT

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.

Re: Short dump due to extract statement

Former Member — Tue, 15 Jan 2008 10:13:17 GMT

Hi,

Goto ST22 and analyze the dump.

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

Thanks,

Sandeep.

Re: Short dump due to extract statement

Former Member — Tue, 15 Jan 2008 11:50:15 GMT

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.

Re: Short dump due to extract statement

Former Member — Tue, 15 Jan 2008 11:52:19 GMT

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

Re: Short dump due to extract statement

Former Member — Tue, 15 Jan 2008 12:19:44 GMT

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

Re: Short dump due to extract statement

Former Member — Tue, 15 Jan 2008 12:21:08 GMT

Re: Short dump due to extract statement

Former Member — Tue, 15 Jan 2008 13:21:45 GMT

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.