SAP Knowledge Base Article - Preview

2028845 - Inconsistent logical indexes - BWA

Symptom

In SAP BW Accelerator (BWA) under transaction RSDDBIAMON there are inconsitent logical Indexes of an InfoObject present:

Check for missing index parts 
Not all parts of the logical index exist 
0bw:bia:p5a:zmaejvlsf [['0bw:bia:p5a:ba0_pcoorder', 'Index is part of a logical index but do not exist']] 
Delete (and recreate) the inconsistent index(es) 
delete_inconsistent_index

When executing report RSDDTREX_SINGLE_TABLE_INDEX in transaction SE38 for the affected InfoObject, the following short dump will be raised in transaction ST22:

Category               ABAP Programming Error
Runtime Errors         MESSAGE_TYPE_X
ABAP Program           SAPLRSDDTREX
Application Component  BW-BEX-OT
Date and Time          10.06.2014 12:59:26
>>>
Information on where terminated
    Termination occurred in the ABAP program "SAPLRSDDTREX" - in
     "RSDDTREX_SINGLE_TABLE_INDEX".
    The main program was "RSDDTREX_SINGLE_TABLE_INDEX ".

    In the source code you have the termination point in line 39
    of the (Include) program "LRSDDTREXU03".
 
    36   READ TABLE l_r_obj->n_t_tables WITH TABLE KEY tablnm = i_tablnm
   37       INTO l_s_tables.
   38   IF sy-subrc <> 0.
>>>>>     MESSAGE x100(rsd_trex) WITH 'TABLE NOT IN INDEX'.


Read more...

Environment

SAP NetWeaver BW Accelerator 7.20

Keywords

BIA, SAP NetWeaver BI Accelerator, TREXADMIN, SAP HANA/BWA Index Maintenance, delete_inconsistent_index, technical name, rsddb, sm37, bw_tr_rsddb_biaindex_fill, 720, accelerator , KBA , BC-TRX-BIA , TREX BI Accelerator , BW-BEX-OT-BIA , BW Accelerator , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.