SAP Knowledge Base Article - Preview

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

Symptom

  • 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.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE). All versions.

Product

SAP Adaptive Server Enterprise 15.7

Keywords

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.