SAP Knowledge Base Article - Preview

3035507 - Error: "No authorized routine named "NVARCHAR" of type "FUNCTION" having compatible arguments was found." after making DDL changes to DB2 table - SAP HANA Smart DATA Integration

Symptom

  • Error: No authorized routine named "NVARCHAR" of type "FUNCTION" having compatible arguments was found.  SQLSTATE=42884, after making DDL changes to remote source
  • Error: "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[***]{***}
    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 Smart Data Integration

Product

SAP BW/4HANA 2.0

Keywords

DB2, SDI, ddl change , 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.