R/3 Consistency

The Database Alert Monitor display contains, among other things, results of the consistency checks between the ABAP Dictionary and the database system.

Prerequisites

Prerequisites

The database instance is the basis of the current SAP Web AS system.

Procedure

       1.      Start the Database Alert Monitor.

       2.      Choose <Name of the database connection> ® R/3 Consistency.

Result

The system displays the following:

·        R/3 Consistency Check: displays when the last consistency check was performed. If no inconsistencies were found, the system displays a green alert.

·        Objects Missing in the Database: yellow and red alerts indicate that some ABAP Dictionary objects (primary indexes, secondary indices, tables, and views) could not be found in the database instance. If you double-click the relevant alert, you can perform additional analyses.
If an object was intentionally deleted in the database instance during development, or if a database error occurred during creation, this list of missing objects can be important for the customer objects. Objects that could not be found in the database instance can cause transports to be incomplete or contain errors, and conversions to terminate.
Create the missing objects in the database system.

·        Unknown Objects in ABAP Dictionary: yellow and red alerts indicate that database objects (tables, indices, and views) have not been defined in the ABAP Dictionary. If you double-click the relevant alert, you can perform additional analyses.
Since the objects do not belong to the SAP system, this list is mainly intended for information purposes. The objects are directly created by means of the database system. If the author is unknown, you can determine the purpose of the object in some cases by using the display function. Since the data display in an SAP system is based on the ABAP Dictionary definitions, data can be displayed only by using the database system.
Always create customer tables, views, and indices with the ABAP Dictionary. This is the only way of ensuring that the objects are recognized by the SAP system and that problems are avoided during the upgrade.

·        Inconsistent Objects: yellow and red alerts indicate that the definitions of the objects (primary indices, secondary indices, tables, and views) in the ABAP Dictionary are not the same as those in the MaxDB database catalog.
Compare the object definition in the ABAP Dictionary with the definition in the catalog and correct the wrong definition.

·        Other Checks: multiple checks are performed, including the check whether the primary indices of the tables defined in the ABAP Dictionary were created exclusively in the database instance, and whether there are objects in the SAP base tables that cannot be described or only incompletely described in the ABAP Dictionary.

·        Optional Indices: the optional database indices found in the ABAP Dictionary are defined indices. Also displayed here are all the indices that were defined in the ABAP Dictionary but that are flagged as not being allowed to be created in your database instance.
Determine if these indices have either been created or not been created as intended.

See also:

Index Analysis