3816408 - The list import failed while processing the staged import records for List Name 'XXXXX' in List Category 'XXXXX'. An unhandled exception occurred while processing the file: 'LIST_entity code_YYYYMMDDHHMMSS.txt

My List import file has the Last Run Status as Failure. The Import Run Details provides the following error message:

The list import failed while processing the staged import records for List Name 'XXXXXX' in List Category 'XXXXX'.
An unhandled exception occurred while processing the file: '20230919171340_16048_LIST_ENTITYCODE_20230919003007_20230919140523.txt'. com.microsoft.sqlserver.jdbc.SQLServerException: The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID 72057594645053440. Dropping and re-creating the index may resolve this; otherwise, use another clustering key. [com.concur.util.StoredProcStatement.execute(StoredProcStatement.java:573)]

How do I resolve the issue?

List Import failed , KBA , CON-CA-TLS-IEM , Import / Extract Monitor , Problem