3432842 - Dump in method DECLARE from program CL_RSDA_ADSO_DTO_PROCESS_ACT==CP raised CX_SY_DYNAMIC_OSQL_SYNTAX exception

ADSO request activation fails with a dump. The following pop up message will appears if you try to manually activate the request:

Activation of load request (Cold) {XXXX-XX-XX XX:XX:XX XXXXXX XXXXXX} first is strongly recommended

Dump:

Category               ABAP programming error
Runtime Errors         SAPSQL_PARSE_ERROR
Except.                CX_SY_DYNAMIC_OSQL_SYNTAX
ABAP Program           CL_RSDA_ADSO_DTO_PROCESS_ACT==CP
Application Component  BW4-DM

Short Text: An error has occurred while parsing a dynamic entry.

"SAPSQL_PARSE_ERROR" CX_SY_DYNAMIC_OSQL_SYNTAX
"CL_RSDA_ADSO_DTO_PROCESS_ACT==CP" bzw. CL_RSDA_ADSO_DTO_PROCESS_ACT==CM005
"DECLARE"

Source code:

    DATA(lt_reqtsn_ranges) = VALUE tt_reqtsn_ranges(
                               FOR <ls_req> IN it_source_requests
                               ( sign = rsmds_c_sign-including
                                 option = rsmds_c_option-equal
                                 low    = <ls_req>-source_request_tsn )
                             ).
>>>    WITH +partition_mapping AS
      ( SELECT (l_selclause) FROM (l_source_table) )
    SELECT
      archreqtsn,
      reqtsn,
      COUNT(*) AS rowcount
    FROM ('+partition_mapping')
    WHERE reqtsn IN @lt_reqtsn_ranges
    GROUP BY
      archreqtsn,
      reqtsn
    INTO TABLE @me->mt_partdata.

Call stack:

|   30 METHOD       CL_RSDA_ADSO_DTO_PROCESS_ACT==CP    CL_RSDA_ADSO_DTO_PROCESS_ACT==CM005    39  |
|      CL_RSDA_ADSO_DTO_PROCESS_ACT=>DECLARE                                                       
|   29 METHOD       CL_RSDA_ADSO_DTO_ADAPTER======CP    CL_RSDA_ADSO_DTO_ADAPTER======CM00O    14  
|      CL_RSDA_ADSO_DTO_ADAPTER=>IF_RSDA_DTO_ADAPTER~DECLARE_UPDATES                               
|   28 METHOD       CL_RSDSO_DATA_PROCESS=========CP    CL_RSDSO_DATA_PROCESS=========CM00S    51  |
|      CL_RSDSO_DATA_PROCESS=>GET_R_DTO_PROCESS                                                    
|   27 METHOD       CL_RSDSO_DATA_TASK============CP    CL_RSDSO_DATA_TASK============CM00O   216  |
|      CL_RSDSO_DATA_TASK=>_OPEN_PROCESS_ACTIVATE                                                  
|   26 METHOD       CL_RSDSO_DATA_TASK============CP    CL_RSDSO_DATA_TASK============CM00K     5  |
|      CL_RSDSO_DATA_TASK=>_OPEN_PROCESS

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP BW/4HANA

Request activation, process chain failing, failure , KBA , BW4-DM-DTO , Data Tiering Optimization , BW4-DM , Data Management (Runtime) , Problem