topic Re: program dump : TABLE_INVALID_INDEX in Application Development and Automation Discussions

program dump : TABLE_INVALID_INDEX

Former Member — Thu, 10 May 2007 12:46:15 GMT

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 — Thu, 10 May 2007 12:48:20 GMT

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 — Thu, 10 May 2007 12:49:28 GMT

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 — Thu, 10 May 2007 12:51:25 GMT

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 — Thu, 10 May 2007 13:24:46 GMT

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