点击采购订单左侧的分组列表(付款条件分组)报错
金蝶云社区-云社区用户Ox175387
云社区用户Ox175387
0人赞赏了该文章 536次浏览 未经作者许可,禁止转载编辑于2016年10月23日 11:29:10


点击采购订单左侧的分组列表(付款条件分组)报错,如下图

完整的报错提示如下
operation":"PUR_PurchaseOrder_List.GetEntryData"}]
发生时间: 2016-10-23 11:28:06
错误编号: BOS_ExecuteReader
错误信息: 无法绑定由多个部分组成的标识符 "t1.FPAYCONDITIONID"。
Sql语句: SELECT * FROM (SELECT t0.FBILLNO fbillno, t0.FDATE fdate, t0.FSUPPLIERID fsupplierid_id, t0.FDOCUMENTSTATUS fdocumentstatus, t0.FPURCHASEORGID fpurchaseorgid_id, t0.FCLOSESTATUS fclosestatus, t3.FMATERIALID fmaterialid_id, t3.FUNITID funitid_id, t3.FQTY fqty, t3_D.FDELIVERYDATE fdeliverydate, t3.FGIVEAWAY fgiveaway, t3.FMRPCLOSESTATUS fmrpclosestatus, t0.FBILLTYPEID fbilltypeid, t0.FPURCHASEORGID fpurchaseorgid, t0.FOBJECTTYPEID fobjecttypeid, t0.FID fid, t3.FENTRYID t3_fentryid, t3.FSeq t3_fseq, ROW_NUMBER() OVER( ORDER BY t0.FCREATEDATE DESC, t0.FBILLNO DESC, t3.FSeq ASC) fidentityid FROM t_PUR_POOrder t0 LEFT OUTER JOIN t_PUR_POOrderEntry t3 ON t0.FID = t3.FID LEFT OUTER JOIN t_PUR_POOrderEntry_D t3_D ON t3.FENTRYID = t3_D.FENTRYID WHERE (t0.FPURCHASEORGID IN (1, 100081, 100082) AND ((t0.FPURCHASEORGID IN (100081, 0) AND t0.FOBJECTTYPEID = 'PUR_PurchaseOrder') AND t1.FPAYCONDITIONID = '20001'))) tlist WHERE ((fidentityid >= 1) AND (fidentityid <= 200)) OPTION ( MAXDOP 0)
===================================================
调用堆栈:

Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteObject[T](Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteDynamicObject(Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
在 Kingdee.BOS.App.Core.ListDataService.GetData(Context ctx, String sql, DynamicObjectType dt, List`1 sqlParams)

Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.IListDataServices.GetData(Context ctx, String sql, DynamicObjectType dt, List`1 sqlParams)
在 Kingdee.BOS.ServiceHelper.ListDataServiceHelper.GetData(Context ctx, String sql, DynamicObjectType dt, List`1 sqlParams)
在 Kingdee.BOS.Model.List.DataAccessPolicy.DirectSQLDataAccessTreeList.GetTreeListData(Int32 start, Int32 rows, FormGroup group, String groupAliasName, Boolean displayChildData)
在 Kingdee.BOS.Model.List.TreeListModel.GetDataByDirectSQL(Int32 start, Int32 rows)
在 Kingdee.BOS.Model.List.ListModel.GetData(Int32 start, Int32 rows, Boolean needRefreshTree)
在 Kingdee.BOS.Web.List.ListView.PrepareDatas(Int32 startRow, Int32& limit, FormOperationEnum operatioEnum, String groupRows, String permissionItemId, JSONObject data)
在 Kingdee.BOS.Web.List.ListView.GetDataByPermission(Int32 startRow, Int32 limit, FormOperationEnum operatioEnum, String groupRows, String permissionItemId, DynamicObjectCollection pageDatas)
在 Kingdee.BOS.Web.List.ListView.GetData(Int32 startRow, Int32 limit, String groupRows)
在 Kingdee.BOS.Web.List.ListView.GetEntryData(String key, Int32 start, Int32 limit, String groupRows)
在 Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.GetEntryData(String key, Int32 start, Int32 limit, String groupRows)