SAP Knowledge Base Article - Preview

2197082 - Common errors when doing load of master database - SAP ASE

Symptom

  • Load of master database fails
  • Common errors when loading / restoring a master dump:

  1. WARNING: In order to LOAD the master database, the SQL Server must run in single-user mode.
    If the master database dump uses multiple volumes, you must execute sp_volchanged on another SQL Server at LOAD time in order to signal volume changes.

  1. Msg 3143, Level 16, State 1
    The master database you are attempting to load was dumped under a different sort order id (xx) or character set id (yy) than the ones running on this server (sort order id = aa, character set id = bb).
    Msg 3144, Level 16, State 1
    Since this load may render the master database unusable, this load will only be permitted under the 3100 traceflag. Please contact Sybase Technical Support regarding the correct usage of this traceflag.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE). All versions

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 12.5 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

load , master , LOAD the master database, the SQL Server must run in single-user mode , single , single user , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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 for Me (Login required).

Search for additional results

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