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 for Me (Login required).

Search for additional results

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