3078537 - Duplicate key error 1505 when changing to nocase sortorder - SAP ASE

• When changing from a case sensitive (binary) sortorder
• To a case insensitive (nocase) sortorder
• ASE log reports error 1505 when rebuilding index
  
  
• The error can be raised against any name (identifier) in a system table
• Common tables where this is found are sysobjects and master..syslogins:

1. user table name in sysobjects
   
   Rebuilding indexes for db_name..sysobjects.
   Error: 1505, Severity: 16, State: 2
   Create unique index aborted on duplicate key.  Primary key is '"my_object", 1, 0'
   Error: 3436, Severity: 20, State: 2
   Cannot rebuild index 2 for the 'sysobjects' table in the 'db_name' database.
   Error: 3434, Severity: 20, State: 1
   Cannot change sortorder. Server shutting down.  Restart to continue with sortorder unchanged.
   
   
2. login name in master..syslogins
   
   Checking partition 'syslogins_33' (partition ID 33) of table 'syslogins'. The logical page size of this table is x bytes.
   Rebuilding indexes for master..syslogins.
   Error: 1505, Severity: 16, State: 2
   Create unique index aborted on duplicate key.  Primary key is '"my_login"'
   Error: 3436, Severity: 20, State: 2
   Cannot rebuild index 2 for the 'syslogins' table in the 'master' database.
   Error: 3434, Severity: 20, State: 1
   Cannot change sortorder. Server shutting down.  Restart to continue with sortorder unchanged.

SAP Adaptive Server Enterprise (ASE). All versions.

sybase , sort order , message 1505 , msg 1505 , error 1505  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem