2418979 - CDS views (DDL SQL views) cannot be activated with unknown function name | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

CDS views (DDL SQL Views) were not activated 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 "SAPP01.CURRENCY_CONVERSION" is an undefined name.

 

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

 

<Hana DB>

SQL-error "459-invalidated function

 

Such errors might occur during activation of CDS views using report RUTDDLSACT, or during system update 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, SQL 0204, 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 , 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 for Oracle , 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.