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

来源：互联网发布：java compareto易错点编辑：程序博客网时间：2024/06/06 19:34

提交订单,当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

0 0