SAP Knowledge Base Article - Preview

2962616 - Error shows in Database Upgrade Completion - NetWeaver

Symptom

• Error message shows when you are performing Databas Upgade Completion for SQL Server upgrade.

• More detailed error message can be found in MssLog.log as the following:

create procedure sap_IndexStatsMaintenance....

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'potential'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Must declare the scalar variable "@DateColumnsOnly".
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'else'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'exclude'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Must declare the scalar variable "@Mode".


Read more...

Environment

• SAP Systems based on SAP NetWeaver

• Microsoft SQL Server release than 2008 R2 SP1 and higher

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

Databas Upgade Completion,Incorrect syntax,potential,DateColumnsOnly , KBA , BC-DB-MSS-UPG , SQL Server Upgrades 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.