在物料中分配管理单元执行时报错，错误如下
2015-04-30 14:14:29 INFO [con.out] [2015-04-30 14:14:29,037 ERROR DefaultQuartzScheduler_Worker-9]GL balance calculate error!
com.kingdee.bos.BOSException: Sql3 execute exception : select max(logNum), fcompanyid from ( select count(*) logNum, fcompanyid from t_gl_voucherlog where fisupdating = 0 group by fcompanyid ) t where t.fcompanyid not in (select fid from t_bas_transaction where fisupdating = 1) group by fcompanyid
Caused exception message is: ORA-00942: table or view does not exist
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:137)
at com.kingdee.eas.fi.gl.app.GLBalanceFacadeControllerBean._updateVoucherBalanceNewTrans(GLBalanceFacadeControllerBean.java:96)
at com.kingdee.eas.fi.gl.app.AbstractGLBalanceFacadeControllerBean.updateVoucherBalanceNewTrans(AbstractGLBalanceFacadeControllerBean.java:64)
at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRES_NEW(TxInvokerBean.java:69)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRES_NEW(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:195)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy128.updateVoucherBalanceNewTrans(Unknown Source)
at com.kingdee.eas.fi.gl.GLBalanceFacade.updateVoucherBalanceNewTrans(GLBalanceFacade.java:57)
at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:194)
at $Proxy127.updateVoucherBalanceNewTrans(Unknown Source)
at com.kingdee.eas.fi.gl.app.BalanceCalJob.execute(BalanceCalJob.java:33)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:204)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:800)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:840)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1125)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
at com.kingdee.bos.sql.shell.KDStatement.executeQuery(KDStatement.java:595)
at com.apusic.jdbc.adapter.StatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:127)
... 20 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:744)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:204)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:800)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:840)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1125)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
at com.kingdee.bos.sql.shell.KDStatement.executeQuery(KDStatement.java:595)
at com.apusic.jdbc.adapter.StatementHandle.executeQuery(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:127)
at com.kingdee.eas.fi.gl.app.GLBalanceFacadeControllerBean._updateVoucherBalanceNewTrans(GLBalanceFacadeControllerBean.java:96)
at com.kingdee.eas.fi.gl.app.AbstractGLBalanceFacadeControllerBean.updateVoucherBalanceNewTrans(AbstractGLBalanceFacadeControllerBean.java:64)
at sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:116)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRES_NEW(TxInvokerBean.java:69)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRES_NEW(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:195)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at $Proxy128.updateVoucherBalanceNewTrans(Unknown Source)
at com.kingdee.eas.fi.gl.GLBalanceFacade.updateVoucherBalanceNewTrans(GLBalanceFacade.java:57)
at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at com.kingdee.bos.ResponseInvocationHandler.invoke(ResponseInvocationHandler.java:194)
at $Proxy127.updateVoucherBalanceNewTrans(Unknown Source)
at com.kingdee.eas.fi.gl.app.BalanceCalJob.execute(BalanceCalJob.java:33)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
在数据库执行了这段代码select max(logNum), fcompanyid from ( select count(*) logNum, fcompanyid from t_gl_voucherlog where fisupdating = 0 group by fcompanyid ) t where t.fcompanyid not in (select fid from t_bas_transaction where fisupdating = 1) group by fcompanyid
出来一个空表，没有数据，没有提示错误
请问这是什么原因
推荐阅读