SAP Knowledge Base Article - Preview

3020873 - Error: 840 followed by Error: 3404 on Device Sysprocsdev and master database - SAP ASE

Symptom

  • ASE Startup fails with Error: 840 and Error: 3404 
    00:0002:00000:00002:2021/01/16 15:45:17.73 server  Error: 840, Severity: 17, State: 2
    00:0002:00000:00002:2021/01/16 15:45:17.73 server  Device 'sysprocsdev' (with physical name '$SYBASE/data01/sybprocs.dat', and virtual device number 1) has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.
    00:0002:00000:00002:2021/01/16 15:45:17.74 server  Error: 3404, Severity: 21, State: 1
    00:0002:00000:00002:2021/01/16 15:45:17.74 server  Rec_complete: Could not open controlling database (id 31514) of controlling database in multi-db transaction.
    00:0002:00000:00002:2021/01/16 15:45:17.74 server  Cannot recover the master database, exiting.
    00:0002:00000:00002:2021/01/16 15:45:17.74 kernel  ueshutdown: exiting
  • Device exists and has full permissions to SYBAS
    • -rwxr-xr-x 1 sybase sybase  524288000 Feb  3 07:29 master.dat
    • -rwxr-xr-x 1 sybase sybase  524288000 Oct 27 12:04 sybprocs.dat
  • Master in multi-db transaction
  • Master cannot be recovered
  • Sybsystemprocs cannot be recovered


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

master, transaction, Error: 840, Severity: 17, State: 2, Error: 3404, Severity: 21, State: 1, multi-db, device, OS, suicide, bypass , 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 ONE Support launchpad (Login required).

Search for additional results

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