SAP Knowledge Base Article - Preview

2506197 - SQL error 137 during Upgrade in phase XPRA_EXECUTION

Symptom

During Support Package Upgrade process to 701 SP19 in phase XPRA_EXECUTION the following error appears:

SQL error 137: Must declare the scalar variable '@cmd'.
Errors occurred during post-handling MSS_SDBP_AFTER_IMP for SDBP L
The errors affect the following components:
BC-DB-MSS (Microsoft SQL Server)
Post-import method MSS_SDBP_AFTER_IMP started for SDBP L, date and time: 20170718192153
Starting processing of SQL scripts (R3TR SDBP)...
SQL script sap_P_retrieve A.0 A being executed
SQL error 137: Must declare the scalar variable '@cmd'.
SQL script sap_P_retrieve B.0 A will be ignored (incorrect release)
...
...


The related work process trace shows the following or similar error:


...
C Wed Jul 19 00:13:01 2017
C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 7683]
C (137) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Must declare the scalar variable "@cmd".
...
...
C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 7683]
C (137) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Must declare the scalar variable "@v".
C DoExecutePrepStmt: stmt of NULL_STMTID
C CREATE PROCEDURE sap_p_retrieve
...


Read more...

Environment

  • SAP NetWeaver 7.0 EHP1 Application Server for ABAP
  • SQL Server 2008(R2)

Product

SAP ERP 6.0 ; SAP enhancement package 1 for SAP NetWeaver 7.0

Keywords

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.