库存调拨单查询报中断

来源:宁波金蝶   发布时间:2011/5/12 17:26:24   浏览次数:0


库存调拨单查询报中断

问题现象

库存调拨单查询报中断:

错误信息:com.kingdee.bos.SQLDataException: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []
. The query sql is:SELECT

"STOCKTRANSFERBILL".FAuditTime AS "AUDITTIME",
"STOCKTRANSFERBILL".FBaseStatus AS "BASESTATUS",
"STOCKTRANSFERBILL".FNumber AS "NUMBER",
"STOCKTRANSFERBILL".FBizDate AS "BIZDATE",
"STOCKTRANSFERBILL".FSourceBillID AS "SOURCEBILLID",
"STOCKTRANSFERBILL".FCreateTime AS "CREATETIME",
"STOCKTRANSFERBILL".FID AS "ID",
"ENTRY".FQty AS "ENTRY.QTY",

解决方案

  二选一即可
                                  

                                        1.升级数据库版本到oracle 10g的最后一个版本(版本号为10.2.0.5)
 
2.二次开发继承PurInWarehsBillListUI类,并继续getBOTPSelectors(),进行字段瘦身(标准产品不知

                     道哪些字段二次开发会用到),去掉一些字段,将部分.*修改为.id/.number/.name

                     扩展PurInWarehsBillListUI类
                     重写
                     getBOTPSelectors(){
                    //获取父类selectors
                    SelectItemCollection sic = super.getBOTPSelectors();
                   //大部分字段不需要查询所有子属性 如库存组织,移除.*查询。
                    sic.removeObject("storageOrgUnit.*");
                   //改为查询id、name、number
                    sic.add(new SelectorItemInfo("storageOrgUnit.id"));
                    sic.add(new SelectorItemInfo("storageOrgUnit.name"));
                    sic.add(new SelectorItemInfo("storageOrgUnit.number"));
                   //。。。。各查询瘦身字段处理同上
                     }


 上一条新闻:金蝶专项服务客户案例之IT运维
 下一条新闻:押金退款如何处理
[打印本文]  [返回服务中心]  [关闭窗口]
友情链接:

宁波金蝶软件有限公司 2006 版权所有 浙ICP备16034465号-2 销售服务电话:15957871790
地址(ADD):浙江省宁波市 网址:www.nbjxsoft.cn
Copyright 2006 Auto Parts All Right Reserved