固定资产处置单保存时报错
金蝶云社区-k3cloud@深圳市铁汉生态环境股份有限公司_1
k3cloud@深圳市铁汉生态环境股份有限公司_1
0人赞赏了该文章 1,082次浏览 未经作者许可,禁止转载编辑于2015年07月10日 16:43:53

K3 CLOUD 5.0 打了PT097134补丁

发生时间: 2015-07-10 04:38:55
错误编号: BOS_ExecuteNonQuery
错误信息: ORA-00600: internal error code, arguments: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []
Sql语句: INSERT INTO TM_FA_ASSERTDEPR SELECT C.FNumber, B.FOwnerOrgID, C.FAssetTypeID, B.FASSETID, C.FAlterID, F.Fyear, F.FPeriod, (((((B.FORGVALP + B.FORGVALINC) - B.FORGVALDEC) - ((B.FDECPREP + B.FDECPREINC) - B.FDECPREDEC)) - ((B.FACCUMDEPRP + B.FACCUMDEPRINC) - B.FACCUMDEPRDEC)) - F.FRESIDUALVALUE) FDEPRREMAIN, B.FShouldDepr, B.FDepr, B.FDeprRate, DECODE((F.FLifePeriods - B.FDeprPeriods), 1, 1, 0) ISLASTPERIOD, D.FCLEARDEPRPOLICY, D.FISAFFECTDEPR, C.FAssetCurStatus, C.FQuantity, F.FACCTPOLICYID, T.FCurrentYear, T.FCurrentPeriod, F.FOrgVal, F.FAccumDevalue, F.FAccumDepr, F.FResidualvalue, F.FLifePeriods, B.FDeprPeriods, 0 FISCAL, M.FDEPROPTION, FIsModifyDeprFac, FIsDeprFactoryModify, F.FDeprMethod, AC.fperiodcount, (((1.00 * F.FLifePeriods) - F.FDeprPeriods) / Fperiodcount) FREMAINYEAR, ((1.00 * FLifePeriods) / Fperiodcount) FLIFEYEAR, 0 FISLASTTWOYEAR, ' ' FERRORDESCRIPTION, ' ' FFORMULACONTENT, NVL(da.FDocumentstatus, ' ') FDOCUMENTSTATUS, FYtdDeprPeriod, FIsNextFirstPeriod, BC.FAmountDigits, DECODE(B.FORGVALP, 0, 1, 0) FISCURRPERIODADD, 1 FISCUMPUTALTER, NVL(F.FPredictWorkLoad, 0) FPREDICTWORKLOAD, NVL(((B.Fdeprworkload - F.Finitialdeprworkload) + f.finitialtotalworkload), 0) FTOTALWORKLOAD, NVL(wle.FPERIODWORKLOAD, 0) FPERIODWORKLOAD, NVL(F.FWorkLoadUnitId, 0) FWORKLOADUNITID, NVL(B.Fdeprworkload, 0) FDEPRWORKLOAD, ((F.Fyear * 100) + F.FPeriod) FYEARPERIOD FROM T_FA_CARD C INNER JOIN T_FA_STATUS S ON (C.FAssetStatusID = S.FID AND S.FWHETHERDEPR = 1) INNER JOIN T_FA_FINANCE F ON C.FAlterID = F.FAlterID INNER JOIN ( select COLUMN_VALUE as FID from table(cast(:FALTERID_udt as udt_inttable))) fc ON FC.FID = F.FAlterID INNER JOIN T_FA_BALANCE B ON ((C.FAssetID = B.FASSETID AND B.FIsNewRec = '2') AND B.FACCTPOLICYID = F.FACCTPOLICYID) INNER JOIN T_FA_ACCTPOLICY P ON P.FACCTPOLICYID = F.FACCTPOLICYID INNER JOIN T_FA_ACCTPOLICYASSET E ON (P.FACCTPOLICYID = E.FACCTPOLICYID AND E.FASSETTYPEID = C.FAssetTypeID) INNER JOIN t_BD_ACCOUNTCALENDAR AC ON P.FACCTCALENDARID = AC.FID INNER JOIN T_FA_DEPRPOLICY D ON D.FPOLICYID = E.FDEPRPOLICYID INNER JOIN T_bd_Currency BC ON P.Fcurrencyid = BC.FCURRENCYID INNER JOIN T_FA_DEPRMETHOD M ON M.FID = F.FDeprMethod INNER JOIN V_FA_SYSTEMPROFILE T ON ((F.FACCTPOLICYID = T.FACCTPOLICYID AND C.FOwnerOrgID = T.FOrgID) AND B.FOwnerOrgID = T.FOrgID) INNER JOIN TM_FA_ASSETANDALTERID MA ON (Ma.FAlterID = C.FAlterID AND Ma.FAssetID = C.FAssetID) LEFT OUTER JOIN t_fa_depradjust DA ON (((da.FOWNERORGID = B.FOWNERORGID AND da.FACCTPOLICYID = F.FACCTPOLICYID) AND da.FYear = T.FCurrentYear) AND da.FPeriod = T.FCurrentPeriod) LEFT OUTER JOIN T_FA_WorkLoad WL ON ((((wl.FYEAR = T.FCurrentYear AND wl.FPeriod = T.FCurrentPeriod) AND wl.FOWNERORGID = T.FOrgID) AND wl.FACCTPOLICYID = T.FACCTPOLICYID) AND wl.FDOCUMENTSTATUS = 'C') LEFT OUTER JOIN T_FA_WorkLoadEntity WLE ON (wl.FID = wle.FID AND wle.FAssetID = C.FAssetID) WHERE ((C.FDOCUMENTSTATUS = 'C' AND C.FFORBIDSTATUS = 'A') AND ((C.FAssetCurStatus IN ('1', '2', '3', '4', '7')) AND (((F.FLifePeriods >= (B.FDeprPeriods + 1)) AND (F.Fdeprmethod < '4')) OR (F.Fdeprmethod = '4' AND ((F.Fpredictworkload > B.Fdeprworkload) OR (F.Fpredictworkload IS NULL) OR (B.Fdeprworkload IS NULL)))))) ORDER BY C.FOWNERORGID ASC, C.FNUMBER ASC
===================================================
调用堆栈:
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteBatch(Context ctx, List`1 lstSqlObj)
在 Kingdee.K3.FIN.FA.App.Core.AssetDeprService.GetMainTableData(Context ctx, Dictionary`2 dtTableName, Dictionary`2 dParam)
在 Kingdee.K3.FIN.FA.App.Core.AssetDeprService.AssetDepr(Context ctx, List`1 lst, Dictionary`2 dParam)
在 Kingdee.K3.FIN.FA.App.ServicePlugIn.Disposal.Save.BeginOperationTransaction(BeginOperationTransactionArgs e)
在 Kingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireBeginOperationTransaction(BeginOperationTransactionArgs e)
在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs)
在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs)
在 Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete()
在 Kingdee.BOS.App.Core.AbstractOprerationService.Excute(DynamicObject[] dataEntities)
在 Kingdee.BOS.App.Core.SaveService.Save(Context ctx, BusinessInfo info, DynamicObject[] dataEntities, OperateOption option, String operationNumber)
Exception rethrown at [0]:
在 Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.Save(Context ctx, BusinessInfo businessInfo, DynamicObject dataObject, OperateOption option, String operationNumber)
在 Kingdee.BOS.Model.Bill.BillModel.Save(OperateOption option)
在 Kingdee.BOS.Business.Bill.Operation.Save.ExecuteBillOperation(OperateOption option)
在 Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult