进销售订单列表报错
金蝶云社区-zjkyyst
zjkyyst
0人赞赏了该文章 1,395次浏览 未经作者许可,禁止转载编辑于2014年03月05日 11:35:01

这系统也忒脆弱了啊,这好好的都没动他,他又发飙了。。。。

列名 'FAMOUNT' 无效。

发生时间: 2014-03-05 11:25:10
错误编号: BOS_ExecuteReader
错误信息: 列名 'FAMOUNT' 无效。
Sql语句: SELECT T_BD_MATERIAL.FMATERIALID, T_BD_MATERIAL.FMasterId, T_BD_MATERIAL.FNUMBER, T_BD_MATERIAL.FUSEORGID, T_BD_MATERIAL.FMATERIALGROUP, T_BD_MATERIAL.FNW1, T_BD_MATERIAL.FGW1, T_BD_MATERIAL.FVOLUME, T_BD_MATERIAL.FAMOUNT, T_BD_MATERIAL.FCZPP, T_BD_MATERIAL.FCX FROM T_BD_MATERIAL INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT T_BD_MATERIAL_L.FPkId, T_BD_MATERIAL_L.FLocaleId, T_BD_MATERIAL_L.FNAME, T_BD_MATERIAL_L.FDESCRIPTION, T_BD_MATERIAL_L.FSPECIFICATION, T_BD_MATERIAL_L.FMATERIALID FROM T_BD_MATERIAL_L INNER JOIN T_BD_MATERIAL ON T_BD_MATERIAL_L.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT t_BD_MaterialBase.FEntryId, t_BD_MaterialBase.FERPCLSID, t_BD_MaterialBase.FISINVENTORY, t_BD_MaterialBase.FISSALE, t_BD_MaterialBase.FISASSET, t_BD_MaterialBase.FISSUBCONTRACT, t_BD_MaterialBase.FISPRODUCE, t_BD_MaterialBase.FISPURCHASE, t_BD_MaterialBase.FBASEUNITID, t_BD_MaterialBase.FTAXTYPE, t_BD_MaterialBase.FCATEGORYID, t_BD_MaterialBase.FMATERIALID FROM t_BD_MaterialBase INNER JOIN T_BD_MATERIAL ON t_BD_MaterialBase.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT t_BD_MaterialStock.FEntryId, t_BD_MaterialStock.FSTOREUNITID, t_BD_MaterialStock.FAUXUNITID, t_BD_MaterialStock.FSTOCKID, t_BD_MaterialStock.FEXPUNIT, t_BD_MaterialStock.FONLINELIFE, t_BD_MaterialStock.FEXPPERIOD, t_BD_MaterialStock.FISBATCHMANAGE, t_BD_MaterialStock.FISKFPERIOD, t_BD_MaterialStock.FISEXPPARTOFLOT, t_BD_MaterialStock.FMATERIALID FROM t_BD_MaterialStock INNER JOIN T_BD_MATERIAL ON t_BD_MaterialStock.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT t_BD_MaterialSale.FEntryId, t_BD_MaterialSale.FSALEPRICEUNITID, t_BD_MaterialSale.FSALEUNITID, t_BD_MaterialSale.FISRETURN, t_BD_MaterialSale.FOUTSTOCKLMTH, t_BD_MaterialSale.FOUTSTOCKLMTL, t_BD_MaterialSale.FMATERIALID FROM t_BD_MaterialSale INNER JOIN T_BD_MATERIAL ON t_BD_MaterialSale.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT t_bd_MaterialPurchase.FEntryId, t_bd_MaterialPurchase.FPURCHASEPRICEUNITID, t_bd_MaterialPurchase.FISVMIBUSINESS, t_bd_MaterialPurchase.FMATERIALID FROM t_bd_MaterialPurchase INNER JOIN T_BD_MATERIAL ON t_bd_MaterialPurchase.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT t_BD_MaterialPlan.FEntryId, t_BD_MaterialPlan.FRESERVETYPE, t_BD_MaterialPlan.FPLANMODE, t_BD_MaterialPlan.FMATERIALID FROM t_BD_MaterialPlan INNER JOIN T_BD_MATERIAL ON t_BD_MaterialPlan.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT t_BD_MaterialProduce.FEntryId, t_BD_MaterialProduce.FISMAINPRD, t_BD_MaterialProduce.FMATERIALID FROM t_BD_MaterialProduce INNER JOIN T_BD_MATERIAL ON t_BD_MaterialProduce.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT t_BD_MaterialAuxPty.FEntryID, t_BD_MaterialAuxPty.FISENABLE, t_BD_MaterialAuxPty.FISCOMCONTROL, t_BD_MaterialAuxPty.FAUXPROPERTYID, t_BD_MaterialAuxPty.FMATERIALID FROM t_BD_MaterialAuxPty INNER JOIN T_BD_MATERIAL ON t_BD_MaterialAuxPty.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
SELECT t_BD_MaterialInvPty.FEntryID, t_BD_MaterialInvPty.FISENABLE, t_BD_MaterialInvPty.FINVPTYID, t_BD_MaterialInvPty.FMATERIALID FROM t_BD_MaterialInvPty INNER JOIN T_BD_MATERIAL ON t_BD_MaterialInvPty.FMATERIALID = T_BD_MATERIAL.FMATERIALID INNER JOIN @PKValue_udt1 t ON t.FID = T_BD_MATERIAL.FMATERIALID;
===================================================
调用堆栈:

Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.OLEDbDriver.ExecuteReader(SelectCallback callback, IEnumerable`1 tablesSchema, DbMetadataTable rootTable, IList`1 selectSqls, ReadWhere where, OperateOption option)
at Kingdee.BOS.Orm.Drivers.DbDriverBase.Select(SelectCallback callback, IEnumerable`1 tablesSchema, DbMetadataTable rootTable, ReadWhere where, OperateOption option)
at Kingdee.BOS.Orm.DataManager.DataManagerImplement.Read(ReadWhere where, OperateOption option)
at Kingdee.BOS.Orm.DataManager.DataManagerImplement.AutoBatchExecute(IEnumerable ids, OperateOption option, Func`2 func)
at Kingdee.BOS.Orm.DataManager.DataManagerImplement.Read(IEnumerable ids, OperateOption option)
at Kingdee.BOS.App.Core.CachedLoadReferenceObjectManager.Read(IDataEntityType dt, Object[] oids)
at Kingdee.BOS.Orm.LoadReferenceObjectManager.DoTasks(ICollection`1 tasks, Dictionary`2 dictReferenceWhere)
at Kingdee.BOS.App.Core.ListDataService.GetData(Context ctx, String sql, DynamicObjectType dt)

Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.IListDataServices.GetData(Context ctx, String sql, DynamicObjectType dt)
at Kingdee.BOS.ServiceHelper.ListDataServiceHelper.GetData(Context ctx, String sql, DynamicObjectType dt)
at Kingdee.BOS.Model.List.DataAccessPolicy.DirectSQLDataAccess.GetListData(Int32 start, Int32 rows, String orderInfo)
at Kingdee.BOS.Model.List.ListModel.GetListData(Int32 start, Int32 rows, Boolean needRefreshTree, String orderInfo)
at Kingdee.BOS.Model.List.ListModel.GetData(Int32 start, Int32 rows, Boolean needRefreshTree)
at Kingdee.BOS.Web.List.ListView.GetDataByPermission(Int32 startRow, Int32 limit, FormOperationEnum operatioEnum, String groupRows, String permissionItemId)
at Kingdee.BOS.Web.List.ListView.GetData(Int32 startRow, Int32 limit, String groupRows)