SAP Knowledge Base Article - Preview

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 :

    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.



SAP Adaptive Server Enterprise (ASE). All versions.


SAP Adaptive Server Enterprise 15.7


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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.