合并报表个别包表上报提示不是用于集团上报报表，但是查询报表接收显示已经审批接收，用 CTRL+ALT+SHIFT+R更新系统又报错。
错误信息：Sql1 execute exception : DELETE FROM T_CSL_RptReceived DEL_RECEIVE
WHERE EXISTS(
SELECT 1
FROM T_CSL_RptReceived RECEIVE
INNER JOIN T_CSL_CslReport RPT
ON RPT.FID = RECEIVE.FREPORTID
INNER JOIN T_RPT_Template TPLV1
ON RPT.FTemplateID = TPLV1.FID
INNER JOIN T_RPT_Template TPLV2
ON TPLV1.FGROUP = TPLV2.FGROUP
INNER JOIN T_CSL_TempletDispense TDISP
ON( TPLV2.FID = TDISP.FDispenseSrcID
AND RPT.forgunitid = TDISP.fcompanyid )
INNER JOIN T_ORG_Tree TREE
ON( TDISP.FOrgboundID = TREE.FID
AND TREE.FID = RECEIVE.FORGTREEID
AND TREE.FNUMBER = '001' )
WHERE( RPT.FENDDATE < TREE.FSTARTDATE
OR ( TREE.FENDDATE IS NOT NULL
AND RPT.FENDDATE > TREE.FENDDATE ) )
AND DEL_RECEIVE.FID = RECEIVE.FID
)
Caused exception message is: 'DEL_RECEIVE' 附近有语法错误。
错误详细堆栈信息：com.kingdee.bos.BOSException: Sql1 execute exception : DELETE FROM T_CSL_RptReceived DEL_RECEIVE
WHERE EXISTS(
SELECT 1
FROM T_CSL_RptReceived RECEIVE
INNER JOIN T_CSL_CslReport RPT
ON RPT.FID = RECEIVE.FREPORTID
INNER JOIN T_RPT_Template TPLV1
ON RPT.FTemplateID = TPLV1.FID
INNER JOIN T_RPT_Template TPLV2
ON TPLV1.FGROUP = TPLV2.FGROUP
INNER JOIN T_CSL_TempletDispense TDISP
ON( TPLV2.FID = TDISP.FDispenseSrcID
AND RPT.forgunitid = TDISP.fcompanyid )
INNER JOIN T_ORG_Tree TREE
ON( TDISP.FOrgboundID = TREE.FID
AND TREE.FID = RECEIVE.FORGTREEID
AND TREE.FNUMBER = '001' )
WHERE( RPT.FENDDATE < TREE.FSTARTDATE
OR ( TREE.FENDDATE IS NOT NULL
AND RPT.FENDDATE > TREE.FENDDATE ) )
AND DEL_RECEIVE.FID = RECEIVE.FID
)
Caused exception message is: 'DEL_RECEIVE' 附近有语法错误。
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)
at com.kingdee.eas.fi.gr.cslrpt.app.CslReportControllerBean.deleteReceiveWithErrorOrgTreeVersion(CslReportControllerBean.java:5705)
at com.kingdee.eas.fi.gr.cslrpt.app.CslReportControllerBean._rptReceiveLostRepair(CslReportControllerBean.java:5618)
at com.kingdee.eas.fi.gr.cslrpt.app.AbstractCslReportControllerBean.rptReceiveLostRepair(AbstractCslReportControllerBean.java:1372)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:60)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at com.sun.proxy.$Proxy885.rptReceiveLostRepair(Unknown Source)
at com.kingdee.eas.fi.gr.cslrpt.CslReport.rptReceiveLostRepair(CslReport.java:960)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gr_1_cslrpt_1_ICslReport.pi150(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gr_1_cslrpt_1_ICslReport.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
Caused by: java.sql.SQLException: 'DEL_RECEIVE' 附近有语法错误。
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:500)
at com.apusic.jdbc.adapter.StatementHandle.execute(StatementHandle.java:245)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:255)
... 22 more
Caused by: java.sql.SQLException
java.sql.SQLException: 'DEL_RECEIVE' 附近有语法错误。
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:500)
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.gr.cslrpt.app.CslReportControllerBean.deleteReceiveWithErrorOrgTreeVersion(CslReportControllerBean.java:5705)
at com.kingdee.eas.fi.gr.cslrpt.app.CslReportControllerBean._rptReceiveLostRepair(CslReportControllerBean.java:5618)
at com.kingdee.eas.fi.gr.cslrpt.app.AbstractCslReportControllerBean.rptReceiveLostRepair(AbstractCslReportControllerBean.java:1372)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:94)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)
at java.lang.reflect.Method.invoke(Method.java:619)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_REQUIRED(TxInvokerBean.java:60)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_REQUIRED(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:171)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at com.sun.proxy.$Proxy885.rptReceiveLostRepair(Unknown Source)
at com.kingdee.eas.fi.gr.cslrpt.CslReport.rptReceiveLostRepair(CslReport.java:960)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gr_1_cslrpt_1_ICslReport.pi150(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_fi_1_gr_1_cslrpt_1_ICslReport.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceCreateObjectAndInvoke(RPCService.java:611)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:122)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
推荐阅读