科目余额表打开时错误
金蝶云社区-云社区用户47Z81095
云社区用户47Z81095
0人赞赏了该文章 839次浏览 未经作者许可,禁止转载编辑于2017年08月13日 10:08:39

打开科目余额表时错误提示:
查询出现异常。A severe error occurred on the current command. The results, if any, should be discarded.

点击详细信息:
CREATE TABLE TMP457F6FB07FC911E7A13DF8DB88F (FACCOUNTBOOKID INT not null DEFAULT 0, FYEAR INT not null DEFAULT 0, FPERIOD INT not null DEFAULT 0, FACCOUNTID INT not null DEFAULT 0, FDETAILID INT not null DEFAULT 0, FCURRENCYID INT not null DEFAULT 0, FBEGINBALANCEFOR DECIMAL (23, 10) null DEFAULT 0, FBEGINBALANCE DECIMAL (23, 10) null DEFAULT 0, FDEBITFOR DECIMAL (23, 10) null DEFAULT 0, FDEBIT DECIMAL (23, 10) null DEFAULT 0, FCREDITFOR DECIMAL (23, 10) null DEFAULT 0, FCREDIT DECIMAL (23, 10) null DEFAULT 0, FYTDDEBITFOR DECIMAL (23, 10) null DEFAULT 0, FYTDDEBIT DECIMAL (23, 10) null DEFAULT 0, FYTDCREDITFOR DECIMAL (23, 10) null DEFAULT 0, FYTDCREDIT DECIMAL (23, 10) null DEFAULT 0, FENDBALANCEFOR DECIMAL (23, 10) null DEFAULT 0, FENDBALANCE DECIMAL (23, 10) null DEFAULT 0, FADJUSTPERIOD INT not null DEFAULT 0, FYEARPERIOD AS (((FYEAR * 100) + FPERIOD)))
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.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL)
at Kingdee.K3.FIN.App.Core.VoucherService.BalanceReportService.CreateUpdateTempTable(Context ctx)
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, Boolean showFullName)
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__DisplayClass4d.b__49()