dbo.QBM_PSessionErrorClean

SQL_STORED_PROCEDURE

Created 2025-06-27T17:57:01.473 · modified 2026-04-14T23:14:10.457 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
@LastEntryOnlybitno

Referenced objects

SchemaObjectColumn/minorClass
QBM_PSessionContextSetOBJECT_OR_COLUMN
dboQBM_FCVIntToStringOBJECT_OR_COLUMN
dboQBM_FCVStringPadLeftOBJECT_OR_COLUMN
dboQBM_FGISessionContextOBJECT_OR_COLUMN
dboQBM_FGISessionErrorCountOBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1 create   procedure QBM_PSessionErrorClean (@LastEntryOnly bit = 0   ) as begin declare @MessageKey varchar(30) declare @LastMessage varchar(1000
2) = '#' declare @Number int = 1 SET XACT_ABORT OFF set nocount on if @LastEntryOnly = 1 begin select @Number = dbo.QBM_FGISessionErrorCount() end while
3 @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 @MessageKey
5, '' select @Number += 1 end end 
6

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:14:10.457

uses session context values

Summary: calls QBM_PSessionContextSet

Declared parameters

ParameterTypeDirection
@LastEntryOnlybitinput

DML targets

None extracted.

Called routines

Read/join references

None extracted.

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @LastEntryOnly @MessageKey @LastMessage @Number @number

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

Referencing objectRelationEvidence
dbo.QBM_PBufferC_RestoreOneColumnSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PConstraintFKDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCustomSQLCompileSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCustomSQLDependencyFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_CurrentMoveSlotSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotExecSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotFill_RangeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueActivityDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueReplGenProcIDSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PExecuteSQLWithRetry_LLPSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMakeConstraintSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PRITriggerCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkDBQueueDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkHistoryDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkJobQueueDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkMaintenanceSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PWorkScheduleSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PXDateSubItemUpdateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZConstraintEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferC_RestoreOneColumnsource text referencehas TRY/CATCH error handling
dbo.QBM_PConstraintFKDropsource text referencehas TRY/CATCH error handling
dbo.QBM_PCustomSQLCompilesource text referencehas TRY/CATCH error handling
dbo.QBM_PCustomSQLDependencyFillsource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_CurrentMoveSlotsource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_SlotExecsource text referenceuses ChangeLimit/session/config throttling, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQCS_SlotFillsource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQCS_SlotFill_Rangesource text referencehas TRY/CATCH error handling
dbo.QBM_PDBQueueActivityDisablesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PDBQueueReplGenProcIDsource text referencehas TRY/CATCH error handling
dbo.QBM_PExecuteSQLWithRetry_LLPsource text referencehas TRY/CATCH error handling
dbo.QBM_PMakeConstraintsource text referencehas TRY/CATCH error handling
dbo.QBM_PRITriggerCreatesource text referencehas TRY/CATCH error handling
dbo.QBM_PTriggerEnablesource text referencehas TRY/CATCH error handling
dbo.QBM_PWorkDBQueueDeletesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkHistoryDeletesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkJobQueueDeletesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkMaintenancesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PWorkSchedulesource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PXDateSubItemUpdatesource text referencecreates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling
dbo.QBM_ZConstraintEnablesource text referenceinserts DBQueue tasks, has TRY/CATCH error handling