在组织机构上新增字段,在过滤列表中选择组织时报错
金蝶云社区-quHongan
quHongan
0人赞赏了该文章 932次浏览 未经作者许可,禁止转载编辑于2017年01月11日 13:02:08

新增字段如下图,名称为F_MEG_SHORTNAME

在凭证模板上设置条件时报错,如下图。

发生时间: 2017-01-11 01:02:15
错误编号: BOS_ExecuteReader
错误信息: 列名 'F_MEG_SHORTNAME' 无效。
Sql语句: SELECT V_SCM_OWNERORG.FOrgID, V_SCM_OWNERORG.FDOCUMENTSTATUS, V_SCM_OWNERORG.FFORBIDSTATUS, V_SCM_OWNERORG.FNUMBER, V_SCM_OWNERORG.FMODIFIERID, V_SCM_OWNERORG.FCREATORID, V_SCM_OWNERORG.FCREATEDATE, V_SCM_OWNERORG.FMODIFYDATE, V_SCM_OWNERORG.FCONTACT, V_SCM_OWNERORG.FORGFORMID, V_SCM_OWNERORG.FTEL, V_SCM_OWNERORG.FACCTORGTYPE, V_SCM_OWNERORG.FPARENTID, V_SCM_OWNERORG.FFORBIDORID, V_SCM_OWNERORG.FFORBIDDATE, V_SCM_OWNERORG.FISBUSINESSORG, V_SCM_OWNERORG.FISACCOUNTORG, V_SCM_OWNERORG.FAUDITDATE, V_SCM_OWNERORG.FAUDITORID, V_SCM_OWNERORG.FPOSTCODE, V_SCM_OWNERORG.FORGFUNCTIONS FROM V_SCM_OWNERORG WHERE V_SCM_OWNERORG.FOrgID IN (SELECT fid FROM @PKValue_udt1);
SELECT V_SCM_OWNERORG_L.FPkId, V_SCM_OWNERORG_L.FLocaleId, V_SCM_OWNERORG_L.FNAME, V_SCM_OWNERORG_L.FDESCRIPTION, V_SCM_OWNERORG_L.FADDRESS, V_SCM_OWNERORG_L.F_MEG_SHORTNAME, V_SCM_OWNERORG_L.FOrgID FROM V_SCM_OWNERORG_L INNER JOIN V_SCM_OWNERORG ON V_SCM_OWNERORG_L.FOrgID = V_SCM_OWNERORG.FOrgID WHERE V_SCM_OWNERORG.FOrgID IN (SELECT fid FROM @PKValue_udt1);
===================================================
调用堆栈:

Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
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, Boolean bNewCn)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, Boolean bNewCn)
at Kingdee.BOS.App.Data.Sql.KSql4SQLDataReader..ctor(IList`1 selectSqls, Context ctx, ReadWhere where, IEnumerable`1 tablesSchema, DbMetadataTable rootTable)
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.BusinessDataReader.Load(Object[] pkArray, DynamicObjectType type, Boolean loadReferenceData)

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.IViewService.Load(Context ctx, BusinessInfo businessInfo, List`1 selector, OQLFilter ofilter)
at Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.Load(Context ctx, BusinessInfo businessInfo, List`1 selector, OQLFilter ofilter)
at Kingdee.BOS.Business.PlugIn.Organizations.OrganizationList.GetOrganizations()
at Kingdee.BOS.Business.PlugIn.Organizations.OrganizationList.OnInitialize(InitializeEventArgs e)
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireOnInitialize(InitializeEventArgs e)
at Kingdee.BOS.Web.DynamicForm.AbstractDynamicWebFormView.Initialize(DynamicFormOpenParameter param, IResourceServiceProvider serviceProvider)
at Kingdee.BOS.Web.List.ListView.Initialize(DynamicFormOpenParameter param, IResourceServiceProvider serviceProvider)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.InitObject(String pageId, String methodName)
at Kingdee.BOS.Web.List.ListController.InitObject(String formID, String layoutViewID, String methodName)
at Kingdee.BOS.ServiceFacade.ServicesStub.DynamicForm.DynamicFormService.Call(String serviceName, String pageId, String layoutId, String methodName, IList pparams, JavaScriptSerializer js)

版本:6.1+PT108346
QQ:469126910