2023年11月29日发(作者：)SAP Note

Header Data

Symptom

There is a termination of transactions or programs with, for example:

lCX_SY_OPEN_SQL_DB

lCX_SY_NO_HANDLER

Programs issue messages stating that there is an error or inconsistency in the ABAP Dictionary.



Other Terms

DB, RTO, inconsistency



Reason and Prerequisites

In a table used, there are inconsistencies with regards to its definition in the database and its runtime object in the ABAP Dictionary. This means

that the table exists in the database and is structured differently there than as described in the ABAP Dictionary. The following differences are

possible:

a. Difference in the number of fields

b. Difference in field categories

c. Difference in field lengths

d. An index is missing in the database

e. An index in the database is missing in the ABAP Dictionary

f. The number of fields varies in an index



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.

4. During an upgrade (and in particular in a shadow system) it may therefore be correct for a database object to be displayed as incorrect. As a

result, you cannot use this display alone to exclude the fact that an error exists.

This SAP 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:

l- Call SE11 and choose the menu path "Utilities -> Database Object -> Check".

l- Call SE14 and choose the menu path "Check -> Database Object".

l- Call SE14 and choose the menu path "Extras -> Database Object -> Check" (F6).

During an upgrade, the SAP Note must not be used before the main upgrade phase MAIN_NEWBAS. Particularly in a shadow

system, you must not use this SAP Note. If you are unsure during the diagnosis or when you execute one of the following solution

steps, open a support incident with the component BC-DWB-DIC.

To eliminate the inconsistency in tables, proceed as follows:

a. Log on as the 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. The system outputs a log of the reconstruction as a list. Return from this list by pressing F3.

xa0 xa0 1248769 - Inconsistency between database and ABAP Dictionary xa0

Version xa0 14 xa0 xa0 Validity: 2015.01.23 - active xa0 Language xa0 English

Released On 2015.01.23 22:27:47

Release Status Released for Customer

Component BC-DWB-DIC ABAP Dictionary

BC-DWB-DIC-AC Activation Prog., Conversion Prog., DB-U

tility, MC, SPDD

Priority Recommendations / Additional Info

Category Help for error analysis

Other Components



x0c



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

h. Select the "Save data" radio button.

i. Choose "Activate and adjust database" to activate the table.

Check the consistency of the table again in transaction SE14:

lF6 - between database and runtime object

lF7 - 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 support incident with the component BC-DWB-DIC.



Validity

This document is not restricted to a software component or software component version

References

This document refers to:

SAP Notes

This document is referenced by:

SAP Notes (2)



785440 xa0 Maintenance Strategy for Add-on OGSD

211492 xa0 Inconsistency between ABAP Dictionary <-> database

211492 xa0 Inconsistency between ABAP Dictionary <-> database

785440 xa0 Maintenance Strategy for Add-on OGSD



x0c