SAP Knowledge Base Article - Preview

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

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 for Business Suite
  • 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 for Me (Login required).

Search for additional results

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