1910759 - Start of Shadow Instance Failed during upgrade

Symptom

Start of Shadow Instance failed during upgrade. The developer trace dev_w* shows the following warning and error.

       Warning: Env(MSSQL_SCHEMA) [prd] <> Prof(dbs/mss/schema) [PRD]. Profile value will be used.
       Incorrect syntax near 'execute.'.
      <if user_name() != 'PRD_shd' execute as login =suser_sname(suser_sid('PRD_shd')) with no revert> failed connect terminated
       sql error 102    performing CON [dbsh         1246]
       Incorrect syntax near 'execute.'. [dbsh         1246]
       *** ERROR => ThInit: db_connect

Environment

SAP application server based on Netweaver which is setup on Microsoft SQL Server.

Product

SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

STARTSSC.log DEVTRACE.LOG, Preprocessing, 5.5, FAIL: process disp+work.EXE Dispatcher not running, CURRENTPHASE MAIN_SHDPREPUT/START_SHDI_PREPUT, 2EETQ399 Starting shadow instance failed , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.