金蝶KIS BOS
      金蝶K3
      金蝶K/3 WISE
      金蝶K/3 RISE

库存调拨单查询报中断

来源:宁波金蝶   发布时间: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备09062560号 电话:0574-27818676传真:0574-27818675  手机:15957871790
地址(ADD):浙江省宁波市中山东路93号 网址:www.nbjxsoft.cn
Copyright 2006 Auto Parts All Right Reserved