SAP Knowledge Base Article - Preview

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

Symptom

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

Error 2.jpg


Read more...

Environment

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

Product

SAP ERP 6.0 ; SAP Work Manager 6.2.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.