DISPATCHER IS NOT STARTING AFTER DATABASE RESTORE

[Former Member]

Hi Experts,

Previously we had used netweaver7.53 system on top of MSSQL server 2016 unfortunately system crashed. so wehave uninstalled it and installed the system with same sid and all, After installtion we have performed system restore with our old DB backup. Db restored successfully but sap system(dispatcher) is not starting. iam providing the dev_w0, log.

dev_w0--------------------------------------------

INFO: A known driver is being used: [ODBC Driver 17 for SQL Server].

C ODBC Driver chosen: ODBC Driver 17 for SQL Server native

C Local connection used on TGRE to named instance: lpc:TGRE\TGRE1

C Local connection used on TGRE to named instance: lpc:TGRE\TGRE1 C Driver: msodbcsql17.dll Driver release: 17.03.0001

C Server Version: 13.00.1601.05

C DB release numbers: (13,0,1601,5)

C EditionID: 1872460670 EngineEdition: 3

C Codepage check was not possible. Table DBPROPERTIES not found.

C C Thu Aug 1 02:14:50:123 2019

C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8741] 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 8741] 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 64 C unc. rd. spid 61

C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8741] 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 8741] 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 ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8741] 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 8741] 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 8741] 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. B Connection 0 opened (DBSL handle 0)

*------------- DbVendorMetaData --------------*

C ERROR: -1 in function StartSelect (execute) [line 17499]

C (208) [42S02] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'SVERS'.

C ERROR: -1 in function StartSelect (execute) [line 17499]

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 1438]

M ***LOG R19=> ThDbConnect, db_connect ( DB-Connect 004096) [thDatabase.c 87]

M in_ThErrHandle: 1

M *** ERROR => ThInit: db_connect (step TH_INIT, thRc ERROR-DB-CONNECT_ERROR, action STOP_WP, level 1) [thxxhead.c 2753]

Kindly help us

thanks in advance.

Naveen

[hrollizo · Accepted solution]

Hi

try with this SAP Notes:

1907868 - SAP system cannot connect to SQL Server after Alwayson failover.
Refer to SAP Note 1294762 – SCHEMA4SAP.VBS, execute the attached script Schema4SAP.zip. Additionally, you may refer to SAP Notes below,
592514 – MSSQL: internal database users, permissions and security
128126 – Database connect for external tools

Kind regards

[Former Member · Accepted solution]

Hi,

thanks for your reply Diego Hernandez Rollizo, system is up and running after execution of Schema4SAP.

Thank you.

[Ravi007 · Accepted solution]

@rozillo, you're the man.1294762 – SCHEMA4SAP.VBS, execute the attached script Schema4SAP.zip solution worked. Simply use the scripts and problem solved.