Problem with SUBMIT -- Urgent ...

[Former Member]

While using SUBMIT, I get DUMP for the stmt

SUBMIT zrabest_alv01

WITH SELECTION-TABLE gi_seltab

AND RETURN.

If the gi_seltab is having more records. Suppose around 18000 records.

Dump messg:

Error analysis

An exception occurred. This exception is dealt with in more detail bel

. The exception, which is assigned to the class 'CX_SY_OPEN_SQL_DB', w

neither

caught nor passed along using a RAISING clause, in the procedure "VIEW

"(FORM)"

.

Since the caller of the procedure could not have expected this excepti

to occur, the running program was terminated.

The reason for the exception is:

The SQL statement generated from the SAP Open SQL Statement violates a

restriction imposed by the database system used in R/3.

Possible errors:

o The maximum size of an SQL statement has been exceeded.

o The statement contains too many input variables.

o The space needed for the input data exceeds the available memory.

o ...

Help me out .... Thnks in Advance

[Former Member]

Hi mohankumar,

1. Suppose around 18000 records

This error will come.

2. Bcos when we have select options,

the final database SQL query which is generated

is in the form of

where field in ('val1','val2','val3', ....... 'val18000')

3. Now , all most all databases, including oracle,

have a limit for such IN values

4. Whenever this limit exceeds, it will give error.

regards,

amit m.

[Former Member]

Hey Mohan,

Hence you are returning back after submit. You can split the values of selection table and sent it. Probably putting the submit in a loop with 1500 records for each submition.

Enjoy...

Cheers,

Thomas.