SAP Knowledge Base Article - Preview

2319006 - Database service automatic startup fails on Windows Server

Symptom

On a SAP MaxDB(Version 7.8 or 7.9) or SAP liveCache(Version 7.9) running on Microsoft Windows operating system(either single server or MSCS Setup) which has set the database service startup type to 'Automatic':

(Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.)

    services1.png

    servicedetail.png

In the event of a Windows restart or a MSCS Failover operation, you notice that the database does not start in ONLINE state.

 Even trying to manually start the SAP MaxDB/liveCache service:

    manualservicestartup.png

 

    startingservice.png

The database is not started in ONLINE state. Checking the database state with 'db_state' command, it can be seen in ADMIN state:

    cmddbstate.png

 

Checking the database Kernel Messages log('KnlMsg'), you can see the following error:

 

        Thread      0x64C Task      -  2016-05-18 10:30:45     RTE        20227:  Database tries automatic restart
        Thread      0x41C Task      -  2016-05-18 10:30:46 ERR RTE        20126:  Database automatic restart failed,_FILE=RTE_ExternalCall.cpp,_LINE=905
        Thread      0x404 Task     56  2016-05-18 10:31:07     CONNECT    19633:  Connect req. (D79, T56, connection obj. 0x277c938, Node:'10.0.0.122', PID: 9644)
        Thread      0x404 Task     56  2016-05-18 10:31:07     RTESec         2:  User  attempts to connect
                                               2016-05-18 10:31:07     RTESec         0:  Authentication method: EXTERNAL
                                              2016-05-18 10:31:07     RTESec         0:  Authenticated identity: NT AUTHORITY\SYSTEM
        Thread      0x64C Task      -  2016-05-18 10:30:45     RTE        20227:  Authenticated identity: BUILTIN\Administrators
        Thread      0x41C Task      -  2016-05-18 10:30:46 ERR RTE        20126:  Authentication rejected
        Thread      0x404 Task     56  2016-05-18 10:31:07     CONNECT    19633:  Authentication method: SCRAMSHA256
        Thread      0x404 Task     56  2016-05-18 10:31:07     RTESec         2:  Authentication rejected


 

 


Read more...

Environment

  • Microsoft Windows operating system.
  • Microsoft Cluster Services (MSCS).
  • SAP MaxDB 7.8 and 7.9.
  • SAP liveCache 7.9.

Product

SAP NetWeaver all versions

Keywords

automatic restart, windows service, database, livecache, maxdb, cluster, microsoft windows, windows, mscs, service, xuser, dbm , KBA , BC-DB-SDB-DBA , Database Administration MaxDB , BC-DB-LVC , liveCache , 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.