Inconsistency between database and Dictionary

Programs issue a message that there is an error or inconsistency in the ABAP Dictionary. An inconsistency may be caused by the following:

1. The table was activated by illegal means and not adjusted to the database in the process.
2. When the table was activated, a database error occurred that prevented the adjustment to the database and, for once, provided no return code.
3.  After an attempted conversion for the table that terminated in step 5, the system restores the table by renaming your QCM table.

This note applies only to transparent tables. It does not apply to physical pools and clusters.

Solution

You can verify the inconsistency using one of the following methods:

• Call SE11 and choose the menu path "Utilities" > "Database Object" > "Check".
• Call SE14 and choose the menu path "Check" > "Database Object".
• Call SE14 and choose the menu path "Extras" > "Database Object" > "Check" (F6).

To prevent loss of data, you can no longer activate the table during a conversion if this inconsistency exists.
Therefore, you cannot execute this conversion.
Activating the table with transaction SE11 does not change its inconsistent state.

To eliminate the inconsistency in tables, proceed as follows:

a) Log on as user DDIC.

b) Call transaction SE14.

c) Enter the name of the table and choose "Edit".

d) In the menu, choose: "Table" -> "Reconstruct".

e) Confirm the execution as an emergency repair.

f) Select the radio button for the processing type as follows: "Direct" or (for very large tables) "Background".

g) Select the "Save data" radio button.

h) Choose "Activate and adjust database" to activate the table.

Check the consistency of the table again in transaction SE14:

• F6 - between database and runtime object
• F7 - between runtime object and the description in the ABAP Dictionary.

To eliminate the inconsistency in an index, proceed as follows:

1. Call transaction SE14.
2. Enter the name of the table and choose "Edit".
3. Choose "Indexes".
4. Select the index and choose "Choose (F2)".
5. If you choose "Activate and adjust", the system creates the index again and it is consistent.
6. Check the object log of this activation.
7. If an error occurs, eliminate the cause and reactivate the index.

If this does not eliminate the inconsistency, create a CSN message under the component BC-DWB-DIC-AC.