Upload 15 million records into z-database

[Former Member]

Hi Experts;

The requirement is like 15 million records are to be inserted into the z-table from application server at a time in foreground. The Processing like insertion happens for the limited no. of records successfully but in the case of entire records i.e. 15 million records at a time, it shows an error like memory / buffer size problems.

Regards

Shashi

[Former Member]

Hi

I would suggest take the values in to a internal.

and insert records into ztable in blocks of 10000 and use commit work

Regards

Madhan

[Former Member]

Yes, I am taking it into an internal table but as we know max at a time 1.5 lacs data can be stored after the sap gives the short dump.

Regards

Shashi

[P561888]

Hi ,

First u want to upload more than the 1.5 lac records,, try to follow this way ...

1. create the Table maintain gen.

2. creat the tcode for the one.

3.Write the BDC program for this to upload .

Hope this will work..Try

Regards,

bharani

[Former Member]

Hi,

You need to insert batch by batch and commit aftre each batch. Trying to insert all the 15 million records in one stretch will surelu dump.

try out this code line:

data: low type i,

high type i,

blocksize i value 50000.

low = 1.

high = blocksize. 'any optimal value

do.

clear: lt_data_block.

append lines of lt_huge_data from low to high

to lt_data_block.

if lt_data_block is initial.

exit.

endif.

-

---

> put your insert statements form table lt_data_block

COMMIT WORK.

low = low + blocksize.

high = high + blocksize.

enddo.

This should work for you,

Poornima

[Former Member]

Hi,

Was your issue resolved with solution provided ? Please mention it , to bring the thread to its logical conclusion.

Regards, Poornima

[Former Member]

Hi:

Its still persists.

Regards

Shashi

[Former Member]

It is done by using balance method

[KK07]

Hi,

Can you Please elabarate the solution,as i am also facing the similar kind of requirement??