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.