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 , SAP Business Suite 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.