删除科目初始数据报错
金蝶云社区-Rossin
Rossin
0人赞赏了该文章 735次浏览 未经作者许可,禁止转载编辑于2018年08月08日 10:53:54
环境: cloud7.1 tel 18502860511 qq 41132475
需要修改账簿启用期间,在删除初始科目数据的时候,最后一行数据删除后保存报错
There are no records in the SqlDataRecord enumeration. To send a table-valued parameter with no rows, use a null reference for the value instead.


[{"operation":"GL_InitBalance.MBIClick.tbSave"}]
发生时间: 10:48:16
错误编号: 986117c37bfd4b95a45b087915bdc07a
错误信息: There are no records in the SqlDataRecord enumeration. To send a table-valued parameter with no rows, use a null reference for the value instead.
===================================================
调用堆栈:
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc, Boolean sync, TaskCompletionSource`1 completion, Int32 startRpc, Int32 startParam)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Kingdee.BOS.App.Data.AbstractDatabase.DoExecuteReader(DbCommand command, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior, Boolean bNewCn)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, Boolean bNewCn)
at Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, List`1 paramList)
at Kingdee.K3.FIN.GL.App.Core.InitBalanceService.DeleteZeroRecords(Context ctx, Int64 iBookId, Int32 iStartYear, Int32 iStartPeriod, String balance, String balanceQty)
at Kingdee.K3.FIN.GL.App.Core.InitBalanceService.ProcessBalanceData(Context ctx, String strTempBal, String strBalTableName, String strBalQTYTableName, Int64 iBookId, Int32 iStartYear, Int32 iStartPeriod, Int32 minLevel, Int32 maxLevel)
at Kingdee.K3.FIN.GL.App.Core.InitBalanceService.SaveBalance(Context ctx, String strTempBal, Int64 iBookId, Int64 iCurrencyId, Int32 iStartYear, Int32 iStartPeriod, Boolean bExistsAdjustPeriod)
at Kingdee.K3.FIN.GL.App.Core.InitBalanceService.SaveTempInitBalance(Context ctx, String strTempFlex, Int64 iBookId, Int64 iCurrencyId, Int32 iStartYear, Int32 iStartPeriod)
at Kingdee.K3.FIN.GL.App.Core.InitBalanceService.SaveInitBalance(Context ctx, Dictionary`2 dctParam, List`1 dyList)
at Kingdee.K3.FIN.GL.ServiceHelper.InitBalanceServiceHelper.SaveInitBalance(Context ctx, Dictionary`2 dctParam, List`1 dyList)
at Kingdee.K3.FIN.GL.Business.PlugIn.InitBalanceEdit.SaveData()
at Kingdee.K3.FIN.GL.Business.PlugIn.InitBalanceEdit.BarItemClick(BarItemClickEventArgs e)
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireBarItemClick(BarItemClickEventArgs e)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.BarItemClick(String parentKey, String barItemKey, BarDataManager bar, Int32 bartype)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.MainBarItemClick(String barItemKey)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.MainBarItemClick(String itemKey, JSONArray postDatas)