SAP Knowledge Base Article - Preview

2715060 - SPAM, SUM fails with error 2004, SQL Error 137 - SAP ASE for Business Suite

Symptom

  • On SAP ASE 157 and 160 SP01 systems, activation of CDS view fails during SPAM - IMPORT_PROPER phase  or SUM - MAIN_NEWBAS/XPRAS_AIMMRG phase with errors:

    SQL error 2004: [ASE Error SQL2004][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Procedure 'P~ACMTST_SQLV_PROD' has already been created with group number 0 - create procedure with an unused group number

    SQL-View "ACMTST_SQLV_PROD" of entity "ACMTST_CDSV_PROD" does not exist in the database (see tx: SE14)
    SQL-View "PRMSEMPLOYEELIST" of entity "P_RMSEMPLOYEELIST" does not exist in the database (see tx: SE14)
  • Report RUTCNVFUNCCRE1 fails with errors on following views:

Deletion and Recreation of CDS Views on Database
*************************************************************************
SQL error 137: [ASE Error SQL137][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Must declare variable '@id4'.
The SQL statement was not executed
View ESJICURRCONV could not be created on the database
SQL error 137: [ASE Error SQL137][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Must declare variable '@id3'.
The SQL statement was not executed
View DEMO_CDS_CRRCONV could not be created on the database
SQL error 137: [ASE Error SQL137][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Must declare variable '@id3'.
The SQL statement was not executed
View DEMO_CDS_UNTCNV could not be created on the database

*************************************************************************
Deletion and Recreation of CDS Views on Database
End phase 004 ***********************************************************

Start phase 005 **********************************************************
Final log
*************************************************************************

The following errors or warnings have occurred:

DDL Source DEMO_CDS_CURRENCY_CONVERSION could not be activated
DDL Source DEMO_CDS_UNIT_CONVERSION could not be activated
DDL Source ESJI_CURRENCYCONVERSION could not be activated




Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP01 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP NetWeaver 7.40 and above

Product

SAP ERP 6.0

Keywords

SUM, MAIN_NEWBAS/XPRAS_AIMMRG, SQL2004, 2004, PRMSEMPLOYEELIST,  ACMTST_SQLV_PROD, CUDF, TUDF, parameter, views, SPAM, SE14, IMPORT_PROPER, SQL137, 137 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.