SAP Knowledge Base Article - Preview

3583135 - SUM fails with Incorrect syntax near 'execute.' - NetWeaver

Symptom

  • SUM fails with below error in phase MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_ALIAS:

[SQL Server]Incorrect syntax near 'execute.'.
<if user_name() != '<sid>_shd' execute as login = suser_sname(suser_sid('<sid>_shd')) with no revert> failed -- connect terminated
Error message: Connect failed
dbrc = 99: 'all DB errors, except for ...'
DB code 102
exit code: "20" 


Read more...

Environment

  • SQL Server in SAP NetWeaver Products

Product

SAP NetWeaver all versions

Keywords

SUM, upgrade, SAP Supplier Relationship Management, SQL Server, syntax error, execute, MAIN_SHDINST/SUBMOD_SHDALIASCRE/SCEXEC_ALIAS. , 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.