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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.