打了总账补丁：PT109652
版本：eas8.2
报错信息如下：
错误信息：create tempTable error!
Caused exception message is: Sql1 execute exception : insert /*+ append */ into VTZ8BJ9VX2H70CIL0WW7CIZ2EUXAJ4O5S5OD(KSQL_SEQ,FAccountID,FBookedDate,FPeriod,voucherId,entryID,entrySeq,FDescription,FBalSeq,FEndBalanceFor,FYearDebitFor,FYearCreditFor) SELECT t.FAccountID, t.FBookedDate, t.FPeriod, t.voucherId, t.entryID, t.entrySeq, t.FDescription, t.FBalSeq, t.FEndBalanceFor, t.FYearDebitFor, t.FYearCreditFor FROM VTZ8BJ9VX2KBYKV68S86HLTI0P5Y66MNNB t LEFT OUTER JOIN T_GL_Voucher voucher ON voucher.fid = t.voucherid LEFT OUTER JOIN t_pm_user creator ON voucher.fcreatorid = creator.fid LEFT OUTER JOIN t_pm_user creator ON voucher.fcreatorid = creator.fid ORDER BY t.FPeriod ASC, t.FBalSeq ASC, t.KSQL_SEQ ASC
Caused exception message is: 在 FROM 子句中多次指定了相关名称 'creator'。
错误详细堆栈信息：com.kingdee.bos.BOSException: create tempTable error!
Caused exception message is: Sql1 execute exception : insert /*+ append */ into VTZ8BJ9VX2H70CIL0WW7CIZ2EUXAJ4O5S5OD(KSQL_SEQ,FAccountID,FBookedDate,FPeriod,voucherId,entryID,entrySeq,FDescription,FBalSeq,FEndBalanceFor,FYearDebitFor,FYearCreditFor) SELECT t.FAccountID, t.FBookedDate, t.FPeriod, t.voucherId, t.entryID, t.entrySeq, t.FDescription, t.FBalSeq, t.FEndBalanceFor, t.FYearDebitFor, t.FYearCreditFor FROM VTZ8BJ9VX2KBYKV68S86HLTI0P5Y66MNNB t LEFT OUTER JOIN T_GL_Voucher voucher ON voucher.fid = t.voucherid LEFT OUTER JOIN t_pm_user creator ON voucher.fcreatorid = creator.fid LEFT OUTER JOIN t_pm_user creator ON voucher.fcreatorid = creator.fid ORDER BY t.FPeriod ASC, t.FBalSeq ASC, t.KSQL_SEQ ASC
Caused exception message is: 在 FROM 子句中多次指定了相关名称 'creator'。
at com.kingdee.eas.fi.gl.rpt.app.dao.SeqTableRptDataManager.createSeqTempTable(SeqTableRptDataManager.java:170)
at com.kingdee.eas.fi.gl.rpt.app.dao.SeqTableRptDataManager.init(SeqTableRptDataManager.java:43)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.createDataSourceTable(AbstractGLRptDao.java:226)
at com.kingdee.eas.fi.gl.rpt.app.GLRptBaseFacadeControllerBean._query(GLRptBaseFacadeControllerBean.java:124)
at com.kingdee.eas.fi.gl.rpt.app.AbstractGLRptBaseFacadeControllerBean.query(AbstractGLRptBaseFacadeControllerBean.java:51)
at sun.reflect.GeneratedMethodAccessor609.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at com.sun.proxy.$Proxy469.query(Unknown Source)
at com.kingdee.eas.fi.gl.rpt.GLRptBaseFacade.query(GLRptBaseFacade.java:48)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptSubLedgerFacade.pi18(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptSubLedgerFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:603)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.kingdee.bos.BOSException: Sql1 execute exception : insert /*+ append */ into VTZ8BJ9VX2H70CIL0WW7CIZ2EUXAJ4O5S5OD(KSQL_SEQ,FAccountID,FBookedDate,FPeriod,voucherId,entryID,entrySeq,FDescription,FBalSeq,FEndBalanceFor,FYearDebitFor,FYearCreditFor) SELECT t.FAccountID, t.FBookedDate, t.FPeriod, t.voucherId, t.entryID, t.entrySeq, t.FDescription, t.FBalSeq, t.FEndBalanceFor, t.FYearDebitFor, t.FYearCreditFor FROM VTZ8BJ9VX2KBYKV68S86HLTI0P5Y66MNNB t LEFT OUTER JOIN T_GL_Voucher voucher ON voucher.fid = t.voucherid LEFT OUTER JOIN t_pm_user creator ON voucher.fcreatorid = creator.fid LEFT OUTER JOIN t_pm_user creator ON voucher.fcreatorid = creator.fid ORDER BY t.FPeriod ASC, t.FBalSeq ASC, t.KSQL_SEQ ASC
Caused exception message is: 在 FROM 子句中多次指定了相关名称 'creator'。
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)
at com.kingdee.eas.fi.gl.rpt.app.dao.SeqTableRptDataManager.createSeqTempTable(SeqTableRptDataManager.java:165)
... 25 more
Caused by: java.sql.SQLException: 在 FROM 子句中多次指定了相关名称 'creator'。
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:504)
at com.apusic.jdbc.adapter.StatementHandle.execute(StatementHandle.java:245)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:255)
... 26 more
Caused by: com.kingdee.bos.BOSException
com.kingdee.bos.BOSException: Sql1 execute exception : insert /*+ append */ into VTZ8BJ9VX2H70CIL0WW7CIZ2EUXAJ4O5S5OD(KSQL_SEQ,FAccountID,FBookedDate,FPeriod,voucherId,entryID,entrySeq,FDescription,FBalSeq,FEndBalanceFor,FYearDebitFor,FYearCreditFor) SELECT t.FAccountID, t.FBookedDate, t.FPeriod, t.voucherId, t.entryID, t.entrySeq, t.FDescription, t.FBalSeq, t.FEndBalanceFor, t.FYearDebitFor, t.FYearCreditFor FROM VTZ8BJ9VX2KBYKV68S86HLTI0P5Y66MNNB t LEFT OUTER JOIN T_GL_Voucher voucher ON voucher.fid = t.voucherid LEFT OUTER JOIN t_pm_user creator ON voucher.fcreatorid = creator.fid LEFT OUTER JOIN t_pm_user creator ON voucher.fcreatorid = creator.fid ORDER BY t.FPeriod ASC, t.FBalSeq ASC, t.KSQL_SEQ ASC
Caused exception message is: 在 FROM 子句中多次指定了相关名称 'creator'。
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)
at com.kingdee.eas.fi.gl.rpt.app.dao.SeqTableRptDataManager.createSeqTempTable(SeqTableRptDataManager.java:165)
at com.kingdee.eas.fi.gl.rpt.app.dao.SeqTableRptDataManager.init(SeqTableRptDataManager.java:43)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.createDataSourceTable(AbstractGLRptDao.java:226)
at com.kingdee.eas.fi.gl.rpt.app.GLRptBaseFacadeControllerBean._query(GLRptBaseFacadeControllerBean.java:124)
at com.kingdee.eas.fi.gl.rpt.app.AbstractGLRptBaseFacadeControllerBean.query(AbstractGLRptBaseFacadeControllerBean.java:51)
at sun.reflect.GeneratedMethodAccessor609.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at com.sun.proxy.$Proxy469.query(Unknown Source)
at com.kingdee.eas.fi.gl.rpt.GLRptBaseFacade.query(GLRptBaseFacade.java:48)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptSubLedgerFacade.pi18(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptSubLedgerFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:603)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: 在 FROM 子句中多次指定了相关名称 'creator'。
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:504)
at com.apusic.jdbc.adapter.StatementHandle.execute(StatementHandle.java:245)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:255)
... 26 more
Caused by: java.sql.SQLException
java.sql.SQLException: 在 FROM 子句中多次指定了相关名称 'creator'。
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:504)
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.fi.gl.rpt.app.dao.SeqTableRptDataManager.createSeqTempTable(SeqTableRptDataManager.java:165)
at com.kingdee.eas.fi.gl.rpt.app.dao.SeqTableRptDataManager.init(SeqTableRptDataManager.java:43)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.createDataSourceTable(AbstractGLRptDao.java:226)
at com.kingdee.eas.fi.gl.rpt.app.GLRptBaseFacadeControllerBean._query(GLRptBaseFacadeControllerBean.java:124)
at com.kingdee.eas.fi.gl.rpt.app.AbstractGLRptBaseFacadeControllerBean.query(AbstractGLRptBaseFacadeControllerBean.java:51)
at sun.reflect.GeneratedMethodAccessor609.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at com.sun.proxy.$Proxy469.query(Unknown Source)
at com.kingdee.eas.fi.gl.rpt.GLRptBaseFacade.query(GLRptBaseFacade.java:48)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptSubLedgerFacade.pi18(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gl_1_rpt_1_IGLRptSubLedgerFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:603)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

有老师给看下么？