Ztable not getting updated after reaching some limit

[chaitanya_mittapally]

Dear Experts,

We are updating the ztable by scheduling background job for a customized program on daily basis. We used modify statement in the program to update it.

But the problem is, up to 1,11,000+ records are getting updated and remaining records are not updated. We checked the technical settings of the ztable. The following are the details  

Data class           APPL1   Transaction data, transparent tables

Size category       9            Data records expected: 1,200,000 to 48,000,000

We are unable to find the reason because, the program will take more time to execute.

Please suggest.....

Thanks

Chaitanya M

[former_member1716]

Hi,

Check whether the recently added values are not getting added at all or is it replacing the older values.

Regards,

Satish

[TanmayVerma]

Hi Chaitanya,

The issue can be due to buffering if technical settings buffering is allowed.

Make sure the Buffering options are set to Buffering not allowed. As your table is getting updated frequently buffering should not be allowed.

Regards,

Tanmay.

[former_member195402]

Hi Chaitanya,

how are you updating your ZTABLE? Via

MODIFY ztable FROM wa.

in a LOOP or line by line with

MODIFY ztable FROM TABLE itab.

The 1st way might cause a lock table overflow.

Regards,

Klaus

[Former Member]

HI Chaitanya,

What is the primary key you are using for this? and what is the length of it ?

may be problem with the length of the primary key...

Regards,

Shony

[chaitanya_mittapally]

Dear All,

Thanks for your suggestions. I was able to find the error .There was a problem in variant creation for this program.

Thanks

Chaitanya M

[Former Member]

is it solved ?