DTP Error : TABLE_INVALID_INDEX

[S_Sriram]

Dear BW Experts,

Yesterday Basis did the system Upgrade successfully. I have restarted the process chain. While running DTPs are failing. As i checked the error, the message is Internal session terminated with a runtime error TABLE_INVALID_INDEX (see ST22). This error was occurring on 2 to 3 DTPs. Please find the below snap for your reference. There are some DTP routines written. There is no recent changes in DTP routine and this load is running from 2015 onwards. Please find the routine written in DTP.

form c_PSPID
tables l_t_range structure rssdlrange
using i_r_request type ref to IF_RSBK_REQUEST_ADMINTAB_VIEW
i_fieldnm type RSFIELDNM
changing p_subrc like sy-subrc.
* Insert source code to current selection field
*$*$ begin of routine - insert your code only below this line *-*
DATA: l_idx LIKE sy-tabix.
READ TABLE l_t_range WITH KEY
fieldname = 'PSPID'.
l_idx = sy-tabix.
DATA: lt_capex TYPE STANDARD TABLE OF /bic/tzm01capex,
ls_capex TYPE /bic/tzm01capex.
SELECT * FROM /bic/tzm01capex
INTO TABLE lt_capex.
LOOP AT lt_capex INTO ls_capex.
READ TABLE l_t_range WITH KEY
fieldname = 'PSPID'.
l_idx = sy-tabix.
l_t_range-low = ls_capex-/bic/zm01capex.
l_t_range-high = ''.
l_t_range-sign = 'I'.
l_t_range-option = 'EQ'.
APPEND l_t_range.
MODIFY l_t_range INDEX l_idx.
ENDLOOP.
p_subrc = 0.
*$*$ end of routine - insert your code only before this line *-*
endform.

Thanks.

[S_Sriram]

Hi Vincent

share the full dumps as a text file attachment.

Regards

SS

[former_member184624]

Hi Sriram,

Please find the atatched St22 log.

I found one OSS message 3059196 - Short dump TABLE_INVALID_INDEX during execution of DTP filter routine. But dont know how to implement. Here is the solution steps provided in the SAP Note.

Solution :

Filter routine needs to check for l_idx value before modifying directly. If l_idx is 0, the value must be Appended to range table instead of Modify.

This note provides an option to allow such routines by inserting an empty row already to l_t_range table such that l_idx is not 0. After the corrections of this note is implemented, please insert the corresponding DTP into RSBKADMIN as:

FIELD: <DTP_ID>

VALUE: DETERMINE_ROUTINES_LIKE_IPAK

To solve the issue please apply the Support Package as mentioned below. In urgent cases you can use the correction instructions.

Questions :

1. How to maintian the values in RSBKADMIN ?

2. what are the other steps need to do ?

Thanks.

st22.txt

[ThorstenHoefer]

Hi,

please check your code. You usean append and modify

APPEND l_t_range.
MODIFY l_t_range INDEX l_idx.

Try something like this:

tables l_t_range type atandart table of rssdlrange,
       wa_range like line of l_t_range.

delete l_t_range where fieldname = 'PSPID'.
wa_range-fieldname = 'PSPID'. 
wa_range-sign= 'I'. 
wa_range-option = 'EQ'. 

LOOP AT lt_capex INTO ls_capex.
  wa_range-low = ls_capex-/bic/zm01capex.
  insert wa_range into table l_t_range.
endloop.