primary missing index in tcode db02

[Former Member]

Hi Gurus

I am finding MKPF-0 primary index missing error in DB02.... While trying to reactivate this index in SE11 it is showing the status that it is Active and saved already so we can't able to reactivate that.... Status message is Active but still its showing error 'Missing primary index' in tx db02.... what is the solution for this....

Immediate response should be appropriated.

Thanks and Regards

Prasad Deshpande

[Former Member]

Hi guru's

Still problem is unsolved as i can't create a new index MKPF as it is primary index in Active state....

Tried to implement the note 1870843 but still problem remains same in db02 it is showing primary index is missing....

regards

Prasad Deshpande

[Reagan]

I would just drop the index and recreate it once again

Regards

RB

[ashish_vikas]

Also you need to Refresh DB02 if last check was outdated.

goto DB02old > Checks > Database <> ABAP Distionary > New Check.

best regards

ashish

[Reagan]

Hello

The must be missing at the DB level

Create the missing index using the Tx SE14

Regards

RB

[Former Member]

Hi Regan

how to check whether primary index is missing in database or not?? in SE14??

[ashish_vikas]

goto DB02old > Detail analysis > MKPF*

It will list all objects which are like MKPF. In this list, do you see MKPF~0 ?

best regards

ashish

[Sriram2009]

Hi Prasad

Kindly refer the SAP KBA 1870843 - Missing Tables and Indexes - How to edit exceptions

Regards

Sriram

[Former Member]

Hi Sriram

I have tried as per mentioned in this note using Tx SM30 but still after executing this giving same error in db02 primary index missing....

Thanks

Prasad Deshpande

[Reagan]

Have you tried what I have suggested below ?

Go to Tx SE14 - MKPF - Check

Perform the check against the Database Object and Runtime Object and check the result.

If the index is not present in the underlying database then create the index from there.

Regards

RB

[Former Member]

Hi Regan

It is showing this index does not exist.....

Database object for MKPF is inconsistent: (Primary index) 

When i tried to create a new index it is not allowing it showing this

The name of the object to be created is identical to the existing name "MKPF~0" of type "INDEX".

Regards

Prasad Deshpande

[Reagan]

Hello Prasad

Go to Tx SE14 - MKPF - Indexes - double click on the Primary Index

Does the system say that primary index "Exists on Database" ?

Check this SAP note

1248769  - Inconsistency between database and ABAP Dictionary

Regards

RB

[Former Member]

Hi Regan

Ya it is showing "Exist in database" that's what i told from my ABAP developer also it exist in db in Active state but still it is showing error in "db02 missing primary index"....

Regards

Prasad

[former_member45419]

Hi prasad,

Go to se11 screen enter the database table name go to the technical setting and make review active and run this transaction db02 then check

regards

Nayeem