库存调拨单查询报中断:
错误信息: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"));
//。。。。各查询瘦身字段处理同上
}