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".

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 for Me (Login required).

Search for additional results

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