2248105 - ABAP error (ID-107013) when running queries using special InfoObjects like 0FISCYEAR and 0CALMONTH

Analysis for Office is throwing the following exception when executing a query:

------------------------------------------------------------------------------------------
ABAP Runtime Error: An exception has occurred that was not caught. (ID-107013)
------------------------------------------------------------------------------------------

The same query can be executed directly in transaction RSRT or in BEx Analyzer for example.

When checking the backend trace in RSTT transaction, there is only one call: BICS_CONS_SET_GET_SESSION_PROP

The following dump is being generated in ST22 transaction:

-------------------------------------------------
Category               ABAP Programming Error
Runtime Errors         UNCAUGHT_EXCEPTION
Except.                CX_RSR_PROPAGATE_X
ABAP Program           CL_RSPLS_HDB_SWITCH===========CP
Application Component  BW-PLA
-----
What happened?
    Exception 'CX_RSR_PROPAGATE_X' was raised, but it was not caught anywhere
     along the
    call hierarchy.

    Since exceptions represent error situations, and this error was not
    adequately responded to, ABAP program 'CL_RS_BASE====================CP' had
     to be terminated.
-----
Error analysis
    An exception has occurred in a class constructor. This exception is
    assigned to class 'CX_RSR_PROPAGATE_X'.
    Since the exception was not caught in the constructor, processing was
    terminated.
    The reason for the exception is:
    An exception occurred

    This exception is closely related to a previous exception "CX_RSR_FIPT_ERROR",
      which
     was raised in program "CL_RSR_FIPT_VAL2SID_PREFETCH==CP", in line 86 of
      (include) program "CL_RSR_FIPT_VAL2SID_PREFETCH==CM002". The
     reason for the exception occurring was:
     No SID found for value '<VALUE>' of characteristic <INFOOBJECT>
-------------------------------------------------

• SAP NetWeaver
• SAP Analysis for Microsoft Office

The issue may be occurring because the content and active versions of the special InfoObjects used in the query are not the same. This can be checked in transaction RSD1.

The affected InfoObject can be found in the dump above in following line:
---------------------------------
No SID found for value '<VALUE>' of characteristic <INFOOBJECT>
---------------------------------

Make sure the content and active versions of the InfoObjects are exactly the same, referring to SAP note below:

>> 2074801 - Dumps and Issues with special InfoObjects like 0FISCYEAR, 0CALMONTH...

2074801 - Dumps and Issues with special InfoObjects like 0FISCYEAR, 0CALMONTH...

Business Warehouse, BW, Analysis Office, Analysis, Office, Excel, AO, CX_RSR_PROPAGATE_X, CL_RSPLS_HDB_SWITCH, BICS_CONS_SET_GET_SESSION_PROP, 107013, exception, InfoObject , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , Problem