版本6.1
在操作组织变更系统验证时报错:
parse error. detail message is :
not support token:Kingdee.BOS.SQL.Parser.Token
source sql is :
SELECT FPARENTID FROM T_ORG_ORGANIZATIONS WHERE EXISTS ( (fn_StrSplit(@FPARENTID, ',',1)) B WHERE B.FID=FPARENTID) AND FForbidStatus = 'A' GROUP BY FPARENTID HAVING COUNT (*) > 1
Server stack trace:
at Kingdee.BOS.SQL.TransUtil.getStmtList(String ksql)
at Kingdee.BOS.SQL.TransUtil.Translate(String kSql, Int32 targetDbType, FormatOptions options)
at Kingdee.BOS.App.Data.AbstractDatabase.CreateCommandByCommandType(CommandType commandType, String commandText, Boolean needTranslate, Int32 commandTimeout)
at Kingdee.BOS.App.Data.AbstractDatabase.CreateCommandByCommandType(CommandType commandType, String commandText, Int32 commandTimeout)
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.Core.OrganizationService.FilterOrgsHasSubOrg(Context ctx, Int64[] orgId)
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.IOrganizationService.FilterOrgsHasSubOrg(Context ctx, Int64[] orgId)
at Kingdee.BOS.ServiceHelper.OrganizationServiceHelper.FilterOrgsHasSubOrg(Context ctx, Int64[] orgId)
at Kingdee.BOS.Business.PlugIn.Organizations.Change.CheckSubOrg.OnValidate(OnCheckArgs e)
at Kingdee.BOS.Core.Base.Organization.PlugIn.ChangeOrgPlugInProxy.FireOnValidate(OnCheckArgs e, BeforeValidationDelegate bValidateDelegate, AfterValidationDelegate aValidateDelegate)
at Kingdee.BOS.Business.PlugIn.Organizations.Change.CheckProgressPlugIn.CheckingOrg(List`1 curConditions, List`1 curPlugIns, List`1 orgIds)
at Kingdee.BOS.Business.PlugIn.Organizations.Change.CheckProgressPlugIn.
请问如何处理???
推荐阅读