2471784 - Input ready query hits exception of CL_RSR_FIPT_VAL2SID->LOOKUP-01- when saving data | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2471784 - Input ready query hits exception of CL_RSR_FIPT_VAL2SID->LOOKUP-01- when saving data

Symptom

  • A HANA Composite Provider (HCPR) contains an InfoObject based HANA model
  • In particular, navigation attribute A__B is used in the HCPR and B is also based on a HANA model
  • The S table of InfoObject B has some SIDs missing compared to the master data in the HANA view
  • An input ready query is built on an aggregation level (AL) on top of this HCPR
  • When saving data, an exception CL_RSR_FIPT_VAL2SID->LOOKUP-01-, or a dump as below happens:
    Category ABAP programming error
    Runtime Errors UNCAUGHT_EXCEPTION
    Except. CX_RSR_X_MESSAGE
    ABAP Program SAPLRRMS
    Application Component BW-BEX-OT
    ........
    Chain of Exception Objects
    Attrib. Name Value
    Level 1 Class CX_RSR_X_MESSAGE
    ....
    IS_RESUMABLE
    KERNEL_ERRID
    PROGRAM LCL_IS_EMPTY_HANDLER_TRANSFORM
    TEXT CL_RSR_FIPT_VAL2SID->LOOKUP-01-//B631/SSEGMENT
    ....
    Active Calls/Events:
    49 FUNCTION SAPLRRMS LRRMSU13 87
    RRMS_X_MESSAGE
    48 METHOD CL_RS_BASE====================CP CL_RS_BASE====================CM001 11
    CL_RS_BASE=>X_MESSAGE
    47 METHOD CL_RSR_FIPT_VAL2SID===========CP CL_RSR_FIPT_VAL2SID===========CCIMP 138
    LCL_IS_EMPTY_HANDLER_TRANSFORM=>IF_RSPLS_HDB_CHECK_RES_HANDLER~HANDLE__IS_EMPTY
    46 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CCIMP 617
    LCL_CHECK_COLLECTOR=>DISPATCH_CHECK_RESULT
    45 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CCIMP 1013
    LCL_CHECK_COLLECTOR=>EXECUTE_CHECK
    44 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CCIMP 139
    LCL_CHECK_COLLECTOR=>FLUSH
    43 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CCIMP 159
    LCL_CHECK_COLLECTOR=>IF_RSPLS_HDB_CHECK_COLLECTOR~FLUSH
    42 METHOD CL_RSR_FIPT_VAL2SID===========CP CL_RSR_FIPT_VAL2SID===========CCIMP 67
    LCL_IS_EMPTY_HANDLER_SOFT=>IF_RSPLS_HDB_CHECK_RES_HANDLER~HANDLE__IS_EMPTY
    41 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CCIMP 617
    LCL_CHECK_COLLECTOR=>DISPATCH_CHECK_RESULT
    40 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CCIMP 1013
    LCL_CHECK_COLLECTOR=>EXECUTE_CHECK
    39 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CCIMP 139
    LCL_CHECK_COLLECTOR=>FLUSH
    38 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CCIMP 159
    LCL_CHECK_COLLECTOR=>IF_RSPLS_HDB_CHECK_COLLECTOR~FLUSH
    37 METHOD CL_RSPLS_HDB_CHECK_COLLECTOR==CP CL_RSPLS_HDB_CHECK_COLLECTOR==CM008 2
    CL_RSPLS_HDB_CHECK_COLLECTOR=>S_FLUSH_CURRENT_COLLECTOR
    36 METHOD CL_RSPLS_DELTA_BUFFER_STORE_T=CP CL_RSPLS_DELTA_BUFFER_STORE_T=CM00J 88
    CL_RSPLS_DELTA_BUFFER_STORE_T=>INSERT_INDEX

Read more...

Environment

SAP Business Warehouse (BW) 7.4 SP 9 above

Product

SAP NetWeaver 7.4 ; SAP NetWeaver 7.5

Keywords

BW, Business Warehouse, CL_RSR_FIPT_VAL2SID, LOOKUP-01-, RSPLS_CREATE_MISSING_SIDS, SID, segment, /BIC/SPFPCDELCT, CL_RSMD_RS_HANA_ATTRIBUTE_VIEW, process chain, fails, pllanning, saving, save, data , KBA , BW-PLA-IP , Integrated Planning , BW-BEX-OT-HCPR , CompositeProvider Query , How To

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.