How To Fix HH073 - This 'primary key' constraint is 'disabled'

HH073 - Overview

• Message type: E = Error

• Message class: HH - (Long) text for check tool 'infcfgcheck'

• Message number: 073

• Message text: This 'primary key' constraint is 'disabled'

What causes this issue?

The specified 'Primary Key' constraint is defined, but it is currently
'disabled'. This is a dangerous condition because:
Columns are no longer unique
Access times are slower, as the relevant index is gone

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

Determine whether the corresponding table is still in use (that is, it
is not a test or demo table).
If yes, 'enable' the constraint as follows:
Access the constraint definition using 'dbschema'
Set the constraint using 'set constraint for ... enabled' in 'dbaccess'
(-> related index is built).
This process may not be successful if the corresponding column contents
are no longer unique. If this occurs, check beforehand (at the
application level) which records need to be deleted.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message HH073 - This 'primary key' constraint is 'disabled' ?

  The SAP error message HH073, which states that a "primary key" constraint is "disabled," typically occurs when there is an issue with the database table's primary key configuration. This can happen for various reasons, such as:
  
  Cause:
  
  Primary Key Constraint Disabled: The primary key constraint for the table has been disabled, which means that the database will not enforce uniqueness for the primary key fields.
  Database Configuration: The database might have been configured in a way that allows for the disabling of primary key constraints.
  Data Integrity Issues: There may be existing data in the table that violates the primary key constraint, leading to its disabling.
  Table Maintenance: During certain maintenance operations, such as data migrations or updates, the primary key constraint might be temporarily disabled.
  
  
  Solution:
  
  Check Database Constraints: Verify the status of the primary key constraint in the database. You can do this by querying the database metadata or using database management tools.
  Re-enable the Primary