I have the following exception by running tcode ME9F, with 4553 purchase orders:
"Runtime Errors DBIF_RSQL_INVALID_RSQL
Date and Time 14.10.2011 10:36:05
Error in RSQL module of database interface.
Error in ABAP application program.
The current ABAP program "RM06ENDR_ALV" had to be terminated because one of the
statements could not be executed.
This is probably due to an error in the ABAP program."
Well, this is probably by reaching the maximu range of single values. BUT, how can i find in how this limit in our system ? i think this have to do with the database and not with SAP. am i right ?
thanks in advance,
BUT, how can i find in how this limit in our system ? i think this have to do with the database and not with SAP. am i right ?
Yes, you're absolutely correct
In fact the limitation exists on the length of the SQL statement which is generated when the Open SQL is parsed. There is an OSS note which describes these in details.(Sorry i don't have an SAP marketplace access at this moment)
Sorry if i sound harsh, but you can [google|http://tinyurl.com/5vwq83e] that
thanks you do it for me! but i have done this, with no REAL result ! i am little confused between the below two notes, and i cannot find the solution ..
Note 635318 - Open SQL: Size restrictions for commands
Note 13607 - Termination of an ABAP with DBIF_RSQL_INVALID_RSQL
In addition i cannot find CLEARLY the specs of DB
the database limits the size of the where clause of select statement. It use to be 16k bytes, I think oracles newer versions can handle limit of 32767 bytes per line. Multiply the number of entries by entry length. If PO length is 10 bytes, then 4500 orders will need 45000 bytes - too much anyway.
Check for your database!
The limit is not 16Kbytes. I put 1900 Purchase Orders and the no run time error occurred ! i found that the limit is Length of a string containing SQL statements (batch size) 65,536 * Network packet size1, but i canot understand what a network packet size is.