SAP Knowledge Base Article - Preview

2501994 - Sum Upgrade fails with SQL840 in phase PREP_INSTALL/SHDUNINST_DB_PREP SAP - SAP ASE for Business Suite

Symptom

  • SUM Uprade fails in CURRENTPHASE PREP_INSTALL/SHDUNINST_DB_PREP in SAPup.log:

    Error message: DBSL error 103 (db code 840):
    [ASE Error SQL840][SAP][ASE ODBC
    Driver][Adaptive Server Enterprise]Device 'sybsecurity_data_001' (with
    physical name '/sybase/<SID>/sybsecurity/sybsecurity_data_001.dat', and virtual
    device number 8) has not been correctly activated at startup time. Please
    contact a user with System Administrator (SA) role.
    exit code: "20"
    Rollback.

  • Original error on the SAP Adaptive Server Enterprise (ASE) that corresponds with the SUM error in ASE errorlog:

    Error: 840, Severity: 17, State: 2
    Device 'sybsecurity_data_001' (with physical name '/sybase/<SID>/sybsecurity/sybsecurity_data_001.dat', and virtual device number 8) has not been correctly activated at startup time.  Please contact a user with System Administrator (SA) role.
    Unable to proceed with the recovery of dbid <31516> because of previous errors.
    Continuing recovery with the next database.
    ***** WARNING: AUDITING CANNOT BE ENABLED DUE TO PROBLEMS WITH THE SYBSECURITY DATABASE. ***** 

     


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver 7.4

Keywords

SUM, SQL840, DBSL error 103, db code 840, Error: 840 , KBA , BC-DB-SYB , Business Suite 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.