2162319 - Error 'No SID found for value ... of characteristic 0FISCYEAR'

• For certain special characteristics such as 0FISCYEAR, 0FISCPER below error might occur when executing some planning query.

          UNCAUGHT_EXCEPTION
          CX_RSR_PROPAGATE_X
          CL_RSPLS_HDB_SWITCH
          BW-PLA

          The dump is triggered in method FILL_SIDS in class CL_RSR_TIME_RELATION_HDB.

          The reason for the exception is 'No SID found for value ... of characteristic 0FISCYEAR' as displayed in the below screenshot:

• When executing some planning sequence of type 0RSPL_CREATE_CR in transaction RSPLAN or executing some planning query based on real-time infocube that has characteristic relationship settings it runs into error.

         UNCAUGHT_EXCEPTION
         CX_RSR_X_MESSAGE
         SAPLRRMS
         BW-BEX-OT

         The reason for this exception is error _GENERATE_RETURN_STRUCTURE-01- raised in program CL_RSMD_RS_SPECIAL.

         The active call stack looks like as displayed below:

Sometimes these error are only noticed after an upgrade of the system to a higher BW release.

• SAP NetWeaver 7.3
• SAP NetWeaver 7.4
• SAP NetWeaver 7.5
• SAP BW/4HANA 1.0
• SAP enhancement package 1 for SAP NetWeaver 7.3
• SAP enhancement package 1 for SAP NetWeaver 7.5

no SID found, 0fiscyear, 0fiscper, _GENERATE_RETURN_STRUCTURE-01-, CL_RSMD_RS_SPECIAL, RSD_0FISCPER_TXT_GET, CX_RSR_FIPT_ERROR, CL_RSR_FIPT_VAL2SID_PREFETCH===CP UNCAUGHT_EXCEPTION,  CX_RSR_PROPAGATE_X, CL_RSPLS_HDB_SWITCH, CL_RSR_FIPT_VAL2SID_PREFETCH, CL_RSR_FIPT_VAL2SID_PREFETCH==CM002, CL_RSPLS_HDB_SWITCH===========CM00F FILL_SIDS CL_RSR_TIME_RELATION_HDB, BRAIN 070, BRAIN070, BRAIN 70, CL_RS_BASE, characteristic 0FISCYEAR (0FISCYEAR) CL_RS_BASE====================CP, CL_RSPLS_HDB_SWITCH===========CP , KBA , BW-PLA-IP , Integrated Planning , BW-BEX-OT-OLAP , Analyzing Data , BW-WHM-DBA-IOBJ , InfoObjects , Problem