Skip to Content
avatar image
Former Member

Dump DBIF_RSQL_INVALID_RSQL

Dear all

I am facing a problem related to abap program, when I run the program like zmatlist

When I give Material Number in selection option ( for example 20000 Material Number )

In one go then abap report give me the following DUMP

DBIF_RSQL_INVALID_RSQL

CX_SY_OPEN_SQL_DB

And when in give selection option in chunk the that report run fine

After the dump I check dev_w0 file it shows like that

*C *** ERROR => max. statement length (65536) exceeded*

http://dbsloci.c 5759

C Dumping statement ...

C 0 | TEXT | 6 | SELECT

C 1 | TEXT | 4 | T_00

C 2 | TEXT | 1 | .

C 3 | IDENTIFIER | 5 | BISMT

.

.

.

So on

C 17481 | TEXT | 3 | AND

C 17482 | TEXT | 4 | T_02

C 17483 | TEXT | 1 | .

C 17484 | IDENTIFIER | 5 | WERKS

C 17485 | TEXT | 1 | =

C 17486 | MARKER(8588)| 0 | NULL

C token_cnt=17487, input_cnt=8589, marker_cnt=8589, stmt_length=86128

B ***LOG BYK=> current SQL statement exceeds a database limit dbtran#5 @ 7261 dbtran 7261

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'PRE'

thankx

Rayyan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 19, 2008 at 05:11 AM

    Hi Shahid,

    Please refer OSS note:

    Note 48230 - Parameters for the SELECT ... FOR ALL ENTRIES statement

    which explains the various option to solve your problem.

    The dump is occuring because of too many inputs(20000 material number) in the select option.

    Please let me know if this helpful, by rating.

    Regards

    Prashanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Prashant,

      What Shahid could mean is that he is inputting a single material number 20000 and not 20000 material nummober.

      Hello Shahid,

      This is a Z program (custom built)..Better debug it and find the error cause.

      Regards.

      Ruchit.

  • avatar image
    Former Member
    Jun 19, 2008 at 07:19 AM

    Hi,

    Use ST05 to make an SQL trace while running the report.

    You will be able to see the bad SQL request and then ask the programmer to correct his code.

    Regards,

    Olivier

    Add comment
    10|10000 characters needed characters exceeded