SAP Knowledge Base Article - Preview

2174430 - default sort order "binaryalt" with SWPM SP8 - LOAD DATABASE fails Error 3120 - SAP ASE for Business Suite


You are running SAP applications on SAP ASE database.

  • On SAP systems installed with SWPM SP8, the database server configuration parameter default sortorder id is set to "binaryalt" (id=99) by SAPinst.  Prior to SWPM SP8, the installation would set this configuration parameter to "binary" (id=25).
  • You load a backup of SID database from an older SAP system to a newly-built SAP system and the LOAD DATABASE fails with the Error 3120:

The database you are attempting to LOAD was DUMPed under a different sort order ID (25) or character set ID (190) than the ones running on this server (SortOrd = 99, CharSet = 190). If the sort orders differ, at least one of them is non-binary. 



  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and higher for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 SP01 and higher for Business Suite
  • SAP Enterprise Resource Planning (ERP) 6.0
  • SAP Customer Relationship Management (CRM) 7.0
  • SAP Supplier Relationship Management (SRM) 7.0
  • SAP Supply Chain Management (SCM) 7.0
  • SAP Solution Manager (SOLMAN) 7.1
  • SAP NetWeaver - All versions


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions


suspect, index, "system copy", sortorder, 3120, LOAD DATABASE, binaryalt, SWPM, sapinst, different, dump, load , KBA , kde_q , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.