In this post, you’ll learn about the SQL error code 1531 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform
Error Code :
1531
Reason for the Error code 1531 in InterSystems IRIS DBMS
The SORTED_DATA_REORG option cannot be used for a nonclustered index if the keys are not unique within the table. CREATE INDEX was aborted because of duplicate keys. Primary key is ‘%S_KEY’.