Error in module RSQL of the database interface
abap吧
全部回复
仅看楼主
level 9
夏木之叶 楼主
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 "GET_DATA" "(METHOD)", 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.
2015年11月11日 07点11分 1
level 9
夏木之叶 楼主
从qals表中捞取一个月的检验批类型为 iqc 检验,差不多有十几万条数据,一运行就报错了。
如何解决!
2015年11月11日 07点11分 2
level 9
夏木之叶 楼主
Please check the entries in the system log (Transaction SM21).
Internal call code.........: "[RSQL/OPEN/QALS ]"
The SAP Open SQL statement concerned must be divided into several
smaller units.
If the problem occurred due to the use of an excessively large table
in an IN itab construct, you can use FOR ALL ENTRIES instead.
When you use this addition, the statement is split into smaller units
according to the restrictions of the database system used.
If the error occures in a non-modified SAP program, you may be able to
find an interim solution in an SAP Note.
If you have access to SAP Notes, carry out a search with the following
keywords:
"DBIF_RSQL_INVALID_RSQL" "CX_SY_OPEN_SQL_DB"
"ZQMR0025" or "ZQMR0025"
"GET_DATA"
2015年11月11日 07点11分 3
level 5
oracle,增加临时表空间
2015年12月01日 12点12分 4
level 4
你把你出错的代码贴出来看看呢。
十几万条数据不足以DUMP的。
IN的输入条件太多会造成这个DUMP,在RZ10可以配置,或者使用FOR ALL ENTRIES IN替代IN 也可以。
2015年12月02日 00点12分 5
是的
2015年12月02日 13点12分
但是用FOR ALL ENTRIES IN 得出的结果集系统会自动删除重复行 这个咋办
2020年05月25日 01点05分
@比邻😘 把表的主键加上就不会了
2020年06月15日 07点06分
1