dbo.QBM_PSessionErrorClean
Stored ProcedureSQL_STORED_PROCEDURESandbox DB
Interpretation
- Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
Relations
- No extracted relations.
Typed Edges
- references source dbo.QBM_FCVIntToString source text reference
- references source dbo.QBM_FCVStringPadLeft source text reference
- references source dbo.QBM_FGISessionContext source text reference
- references source dbo.QBM_FGISessionErrorCount source text reference
- references source dbo.QBM_PSessionContextSet source text reference
References
- dbo.QBM_FCVIntToString
- dbo.QBM_FCVStringPadLeft
- dbo.QBM_FGISessionContext
- dbo.QBM_FGISessionErrorCount
- dbo.QBM_PSessionContextSet
Referenced By
- dbo.QBM_PBufferC_RestoreOneColumn
- dbo.QBM_PConstraintFKDrop
- dbo.QBM_PCustomSQLCompile
- dbo.QBM_PCustomSQLDependencyFill
- dbo.QBM_PDBQCS_CurrentMoveSlot
- dbo.QBM_PDBQCS_SlotExec
- dbo.QBM_PDBQCS_SlotFill
- dbo.QBM_PDBQCS_SlotFill_Range
- dbo.QBM_PDBQueueActivityDisable
- dbo.QBM_PDBQueueReplGenProcID
- dbo.QBM_PExecuteSQLWithRetry_LLP
- dbo.QBM_PMakeConstraint
- dbo.QBM_PRITriggerCreate
- dbo.QBM_PTriggerEnable
- dbo.QBM_PWorkDBQueueDelete
- dbo.QBM_PWorkHistoryDelete
- dbo.QBM_PWorkJobQueueDelete
- dbo.QBM_PWorkMaintenance
- dbo.QBM_PWorkSchedule
- dbo.QBM_PXDateSubItemUpdate
- dbo.QBM_ZConstraintEnable
Complete Source
1CREATE PROCEDURE QBM_PSessionErrorClean(2 @LastEntryOnly BIT = 03)4AS5BEGIN6 DECLARE @MessageKey varchar(30)7 DECLARE @LastMessage varchar(1000) = '#'8 DECLARE @Number int = 19 SET XACT_ABORT OFF10 SET nocount11 ON12 IF @LastEntryOnly = 113 BEGIN14 SELECT @Number = dbo.QBM_FGISessionErrorCount()15 END16 WHILE @number < 1000 AND @LastMessage > ' '17 BEGIN18 SELECT19 @MessageKey = CONCAT('ErrorMessage',20 dbo.QBM_FCVStringPadLeft(dbo.QBM_FCVIntToString(@number), 3, '0'))21 SELECT @LastMessage = dbo.QBM_FGISessionContext(@MessageKey)22 IF ISNULL(@LastMessage,23 '') = ''24 BEGIN25 CONTINUE26 END27 EXEC QBM_PSessionContextSet @MessageKey,28 ''29 SELECT @Number += 130 END31ENDOpen raw exported source
1 create procedure QBM_PSessionErrorClean (@LastEntryOnly bit = 0 ) as begin declare @MessageKey varchar(30) declare @LastMessage varchar(10002) = '#' declare @Number int = 1 SET XACT_ABORT OFF set nocount on if @LastEntryOnly = 1 begin select @Number = dbo.QBM_FGISessionErrorCount() end while3 @number < 1000 and @LastMessage > ' ' begin select @MessageKey = CONCAT('ErrorMessage', dbo.QBM_FCVStringPadLeft( dbo.QBM_FCVIntToString(@number), 3, 4'0') ) select @LastMessage = dbo.QBM_FGISessionContext(@MessageKey) if ISNULL(@LastMessage, '') = '' begin continue end exec QBM_PSessionContextSet @MessageKey5, '' select @Number += 1 end end 6