How To Fix MDC_HDB_MTC047 - SAP HANA database connection details not found in the landscape profile

SAP Error Message - Details

• Message type: E = Error

• Message class: MDC_HDB_MTC - Message class for master data consolidation matching

• Message number: 047

• Message text: SAP HANA database connection details not found in the landscape profile

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message MDC_HDB_MTC047 - SAP HANA database connection details not found in the landscape profile ?

  The SAP error message MDC_HDB_MTC047 indicates that the SAP HANA database connection details are not found in the landscape profile. This error typically occurs in the context of a multi-tenant database container (MDC) setup in SAP HANA, where the system is unable to locate the necessary connection information for the database.
  Cause:
  
  Missing Configuration: The landscape profile may not be properly configured, or the connection details for the HANA database are missing.
  Incorrect Landscape Profile: The landscape profile being used may not correspond to the correct database or may not have been set up correctly.
  Authorization Issues: The user or service trying to access the database may not have the necessary permissions to view or use the connection details.
  Network Issues: There may be network connectivity issues preventing access to the database.
  
  Solution:
  
  
  Check Landscape Profile Configuration:
  
  Ensure that the landscape profile is correctly configured in the SAP HANA system. You can do this by accessing the SAP HANA cockpit or using the HANA Studio.
  Verify that the connection details (host, port, user, password) for the HANA database are correctly specified in the landscape profile.
  
  
  
  Update or Create Landscape Profile:
  
  If the landscape profile is missing or incorrect, you may need to create a new one or update the existing one with the correct connection details.
  Use the SAP HANA cockpit or the command line to create or modify the landscape profile.
  
  
  
  Check User Permissions:
  
  Ensure that the user or service account has the necessary permissions to access the database and the landscape profile.
  You may need to grant additional roles or privileges to the user.
  
  
  
  Test Database Connectivity:
  
  Use tools like the HANA Studio or SQL console to test the connectivity to the HANA database using the specified connection details.
  Check for any network issues that may be preventing access to the database.
  
  
  
  Consult Documentation:
  
  Refer to the official SAP documentation for guidance on configuring landscape profiles and troubleshooting connection issues.
  
  
  
  Related Information:
  
  SAP Notes: Check for any relevant SAP Notes that may address this specific error or provide additional troubleshooting steps.
  SAP Community: Engage with the SAP Community forums to see if other users have encountered similar issues and what solutions they found effective.
  Logs and Traces: Review the logs and traces in the SAP HANA system for any additional error messages or warnings that may provide more context about the issue.
  
  By following these steps, you should be able to resolve the MDC_HDB_MTC047 error and ensure that the SAP HANA database connection details are correctly configured in the landscape profile.