cancel
Showing results for 
Search instead for 
Did you mean: 

No.of Missing Tables and Indexes in BW system

former_member385596
Participant
0 Kudos

Hi All ,

in my production BW system we found 63 Missing Tables and Indexes. Could you please advise me.

Thanks ,

RAJU

Accepted Solutions (1)

Accepted Solutions (1)

Sriram2009
Active Contributor
0 Kudos

Hi Raju.

You have to check with your SAP BI function consultant guys to move forward those secondary indexes are required or not, Mostly it may not required.

Regards

SS

Answers (3)

Answers (3)

raymond_giuseppi
Active Contributor

Check

  • Is the Infoprovider active in this system (e.g. 0FITV_C01)
  • Is a process chain running (or aborted) which fills this Infoprovider ('Delete Index' was executed during execution but 'Create Index' was then not executed, or even removed from Process Chain)
    (Classic PC: Start/Delete Index/Load Data/Data Transfer Proc./Create Index/Initial Fill/Delete PSA)

You can then either: RSA1: change, activate the InfoProvider /or/ RSA1: manage, performance, recreate the indexes /or/ RSPCM: repair or repeat the last execution.

former_member385596
Participant
0 Kudos

Thank you all

p244500
Active Contributor
0 Kudos