SAP Knowledge Base Article - Preview

3393159 - Must declare the table variable "@er"

Symptom

When switching the system to a monitored system on DBACOCKPIT, The following error happens.


@5C\QError Message@ <Remote_system ID> SQL 1,087 : Must declare the table variable "@er".[WP3 ] [READ_TFLIST]
@8O\QException@ <Remote_system ID> SMSS error GET_PARA_LIST: SQL 1,087 : Must declare the table variable "@er". [WP11 ] [READ_TFLIST]

Developer trace shows the error in details:

[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the table variable "@er".
C  Error 99 (dbcode 1087) in StartSelect
C  StartSelect: stmt of NULL_STMTID
C  -- =======================================================================
C  -- C
C  reate table function sap_tf_tlist
C  -- (C) SAP Labs, 2001, 2002, 2003, 2008, 2009
C  , 2010, 2011
C  -- ===============================================================
C  ========
C  
C    SET NOCOUNT ON
C    DECLARE @objname varchar(64)  -- new parameter i
C  n 731, dematerialized
C  
C    SET @objname = LTRIM(RTRIM( ? ))
C  
C    DECLARE @ergebn


Read more...

Environment

SAP application system based on Netweaver.

Remote database is Microsoft SQL Server.

Keywords

KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , 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.