Skip to Content

MIssing secondary index for DSO

Hello Experts ,

I have noticed recently a missing secondary index when refreshing DB02 TCODE.Wich impact the performance data loading from this DSO to others infocubes.

to fix this issue I have schueled the report SAP_INFOCUBE_INDEXES_REPAIR to rebuild daily the all missing secondary index .

But unfounthly , some times I get the missing secondary in the middle of the night after the execution the above report .hence . the data loading is impacted

Do you have eplease any idea regarding the root cause of the missing secondary index?

Any alternate solution to avoid this situation?

Many thanks in advance for your help.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Posted on Sep 25, 2018 at 12:17 PM

    Do you delete/create a indexes for cube (by process "Delete index"/"Build index") when you loading data by process chain? Before loading you must delete indexes and after loading you must build indexes. Check help:

    Add comment
    10|10000 characters needed characters exceeded