EAS期未结账报错!请问怎么处理呢?急!
1,055次浏览
编辑于2016年07月07日 16:25:40
日志如下:
错误信息:Sql222 execute exception : insert into t_gl_assistbalance(fbaltype, forgunitid, fperiodid, faccountid, fassistgrpid, fcurrencyid, fperiodyear, fperiodnumber)
select ab.fbaltype, ab.forgunitid, 'H+cAAAABgfaCOIxM' fperiodid, ab.faccountid, ab.fassistgrpid, ab.fcurrencyid, tp.fperiodyear, tp.fperiodnumber
from t_gl_assistbalance ab
inner join t_bd_period tp on tp.fid='H+cAAAABgfaCOIxM'
where ab.forgunitid = ? and ab.fperiodid = ?
and (ab.fendbalancefor<>0 or ab.fendbalancelocal<>0 or ab.fendbalancerpt<>0 or ab.fendqty<>0 or ab.fyeardebitfor<>0 or ab.fyearcreditfor<>0 or ab.fyeardebitlocal<>0 or ab.fyearcreditlocal<>0 or ab.fyeardebitrpt<>0 or ab.fyearcreditrpt<>0 or ab.fyearpnlfor<>0 or ab.fyearpnllocal<>0 or ab.fyearpnlrpt<>0 or ab.fyeardebitqty<>0 or ab.fyearcreditqty<>0)
and not exists (select 1 from t_gl_assistbalance ab1
where ab1.fbaltype=ab.fbaltype and ab1.forgunitid=ab.forgunitid and ab1.fperiodid = ? and ab1.faccountid=ab.faccountid and ab1.fassistgrpid=ab.fassistgrpid and ab1.fcurrencyid=ab.fcurrencyid)
Caused exception message is: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
Caused exception message is: Sql222 execute exception : insert into t_gl_assistbalance(fbaltype, forgunitid, fperiodid, faccountid, fassistgrpid, fcurrencyid, fperiodyear, fperiodnumber)
select ab.fbaltype, ab.forgunitid, 'H+cAAAABgfaCOIxM' fperiodid, ab.faccountid, ab.fassistgrpid, ab.fcurrencyid, tp.fperiodyear, tp.fperiodnumber
from t_gl_assistbalance ab
inner join t_bd_period tp on tp.fid='H+cAAAABgfaCOIxM'
where ab.forgunitid = ? and ab.fperiodid = ?
and (ab.fendbalancefor<>0 or ab.fendbalancelocal<>0 or ab.fendbalancerpt<>0 or ab.fendqty<>0 or ab.fyeardebitfor<>0 or ab.fyearcreditfor<>0 or ab.fyeardebitlocal<>0 or ab.fyearcreditlocal<>0 or ab.fyeardebitrpt<>0 or ab.fyearcreditrpt<>0 or ab.fyearpnlfor<>0 or ab.fyearpnllocal<>0 or ab.fyearpnlrpt<>0 or ab.fyeardebitqty<>0 or ab.fyearcreditqty<>0)
and not exists (select 1 from t_gl_assistbalance ab1
where ab1.fbaltype=ab.fbaltype and ab1.forgunitid=ab.forgunitid and ab1.fperiodid = ? and ab1.faccountid=ab.faccountid and ab1.fassistgrpid=ab.fassistgrpid and ab1.fcurrencyid=ab.fcurrencyid)
Caused exception message is: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
错误详细堆栈信息:com.kingdee.bos.BOSException: Sql222 execute exception : insert into t_gl_assistbalance(fbaltype, forgunitid, fperiodid, faccountid, fassistgrpid, fcurrencyid, fperiodyear, fperiodnumber)
select ab.fbaltype, ab.forgunitid, 'H+cAAAABgfaCOIxM' fperiodid, ab.faccountid, ab.fassistgrpid, ab.fcurrencyid, tp.fperiodyear, tp.fperiodnumber
from t_gl_assistbalance ab
inner join t_bd_period tp on tp.fid='H+cAAAABgfaCOIxM'
where ab.forgunitid = ? and ab.fperiodid = ?
and (ab.fendbalancefor<>0 or ab.fendbalancelocal<>0 or ab.fendbalancerpt<>0 or ab.fendqty<>0 or ab.fyeardebitfor<>0 or ab.fyearcreditfor<>0 or ab.fyeardebitlocal<>0 or ab.fyearcreditlocal<>0 or ab.fyeardebitrpt<>0 or ab.fyearcreditrpt<>0 or ab.fyearpnlfor<>0 or ab.fyearpnllocal<>0 or ab.fyearpnlrpt<>0 or ab.fyeardebitqty<>0 or ab.fyearcreditqty<>0)
and not exists (select 1 from t_gl_assistbalance ab1
where ab1.fbaltype=ab.fbaltype and ab1.forgunitid=ab.forgunitid and ab1.fperiodid = ? and ab1.faccountid=ab.faccountid and ab1.fassistgrpid=ab.fassistgrpid and ab1.fcurrencyid=ab.fcurrencyid)
Caused exception message is: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
Caused exception message is: Sql222 execute exception : insert into t_gl_assistbalance(fbaltype, forgunitid, fperiodid, faccountid, fassistgrpid, fcurrencyid, fperiodyear, fperiodnumber)
select ab.fbaltype, ab.forgunitid, 'H+cAAAABgfaCOIxM' fperiodid, ab.faccountid, ab.fassistgrpid, ab.fcurrencyid, tp.fperiodyear, tp.fperiodnumber
from t_gl_assistbalance ab
inner join t_bd_period tp on tp.fid='H+cAAAABgfaCOIxM'
where ab.forgunitid = ? and ab.fperiodid = ?
and (ab.fendbalancefor<>0 or ab.fendbalancelocal<>0 or ab.fendbalancerpt<>0 or ab.fendqty<>0 or ab.fyeardebitfor<>0 or ab.fyearcreditfor<>0 or ab.fyeardebitlocal<>0 or ab.fyearcreditlocal<>0 or ab.fyeardebitrpt<>0 or ab.fyearcreditrpt<>0 or ab.fyearpnlfor<>0 or ab.fyearpnllocal<>0 or ab.fyearpnlrpt<>0 or ab.fyeardebitqty<>0 or ab.fyearcreditqty<>0)
and not exists (select 1 from t_gl_assistbalance ab1
where ab1.fbaltype=ab.fbaltype and ab1.forgunitid=ab.forgunitid and ab1.fperiodid = ? and ab1.faccountid=ab.faccountid and ab1.fassistgrpid=ab.fassistgrpid and ab1.fcurrencyid=ab.fcurrencyid)
Caused exception message is: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
at com.kingdee.eas.basedata.common.perf.app.CreateJobFacadeControllerBean._executeJob(CreateJobFacadeControllerBean.java:198)
at com.kingdee.eas.basedata.common.perf.app.AbstractCreateJobFacadeControllerBean.executeJob(AbstractCreateJobFacadeControllerBean.java:49)
at sun.reflect.GeneratedMethodAccessor2078.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_SUPPORTS(TxInvokerBean.java:61)
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 $Proxy509.executeJob(Unknown Source)
at com.kingdee.eas.basedata.common.perf.CreateJobFacade.executeJob(CreateJobFacade.java:48)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_common_1_perf_1_ICreateJobFacade.pi8(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_common_1_perf_1_ICreateJobFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:773)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:138)
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: com.kingdee.bos.BOSException: Sql222 execute exception : insert into t_gl_assistbalance(fbaltype, forgunitid, fperiodid, faccountid, fassistgrpid, fcurrencyid, fperiodyear, fperiodnumber)
select ab.fbaltype, ab.forgunitid, 'H+cAAAABgfaCOIxM' fperiodid, ab.faccountid, ab.fassistgrpid, ab.fcurrencyid, tp.fperiodyear, tp.fperiodnumber
from t_gl_assistbalance ab
inner join t_bd_period tp on tp.fid='H+cAAAABgfaCOIxM'
where ab.forgunitid = ? and ab.fperiodid = ?
and (ab.fendbalancefor<>0 or ab.fendbalancelocal<>0 or ab.fendbalancerpt<>0 or ab.fendqty<>0 or ab.fyeardebitfor<>0 or ab.fyearcreditfor<>0 or ab.fyeardebitlocal<>0 or ab.fyearcreditlocal<>0 or ab.fyeardebitrpt<>0 or ab.fyearcreditrpt<>0 or ab.fyearpnlfor<>0 or ab.fyearpnllocal<>0 or ab.fyearpnlrpt<>0 or ab.fyeardebitqty<>0 or ab.fyearcreditqty<>0)
and not exists (select 1 from t_gl_assistbalance ab1
where ab1.fbaltype=ab.fbaltype and ab1.forgunitid=ab.forgunitid and ab1.fperiodid = ? and ab1.faccountid=ab.faccountid and ab1.fassistgrpid=ab.fassistgrpid and ab1.fcurrencyid=ab.fcurrencyid)
Caused exception message is: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:304)
at com.kingdee.eas.fi.gl.app.GLBalanceFacadeControllerBean._transBalanceToNextPeriod(GLBalanceFacadeControllerBean.java:1457)
at com.kingdee.eas.fi.gl.app.AbstractGLBalanceFacadeControllerBean.transBalanceToNextPeriod(AbstractGLBalanceFacadeControllerBean.java:172)
at sun.reflect.GeneratedMethodAccessor1979.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_REQUIRED(TxInvokerBean.java:57)
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 $Proxy12.transBalanceToNextPeriod(Unknown Source)
at com.kingdee.eas.fi.gl.GLBalanceFacade.transBalanceToNextPeriod(GLBalanceFacade.java:156)
at sun.reflect.GeneratedMethodAccessor1978.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 $Proxy11.transBalanceToNextPeriod(Unknown Source)
at com.kingdee.eas.fi.gl.app.GLPeriodEndFacadeControllerBean._closePeriod(GLPeriodEndFacadeControllerBean.java:5617)
at com.kingdee.eas.fi.gl.app.GLPeriodEndFacadeControllerBean._closePeriod(GLPeriodEndFacadeControllerBean.java:5480)
at com.kingdee.eas.fi.gl.app.AbstractGLPeriodEndFacadeControllerBean.closePeriod(AbstractGLPeriodEndFacadeControllerBean.java:166)
at sun.reflect.GeneratedMethodAccessor2082.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_REQUIRED(TxInvokerBean.java:57)
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 $Proxy632.closePeriod(Unknown Source)
at com.kingdee.eas.fi.gl.GLPeriodEndFacade.closePeriod(GLPeriodEndFacade.java:120)
at sun.reflect.GeneratedMethodAccessor2081.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 $Proxy642.closePeriod(Unknown Source)
at com.kingdee.eas.fi.gl.app.GLPeriodEndJobHandler.execute(GLPeriodEndJobHandler.java:79)
at com.kingdee.eas.basedata.common.perf.app.CreateJobFacadeControllerBean._executeJob(CreateJobFacadeControllerBean.java:195)
... 19 more
Caused by: java.sql.SQLException: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at com.kingdee.bos.sql.shell.KDPreparedStatement.execute(KDPreparedStatement.java:264)
at com.apusic.jdbc.adapter.PreparedStatementHandle.execute(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:294)
... 56 more
Caused by: com.kingdee.bos.BOSException
com.kingdee.bos.BOSException: Sql222 execute exception : insert into t_gl_assistbalance(fbaltype, forgunitid, fperiodid, faccountid, fassistgrpid, fcurrencyid, fperiodyear, fperiodnumber)
select ab.fbaltype, ab.forgunitid, 'H+cAAAABgfaCOIxM' fperiodid, ab.faccountid, ab.fassistgrpid, ab.fcurrencyid, tp.fperiodyear, tp.fperiodnumber
from t_gl_assistbalance ab
inner join t_bd_period tp on tp.fid='H+cAAAABgfaCOIxM'
where ab.forgunitid = ? and ab.fperiodid = ?
and (ab.fendbalancefor<>0 or ab.fendbalancelocal<>0 or ab.fendbalancerpt<>0 or ab.fendqty<>0 or ab.fyeardebitfor<>0 or ab.fyearcreditfor<>0 or ab.fyeardebitlocal<>0 or ab.fyearcreditlocal<>0 or ab.fyeardebitrpt<>0 or ab.fyearcreditrpt<>0 or ab.fyearpnlfor<>0 or ab.fyearpnllocal<>0 or ab.fyearpnlrpt<>0 or ab.fyeardebitqty<>0 or ab.fyearcreditqty<>0)
and not exists (select 1 from t_gl_assistbalance ab1
where ab1.fbaltype=ab.fbaltype and ab1.forgunitid=ab.forgunitid and ab1.fperiodid = ? and ab1.faccountid=ab.faccountid and ab1.fassistgrpid=ab.fassistgrpid and ab1.fcurrencyid=ab.fcurrencyid)
Caused exception message is: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:304)
at com.kingdee.eas.fi.gl.app.GLBalanceFacadeControllerBean._transBalanceToNextPeriod(GLBalanceFacadeControllerBean.java:1457)
at com.kingdee.eas.fi.gl.app.AbstractGLBalanceFacadeControllerBean.transBalanceToNextPeriod(AbstractGLBalanceFacadeControllerBean.java:172)
at sun.reflect.GeneratedMethodAccessor1979.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_REQUIRED(TxInvokerBean.java:57)
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 $Proxy12.transBalanceToNextPeriod(Unknown Source)
at com.kingdee.eas.fi.gl.GLBalanceFacade.transBalanceToNextPeriod(GLBalanceFacade.java:156)
at sun.reflect.GeneratedMethodAccessor1978.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 $Proxy11.transBalanceToNextPeriod(Unknown Source)
at com.kingdee.eas.fi.gl.app.GLPeriodEndFacadeControllerBean._closePeriod(GLPeriodEndFacadeControllerBean.java:5617)
at com.kingdee.eas.fi.gl.app.GLPeriodEndFacadeControllerBean._closePeriod(GLPeriodEndFacadeControllerBean.java:5480)
at com.kingdee.eas.fi.gl.app.AbstractGLPeriodEndFacadeControllerBean.closePeriod(AbstractGLPeriodEndFacadeControllerBean.java:166)
at sun.reflect.GeneratedMethodAccessor2082.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_REQUIRED(TxInvokerBean.java:57)
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 $Proxy632.closePeriod(Unknown Source)
at com.kingdee.eas.fi.gl.GLPeriodEndFacade.closePeriod(GLPeriodEndFacade.java:120)
at sun.reflect.GeneratedMethodAccessor2081.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 $Proxy642.closePeriod(Unknown Source)
at com.kingdee.eas.fi.gl.app.GLPeriodEndJobHandler.execute(GLPeriodEndJobHandler.java:79)
at com.kingdee.eas.basedata.common.perf.app.CreateJobFacadeControllerBean._executeJob(CreateJobFacadeControllerBean.java:195)
at com.kingdee.eas.basedata.common.perf.app.AbstractCreateJobFacadeControllerBean.executeJob(AbstractCreateJobFacadeControllerBean.java:49)
at sun.reflect.GeneratedMethodAccessor2078.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_SUPPORTS(TxInvokerBean.java:61)
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 $Proxy509.executeJob(Unknown Source)
at com.kingdee.eas.basedata.common.perf.CreateJobFacade.executeJob(CreateJobFacade.java:48)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_common_1_perf_1_ICreateJobFacade.pi8(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_common_1_perf_1_ICreateJobFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:773)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:138)
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: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at com.kingdee.bos.sql.shell.KDPreparedStatement.execute(KDPreparedStatement.java:264)
at com.apusic.jdbc.adapter.PreparedStatementHandle.execute(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:294)
... 56 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-01502: 索引 'HWCA.PK_GL_ASSTBAL' 或这类索引的分区处于不可用状态
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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:965)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1169)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3338)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3444)
at com.kingdee.bos.sql.shell.KDPreparedStatement.execute(KDPreparedStatement.java:264)
at com.apusic.jdbc.adapter.PreparedStatementHandle.execute(Unknown Source)
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:294)
at com.kingdee.eas.fi.gl.app.GLBalanceFacadeControllerBean._transBalanceToNextPeriod(GLBalanceFacadeControllerBean.java:1457)
at com.kingdee.eas.fi.gl.app.AbstractGLBalanceFacadeControllerBean.transBalanceToNextPeriod(AbstractGLBalanceFacadeControllerBean.java:172)
at sun.reflect.GeneratedMethodAccessor1979.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_REQUIRED(TxInvokerBean.java:57)
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 $Proxy12.transBalanceToNextPeriod(Unknown Source)
at com.kingdee.eas.fi.gl.GLBalanceFacade.transBalanceToNextPeriod(GLBalanceFacade.java:156)
at sun.reflect.GeneratedMethodAccessor1978.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 $Proxy11.transBalanceToNextPeriod(Unknown Source)
at com.kingdee.eas.fi.gl.app.GLPeriodEndFacadeControllerBean._closePeriod(GLPeriodEndFacadeControllerBean.java:5617)
at com.kingdee.eas.fi.gl.app.GLPeriodEndFacadeControllerBean._closePeriod(GLPeriodEndFacadeControllerBean.java:5480)
at com.kingdee.eas.fi.gl.app.AbstractGLPeriodEndFacadeControllerBean.closePeriod(AbstractGLPeriodEndFacadeControllerBean.java:166)
at sun.reflect.GeneratedMethodAccessor2082.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_REQUIRED(TxInvokerBean.java:57)
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 $Proxy632.closePeriod(Unknown Source)
at com.kingdee.eas.fi.gl.GLPeriodEndFacade.closePeriod(GLPeriodEndFacade.java:120)
at sun.reflect.GeneratedMethodAccessor2081.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 $Proxy642.closePeriod(Unknown Source)
at com.kingdee.eas.fi.gl.app.GLPeriodEndJobHandler.execute(GLPeriodEndJobHandler.java:79)
at com.kingdee.eas.basedata.common.perf.app.CreateJobFacadeControllerBean._executeJob(CreateJobFacadeControllerBean.java:195)
at com.kingdee.eas.basedata.common.perf.app.AbstractCreateJobFacadeControllerBean.executeJob(AbstractCreateJobFacadeControllerBean.java:49)
at sun.reflect.GeneratedMethodAccessor2078.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_SUPPORTS(TxInvokerBean.java:61)
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 $Proxy509.executeJob(Unknown Source)
at com.kingdee.eas.basedata.common.perf.CreateJobFacade.executeJob(CreateJobFacade.java:48)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_common_1_perf_1_ICreateJobFacade.pi8(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_basedata_1_common_1_perf_1_ICreateJobFacade.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:773)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:138)
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)
11111111.jpg(55.72KB)
推荐阅读