How To Fix MDG_HDB_SEARCH077 - Key attribute &1 will be added from entity &2

SAP Error Message - Details

• Message type: E = Error

• Message class: MDG_HDB_SEARCH -

• Message number: 077

• Message text: Key attribute &1 will be added from entity &2

What causes this issue?

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

System Response

In case of ruleset generation, key attribute of an entity is added to
the view and ruleset when an entity is selected on the UI though this
attribute might not be selected explicitly on the UI. When multipe
entities are chosen on the UI having the same key attribute, the system
is not able to identify from which entity, this key attribute should be
selected and added to the view

How to fix this error?

To aviod having duplicate keys in the Hana views, the key attribute
should be exposed from one of the entity. In order to acheive this,
select only one entity which has this as key attribute

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message MDG_HDB_SEARCH077 - Key attribute &1 will be added from entity &2 ?

  The SAP error message MDG_HDB_SEARCH077 indicates that a key attribute is being added from a specific entity in the context of SAP Master Data Governance (MDG) and its integration with HANA database search functionalities. This message typically arises during the configuration or execution of search functionalities in MDG, particularly when dealing with key attributes in the search model.
  Cause:
  The error message is generally triggered when:
  
  Key Attributes Configuration: There is a mismatch or misconfiguration in the key attributes defined for the entity in the search model.
  Entity Relationships: The entity from which the key attribute is being added may not be properly linked or configured in the MDG data model.
  Search Model Definition: The search model may not be correctly defined to include the necessary key attributes from the specified entity.
  
  Solution:
  To resolve the issue, you can follow these steps:
  
  
  Check Key Attributes:
  
  Go to the MDG data model configuration and verify the key attributes defined for the entity in question.
  Ensure that the key attributes are correctly set up and that they are relevant to the entity.
  
  
  
  Review Entity Relationships:
  
  Check the relationships between the entities in your data model. Ensure that the entity from which the key attribute is being added is correctly linked to the main entity.
  
  
  
  Update Search Model:
  
  If necessary, update the search model to include the key attributes from the specified entity. This may involve modifying the search model configuration in the MDG application.
  
  
  
  Rebuild Search Index:
  
  After making changes, it may be necessary to rebuild the search index to ensure that the changes take effect. This can usually be done through the MDG application or relevant transaction codes.
  
  
  
  Testing:
  
  After making the necessary adjustments, test the search functionality to ensure that the error no longer occurs and that the search results are as expected.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may provide additional insights or patches related to this error message.
  MDG Documentation: Refer to the official SAP MDG documentation for detailed information on configuring search models and key attributes.
  Community Forums: Engage with the SAP Community or forums where other users may have encountered similar issues and can provide insights or solutions.
  
  If the problem persists after following these steps, consider reaching out to SAP support for further assistance, providing them with detailed information about the error and the steps you have already taken.