How To Fix MDC_HDB_MTC056 - '&1' name cannot have more than 9 non-consecutive periods

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 056

• Message text: '&1' name cannot have more than 9 non-consecutive periods

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_MTC056 - '&1' name cannot have more than 9 non-consecutive periods ?

  The SAP error message MDC_HDB_MTC056 indicates that there is an issue with the naming convention of an object in the SAP HANA database. Specifically, the error states that the name you are trying to use contains more than 9 non-consecutive periods (dots). In SAP HANA, there are restrictions on the naming of database objects, and this is one of them.
  Cause:
  The error is triggered when you attempt to create or modify an object (like a table, view, or schema) with a name that exceeds the allowed limit of non-consecutive periods. This can happen if:
  
  The name of the object is too long or improperly formatted.
  You are trying to use a naming convention that includes too many segments separated by periods.
  
  Solution:
  To resolve this error, you should:
  
  Review the Object Name: Check the name of the object you are trying to create or modify. Ensure that it does not contain more than 9 non-consecutive periods.
  Rename the Object: If the name exceeds the limit, consider renaming the object to comply with the naming conventions. You can use underscores or other characters to separate segments instead of periods.
  Check Naming Conventions: Familiarize yourself with the naming conventions for SAP HANA objects. Generally, it is advisable to keep names concise and meaningful while adhering to the limitations set by the system.
  
  Related Information:
  
  SAP HANA Naming Conventions: SAP HANA has specific rules regarding the naming of database objects. Names should be unique within their scope and should not exceed certain lengths or contain invalid characters.
  Documentation: Refer to the official SAP HANA documentation for detailed guidelines on naming conventions and restrictions.
  Testing: After renaming the object, test the creation or modification process again to ensure that the error is resolved.
  
  By following these steps, you should be able to resolve the MDC_HDB_MTC056 error and successfully create or modify your database object in SAP HANA.