SAP Knowledge Base Article - Preview

2657804 - TUDF creation - SQL2714 There is already an object named '##..." in the database - SAP ASE for Business Suite

Symptom

  • You run SAP applications on SAP ASE 160 SP03 PL03
  • You are upgrading the SAP system to a higher EHP release or applying Basis Support Packs/MOPZ- via SUM / SPAM / SAINT
  • IMPORT or MOVE NAMETAB phase of the upgrade terminates due to following set of errors:

Fehler 2714-[ASE Error SQL2714][SAP][ASE ODBC Driver][Ada beim Ausführen der DDL für aufgetreten
Fehler beim Ausführen der DDL für aufgetreten
Fehler in DDL statement for beim Ausführen der DDL für aufgetreten
DB-ROLLBACK()
keine DDL-Befehle für Aktivierung von V_OIJ05_MAT_PRNH gefunden

Error 7306-[ASE Error SQL7306][SAP][ASE ODBC Driver][Ada when executing ADD-FIELD of
Error when executing ADD-FIELD of
Error in DDL statement for when executing ADD-FIELD of
DB-ROLLBACK()
No DDL commands found for activation of V_SAME_UOM

Error 2714-[ASE Error SQL2714][SAP][ASE ODBC Driver][Ada when executing ADD-FIELD of
Error when executing ADD-FIELD of
Error in DDL statement for when executing ADD-FIELD of
DB-ROLLBACK()
No DDL commands found for activation of V_SO_PO_DOCS

  • Reports RUTSDDLCREATE and RUTDDLSACT - views cannot be activated due to similar SQL2714 errors
  • Attempts to create any of the above referenced views/functions fail with errors:

SQL error 2714: [ASE Error SQL2714][SAP][ASE ODBC Driver][Adaptive Server Enterprise]There is already an object named '##<table>' in the database.

SQL error 2812: [ASE Error SQL2812][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Stored procedure 'GOIJ05_FRACK_784037818' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).     


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL03 only

Product

SAP Adaptive Server Enterprise 16.0 ; SAP ERP 6.0

Keywords

"create function", 2714, GTT, upgrade, CDS, view, function, activation, CR813898, CR#813898, 813898, inlined, table-valued, UDF, VUDF, Global, Temporary , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.