on 06-19-2008 4:13 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.