Cloud V6.0
新增核算维度“销售主管”,维度类型=基础资料、维度来源=销售员。
现在只要是挂有销售主管维度科目在新增凭证录入销售主管维度值则报错,报错截图及系统日志如下所示:
报错详细信息:
[{"operation":"GL_VOUCHER.F8BClick.$$FDETAILID__FF100019"}]
发生时间:23:20:59
错误来源: Kingdee.BOS.SQL
错误信息:ERROR. Token's value : from, token's type : Keyword, line 1, column 79
===================================================
调用堆栈:
at Kingdee.BOS.SQL.Parser.SqlExprParser.primary()
at Kingdee.BOS.SQL.Parser.SqlExprParser.expr()
at Kingdee.BOS.SQL.Parser.SelectParser.selectList(IList selectItemCol)
at Kingdee.BOS.SQL.Parser.SelectParser.select(Boolean parseOrderBy)
at Kingdee.BOS.SQL.Parser.SqlExprParser.inRest(SqlExpr expr)
at Kingdee.BOS.SQL.Parser.SqlExprParser.expr()
at Kingdee.BOS.SQL.Parser.SelectParser.where(SqlSelect select)
at Kingdee.BOS.SQL.Parser.SelectParser.select(Boolean parseOrderBy)
at Kingdee.BOS.SQL.Parser.SqlStmtParser.select()
at Kingdee.BOS.SQL.Parser.SqlStmtParser.stmt()
at Kingdee.BOS.SQL.Parser.SqlStmtParser.stmtList(IList stmtCol, Token tok)
at Kingdee.BOS.SQL.Parser.SqlParser.parseStmtList()
at Kingdee.BOS.SQL.TransUtil.getStmtList(String ksql)
错误数据: System.Collections.ListDictionaryInternal
App_Data/log:
Log里边有段明显错误的SQL语句:
SELECT DISTINCT FBizOrgId FROM V_BD_SALESMAN WHERE FID in (select distinct from V_BD_SALESMAN where FBizOrgId in(100008) )
后边括号里的 distinct后边没有接字段。
推荐阅读