SAP Knowledge Base Article - Preview

2127147 - Error 3434: Cannot change sortorder or character set - SAP ASE


  • Executing sp_configure to change character set and / or sort order fails with error 3434

Error: 3434, Severity: 20, State: 1
Cannot change sortorder. Server shutting down. Restart to continue with sortorder unchanged.

  • And the ASE errorlog showing:

The configuration parameter 'number of open databases' must be at least as large as the number of databases, in order to change the character set or sort order.
Re-start Adaptive Server, use sp_configure to increase 'number of open databases' to at least 27, then re-configure the character set or sort order



SAP Adaptive Server Enterprise (ASE)


SAP Adaptive Server Enterprise all versions


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.