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 ONE Support launchpad (Login required).

Search for additional results

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