Symptom
- On an attempt to change ASE's default character set and sort order:
Attempting to change default sortorder ID from 50 to 22
Attempting to change default character set ID from 1 to 4
- ASE is booted in single-user mode:
ASE booted single user mode - updates allowed to system catalogs
- It reports the following errors when rebuilding an index on the table sysattributes:
Checking table 'sysattributes' (object ID 21): Logical page size is 2048 bytes.
Checking partition 'sysattributes_21' (partition ID 21) of table 'sysattributes'. The logical page size of this table is 2048 bytes.
Rebuilding indexes for master..sysattributes.
Error: 14127, Severity: 16, State: 2
Cannot drop or modify partition descriptor database 'master' (1), object 'sysattributes' (21), index 'sysattributes' (0), partition 'sysattributes_21' (21) as it is in use. Please retry your command later. Total reference count '8'. Task reference count '2'.
Error: 3436, Severity: 20, State: 2
Cannot rebuild index 3 for the 'sysattributes' table in the 'master' database.
Error: 3434, Severity: 20, State: 1
Cannot change sortorder. Server shutting down. Restart to continue with sortorder unchanged.
- ASE is shutdown.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
Keywords
charset , 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.