cancel
Showing results for 
Search instead for 
Did you mean: 

Problem about Indexes missing in the database

Former Member
0 Kudos

Dear all,

We found a missing index in DB02 view of our sap system.

This missing index is a Secondary index,

and its name is S509-VAB.

We tried to create it in DB, but got below error log as below:

Index S509~VAB could not be set up in the database

Message no. DI 006

Diagnosis

It was not possible to create the index in the database.

This could be caused by the fact that an index with the same name exists in the database, but it is unknown to the ABAP/4 Dictionary. Activating the index in the ABAP/4 Dictionary is possible, but it is not possible to create it in the database.

Procedure

For more information about the cause of the error, analyze the SQL error messages in this log.

Our question is How to Activate the index in the ABAP/4 Dictionary?

Anyone experienced,

Please kindly give advice.

Regards,

Allen

Accepted Solutions (1)

Accepted Solutions (1)

former_member188883
Active Contributor
0 Kudos

Hi,

We found a missing index in DB02 view of our sap system. This missing index is a Secondary index, and its name is S509-VAB.

S509 is an infostructure table which is maintained using a maintenence view in SM30. Could you please check where exactly the index is missing. Is it in the R3 repository or SAP database.

In db02 you can perform DB<-> R3 consistency check.

Also since it is an infostructure index, it would not cause much issue in the performance.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

In db02 we perform DB<-> R3 consistency check,

and find that exactly the index is missing in the SAP database.

So we can't maintain it in SM30.

How should we do in this situation?

You mentioned it is an infostructure index, it would not cause much issue in the performance.

Is it means we should ignore this index missing?

Regards,

Allen

former_member188883
Active Contributor
0 Kudos

Hi Allen,

S509 is an information structure table. Data is populated into it post we do some necessary cutomizing and is mainly used for reporting purpose. I do not know what reports you are generating out of this. Hence difficult to say whether you can ignore this missing index or not.

I would suggest you to do the following

In se14, type the table name S509.

Go to indexes tab. Look for the list of indexes defined.

Select the index name VAB ( Which is missing in your case ).

1) check the status of this index ? Does it says "exists in database"

2) If point 1 is not valid then , select the option create in database button and create the index in the database.

Regards,

Deepak Kori

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Try to Update the DB statistics. This could resolve your issue.

Regards,

Varadharajan M