付款单审核时出现错误提示.
quHongan
2,791次浏览
编辑于2015年09月25日 14:16:12
付款单审核时出现如下错误提示，用以下dbcc修复数据库未发现问题，请问什么原因.dbcc checkdb('AIS20150613103711',REPAIR_ALLOW_DATA_LOSS)
dbcc checkdb('AIS20150613103711',REPAIR_REBUILD)
错误提示:
[{"operation":"AP_ApprovalAssignHandle.MBIClick.tbWFSubmit"}]发生时间： 2015-09-2501:18:47错误编号：BOS_ExecuteNonQuery错误信息： 尝试在数据库 2 中提取逻辑页 (1:336) 失败。该逻辑页属于分配单元 1080864272902979584，而非 7854278116318445568。Sql语句： INSERT INTO#TM_AP_INSTANCEOBJS (FSFormId, FSTableName, FSID, FTFormId, FTTableName, FTID,FAMOUNT, FOldTFormId, FOldTTableName, FOldTID, FOldAMOUNT) SELECTbfSTable.FFormId fsformid, bfEntry.FSTableName, bfEntry.FSID, bfTTable.FFormIdftformid, bfEntry.FTTableName, bfEntry.FTID, bfAmount.FAmount,tmpNoSrc.FOldTFormId, tmpNoSrc.FOldTTableName, tmpNoSrc.FOldTID,tmpNoSrc.FOldAmount FROM #TM_AP_INSTANCEENTRY bfEntry LEFT OUTER JOIN #TM_AP_INSTANCEAMOUNTbfAmount ON bfEntry.FRouteId = bfAmount.FRouteId LEFT OUTER JOINt_bf_TableDefine bfTTable ON bfEntry.FTTableName = bfTTable.FTableNumber LEFTOUTER JOIN t_bf_TableDefine bfSTable ON bfEntry.FSTableName =bfSTable.FTableNumber INNER JOIN (SELECT tmpTgt.FSTableName, tmpTgt.FSID,tmpTgt.FOldTFormId, tmpTgt.FOldTTableName, tmpTgt.FOldTId, tmpTgt.FOldAmountFROM #TM_AP_INSTANCEOBJS tmpTgt LEFT OUTER JOIN #TM_AP_INSTANCEOBJS tmpSrc ON(tmpTgt.FSTableName = tmpSrc.FTTableName AND tmpTgt.FSID = tmpSrc.FTID) INNERJOIN t_bf_TableDefine bfSTable ON tmpTgt.FSTableName = bfSTable.FTableNumberWHERE (((tmpTgt.FSID <> 0) AND ISNULL(tmpSrc.FTID, 0) = 0) ANDbfSTable.Fformid NOT IN ('AP_OtherPayable', 'AP_Payable'))) tmpnosrc ON(tmpNoSrc.FSTableName = bfEntry.FTTableName AND tmpNoSrc.FSID = bfEntry.FTID)===================================================调用堆栈： atKingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command,IEnumerable`1 listParam) atKingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1paramList, Boolean needTranslate) atKingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL) atKingdee.K3.FIN.App.Core.MatchOperation.AbstractMatchOperation.SourceTargetMatch(Contextctx, IList`1 source, String targetFromID, String targetTable, StringtargetEntryTable, String targetEntryName) atKingdee.K3.FIN.App.Core.MatchOperation.AbstractMatchOperation.GetBillTypeEntrysForSave(Dictionary`2billInfo) atKingdee.K3.FIN.App.Core.MatchOperation.AbstractMatchOperation.SaveMatchOperation(DynamicObject[]DataEntitys) atKingdee.K3.FIN.App.ServicePlugIn.Match.PayBillAudit.EndOperationTransaction(EndOperationTransactionArgse) atKingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireEndOperationTransaction(EndOperationTransactionArgse) atKingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]&objs) atKingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[]objs) atKingdee.BOS.App.Core.AbstractOprerationService.DoExcete() atKingdee.BOS.App.Core.AbstractOprerationService.Excute(Object[] ids) atKingdee.BOS.App.Core.SetStatusService.SetBillStatus(Context ctx, BusinessInfobusinessInfo, List`1 pkEntryIds, List`1 paras, String operationNumber,OperateOption option) atKingdee.BOS.Workflow.App.Core.AuditInvokeService.Execute(Context ctx,BusinessInfo info, DynamicObject[] dataEntities, String operationNumber,OperateOption option) atKingdee.BOS.Workflow.App.Core.WFInvokeOperationService.InvokeService(Contextctx, String operationName, BusinessInfo info, DynamicObject[] dataEntities,OperateOption option, Boolean needNewTrans) atKingdee.BOS.Workflow.App.Core.ApprovalAssignmentService.InvokeAssignAndOperate(Contextctx, OperateOption option, Field billNoField, List`1 lstOnlyCompletedContext,Dictionary`2 dctCompletedWithOperate, List`1 lstUnCompletedContext, LocaleValueresultName, Int32& successCount) atKingdee.BOS.Workflow.App.Core.ApprovalAssignmentService.SubmitApprovalItems(Contextctx, ApprovalAssignmentContext assignContext) atKingdee.BOS.Workflow.App.Core.ApprovalAssignmentService.SubmitApprovalItem(Contextctx, ApprovalAssignmentContext assignContext) atKingdee.BOS.Workflow.ServiceHelper.ApprovalAssignmentServiceHelper.SubmitApprovalItem(Contextctx, ApprovalAssignmentContext assignContext) atKingdee.BOS.ApprovalFlow.PlugIns.ApprovalAssignmet.ApprovalAssignDeal.DoSubmitAssignment(ApprovalItemapprovalItem, ApprovalAssignResult approvalResult, OperateOption option) atKingdee.BOS.ApprovalFlow.PlugIns.ApprovalAssignmet.ApprovalAssignDeal.SubmitAssignment(Nullable`1postId, OperateOption option) atKingdee.BOS.Workflow.PlugIns.AssignApprovalBaseEdit.Submit(OperateOptionoption) atKingdee.BOS.ApprovalFlow.PlugIns.ApprovalAssignmet.ApprovalAssignDeal.BarItemClick(BarItemClickEventArgse) atKingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireBarItemClick(BarItemClickEventArgse) atKingdee.BOS.Web.DynamicForm.DynamicWebFormView.BarItemClick(String parentKey,String barItemKey, BarDataManager bar, Int32 bartype) atKingdee.BOS.Web.DynamicForm.DynamicWebFormView.MainBarItemClick(StringbarItemKey) atKingdee.BOS.Web.DynamicForm.DynamicWebFormController.MainBarItemClick(StringitemKey, JSONArray postDatas)
dbcc checkdb('AIS20150613103711',REPAIR_REBUILD)
错误提示:
[{"operation":"AP_ApprovalAssignHandle.MBIClick.tbWFSubmit"}]发生时间： 2015-09-2501:18:47错误编号：BOS_ExecuteNonQuery错误信息： 尝试在数据库 2 中提取逻辑页 (1:336) 失败。该逻辑页属于分配单元 1080864272902979584，而非 7854278116318445568。Sql语句： INSERT INTO#TM_AP_INSTANCEOBJS (FSFormId, FSTableName, FSID, FTFormId, FTTableName, FTID,FAMOUNT, FOldTFormId, FOldTTableName, FOldTID, FOldAMOUNT) SELECTbfSTable.FFormId fsformid, bfEntry.FSTableName, bfEntry.FSID, bfTTable.FFormIdftformid, bfEntry.FTTableName, bfEntry.FTID, bfAmount.FAmount,tmpNoSrc.FOldTFormId, tmpNoSrc.FOldTTableName, tmpNoSrc.FOldTID,tmpNoSrc.FOldAmount FROM #TM_AP_INSTANCEENTRY bfEntry LEFT OUTER JOIN #TM_AP_INSTANCEAMOUNTbfAmount ON bfEntry.FRouteId = bfAmount.FRouteId LEFT OUTER JOINt_bf_TableDefine bfTTable ON bfEntry.FTTableName = bfTTable.FTableNumber LEFTOUTER JOIN t_bf_TableDefine bfSTable ON bfEntry.FSTableName =bfSTable.FTableNumber INNER JOIN (SELECT tmpTgt.FSTableName, tmpTgt.FSID,tmpTgt.FOldTFormId, tmpTgt.FOldTTableName, tmpTgt.FOldTId, tmpTgt.FOldAmountFROM #TM_AP_INSTANCEOBJS tmpTgt LEFT OUTER JOIN #TM_AP_INSTANCEOBJS tmpSrc ON(tmpTgt.FSTableName = tmpSrc.FTTableName AND tmpTgt.FSID = tmpSrc.FTID) INNERJOIN t_bf_TableDefine bfSTable ON tmpTgt.FSTableName = bfSTable.FTableNumberWHERE (((tmpTgt.FSID <> 0) AND ISNULL(tmpSrc.FTID, 0) = 0) ANDbfSTable.Fformid NOT IN ('AP_OtherPayable', 'AP_Payable'))) tmpnosrc ON(tmpNoSrc.FSTableName = bfEntry.FTTableName AND tmpNoSrc.FSID = bfEntry.FTID)===================================================调用堆栈： atKingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command,IEnumerable`1 listParam) atKingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1paramList, Boolean needTranslate) atKingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL) atKingdee.K3.FIN.App.Core.MatchOperation.AbstractMatchOperation.SourceTargetMatch(Contextctx, IList`1 source, String targetFromID, String targetTable, StringtargetEntryTable, String targetEntryName) atKingdee.K3.FIN.App.Core.MatchOperation.AbstractMatchOperation.GetBillTypeEntrysForSave(Dictionary`2billInfo) atKingdee.K3.FIN.App.Core.MatchOperation.AbstractMatchOperation.SaveMatchOperation(DynamicObject[]DataEntitys) atKingdee.K3.FIN.App.ServicePlugIn.Match.PayBillAudit.EndOperationTransaction(EndOperationTransactionArgse) atKingdee.BOS.App.Core.PlugInProxy.OperationServicePlugInProxy.FireEndOperationTransaction(EndOperationTransactionArgse) atKingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]&objs) atKingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[]objs) atKingdee.BOS.App.Core.AbstractOprerationService.DoExcete() atKingdee.BOS.App.Core.AbstractOprerationService.Excute(Object[] ids) atKingdee.BOS.App.Core.SetStatusService.SetBillStatus(Context ctx, BusinessInfobusinessInfo, List`1 pkEntryIds, List`1 paras, String operationNumber,OperateOption option) atKingdee.BOS.Workflow.App.Core.AuditInvokeService.Execute(Context ctx,BusinessInfo info, DynamicObject[] dataEntities, String operationNumber,OperateOption option) atKingdee.BOS.Workflow.App.Core.WFInvokeOperationService.InvokeService(Contextctx, String operationName, BusinessInfo info, DynamicObject[] dataEntities,OperateOption option, Boolean needNewTrans) atKingdee.BOS.Workflow.App.Core.ApprovalAssignmentService.InvokeAssignAndOperate(Contextctx, OperateOption option, Field billNoField, List`1 lstOnlyCompletedContext,Dictionary`2 dctCompletedWithOperate, List`1 lstUnCompletedContext, LocaleValueresultName, Int32& successCount) atKingdee.BOS.Workflow.App.Core.ApprovalAssignmentService.SubmitApprovalItems(Contextctx, ApprovalAssignmentContext assignContext) atKingdee.BOS.Workflow.App.Core.ApprovalAssignmentService.SubmitApprovalItem(Contextctx, ApprovalAssignmentContext assignContext) atKingdee.BOS.Workflow.ServiceHelper.ApprovalAssignmentServiceHelper.SubmitApprovalItem(Contextctx, ApprovalAssignmentContext assignContext) atKingdee.BOS.ApprovalFlow.PlugIns.ApprovalAssignmet.ApprovalAssignDeal.DoSubmitAssignment(ApprovalItemapprovalItem, ApprovalAssignResult approvalResult, OperateOption option) atKingdee.BOS.ApprovalFlow.PlugIns.ApprovalAssignmet.ApprovalAssignDeal.SubmitAssignment(Nullable`1postId, OperateOption option) atKingdee.BOS.Workflow.PlugIns.AssignApprovalBaseEdit.Submit(OperateOptionoption) atKingdee.BOS.ApprovalFlow.PlugIns.ApprovalAssignmet.ApprovalAssignDeal.BarItemClick(BarItemClickEventArgse) atKingdee.BOS.Core.DynamicForm.PlugIn.DynamicFormViewPlugInProxy.FireBarItemClick(BarItemClickEventArgse) atKingdee.BOS.Web.DynamicForm.DynamicWebFormView.BarItemClick(String parentKey,String barItemKey, BarDataManager bar, Int32 bartype) atKingdee.BOS.Web.DynamicForm.DynamicWebFormView.MainBarItemClick(StringbarItemKey) atKingdee.BOS.Web.DynamicForm.DynamicWebFormController.MainBarItemClick(StringitemKey, JSONArray postDatas)
推荐阅读