SAP Knowledge Base Article - Preview

3109483 - SAP system fails to start after alwayson failover

Symptom

Alwayson is configured by following SAP note 1772688.

When performing SQL server failover from node 1 to node 2, SAP systems failed to start with the following error in work process trace:

C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8909]
C  (2714) [42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'sap_set_spid_container' in the database.
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8909]
C  (2714) [42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'sap_get_spid_container' in the database.
C  comm. rd. spid 79 
C  unc. rd. spid 96 
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8909]
C  (2714) [42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'get_MSSQL_CLIENT' in the database.
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8909]
C  (2714) [42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'get_MSSQL_USER' in the database.
C  

...
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8909]
C  (2714) [42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'get_MSSQL_LANGU' in the database.
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8909]
C  (2714) [42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'get_mssql_session_id' in the database.
C  ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8909]
C  (2714) [42S01] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'get_MSSQL_SYSTEM_DATE' in the database.

...
C  ERROR: -1 in function StartSelect (execute) [line 17730]
C  (208) [42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'SVERS'.
C  ERROR: -1 in function StartSelect (execute) [line 17730]
C  (8180) [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.
C  Error 103 (dbcode 208) in StartSelect
C  StartSelect: stmt of NULL_STMTID
C  SELECT VERSION FROM SVERS 
C  /* R3::0 T:SVERS M:    */
C  
B  ***LOG BZA=> table SVERS does not exist on database            [dblink       1455]
M  ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 004096) [thDatabase.c 88]
M  in_ThErrHandle: 1
M  *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c   2792]


Read more...

Environment

SAP NetWeaver Application Server system based on Microsoft SQL Server 2012 or higher

Product

SAP NetWeaver Application Server for ABAP 7.52

Keywords

KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.