Transaction DB02 => Missing Tables and Indexes shows under Secondary indexes from package $tmp

[behlau_carlos]

Hi SAP Gurus,

I noticed on our SAP business warehouse (BW) system (NetWeaver 7.0 based on AIX/Oracle 11g) in transaction DB02 => Diagnostics => Missing Tables and Indexes under Secondary indexes, 26 indexes, in package $tmp:

The indexes are defined, but they don't have been created on the database.

When I try to create them via the database tool, I am getting the warning:

Does the warning raise up, because they where defined in the $tmp package?

I was looking in SAP notes for a solution for this "warning" concerning the /BIC/F-Indexes but I didn't found yet anything helpful ...

Thanks for your help and ideas ...

Best regards

Carlos

[Reagan · Accepted solution]

These are secondary indexes associated with the Fact tables of an infocube. You do not create secondary indexes like you create indexes for other BW tables or database tables using SE14.

It is not necessarily a problem If Tx DB02 reports them as missing.

Most of the times the BW specialists repair these indexes from Tx RSA1 if the index is really required.

There is an SAP note addressing this situation and what can be done

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

Regards

RB

[behlau_carlos · Accepted solution]

Hi Benjamin,

thanks for your help.

We are having also a BW 3.x system, where we had the same situation.

We where able to solve the situation within SAP note 401242.

Is it possible also to run SAP_INFOCUBE_INDEXES_REPAIR on SAP BW 7.x or is it recommended to create the index via RSA1?

Best regards

Carlos

[Reagan · Accepted solution]

Hello Carlos

If the report is available I would try to run it and see if that helps. According to the SAP note 157918 - BW: DB02 shows "missing indexes" the report is available from BW 2.0B patch 3 onwards.

If that doesn't help then follow the initial note I have suggested.

Good Luck

RB

[behlau_carlos · Accepted solution]

Hi Benjamin,

the report is available and after running it all in DB02 is back to green

Thanks for helping me.

Best regards

Carlos

[former_member188883]

Hi Carlos,

These are secondary indexes created during process chains in BI to improvise performance.

You may refer below SCN blogs on creation of these indices in BI.

Hope this helps.

Regards,

Deepak Kori