根据报错信息,sql语句是错误的,少了from关键字,只有where关键字
由于暂时不能提单处理,所以放到这里来,希望总部的人员看一下
报错信息如下:
错误信息:Can't found propertyUnit: [accountTableID] in [com.kingdee.eas.fi.gl.app.AcctCussent]!, query : com.kingdee.eas.fi.gl.app.AcctCussentQuery, view :
SELECT id, period, bizDate, voucher.number, description, account.number, account.longName, measureUnit.name, endDate, quantity, verifiedQty, unVerifiedQty,
holdedQty, unHoldedQty, currency.name, currency.precision, originalAmount, verifiedAmtFor, unVerifiedAmtFor, holdedAmtFor, unHoldedAmtFor, localAmount,
verifiedAmtLocal, unVerifiedAmtLocal, holdedAmtLocal, unHoldedAmtLocal, reportingAmount, verifiedAmtRpt, unVerifiedAmtRpt, holdedAmtRpt, unHoldedAmtRpt, voucher.id, assGrp.customer.name, assGrp.provider.name, assGrp.companyOrg.name, assGrp.person.name, bizNumber, voucherType, accountTableID.id WHERE company.id = 'Ut4AAAAACgPM567U' AND (isinit = 0 OR isinit = 1 AND isinitclosed = 1) AND (period.periodYear = 2015 AND period.periodNumber = 1 AND (voucher.bizStatus IS NOT NULL) AND (voucher.bizStatus <> 0) AND (voucher.bizStatus <> 2) OR (voucher.bizStatus IS NULL)) AND (assGrp.customer.id IS NOT NULL) AND account.accountTableID.id = 'Ut4AAAAE+b0XaY5t' ORDER BY assGrp.customer.number ASC, VARBizDate ASC, id ASC
错误详细堆栈信息:com.kingdee.bos.BOSException: Can't found propertyUnit: [accountTableID] in [com.kingdee.eas.fi.gl.app.AcctCussent]!, query : com.kingdee.eas.fi.gl.app.AcctCussentQuery, view :
SELECT id, period, bizDate, voucher.number, description, account.number, account.longName, measureUnit.name, endDate, quantity, verifiedQty, unVerifiedQty, holdedQty, unHoldedQty, currency.name, currency.precision, originalAmount, verifiedAmtFor, unVerifiedAmtFor, holdedAmtFor, unHoldedAmtFor, localAmount, verifiedAmtLocal, unVerifiedAmtLocal, holdedAmtLocal, unHoldedAmtLocal, reportingAmount, verifiedAmtRpt, unVerifiedAmtRpt, holdedAmtRpt, unHoldedAmtRpt, voucher.id, assGrp.customer.name, assGrp.provider.name, assGrp.companyOrg.name, assGrp.person.name, bizNumber, voucherType, accountTableID.id
WHERE company.id = 'Ut4AAAAACgPM567U' AND (isinit = 0 OR isinit = 1 AND isinitclosed = 1) AND (period.periodYear = 2015 AND period.periodNumber = 1 AND (voucher.bizStatus IS NOT NULL) AND (voucher.bizStatus <> 0) AND (voucher.bizStatus <> 2) OR (voucher.bizStatus IS NULL)) AND (assGrp.customer.id IS NOT NULL) AND account.accountTableID.id = 'Ut4AAAAE+b0XaY5t' ORDER BY assGrp.customer.number ASC, VARBizDate ASC, id ASC
at com.kingdee.bos.metadata.query.util.QueryDeleUtil.processPropertyName(QueryDeleUtil.java:380)
at com.kingdee.bos.metadata.query.QueryDeleUpdater.updateQueryField(QueryDeleUpdater.java:97)
at com.kingdee.bos.metadata.query.QueryDeleUpdater.innerUpdateQuery(QueryDeleUpdater.java:70)
at com.kingdee.bos.metadata.query.QueryDeleUpdater.updateQuery(QueryDeleUpdater.java:39)
at com.kingdee.bos.metadata.query.util.QuerySqlAccessBase.init(QuerySqlAccessBase.java:103)
at com.kingdee.bos.dao.query.server.QueryContext.init(QueryContext.java:151)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.innerOpenQuery(VirtualModeDataAccess.java:217)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.innerOpenQuery(VirtualModeDataAccess.java:184)
at com.kingdee.bos.dao.query.server.VirtualModeDataAccess.openQuery(VirtualModeDataAccess.java:165)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_IVirtualModeDataAccess.pi19(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_bos_1_dao_1_query_1_server_1_IVirtualModeDataAccess.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)