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

• 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 in Transaction ST22 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

SAP Business Warehouse (BW) 7.4 SP 9 above

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 , EPM-BPC-BW4-PLA , BPC/4 - Planning Enginee , BW-BEX-OT-HCPR , CompositeProvider Query , How To