Skip to Content

The maximum size of an SQL statement has been exceeded.

In ST22, abap dump shows that one of the possible reason was "The maximum size of an SQL statement has been exceeded."

How can I know what's the maximum size and how to compute that size had been reached?

Is this shown anywhere in the log?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 21, 2007 at 02:14 AM

    HI

    Can you Paste your SQL Query...

    Else..Why dont you check some Notes with this Dump Error..

    Hope you will find some notes which tells about such Issue...

    Like 946196

    Check SAP NOTE : 1002491

    Hope it Helps .

    Thanks

    Praveen

    Edited by: praveen parasiya on Dec 21, 2007 3:17 AM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Siew Tim, Colin Cheong

      Hi friend,

      I think ur sql statement is mismatched, so thats y, it goes into short dump.It takes loop iteration,the size should be infinite.

      If it is useful, reward points.

      regards,

      satish.

  • Dec 21, 2007 at 02:24 AM

    did you give a lot of entries in your select-options?

    something like over 1000 entries in the select-options?

    I think that must be the problem.

    Regards,

    Ravi Kanth Talagana

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ravi Kanth,

      My select query is trying to access over 10,000 records and I am getting the same short dump. How should I deal with this? My requirement expects me to pick up those many records from the table.

      Please suggest how I can go about this problem.