SAP Knowledge Base Article - Preview

2418979 - CDS views (DDL SQL views) cannot be activated with unknown function name

Symptom

CDS views (DDL SQL Views) failed to be activated/created because of unknown function name. The error expression on different databases are also not the same.

Here are some examples:

 

Oracle database

ORA-00904: "SAP_SUBSTRING": invalid identifier

ORA-00904: "CURRENCY_CONVERSION": invalid identifier

 

SQL Server database

SQL-error "4121-Cannot find either column "<sid>" or the user-defined function or aggregate "<sid>.SAP_LPAD", or the name is ambiguous."

SQL-error "4121-Cannot find either column "<sid>" or the user-defined function or aggregate "<sid>.SAP_CONCAT", or the name is ambiguous."

 

DB6

SQL0204N "SAP<SID>.CURRENCY_CONVERSION" is an undefined name.

SQL0440N  No authorized routine named "TSTMP_CURRENT_UTCTIMESTAMP" of type "FUNCTION" having compatible arguments was found.

DB4

ST11-> developer trace file (dev_w<No.>):

Unknown DB object while executing: DROP VIEW ....
 ThEppGetConnectionCounter: read connectionCounter 0 from * 0
 *** ERROR => ds_dbsl_funs.execute returned 103.

Unknown DB object while executing: CREATE VIEW ...
ThEppGetConnectionCounter: read connectionCounter 0 from * 0
*** ERROR => ds_dbsl_funs.execute returned 103

 

SAP ASE

[ASE Error SQL14217][SAP][ASE ODBC Driver][Adaptive Server Enterprise] SQL function not found.

[ASE Error SQL102:42000][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near 'sp_procxmode'. 

HANA DB

SQL-error "459-invalidated function

 

Such errors may occur when you try to activate CDS views in ADT(ABAP Development Tool), using report RUTDDLSACT or during system maintenance using SPAM/SAINT/SUM.


Read more...

Environment

NetWeaver based systems

Product

SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

DDL SQL views, CDS views, SQL4121, SQL 4121, ORA-00904, SQL0204N, SQL0204, SQL0440N  No authorized routine named, SQL0440N, ds_dbsl_funs.execute returned 103, ASE Error SQL14217, invalid identifier, user-defined function or aggregate, undefined name, SQL function not found, SAP_SUBSTRING, CURRENCY_CONVERSION, SAP_CONCAT, SAP_LPAD, RUTDDLSACT, RUTCNVFUNCCRE1, Incorrect syntax near 'sp_procxmode', Incorrect syntax near, SQL102 , KBA , BC-DWB-DIC-AC , Activation Prog., Conversion Prog., DB-Utility, MC, SPDD , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-SDB , MaxDB , BC-DB-DB4 , DB2 for AS/400 , BC-DB-DB2 , DB2 for z/OS , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DB-ORA-SYS , Database Interface / DBMS , 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.