AMDP_EXECUTION_FAILED in QA System.

[Former Member]

Hi ,

I'm facing AMDP_EXECUTION_FAILED error in QA system .

"column store error: search table error: [2620] executor: plan operation
failed;CalculationNode ($$DUMMY$$) -> operation (CustomLOp):Compilation
failed; CompileServerNotFoundException: No details;#"

I have tried all possible ways as per forum discussions , KBA notes . The selection crietria would pull not more than 7 k records . This happens only in QA system while in Dev it's working with both clients .

Snippet :-

lv_where = ( MANDT = 'XXX') AND( BUKRS = 'XXXX') AND( ENDDA >= '20191205')

CLASS-METHODS : get_pernr_pa0001

IMPORTING VALUE(lv_where) TYPE string
CHANGING VALUE(ct_pernr) TYPE tt_pernr.

TRY .

CALL METHOD zcl_hr_minimaster_report=>get_pernr_pa0001
EXPORTING
lv_where = lv_where
CHANGING
ct_pernr = lt_pernr.

CATCH cx_amdp_error INTO lx_amdp_error ."Exceptions

ENDTRY.

ENDIF.

Thnaks!

[Former Member]

Hi ,

I'm facing AMDP_EXECUTION_FAILED error in QA system .

"column store error: search table error: [2620] executor: plan operation
failed;CalculationNode ($$DUMMY$$) -> operation (CustomLOp):Compilation
failed; CompileServerNotFoundException: No details;#"

I have tried all possible ways as per forum discussions , KBA notes . The selection crietria would pull not more than 7 k records . This happens only in QA system while in Dev it's working with both clients .

Snippet :-

lv_where = ( MANDT = 'XXX') AND( BUKRS = 'XXXX') AND( ENDDA >= '20191205')

CLASS-METHODS : get_pernr_pa0001

IMPORTING VALUE(lv_where) TYPE string
CHANGING VALUE(ct_pernr) TYPE tt_pernr.

TRY .

CALL METHOD zcl_hr_minimaster_report=>get_pernr_pa0001
EXPORTING
lv_where = lv_where
CHANGING
ct_pernr = lt_pernr.

CATCH cx_amdp_error INTO lx_amdp_error ."Exceptions

ENDTRY.

ENDIF.

Thnaks!

[former_member1716]

Guna P,

Could you please explain a bit further on your issue.

Are you trying AMDP with CDS? Is the issue is when the records are more than 7K?

Regards!

[Former Member]

Hi Satish Kumar Balasubramanian,

I'm using this method in reports not CDS . This issue occurs in Quality but not in Dev irrepective of number of records.

Thanks!