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 examples of tables where this is found are sysobjects and master..syslogins
  
  Example 1. user table 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.
  
  
  Example 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