bug--报销单审批通过节点挂起

used by: com.kingdee.bos.BOSException :
Sql1 execute exception : update T_BC_EvectionLoanBill set fstate=80 where fid not in(select fbillid from T_BC_EvectionLoanBillEntry where fbudgetBalance>0 and fbillid in ()) and fid in()
Caused exception message is: “)”附近有语法错误。
java.sql.SQLException: “)”附近有语法错误。
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2886)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2328)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:638)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:614)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:573)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:810)
at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java:1290)
at com.kingdee.bos.sql.shell.KDStatement.execute(KDStatement.java:480)
at com.apusic.jdbc.adapter.StatementHandle.execute(StatementHandle.java:245)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:255)
at com.kingdee.eas.cp.bc.util.ReverseUtil.reverseSourceBillState(ReverseUtil.java:631)
at com.kingdee.eas.cp.bc.util.ReverseUtil.checkSourceBillCanClose(ReverseUtil.java:526)
at com.kingdee.eas.cp.bc.app.ExpenseAccountFacadeControllerBean._setPassStateEvent(ExpenseAccountFacadeControllerBean.java:449)
at com.kingdee.eas.cp.bc.app.AbstractExpenseAccountFacadeControllerBean.setPassStateEvent(AbstractExpenseAccountFacadeControllerBean.java:158)
at sun.reflect.GeneratedMethodAccessor2765.invoke(Unknown Source)