SAP Knowledge Base Article - Preview

3035507 - Error: No authorized routine named "NVARCHAR" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884, after making DDL changes to DB2 remote source, SDI 2.4.x

Symptom

  • Error: No authorized routine named "NVARCHAR" of type "FUNCTION" having compatible arguments was found.  SQLSTATE=42884, after making DDL changes to remote source
  • Occured after the update of our HANA 2.0 Revision from 52 to 53 we experience different issues with some datasources connected via SDI from DB2 database.
    • When searching tables on DB2 side, only the first 200 are shown when entering the '*' in the search field. If you type in some combination with normal letters (e.g. 'AB*') no table is found even if there are some beginning with AB...
    • Changes of fields in datasouces cannot be activated, since the Views are not found anymore (similar to point 1)
    • When extracting preview data from data source GL_TRAN_08 (source system HANASDA), the following errors come up in the HANA indexserver trace:

[31056]{214205}[27/-1] 2021-02-18 14:55:52.972380 i TraceContext     TraceContext.cpp(01269) : UserName=SAPSR3, ApplicationUserName=LANGTH, ApplicationName=ABAP:M1D, ApplicationSource=SAPLRS_GENERAL:4831, Client=001, StatementHash=86c356c4d56d0ed22c20a07963082f13, EppRootContextId=D1C7A192AFBC491E9322673F5FC760E8, EppTransactionId=19BC1C24E15742408E8E4ACE2AD51207, EppConnectionId=FDC2969071F011EBB0B9FB480A9D80B6, EppConnectionCounter=1, EppComponentName=, EppAction=, StatementExecutionID=844435514378197[31056]{214205}[27/-1] 2021-02-18 14:55:52.972354 e FedTrace         odbcaccess.cpp(03879) : ODBC error: connected: 1 state: 42884 code: -440 [IBM][CLI Driver][DB2/LINUXX8664] SQL0440N  No authorized routine named "NVARCHAR" of type "FUNCTION" having compatible arguments was found.  SQLSTATE=42884


Read more...

Environment

SAP Hana 
Revision:  HANA 2.0 Revision 53
On premise: yes
Single DB: yes

Data Provisioning Agent: yes but DB2 is bound on indexserver
Version:
Operating System of DPAgent machine:
Version of JAVA used for DPAgent:
Adapter in use: DB2

Product

SAP BW/4HANA 2.0

Keywords

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

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.