计提折旧报错违反了 PRIMARY KEY
余伟强
784次浏览
编辑于2016年02月15日 10:38:36
[u]打了 PT102061 补丁后报错 计提折旧[/u]
[u]{"operation":"FA_DEPR.BClick.FDEPR."}]
发生时间： 2016-02-15 10:27:59
错误编号： BOS_ExecuteNonQuery
错误信息： 违反了 PRIMARY KEY 约束“PK_T_FA_DEPREXCEPTION”。不能在对象“dbo.T_FA_DEPREXCEPTION”中插入重复键。重复键值为 (100008)。
语句已终止。
Sql语句： INSERT INTO T_FA_DEPREXCEPTION (FID, FOwnerOrgID, FAcctPolicyID, FYear, FPeriod, FYearPeriod, FAssetTypeID, FAlterID, FErrorDescription, FDOCUMENTSTATUS, FBILLNO) SELECT FTempID, FOwnerOrgID, FAcctPolicyID, FCurrentYear, FCurrentPeriod, FYearPeriod, FAssetTypeID, FAlterID, FErrorDescription, 'C', FBILLNO FROM #TM_FA_ACCTDEPREXCEPTION
===================================================
调用堆栈：
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
at Kingdee.K3.FIN.FA.App.Core.DeprAdjustService.BuildDeprException(String tempTableName)
at Kingdee.K3.FIN.FA.App.Core.AssetDeprService.AssetDepr(Context ctx, List`1 lst, Dictionary`2 dParam)
at Kingdee.K3.FIN.FA.ServiceHelper.AssetDeprServiceHelper.AssetDepr(Context ctx, List`1 lst, Dictionary`2 dParam)
at Kingdee.K3.FIN.FA.Business.PlugIn.AssetDepr.AssetDeprMain()
at Kingdee.K3.FIN.FA.Business.PlugIn.AssetDepr.ButtonClick(ButtonClickEventArgs e)
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireButtonClick(ButtonClickEventArgs e)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.ButtonClick(String key, String menuKey)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.ButtonClick(String buttonKey, String menuKey, JSONArray postDatas[/u]
[u]{"operation":"FA_DEPR.BClick.FDEPR."}]
发生时间： 2016-02-15 10:27:59
错误编号： BOS_ExecuteNonQuery
错误信息： 违反了 PRIMARY KEY 约束“PK_T_FA_DEPREXCEPTION”。不能在对象“dbo.T_FA_DEPREXCEPTION”中插入重复键。重复键值为 (100008)。
语句已终止。
Sql语句： INSERT INTO T_FA_DEPREXCEPTION (FID, FOwnerOrgID, FAcctPolicyID, FYear, FPeriod, FYearPeriod, FAssetTypeID, FAlterID, FErrorDescription, FDOCUMENTSTATUS, FBILLNO) SELECT FTempID, FOwnerOrgID, FAcctPolicyID, FCurrentYear, FCurrentPeriod, FYearPeriod, FAssetTypeID, FAlterID, FErrorDescription, 'C', FBILLNO FROM #TM_FA_ACCTDEPREXCEPTION
===================================================
调用堆栈：
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
at Kingdee.K3.FIN.FA.App.Core.DeprAdjustService.BuildDeprException(String tempTableName)
at Kingdee.K3.FIN.FA.App.Core.AssetDeprService.AssetDepr(Context ctx, List`1 lst, Dictionary`2 dParam)
at Kingdee.K3.FIN.FA.ServiceHelper.AssetDeprServiceHelper.AssetDepr(Context ctx, List`1 lst, Dictionary`2 dParam)
at Kingdee.K3.FIN.FA.Business.PlugIn.AssetDepr.AssetDeprMain()
at Kingdee.K3.FIN.FA.Business.PlugIn.AssetDepr.ButtonClick(ButtonClickEventArgs e)
at Kingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireButtonClick(ButtonClickEventArgs e)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormView.ButtonClick(String key, String menuKey)
at Kingdee.BOS.Web.DynamicForm.DynamicWebFormController.ButtonClick(String buttonKey, String menuKey, JSONArray postDatas[/u]
