How To Fix SMMSS_DDIC005 - There can be only one clustered index

SMMSS_DDIC005 - Overview

• Message type: E = Error

• Message class: SMMSS_DDIC - DDIC Messages for Microsoft SQL Server

• Message number: 005

• Message text: There can be only one clustered index

What causes this issue?

There is a clustered secondary index in the database. However, there is
no primary index for the table in the database. As CLUSTERED NO is not
set for the primary index, a conversion would cause a database error.

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?

If you want the secondary index to be clustered, you must set the
primary index to CLUSTERED NO.

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 SMMSS_DDIC005 - There can be only one clustered index ?

  The SAP error message SMMSS_DDIC005 indicates that there is an issue with the definition of a database table in the Data Dictionary (DDIC) where more than one clustered index is being defined. In a database, a clustered index determines the physical order of data in a table, and only one clustered index can exist per table.
  
  Cause:
  The error typically arises from one of the following scenarios:
  
  Multiple Clustered Indexes: The table definition in the Data Dictionary has been incorrectly set up to include more than one clustered index.
  Database Configuration: The underlying database system (like SAP HANA, Oracle, etc.) enforces the rule that only one clustered index can exist per table, and the DDIC definition is violating this rule.
  
  
  Solution:
  To resolve the error, you can follow these steps:
  
  
  Check Table Definition:
  
  Go to the Data Dictionary (transaction SE11) and check the definition of the table that is causing the error.
  Look for the indexes defined for the