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
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.
SAP Knowledge Base Article - Preview