网页资讯视频图片知道文库贴吧地图采购
进入贴吧全吧搜索

 
 
 
日一二三四五六
       
       
       
       
       
       

签到排名:今日本吧第个签到,

本吧因你更精彩,明天继续来努力!

本吧签到人数:0

一键签到
成为超级会员,使用一键签到
一键签到
本月漏签0次!
0
成为超级会员,赠送8张补签卡
如何使用?
点击日历上漏签日期,即可进行补签。
连续签到:天  累计签到:天
0
超级会员单次开通12个月以上,赠送连续签到卡3张
使用连续签到卡
12月07日漏签0天
abap吧 关注:2,988贴子:15,797
  • 看贴

  • 图片

  • 吧主推荐

  • 视频

  • 游戏

  • 7回复贴,共1页
<<返回abap吧
>0< 加载中...

Error in module RSQL of the database interface

  • 只看楼主
  • 收藏

  • 回复
  • 夏木之叶
  • 武林高手
    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.


  • 夏木之叶
  • 武林高手
    9
该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
从qals表中捞取一个月的检验批类型为 iqc 检验,差不多有十几万条数据,一运行就报错了。
如何解决!


2025-12-07 18:27:29
广告
不感兴趣
开通SVIP免广告
  • 夏木之叶
  • 武林高手
    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"


  • james_lx
  • 四方游侠
    5
该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
oracle,增加临时表空间


  • 饿啊饿啊饿啊恩
  • 人海孤鸿
    4
该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
你把你出错的代码贴出来看看呢。
十几万条数据不足以DUMP的。
IN的输入条件太多会造成这个DUMP,在RZ10可以配置,或者使用FOR ALL ENTRIES IN替代IN 也可以。


登录百度账号

扫二维码下载贴吧客户端

下载贴吧APP
看高清直播、视频!
  • 贴吧页面意见反馈
  • 违规贴吧举报反馈通道
  • 贴吧违规信息处理公示
  • 7回复贴,共1页
<<返回abap吧
分享到:
©2025 Baidu贴吧协议|隐私政策|吧主制度|意见反馈|网络谣言警示