How To Fix MDG_HDB_SEARCH074 - Enter SAP HANA conn. data in custom. activ. Define MDG Landscape Profile


SAP Error Message - Details

  • Message type: E = Error

  • Message class: MDG_HDB_SEARCH -

  • Message number: 074

  • Message text: Enter SAP HANA conn. data in custom. activ. Define MDG Landscape Profile

  • Show details Hide details
  • 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

    Enter SAP HANA conn. data in custom. activ. Define MDG Landscape Profile

    How to fix this error?

    Enter the HANA connection data in the customizing activity "Define MDG
    Landscape Profile" under MDGIMG-->General Settings-->Technical Settings
    for Master Data-->Define MDG Landscape Profile.

    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_SEARCH074 - Enter SAP HANA conn. data in custom. activ. Define MDG Landscape Profile ?

    The SAP error message MDG_HDB_SEARCH074 typically indicates that there is an issue with the configuration of the SAP HANA connection data in the Master Data Governance (MDG) landscape profile. This error usually arises when the system is unable to find the necessary connection details to access the HANA database for search functionalities.

    Cause:

    1. Missing HANA Connection Data: The error suggests that the required connection data for SAP HANA is not defined in the custom activity for the MDG landscape profile.
    2. Incorrect Configuration: There may be incorrect or incomplete configuration settings in the MDG landscape profile.
    3. Profile Not Activated: The MDG landscape profile may not be activated or properly set up.

    Solution:

    To resolve the error, follow these steps:

    1. Access the MDG Customizing:

      • Go to the SAP GUI and navigate to the transaction code SPRO.
      • Follow the path: SAP Reference IMG -> Master Data Governance -> MDG Landscape Profile.
    2. Define the MDG Landscape Profile:

      • Locate the relevant landscape profile that you are using.
      • Ensure that the SAP HANA connection data is correctly defined. This includes specifying the connection parameters such as:
        • Hostname
        • Instance number
        • Database name
        • User credentials (username and password)
      • Make sure that the connection type is set correctly (e.g., JDBC).
    3. Activate the Profile:

      • After entering the necessary connection data, ensure that the profile is activated.
      • Save your changes.
    4. Test the Connection:

      • After configuration, test the connection to ensure that the settings are correct and that the system can connect to the HANA database.
    5. Check Authorization:

      • Ensure that the user account used for the connection has the necessary authorizations to access the HANA database.
    6. Review Logs:

      • If the issue persists, check the application logs for any additional error messages that might provide more context.

    Related Information:

    • Documentation: Refer to the official SAP documentation for MDG and HANA for detailed configuration steps and best practices.
    • SAP Notes: Check for any relevant SAP Notes that might address known issues or provide additional guidance related to this error.
    • Community Forums: Consider visiting SAP Community forums or other user groups where similar issues may have been discussed.

    By following these steps, you should be able to resolve the MDG_HDB_SEARCH074 error and ensure that your MDG system can successfully connect to the SAP HANA database.

    • Do you have any question about this error?


      Upgrade now to chat with this error.


Instant HelpGet instant SAP help. Start your 7-day free trial now.


Related SAP Error Messages

Click the links below to see the following related messages:

Click on this link to search all SAP messages.


Rating
ERPlingo's SAP support assistant is amazing. Saves me countless hours trying to solve complex SAP issues myself. It's a real game changer!
Rate 1
Thomas Michael
SAP Consultant, Author & Speaker