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

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


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.