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

SAP Knowledge Base Article - Preview

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

Symptom

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. 


Read more...

Environment

  • 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

Product

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

Keywords

suspect, index, "system copy", sortorder, 3120, LOAD DATABASE, binaryalt, SWPM, sapinst, different, dump, load , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , 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.