Sunday, January 9, 2011

Missing Tables and Indexes While Creating Index in DB02

Question:
We are getting error while creating  primary index in db02 for the
table EDIDC.


Error in unknown objects in abap dictionary.
ST04 -> Diagnostics -> Missing Tables and Indexes->unknown objects in
abap dictionary.


Answer:
Missing tables and indexes meaning there is inconsistency between
database and data dictionary which causes number of missing indexes,
please check whether the preceding step like reorganisation or upgrade
was completed correctly.


541538 FAQ: Reorganization

Also, please check these indexes to see if they need to be created on
the database level. In some cases the index does not need to be created
on the Oracle database but it is delivered in the ABAP dictionary as
it exists on anther database e.g. Informix. Please go to

ST04 -> Diagnostics -> Missing Tables and Indexes
     -> Optional indexes -> indexes not created


Please also take a look at attached notes below for relevant information
   211492    Inconsistency between ABAP dictionary <-> database
   33814     Warnings of inconsistencies between database & R/3
   117219    DB02 reports missing DD/DB objects: procedure
   582427    Error due to inconsistent Oracle DDICMS: missing tables and
             indexes db02


To resolve the problem, you can drop the index from database
level and recreate via SE14 as it is already exist in ABAP dictionary
Please apply the drop and recreated at a system non-busy time.

No comments:

Post a Comment