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

SMMSS_DDIC003 - Overview

• Message type: E = Error

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

• Message number: 003

• Message text: There can be only one clustered index

What causes this issue?

You have set CLUSTERED YES for a secondary index and you set the index
memory parameters for a table that does not (yet) exist in the database
or that does exist in the database but that does not have a primary
index or a clustered primary index.

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

As you did not set CLUSTERED NO for the primary index, a database error
would occur for the non-existent table if it was created in the
database or for the existent table during a conversion.

System Response

How to fix this error?

If you really want to create a clustered secondary index, 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_DDIC003 - There can be only one clustered index ?

  The SAP error message SMMSS_DDIC003 indicates that there is an attempt to create more than one clustered index on a database table, which is not allowed. In relational database management systems (RDBMS), 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 in the following scenarios:
  
  Multiple Clustered Index Definitions: You may have defined more than one clustered index for a database table in the Data Dictionary (DDIC).
  Table Redefinition: If you are trying to redefine a table or its indexes, and the new definition includes a clustered index while another already exists.
  Transport Issues: If you are transporting objects between systems, there might be inconsistencies in the definitions of the indexes.
  
  
  Solution:
  To resolve the error, you can follow these steps:
  
  
  Check Existing Indexes:
  
  Use transaction code SE11 (Data Dictionary) to check the existing indexes on the table.
  Look for any existing clustered