Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error in module RSQL of the database interface.

Hi Expert,

I get this error "Error in module RSQL of the database interface." when the below ABAP statement executed, do you know the root cuase? Thanks.

ABAP Code:

data lt_fact type TABLE OF /BIC/FZRT_C002.

data ls_Fact type /BIC/FZRT_C002.

*SELECT * INTO table lt_fact FROM /BIC/FZRT_C002 WHERE KEY_ZRT_C0021 in lt_RSDIMID and KEY_ZRT_C0022 in lt_caRSDIMID*.

Information in ST22.

What happened?

Error in the ABAP Application Program

The current ABAP program "SAPLZZ_FG" had to be terminated because it has

come across a statement that unfortunately cannot be executed.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

in

procedure "ZCA_GET_CUBE_STOCK" "(FUNCTION)", nor was it propagated by a RAISING

clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

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

restriction imposed by the underlying database system of the ABAP

system.

Possible error causes:

o The maximum size of an SQL statement was exceeded.

o The statement contains too many input variables.

o The input data requires more space than is available.

o ...

You can generally find details in the system log (SM21) and in the

developer trace of the relevant work process (ST11).

In the case of an error, current restrictions are frequently displayed

in the developer trace.

Best Regards,

Andrew

Former Member
Former Member replied

the IN for RANGES is designed for manual input, i.e. it should not become too large.

Usually it will dump, if the number of records is in the range of 1.000, because the resulting statement is too large.

Use FOR ALL ENTRIES instead.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question