总是报以下错误，怎么解决啊？

crj

aused by: com.justep.model.exception.ModelException: 编码: JUSTEP154064; 提示: 计算表达式(getRole(currentPersonMemberID())='员工') or (getRole(currentPersonMemberID())='职员')出错
        at com.justep.model.exception.ModelException.create(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.evaluate(Unknown Source)
        at com.justep.system.process.ExpressEngine.calculate(Unknown Source)
        at com.justep.system.process.ExpressEngine.calculateBoolean(Unknown Source)
        at com.justep.system.process.ActivityEnabledEngine.unitfy(Unknown Source)
        at com.justep.system.process.ActivityEnabledEngine.isActiveActivity(Unknown Source)
        at com.justep.system.process.ActivityEnabledEngine.a(Unknown Source)
        at com.justep.system.process.ActivityEnabledEngine.execute(Unknown Source)
        at com.justep.system.process.ProcessQueryEngine.a(Unknown Source)
        at com.justep.system.process.ProcessQueryEngine.outPlace(Unknown Source)
        at com.justep.system.process.ProcessQueryEngine.outActivityInstance(Unknown Source)
        at com.justep.system.process.AdvanceProcessQueryEngine.d(Unknown Source)
        at com.justep.system.process.AdvanceProcessQueryEngine.a(Unknown Source)
        at com.justep.system.process.AdvanceProcessQueryEngine.execute(Unknown Source)
        at com.justep.system.process.ProcessEngine.advanceQuery(Unknown Source)
        at ProcessProcedure.advanceProcessQuery(ProcessProcedure.java:268)
        ... 35 more
Caused by: com.justep.model.exception.ModelException: 编码: JUSTEP154075; 提示: 调用函数getRole出错
        at com.justep.model.exception.ModelException.create(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.functionExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.constExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.unaryExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.multiExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.addExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.compExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.notExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.andExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.orExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.unaryExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.multiExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.addExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.compExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.notExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.andExpression(Unknown Source)
        at com.justep.system.ksql.parser.ExpressionImpl.orExpression(Unknown Source)
        ... 50 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:592)
        ... 66 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT opr.sName FROM SA_OPRole opr where opr=(SELECT opa.sAuthorizeRoleID FROM SA_OPAuthorize opa where opa.sOrgID like 'PSN01@ORG01%')
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.KSQL.select(Unknown Source)
        at FindRole.getRoleById(FindRole.java:18)
        ... 70 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT  opr.SNAME AS sName FROM SA_OPRole opr  WHERE opr.sID = (SELECT  opa.sAuthorizeRoleID AS sAuthorizeRoleID FROM SA_OPAuthorize opa  WHERE opa.SORGID LIKE ?)), binds: [PSN01@ORG01%]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 75 more
Caused by: java.sql.SQLException: 子查询返回的值不止一个。当子查询跟随在 =、!=、<、<=、>、>= 之后，或子查询用作表达式时，这种情况是不允许的。
        at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
        at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
        at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
        at net.sourceforge.jtds.jdbc.TdsCore.isDataInResultSet(TdsCore.java:792)
        at net.sourceforge.jtds.jdbc.JtdsResultSet.<init>(JtdsResultSet.java:146)
        at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:424)
        at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 76 more

fpj

1、你写的KSQL有问题
opr=(SELECT ）     如果select 后有多个值 ，那个 opr= 就会有错，你改成  opr in  (select) 试试；

2、计算表达式有问题
getRole 是你自定义的函数吗？我知道在 BIZ Java里可以用 ContextHelper.getOperator().getRoles()，直接获取当前操作者的角色

crj

fpj 发表于 2014-7-28 16:06
1、你写的KSQL有问题
opr=(SELECT ）     如果select 后有多个值 ，那个 opr= 就会有错，你改成  opr in  ( ...

getRole这个函数是系统自带的函数，不是我自己定义的，奇怪的是我用什么函数都是报错的，我怀疑是权限的问题

jishuang

(SELECT opa.sAuthorizeRoleID FROM SA_OPAuthorize opa where opa.sOrgID like 'PSN01@ORG01%')
返回的值是多个

where opr=(SELECT opa.sAuthorizeRoleID FROM SA_OPAuthorize opa where opa.sOrgID like 'PSN01@ORG01%')不能用=

改为in

crj

jishuang 发表于 2014-7-28 17:22
(SELECT opa.sAuthorizeRoleID FROM SA_OPAuthorize opa where opa.sOrgID like 'PSN01@ORG01%')
返回的值 ...

问题是在哪里改啊。这应该是系统自带的，不是我自己写的东西啊

jishuang

平台没有提供getRole这个函数，这个函数应该是自己自定义的，看看自定义的函数中拼的ksql是不是不正确

crj

jishuang 发表于 2014-7-29 09:39
平台没有提供getRole这个函数，这个函数应该是自己自定义的，看看自定义的函数中拼的ksql是不是不正确 ...

好的，找到了，谢谢您的解答！