Secondary Index Missing in DB02 Alerts.

[Former Member]

Dear all,

While monitoring the Alerts in DB02, Alert Monitor --> Under the alert tree nodes, SAP consistency --> Objects missing in database --> Secondary Indexes missing  prompts in red from a very long period.

When trying to check that node in detail, I`m getting a message like "Detailed view not available".

Could some one please tell me why this error was occurring and how to resolve that Node.

I`m attaching a screen shot for your reference.

Thanks in Advance.

Regards,

Vamc.

[Former Member]

Hi Vamsi,

The secondary indexes will be dropped in BI systems usually, you can also rebuild them in DB02.

If it did not work try to build it from DB20 or using brtools.

If it is a Z index you can build them using SE14.

Thanks,

Pavan

[Former Member]

Hi Vamsi,

I guess its a BW system, go to the tcode DB02OLD there you can find a button missing indexes click it.

By clicking on the secondary indexes press Ctrl+F2 the index will be rebuilt.

Thanks,

Pavan

[Former Member]

Hey Pavan,

Yes it`s a BW system, DB02OLD this functionality is not supported by our system.

Could you please suggest any other solution.

Thanks

vamsi.

[Reagan]

Have you checked the notes I have provided you ?

RB

[Sriram2009]

Hi Vamsi

1. If possible find the table information and them check with BI function consolutentant.

2. Just check this SAP Note - 1751219 - DB02: Missing secondary indexes

BR

SS

[Reagan]

Is this a BW system ? if yes then follow these SAP notes

1820508 - Missing secondary indexes for infocubes in transaction DB02 > Missing Tables and Indexes

157918 - BW: DB02 shows "missing indexes"

Regards

RB