SAP Knowledge Base Article - Preview

3106564 - SYB - ASE Error SQL2809 occurred on SQL function

Symptom

  • You are running SAP Business Suite or BW on SAP ASE. And you see the Error 2809 and Error 2846 from dev_w** or SM21:

    C  ERROR: -1 in function StartSelect (execute) [line 30269]
    C  (2809) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]The request for SQL function '
    C  SAPSR3.SAP_LEFT' failed because 'SAPSR3.SAP_LEFT' is a function object.
    C  
    C  ERROR: -1 in function StartSelect (execute) [line 30269]
    C  (2846) [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]SQL function 'SAPSR3.SAP_LEFT'
    C   not found. Specify owner.objectname or use sp_help to checkwhether the object e
    C  xists (sp_help may produce lots of output)
    C  
    C  sql statement is ==> SELECT "VIEWNAME" ,"DDLNAME" ,"STRUCOBJN" ,"DATACATEGORY" ,"DEVCLASS" ,"HIDDEN" 
    C  ,"QUERY" FROM /* Entity name: RSODP_ABAP_CDS_F4_ALL_P1 */ "RSODPABAPCDSF4A1" "RS
    C  ODP_ABAP_CDS_F4_ALL_P1" WHERE "VIEWNAME" LIKE ? ESCAPE ? ORDER BY "RSODP_ABAP_CD
    C  S_F4_ALL_P1" ."VIEWNAME" 
    C  /* R3:CL_RSODP_ABAP_CDS_CONTEXT=====CP:9187 T:RSODPABA
    C  PCDSF4A1 M:400 */
    C  
    B  ***LOG BY4=> sql error 2846   performing PRE on table RSODP_ABAP_CDS_F4_ALL_P1 [dbdbslst     5137]
    B  ***LOG BY0=> [ASE Error SQL2809][SAP][ASE ODBC Driver][Adaptive Server Enterprise]The request for SQL function 'SAPSR3.SAP_LEFT' failed because 'SAPSR3.SAP_LEFT' is a function object.
     [dbdbslst     5137]

  • You confirmed from database that the objects reported in the error message is not in database.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

 2809, 2846, CUDF, SQL function , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , 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.