Dump issue

[Former Member]

Hi,

In my program I am using 'BAPI_DELIVERY_GETLIST' but i am getting run time error as

DBIF_RSQL_INVALID_RSQL

CX_SY_OPEN_SQL_DB

when seen in dump, I am getting pointed at the following statement

Termination occurred in the ABAP program "/1SAP1/%LE_SHP%_LIKP05A004" - in
"1L24".
The main program was "ZUSPP_342_SHIPPING_SCHED ".

In the source code you have the termination point in line 46
of the (Include) program "/1SAP1/%LE_SHP%_LIKP05A004".
The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
procedure "1L24" "(FORM)", but it was neither handled locally nor declared
in the RAISING clause of its signature.

SELECT * APPENDING TABLE ct_likp

         FROM  likp

*        LIKP-Selektionskriterien

WHERE ablad in ix_select_options-ablad

AND aulwe in ix_select_options-aulwe

AND bldat in ix_select_options-bldat

AND cmfre in ix_select_options-cmfre

AND cmngv in ix_select_options-cmngv

AND ctlpc in ix_select_options-ctlpc

AND erdat in ix_select_options-erdat

AND ernam in ix_select_options-ernam

AND grupp in ix_select_options-grupp

AND kkber in ix_select_options-kkber

AND knkli in ix_select_options-knkli

AND kodat in ix_select_options-kodat

AND kunnr in ix_select_options-kunwe

AND kunag in ix_select_options-kunnr

AND lddat in ix_select_options-lddat

AND lfart in ix_select_options-lfart

AND lfdat in ix_select_options-lfdat

AND lgnum in ix_select_options-lgnum

AND lgtor in ix_select_options-lgtor

AND lifex in ix_select_options-lifex

AND lifsk in ix_select_options-lifsk

AND lprio in ix_select_options-lprio

AND lstel in ix_select_options-lstel

AND prvbe in ix_select_options-prvbe

AND route in ix_select_options-route

AND sbgrp in ix_select_options-sbgrp

AND tddat in ix_select_options-tddat

AND traid in ix_select_options-traid

AND vbeln in ix_select_options-vbeln

AND vbtyp in ix_select_options-vbtyp

AND vkorg in ix_select_options-vkorg

AND vsbed in ix_select_options-vsbed

AND vstel in ix_select_options-vstel

AND wadat in ix_select_options-wadat

AND wadat_ist in

            ix_select_options-wadat_ist

AND wauhr in ix_select_options-wauhr

AND xblnr in ix_select_options-xblnr

AND vlstk in ix_select_options-vlstk

AND spe_rel_tmstmp in

    ix_select_options-spe_rel_tmstmp

AND EXISTS

( select *  FROM lips

            WHERE VBELN = LIKP~VBELN

AND werks IN ix_select_options-werks

AND vgbel IN ix_select_options-vgbel

)

           .

cf_subrc = sy-subrc.

Can anyone please help me?

[RaymondGiuseppi]

Check via tools like SM21 (sys log) or ST05 (SQL trace) if you can find the cause of the raised SQL error. (Is one or some of the range too big , reaching maximal size of a SQL statement for your database)

Regards,

Raymond

[amy_king]

Hi Neha,

The likely culprit is that the generated SQL statement is just too large for your database and you have exceeded its maximum allowed statement length. Check out this document for an explanation, .

Cheers,

Amy

[Former Member]

Hi,

The issue has been resolved. I passed the data to function module in chunks which managed to resolve the issue.

Thanks for your replies.