cancel
Showing results for 
Search instead for 
Did you mean: 

Dump DBIF_RSQL_INVALID_RSQL

0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

prashb
Participant
0 Kudos

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

Former Member
0 Kudos

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.