Problem with INSERT

[Former Member]

Hi,

I am inserting records from an internal table to a Z table, in my report.

Its working fine in development server but in production it goes to short dump and gives error discription as record already exists with the same key.

But when I check the table entries, there are no records in that Z table.

Please help me solve the problem.

Thanks,

Sai.

[Former Member]

Use MODIFY instead of INSERT.

Regards

Kannaiah

[Former Member]

do check the table attributes in the other server..weather the table maintanace is allowed or not..if not chenge that to allowed and that solves your problem.

regards,

babu

[Former Member]

Hi babu,

I have checked the table attributes, here the display maintanance is allowed.

Thanks,

Sai.

[Former Member]

Hi,

goto SE14 save and adjust the z table and again try to insert..

[Former Member]

I have adjusted the object, but still I get above problem.

[Former Member]

it is better to use the UPDATE for this

[Former Member]

Use MODIFY ..

or if UR using Insert use .. the addition

ACCEPTING DUPLICATE KEYS..

[former_member8532]

Hi ,

check the field that you are updating set as primary key in your table.

if it is a primary key just remove that primary key on field.

i got the same problem .

Edited by: Punit Pawar on Jul 11, 2008 11:01 AM