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