Database table not getting updated

[Former Member]

Hi,

I am trying to update a Z-table in CRM. It has primary key of four columns. When I try to insert new record, ONLY SOMETIMES for few records it does not create new record, although it gives sy-subrc 0 on insertion. On repeating for same record many times it behaves same way, then as a last resort I have to create new entry manually.

What can be the reason for this ??

[Former Member]

Hi,

If it is a Z-Table , u have to create a Module pool program then u create a trnasaction fro this....based on this transaction u can upload what ever the records...

[Former Member]

But it does work fine for other records, only for a few records, it does not work. Please provide the reason not a workaround. Also, it woulld be a major change which would take time.

[former_member848108]

Hello Chitwanjit,

Do you use the "insert" or "modify" command to insert the new lines? If you are using the modify command, maybe some records are updated and there are fewer new records created than you have expected.

Hope it helps.

Ozcan.

[Former Member]

Hi ozcan

I am using the insert command. So I think it should work.

[former_member842213]

U might be having the records in the internal table. Use Statement wait 2 seconds inside the loop after your insert

Edited by: san on Jun 11, 2010 2:24 PM

[Former Member]

Hi San,

I have already put wait of 3 seconds. But for most records it does work, for some it does not. Is it that it might be open in some other t-code and there is lock on entry to be changed.

[Former Member]

Hello Mr. Singh

Insert command is working fine in this case. Check for the few records that are not being updated, There might be duplicate entries in it.

When we are using the Insert command if the duplicate entries are there only one is updated and sy-subrc = 0 in that case.

[Former Member]

Hi ,

Please read documentation for INSERT , it will behave differently when record with same primary key already aexists other than giving an error.

Rerards,

Uma Dave