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.