SAP Knowledge Base Article - Preview

3788370 - When changing configuration in T-code OADB, runtime error DBSQL_SQL_ERROR is met

Symptom

Dump as below is met when changing settings in T-code OADB, such like adding new depreciation area, or changing some indicator etc.

Category               ABAP programming error
Runtime Errors         DBSQL_SQL_ERROR
Except.                CX_SY_OPEN_SQL_DB
ABAP: Program          CL_FAA_CFG_SERVICES===========CP
Application Component  FI-AA-AA

Short Text                                                                  
    SQL error "SQL code: 4" occurred while accessing table "FAAV_LINEITEMS".

Keywords

    "DBSQL_SQL_ERROR" CX_SY_OPEN_SQL_DB                                       
    "CL_FAA_CFG_SERVICES===========CP" or CL_FAA_CFG_SERVICES===========CM01J 
    "CHECK_PROD_DATA_EXISTENCE"       

   53|*              nafap NE 0  OR  nafag NE 0  OR                                   
   54|*              safap NE 0  OR  safag NE 0  OR                                   
   55|*              mafap NE 0  OR  mafag NE 0  OR                                   
   56|*              aafap NE 0  OR  aafag NE 0 )              "#EC CI_NOFIRST        
   57|*      INTO @eb_data_exist.                                                     
   58|                                                                                
   59|                                                                                
   60|*   Check if postings exist (no matter if statistical or posted)     "< 3171085 
>>>>>|    SELECT * FROM faav_lineitems UP TO 1 ROWS                        "< 3171085 
   62|               INTO ls_faav_lineitems where bukrs IN lr_bukrs.       "< 3171085 
   63|    ENDSELECT.                                                       "< 3171085 
   64|                                                                                
   65|    IF sy-subrc = 0.                                                            
   66|      eb_data_exist = abap_true.                                                
   67|      ev_comp_code  = ls_faav_lineitems-bukrs.                       "< 3171085 
   68|    ENDIF.                                                                         

                                    


Read more...

Environment

  • SAP enhancement package for SAP ERP, version for SAP HANA
  • SAP S/4HANA Finance
  • SAP S/4HANA

Product

SAP S/4HANA Finance all versions ; SAP S/4HANA all versions ; SAP enhancement package for SAP ERP, version for SAP HANA all versions

Keywords

T093, ACDOCA, FAAT_DOC_IT, Database error text: "SQL message: cannot allocate enough memory, dump , KBA , FI-AA-AA-B , Transaction Figures / Valuation , FI-AA-AA-C , Transactions , 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.