Symptom
- When changing the default character set and sort order, ASE rebuilds indexes in all recovered databases using the new character set and sort order, and then it fails with Error 930.
- The old character sets and sort order is restored.
- ASE errorlog shows the following messages:
Recovery complete.
Now loading ASE's new default sort order and character set
Checking table 'sysobjects' (object ID 1): Logical page size is 4096 bytes.
Checking partition 'sysobjects_1' (partition ID 1) of table 'sysobjects'. The logical page size of this table is 4096 bytes.
Checking table 'systypes' (object ID 4): Logical page size is 4096 bytes.
Checking partition 'systypes_4' (partition ID 4) of table 'systypes'. The logical page size of this table is 4096 bytes.
Checking table 'sysusers' (object ID 10): Logical page size is 4096 bytes.
Checking partition 'sysusers_10' (partition ID 10) of table 'sysusers'. The logical page size of this table is 4096 bytes.
Checking table 'sysreferences' (object ID 16): Logical page size is 4096 bytes.
Checking partition 'sysreferences_16' (partition ID 16) of table 'sysreferences'. The logical page size of this table is 4096 bytes.
Checking table 'sysreferences' (object ID 16): Logical page size is 4096 bytes.
Checking partition 'sysreferences_16' (partition ID 16) of table 'sysreferences'. The logical page size of this table is 4096 bytes.
Checking table 'sysreferences' (object ID 16): Logical page size is 4096 bytes.
Checking partition 'sysreferences_16' (partition ID 16) of table 'sysreferences'. The logical page size of this table is 4096 bytes.
Checking table 'sysattributes' (object ID 21): Logical page size is 4096 bytes.
Checking partition 'sysattributes_21' (partition ID 21) of table 'sysattributes'. The logical page size of this table is 4096 bytes.
Checking table 'sysattributes' (object ID 21): Logical page size is 4096 bytes.
Checking partition 'sysattributes_21' (partition ID 21) of table 'sysattributes'. The logical page size of this table is 4096 bytes.
Rebuilding indexes for model..sysattributes.
Non-clustered index restored for model..sysattributes.
....
Error: 930, Severity: 14, State: 1
Database 'mydb' cannot be opened because either an earlier system termination left LOAD DATABASE incomplete or the database is created with 'for load' option. Load the database or contact a user with System Administrator (SA) role.
Error: 3434, Severity: 20, State: 1
Cannot change sortorder. Server shutting down. Restart to continue with sortorder unchanged.
ueshutdown: exiting
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- ASE contains a database that was created with the "for load" option but hasn't yet been loaded.
Product
Keywords
795029, CR795029, charset, sortorder , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.