dbo.QBM_PExecuteSQLWithRetry_LLP

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

NameTypeOutput
@SQLStatementnvarcharno
@LockTimeout_msintno
@MaxWaitTimeForLock_sfloatno
@ProcIDForJournalintno
@HandleErrorSilentbitno
@DeadlockPriorityintno
@ExecuteWithTransactbitno
@ErrorInExecutebityes

Referenced objects

SchemaObjectColumn/minorClass
QBM_PJournalOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBM_PSessionErrorCleanOBJECT_OR_COLUMN
QBM_PWaitForSecondsOBJECT_OR_COLUMN
QBM_YSessionErrorTYPE
dboQBM_FCVDatetimeToStringOBJECT_OR_COLUMN
dboQBM_FCVFloatToStringOBJECT_OR_COLUMN
dboQBM_FGISessionErrorCountOBJECT_OR_COLUMN
dboQBM_FGISessionErrorForLogOBJECT_OR_COLUMN
dboQBM_FGISessionErrorIsDeadlockOBJECT_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_PExecuteSQLWithRetry_LLP (@SQLStatement nvarchar(max) , @LockTimeout_ms int = 150  , @MaxWaitTimeForLock_s float = 8.0
2  , @ProcIDForJournal int = null  , @HandleErrorSilent bit = 0   , @DeadlockPriority int = -5  , @ExecuteWithTransact bit = 1  , @ErrorInExecute bit = 
30 output ) as begin declare @Starttime datetime declare @CurrentDeadlock_priority int declare @waittime float = 0.0 declare @Success int = 0    declare
4 @OurOwnMessage nvarchar(max)  declare @TransactionCount int declare @erg int = 0 declare @MyName nvarchar(256) = object_name(@@procid) declare @VersuchNummer
5 int = 1 declare @DebugSwitch int = 0 declare @DebugLevel varchar(1) = 'W' declare @FinalMisserfolg nvarchar(1000) = '#LDS#No success after all retries.|'
6 declare @JournalMessage nvarchar(max) declare @JournalProcedureExists bit = 0  declare @SQLIntern nvarchar(max) declare @ErrorBuffer QBM_YSessionError
7 declare @tran1 int declare @tran2 int declare @CountEntriesSessionError int declare @XactMissmatch bit = 0 declare @FinalMisserfolgXact nvarchar(1000)
8 = '#LDS#No success after all retries. Please do schema changes without transaction.|' declare @DebugRetries int = -1 declare @DebugWaitSum float = 0.0
9 set XACT_ABORT off BEGIN TRY if exists (select top 1 1 from sys.objects o where o.name = 'QBM_PJournal' and type = 'P' ) begin select @JournalProcedureExists
10 = 1 end if @DebugSwitch = 2 print ' trancount eingang' + str(@@trancount) if @ExecuteWithTransact = 1 begin begin transaction  end if @DebugSwitch = 2
11 print ' trancount eingang 2' + str(@@trancount) set nocount on select top 1 @CurrentDeadlock_priority = s.deadlock_priority FROM sys.dm_exec_sessions 
12s where s.session_id = @@spid select @TransactionCount = @@trancount set deadlock_priority @DeadlockPriority  if @LockTimeout_ms = 150  begin set lock_timeout
13 150  select @SQLIntern = @SQLStatement end else begin   select @SQLIntern = CONCAT( 'set lock_timeout ' , str(@LockTimeout_ms) , ';SET XACT_ABORT OFF;'
14 , @SQLStatement ) end select @CountEntriesSessionError = dbo.QBM_FGISessionErrorCount() select @starttime = getutcdate() while @Success = 0 and convert
15(float, datediff(ms, @starttime, getutcdate())) < @MaxWaitTimeForLock_s * 1000.0 and @XactMissmatch = 0 begin select @waittime = (RAND() / 2.0 ) + 0.05
16 select @DebugRetries += 1 if @ExecuteWithTransact = 1 begin if @DebugSwitch = 2 print 'vor save transaction' save transaction IchVersuche if @DebugSwitch
17 = 2 print 'save transaction geschafft' end BEGIN TRY if @DebugSwitch = 2 print ' trancount vor execute ' + str(@@trancount)  select @tran1 = @@TRANCOUNT
18 exec sp_executesql @SQLIntern select @erg = @@ROWCOUNT select @Success = 1 END TRY BEGIN CATCH if @DebugSwitch = 2 print 'catch 1' if @DebugSwitch = 2
19 print ' trancount catch 1' + str(@@trancount) if @DebugSwitch = 2 print ERROR_MESSAGE() select @tran2 = @@TRANCOUNT if @tran1 = @tran2 -1  begin commit
20 transaction end delete @ErrorBuffer    insert into @ErrorBuffer (ErrorMessage, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, 
21MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode) select ERROR_MESSAGE(),ERROR_SEVERITY(), ERROR_STATE(), ERROR_NUMBER() , @MyName , ERROR_LINE
22(), GETUTCDATE() , null, 0, 0, @SQLIntern exec QBM_PSessionErrorAdd @ErrorBuffer END CATCH if @Success = 0 begin if @DebugSwitch = 2 print '@Success ' 
23+ str(@Success) BEGIN TRY if @DebugSwitch = 2 print 'try 1' if @DebugSwitch = 2 print ' trancount 1' + str(@@trancount) if @DebugSwitch = 2 print 'Current XACT '
24 + str(XACT_STATE()) if @ExecuteWithTransact = 1 begin   begin TRY rollback transaction IchVersuche if @DebugSwitch = 2 print 'Rollbackversuch geklappt'
25 END TRY BEGIN CATCH  select @XactMissmatch = 1 if @DebugSwitch = 2 print 'Rollbackversuch NICHT geklappt' END CATCH end if @DebugSwitch = 2 print 'try 2'
26 if @DebugSwitch = 2 print ' trancount 2' + str(@@trancount) END TRY BEGIN CATCH if @DebugSwitch = 2 print 'catch 2'  END CATCH end  if @Success = 1 begin
27 if @DebugSwitch > 0 begin print dbo.QBM_FCVDatetimeToString(GETUTCDATE()) + ' Versuch geschafft' end end else begin if dbo.QBM_FGISessionErrorIsDeadlock
28(@ErrorBuffer) = 1 begin if @DebugSwitch = 2 print 'es ist eine lock-Meldung' exec QBM_PWaitForSeconds @waittime select @DebugWaitSum += @waittime end 
29else begin   select @Success = -1 continue end end  if @TransactionCount <> @@TRANCOUNT and @ExecuteWithTransact = 1 begin if @DebugSwitch = 2 print 'transaction Differenz '
30 + str(@TransactionCount) + str(@@TRANCOUNT) select @OurOwnMessage = concat('#LDS#Expected transaction count {0} does not match existing {1}, called from {2}.|'
31 , str(isnull(@TransactionCount, 0)) , '|' , str( @@TRANCOUNT) , '|' , @MyName , '|' ) delete @ErrorBuffer insert into @ErrorBuffer (ErrorMessage, ErrorSeverity
32, ErrorState, ErrorNumber , ProcedureName, ProcedureLine, MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode) select @OurOwnMessage,18, 1, 50000
33 , @MyName, 0, GETUTCDATE() , null, 0, 0, @SQLIntern exec QBM_PSessionErrorAdd @ErrorBuffer RAISERROR (@OurOwnMessage, 18, 1) WITH NOWAIT end if @DebugSwitch
34 = 2 print 'auf zum nächsten Versuch' select @VersuchNummer += 1 end  if @ExecuteWithTransact = 1 and @XactMissmatch = 0 begin commit transaction  end 
35 if @Success in ( 0, -1) begin   if @Success = 0  or (@Success = -1 and @XactMissmatch = 1) begin delete @ErrorBuffer select @OurOwnMessage = case @XactMissmatch
36 when 0 then @FinalMisserfolg else @FinalMisserfolgXact end insert into @ErrorBuffer (ErrorMessage, ErrorSeverity, ErrorState, ErrorNumber , ProcedureName
37, ProcedureLine, MessageDate , GenProcID, RepeatCounter, IsReThrow, SourceCode) select @OurOwnMessage, 18, 1, 50000 , @MyName, 229, GETUTCDATE() , null
38, 0, 0, @SQLIntern exec QBM_PSessionErrorAdd @ErrorBuffer end else  begin select @OurOwnMessage = '#LDS#Error exececuting direct sql command.|' end if 
39@HandleErrorSilent = 0 begin if @DebugSwitch = 2 print 'raise ' + @OurOwnMessage  select @FinalMisserfolgXact = 'eigentlich müßte hier ein "set XACT_ABORT on" rein, lassen wir aber erst mal, da nur in einem einzigen Trigger verwendet'
40 RAISERROR (@OurOwnMessage, 18, 1) WITH NOWAIT end end else begin   while dbo.QBM_FGISessionErrorCount() > @CountEntriesSessionError begin exec QBM_PSessionErrorClean
41 @LastEntryOnly = 1 end end END TRY BEGIN CATCH if @DebugSwitch = 2 print 'catch 3' if @DebugSwitch = 2 print ' trancount ausgang' + str(@@trancount) exec
42 QBM_PSessionErrorAdd default, @SQLStatement RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: if (@DebugRetries > 0 or ( @Success in (0, -1) and @HandleErrorSilent
43 = 0) ) and @JournalProcedureExists = 1 begin select @OurOwnMessage = concat( OBJECT_NAME(@@procid), ' ' , ' retries' , right(str(@DebugRetries), 5) , 
44' waitsum ', dbo.QBM_FCVFloatToString(@DebugWaitSum) , ' stmt ' , left(@SQLStatement, 50) ) exec QBM_PJournal @OurOwnMessage, @@procid, 'T', @DebugLevel
45 end if @ProcIDForJournal > ' ' and @Success in (0, -1) and @JournalProcedureExists = 1 begin select @OurOwnMessage = dbo.QBM_FGISessionErrorForLog() exec
46 QBM_PJournal @OurOwnMessage, @ProcIDForJournal, 'E', @DebugLevel end if @Success in (0, -1) begin select @ErrorInExecute = 1 end set deadlock_priority
47 @CurrentDeadlock_priority set lock_timeout -1 set nocount off return (@erg) end 
48

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.603

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd, QBM_PWaitForSeconds, QBM_PSessionErrorClean, QBM_PJournal; writes INSERT into; reads/joins sys

Declared parameters

ParameterTypeDirection
@SQLStatementnvarcharinput
@LockTimeout_msintinput
@MaxWaitTimeForLock_sfloatinput
@ProcIDForJournalintinput
@HandleErrorSilentbitinput
@DeadlockPriorityintinput
@ExecuteWithTransactbitinput
@ErrorInExecutebitOUTPUT

DML targets

INSERT into

Called routines

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: #LDS #No #Expected #Error

Variables: @SQLStatement @LockTimeout_ms @MaxWaitTimeForLock_s @ProcIDForJournal @HandleErrorSilent @DeadlockPriority @ExecuteWithTransact @ErrorInExecute @Starttime @CurrentDeadlock_priority @waittime @Success @OurOwnMessage @TransactionCount @erg @MyName @procid @VersuchNummer @DebugSwitch @DebugLevel @FinalMisserfolg @JournalMessage @JournalProcedureExists @SQLIntern @ErrorBuffer @tran1 @tran2 @CountEntriesSessionError @XactMissmatch @FinalMisserfolgXact @DebugRetries @DebugWaitSum @trancount @spid @starttime @TRANCOUNT @ROWCOUNT @LastEntryOnly

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.CCC_VBScriptFindSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_PRuleCompareAffectedPersonSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_PRuleCompareWorkForReportSQL expression dependencyOBJECT_OR_COLUMN
dbo.CPL_ZSubRuleFillObjectSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferC_RestoreOneColumnSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PBufferT_ProcAll_Delta_iSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCheckSameCase_38SQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PColumnCustomRemoveSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PColumnDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PConstraintChangeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PConstraintDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PConstraintEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PConstraintFKDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCursorDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCustomSQLCompileSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCustomSQLDependencyFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PCustomSQLPropagate_ContSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDatabaseTriggerDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDatabaseTriggerDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDatabaseTriggerEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQCS_SlotFill_RangeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDBQueueCompressSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PDialogProcessShrink_3SQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PExecuteSQLMultiSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PForeignKeyWrongRepairSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PGITableCountAndLastChangeSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PIndexCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PIndexDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PIndexDropSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PIndexEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PIndexRebuildSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobQueueInit_iSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobQueueLoadSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobRestartSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PJobUpdateState_BulkSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMakeConstraintSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMNTableDeleteSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMNTableInsertSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMNTableInsertOwnPKSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMNTableOriginUpdateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PMultilanguageFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PNonlinear_DeleteUntouchedSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PNonlinear_SetFoundSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PPrePropCheckExpressionSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PRITriggerCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PSetRowLockOnlySQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PSQLCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTableCustomRemove_RUSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTableLockEscalationSetSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTableReloadSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerDisableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerEnableSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerWatchCreateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PXDateSubItemUpdateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZCheckDefaultZeroSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZCheckInvalidDateSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZCheckStatisticsSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZConnectionClearUnusedSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZObjectKeyRepairSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZPrepropGenerateFunctionSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_ZXMarkedForDeletionPushSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeMoveSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZEntitlementSourceMakeProcSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZITShopDecisionMakerFillSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZPersonFindGenerateFunctSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_TUOrgRootAssignSQL expression dependencyOBJECT_OR_COLUMN
dbo.CCC_VBScriptFindsource text referencehas TRY/CATCH error handling
dbo.CPL_PRuleCompareAffectedPersonsource text referencehas TRY/CATCH error handling
dbo.CPL_PRuleCompareWorkForReportsource text referencehas TRY/CATCH error handling
dbo.CPL_ZSubRuleFillObjectsource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PBufferC_RestoreOneColumnsource text referencehas TRY/CATCH error handling
dbo.QBM_PBufferT_ProcAll_Delta_isource text referencehas TRY/CATCH error handling
dbo.QBM_PCheckSameCase_38source text referencehas TRY/CATCH error handling
dbo.QBM_PColumnCustomRemovesource text referencehas TRY/CATCH error handling
dbo.QBM_PColumnDropsource text referencehas TRY/CATCH error handling
dbo.QBM_PConstraintChangesource text referencehas TRY/CATCH error handling
dbo.QBM_PConstraintDisablesource text referencehas TRY/CATCH error handling
dbo.QBM_PConstraintEnablesource text referencehas TRY/CATCH error handling
dbo.QBM_PConstraintFKDropsource text referencehas TRY/CATCH error handling
dbo.QBM_PCursorDropsource 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_PCustomSQLPropagate_Contsource text referencehas TRY/CATCH error handling
dbo.QBM_PDatabaseTriggerDisablesource text referencehas TRY/CATCH error handling
dbo.QBM_PDatabaseTriggerDropsource text referencehas TRY/CATCH error handling
dbo.QBM_PDatabaseTriggerEnablesource text referencehas 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_PDBQueueCompresssource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PDialogProcessShrink_3source text referencehas TRY/CATCH error handling
dbo.QBM_PExecuteSQLMultisource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PForeignKeyWrongRepairsource text referencehas TRY/CATCH error handling
dbo.QBM_PGITableCountAndLastChangesource text referenceSQL_STORED_PROCEDURE
dbo.QBM_PIndexCreatesource text referencehas TRY/CATCH error handling
dbo.QBM_PIndexDisablesource text referencehas TRY/CATCH error handling
dbo.QBM_PIndexDropsource text referencehas TRY/CATCH error handling
dbo.QBM_PIndexEnablesource text referencehas TRY/CATCH error handling
dbo.QBM_PIndexRebuildsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling
dbo.QBM_PJobQueueInit_isource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PJobQueueLoadsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QBM_PJobRestartsource text referencehas TRY/CATCH error handling
dbo.QBM_PJobUpdateState_Bulksource text referencecreates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, has TRY/CATCH error handling
dbo.QBM_PMakeConstraintsource text referencehas TRY/CATCH error handling
dbo.QBM_PMNTableDeletesource text referencecreates object-layer jobs via QBM_PJobCreate*, uses session context values, has TRY/CATCH error handling
dbo.QBM_PMNTableInsertsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QBM_PMNTableInsertOwnPKsource text referencecreates object-layer jobs via QBM_PJobCreate*, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QBM_PMNTableOriginUpdatesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QBM_PMultilanguageFillsource text referencehas TRY/CATCH error handling
dbo.QBM_PNonlinear_DeleteUntouchedsource text referencehas TRY/CATCH error handling
dbo.QBM_PNonlinear_SetFoundsource text referencehas TRY/CATCH error handling
dbo.QBM_PPrePropCheckExpressionsource text referencehas TRY/CATCH error handling
dbo.QBM_PRITriggerCreatesource text referencehas TRY/CATCH error handling
dbo.QBM_PSetRowLockOnlysource text referencehas TRY/CATCH error handling
dbo.QBM_PSQLCreatesource text referencehas TRY/CATCH error handling
dbo.QBM_PTableCustomRemove_RUsource text referencehas TRY/CATCH error handling
dbo.QBM_PTableLockEscalationSetsource text referencehas TRY/CATCH error handling
dbo.QBM_PTableReloadsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QBM_PTriggerDisablesource text referencehas TRY/CATCH error handling
dbo.QBM_PTriggerEnablesource text referencehas TRY/CATCH error handling
dbo.QBM_PTriggerWatchCreatesource text referenceuses 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_ZCheckDefaultZerosource text referencehas TRY/CATCH error handling
dbo.QBM_ZCheckInvalidDatesource text referencehas TRY/CATCH error handling
dbo.QBM_ZCheckStatisticssource text referencehas TRY/CATCH error handling
dbo.QBM_ZConnectionClearUnusedsource text referencehas TRY/CATCH error handling
dbo.QBM_ZObjectKeyRepairsource text referencehas TRY/CATCH error handling
dbo.QBM_ZPrepropGenerateFunctionsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QBM_ZXMarkedForDeletionPushsource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_PITShopProductNodeMovesource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_ZEntitlementSourceMakeProcsource text referencehas TRY/CATCH error handling
dbo.QER_ZITShopDecisionMakerFillsource text referenceuses session context values, has TRY/CATCH error handling
dbo.QER_ZPersonFindGenerateFunctsource text referencehas TRY/CATCH error handling
dbo.QER_TUOrgRootAssignsource text referenceinserts DBQueue tasks, uses session context values, has TRY/CATCH error handling