SBL-DAT-00500 There were more rows than could bereturned.

最新推荐文章于 2021-06-22 10:06:53 发布

wyq731

最新推荐文章于 2021-06-22 10:06:53 发布

阅读量635

点赞数 1

分类专栏：开发配置文章标签： siebel

本文链接：https://blog.csdn.net/wyq731/article/details/41823427

版权

开发配置专栏收录该内容

1 篇文章 0 订阅

订阅专栏

提交订单,当Order Line item有大量记录需要update时,报错:
SBL-DAT-00500: There were more rows than could bereturned. Please refine your query tobring back fewer rows
日志:
Buscomp:Order Entry - Line Items, Forward Only: 0, Fetch Rows: 500, Fetch All Time:1.366 seconds.
Errorinvoking service 'CUT eSales Order Entry Toolkit Service', method'SetLIAccounts' at step 'Set Line Accounts / Status'.
原因&解决:
WF: SIS OM Submit Order Process中的step: Set Line Accounts / Status,当line item 数量超过500时会报错,因为此时查询结果已超过maximum,这个属性可以在BC的maximum cursor size设置,默认是500,过大可能会引起性能问题.
BS:CUT eSales Order Entry Toolkit Service Method: SetLIAccounts的解释: Rolls down the Service & BillingAccount field values from the Quote Header to the line items if value is NULL