Dump due to large amount of data in the internal table

[Former Member]

Hi All,

I have a select statment which fetches data from a Z table.The data volume is more that 3 lakh records.Hence the system is giving dump 'No storage space available for extending table "IT_57".'

[Former Member]

Hi Rakesh,

This is just coz you have huge amount of data to be fetched. You can avoid this by using a stringent filtering criteria i.e. WHERE clause in your select query, to get only the required records from the data base.

Regards,

Kunjal

[Former Member]

then how can i fetch all the data in one internal table?

[bpawanchand]

Hi

Check this

Regards

Pavan

[Former Member]

You will not be able to do this. This will give you dump u run this report every time...

Regards,

K

[Subhankar]

Hi..

If your program goes to run in batch job please follow this.

Try to use primary fields in select query.

If you use it then change select statement into select endselect format.

Here performance is bad but memory consumption will low.

Here you fetch one record and process this record in a select endselect loop.

That's why memory consumption will low.

[vinod_vemuru2]

Hi Rakesh,

two ways.

1. Ask ur BASIS team to increase the memory level.

2. Check the PACKAGE SIZE option of select statement

Here u won't select all the data once but in packets of specified size. So get the packets of data and process.

Just press F1 on package size. That explanation will be enough to proceed further.

Thanks,

Vinod.

[Former Member]

HI,

try using background job.

Regards,

Purvesh Patel.

[Former Member]

PACKAGE SIZE option should normally work.

Thanks,

SKJ