已解决【科目余额表】查询出现异常!
金蝶云社区-云小爱
云小爱
0人赞赏了该文章 1,858次浏览 未经作者许可,禁止转载编辑于2015年01月07日 10:38:44

[i]有几个月份能够查询
但是10,11,12月份就不能查询[/i]

如下:
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Kingdee.BOS.App.Data.Sql.SqlDatabase.ExecuteBatch(List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatchWithTime(Context ctx, List`1 sqlArray, Int32 batchSize, Int32 commandTimeout)
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, Int64[] acctBookIds)
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.Model.Report.SysReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass33.b__2f()