# 问题现象
web流程设计器配置职员参与人时报错，无法正常显示职员数据，如下图：
``` java
详细信息: java.lang.RuntimeException: Prepared or callable statement has more than 2000 parameter markers.
at com.kingdee.wbos.life.common.data.Util.innerTranslateRuntimeException(Util.java:21)
at com.kingdee.wbos.life.metax.err.DefaultErrorLogger.translate(DefaultErrorLogger.java:56)
at com.kingdee.wbos.life.common.data.ErrorWrapper.wrap(ErrorWrapper.java:20)
at com.kingdee.wbos.life.meta.obj.entity.OperationDelegate.invoke(OperationDelegate.java:45)
at com.kingdee.wbos.life.db.transaction.DefaultTransactionManager.invoke(DefaultTransactionManager.java:91)
at com.kingdee.wbos.life.util.db.DbUtil.invoke(DbUtil.java:510)
at com.kingdee.wbos.life.meta.obj.entity.EntityAdapter.execute(EntityAdapter.java:112)
......
Caused by: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:1246)
at net.sourceforge.jtds.jdbc.SQLParser.parse(SQLParser.java:156)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.<init>(JtdsPreparedStatement.java:97)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2468)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareStatement(ConnectionJDBC2.java:2426)
......
```
# 问题原因
查询到职员数据过多，超多2000就会有此问题，可在查询分析器查询如下sql确认：
``` sql
select count(1) from T_BD_PERSON where femployeetypeid not in (
select fid from T_HR_BDEMPLOYEETYPE where finservice =1 or finservice=4 or finservice is null
) or fdeletedstatus = 2
```
# 解决方案
861版已有补丁优化，可打web流程设计器补丁PT164240验证。
