topic Re: Short Dump in Application Development and Automation Discussions

Short Dump

Former Member — Thu, 19 Jul 2007 10:11:29 GMT

Hi,

I'm having a problem, i have a program that selects data from a join of the table mkpf with the table mseg. what appens is that when i select a material with more data it gives a short dump, and i don't know how to solve it. Any ideas? Next i'm going to put the code where the short dump is called:

SELECT mkpf_{mblnr mkpf}mjahr mkpf~budat

mkpf_{cputm mkpf}xblnr mkpf~xabln

mkpf_{bktxt mkpf}frbnr

mseg_{matnr mseg}werks mseg~mblnr

mseg_{zeile mseg}mjahr mseg~bwart

mseg_{lgort mseg}meins mseg~shkzg

mseg_{menge mseg}kunnr

INTO CORRESPONDING FIELDS OF TABLE t_aux_pt

FROM mkpf JOIN mseg ON

( mseg_{mblnr = mkpf}mblnr ) AND

( mseg_{mjahr = mkpf}mjahr )

WHERE budat < datamv-low

AND matnr IN mat

AND werks = centro

AND lgort IN depos

AND bwart IN tpomov

AND sobkz IN stkesp

AND shkzg = 'H'.

and the short dump is:

DBIF_RSQL_INVALID_RSQL

CX_SY_OPEN_SQL_DB

Re: Short Dump

seshatalpasai_madala — Thu, 19 Jul 2007 10:15:12 GMT

Hi,

Use SELECT ENDSELCT and use PACKAGE SIZE option to retrive the data in packets.

SELECT mkpf_{mblnr mkpf}mjahr mkpf~budat

mkpf_{cputm mkpf}xblnr mkpf~xabln

mkpf_{bktxt mkpf}frbnr

mseg_{matnr mseg}werks mseg~mblnr

mseg_{zeile mseg}mjahr mseg~bwart

mseg_{lgort mseg}meins mseg~shkzg

mseg_{menge mseg}kunnr

APPENDING CORRESPONDING FIELDS OF TABLE t_aux_pt PACKAGE SIZE 500

FROM mkpf JOIN mseg ON

( mseg_{mblnr = mkpf}mblnr ) AND

( mseg_{mjahr = mkpf}mjahr )

WHERE budat < datamv-low

AND matnr IN mat

AND werks = centro

AND lgort IN depos

AND bwart IN tpomov

AND sobkz IN stkesp

AND shkzg = 'H'.

ENDSELECT.

Regards,

Sesh

Re: Short Dump

Former Member — Thu, 19 Jul 2007 10:15:41 GMT

Hallo,

This can be due to too many entries in a range table or select option.

select * from table where field in MAT.

If MAT has too many entries the DB will choke on it.

So try with Select .. Appending ..

Regards,

Vasanth

Re: Short Dump

Former Member — Thu, 19 Jul 2007 10:15:51 GMT

check the declarations in the internal table t_aux_pt if they are compatible with those fields used in the SELECT statement

Re: Short Dump

Former Member — Thu, 19 Jul 2007 10:17:02 GMT

Hi!

I think the date format, you give can be a problem in the WHERE condition.

Try comment out (with *) the some part of the code to see is it working now?

You can find the problem quickly.

Regards

Tamá

Re: Short Dump

Former Member — Thu, 19 Jul 2007 10:33:18 GMT

I tried every solutions and the shortdump continues.

Re: Short Dump

Former Member — Thu, 16 Aug 2007 09:43:05 GMT

Hi Ricardo,

Try replacing the code:

WHERE matnr IN Mat

with the following:

FOR ALL ENTRIES IN mat

WHERE matnr EQ mat-low.