CLOUD5.0
之前科目余额表都用的很正常，今天突然之间，打开科目余额表，系统提示错误了，详细的错误如下：
查询出现异常。对象名 'T_GL_BALANCE_102943' 无效。
详细信息如下：
INSERT INTO TMPD57545CC559011E78A9090B11C2 (FACCOUNTBOOKID, FYEAR, FPERIOD, FACCOUNTID, FDETAILID, FCURRENCYID, FBEGINBALANCEFOR, FBEGINBALANCE, FDEBITFOR, FDEBIT, FCREDITFOR, FCREDIT, FYTDDEBITFOR, FYTDDEBIT, FYTDCREDITFOR, FYTDCREDIT, FENDBALANCEFOR, FENDBALANCE, FADJUSTPERIOD) SELECT A.FACCOUNTBOOKID, A.FYear, A.FPeriod, A.FAccountID, A.FDetailID, A.FCurrencyID, A.FBeginBalanceFor, A.FBeginBalance, A.FDebitFor, A.FDebit, A.FCreditFor, A.FCredit, A.FDebitFor fytddebitfor, A.FDebit fytddebit, A.FCreditFor fytdcreditfor, A.FCredit fytdcredit, (A.FDebitFor - A.FCreditFor) fendbalancefor, (A.FDebit - A.FCredit) fendbalance, 0 fadjustperiod FROM T_GL_BALANCE_102943 A WHERE ((A.FACCOUNTBOOKID = @FBOOKID AND (A.FYEARPERIOD >= @FBEGINYEARPERIOD)) AND (A.FYEARPERIOD <= @FENDYEARPERIOD))
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
at Kingdee.K3.FIN.App.Core.VoucherService.BalanceReportService.GetBalaceDataNotPost(Context ctx, VoucherPostParameters postParam, String balanceTempTable, Int32 endDateNum, Int32 currDateNum, DynamicObject accountBookObject)
at Kingdee.K3.FIN.App.Core.VoucherService.BalanceReportService.GetBalanceData(Context ctx, VoucherPostParameters postParam)
at Kingdee.K3.FIN.GL.App.Core.AccountBalanceStatement..ctor(Context ctx, Int64 acctBookId, Int64 currencyId, Int32 startYear, Int32 endYear, Int32 startPeriod, Int32 endPeriod, String startAccountNum, String endAccountNum, Int32 accountLevel, Boolean noPost, Int64 acctTableId, Boolean viewItem, Boolean forbid, Boolean balanceTotal, Boolean noUsed, Boolean noPeriodUsed, Boolean noYearUsed, Boolean noZerobal)
at Kingdee.K3.FIN.GL.App.Report.AccountBalanceService.AccountBalanceDeal(String tableName, Int64 acctTableId, String filter, String orderby)
at Kingdee.K3.FIN.GL.App.Report.AccountBalanceService.BuilderSql(IRptParams filter, String tableName)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.CreateTempTable(IRptParams filter, String tablename)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetDataForVirtual(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetReportData(ReportServiceParameter parameter)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISysReportService.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetReportData(ReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass3d.
这个是怎么回事呢？