program dump : TABLE_INVALID_INDEX

[Former Member]

Hi Gurus,

i am back with a problem - i am running the program in back ground which updates a z-table.

but the prog. has failed in background and gave dump reason as - TABLE_INVALID_INDEX.

kindly help me - if any one possible.

Advance Thanks

Harini

[Former Member]

Hello,

It means that when u are updating the index of the table is not properly mentioned.

Are u using modify / Insert command ?

Use modify command.

Please post ur entire code so that we can help u out.

Regards,

Deepu.K

[Former Member]

Hello Harini,

I think the problem with the internal table.

You are try to modify an internal table with invalid index.

check this.

Vasanth

[Former Member]

hi Harini,

You need to revist the SQL statement used to update the Z-table.

While trying to update modify a record, it is finding multiple records with the same key, that is the reason for this error.

You should provide the complete key (the primary keys) in the where condition when updating a record in the database.

Hope this helps,

Sajan Joseph.

[harishaginati]

hi,

1) try to use MODIFY rather then UPDATE when updating DB tables, update doesn't create new record.. which might have caused the problem,

2) check if you are trying to modify or inserting internal tables with wrong index.

3) if this doesn't solve your problem copy and paste the error message so that we can help u better.

4)debug in fourground and if everything is fine do debugging in background so that you can know exactly where it is making such errors...

cheers and award points if useful,

Harish