2487402 - CX_SY_OPEN_SQL_DB - the open sql command is too long - Agentry

When downloading over 5000 records of equipment related data in the below query: /SMERP/CL_PM_EQUIPMENT_DO-GET method

SELECT (lv_select_clause) FROM imptt
INTO CORRESPONDING FIELDS OF TABLE ls_mdo_output_vals-et_measuring_points->*
FOR ALL ENTRIES IN lt_mpobj
WHERE mpobj EQ lt_mpobj-mpobj
AND mpobj IN ls_dof_filter_vals-mpobject->*
AND mpobj IN ls_mdo_input_vals-it_mpobject_ra->*
AND point IN ls_dof_filter_vals-measuring_point->*
AND point IN ls_mdo_input_vals-it_measuring_point_ra->*
AND lvorm NE lc_delete_flag.

an exception occurs with the message:

CX_SY_OPEN_SQL_DB - the open sql command is too long

• Work Manager 6.2
• SMERP 610_700 PL05
• SMFND 610_700 PL05

CX_SY_OPEN_SQL_DB , KBA , MOB-SYC-SAP , Syclo Mobility for SAP backend , MOB-APP-MAO-ERP , S4MERP/SMERP-Mobile Add-On integration to S4/ERP , Problem