dbo.QBM_PDBQueueInsert_Single
Stored ProcedureSQL_STORED_PROCEDURESandbox DB
Interpretation
- Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
- DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.
Verified DBQueue Single Insert Wrapper Notes
- Source catalog entry
dbo.QBM_PDBQueueInsert_Singleis a non-generated SQL stored procedure fromsandbox-db sys.sql_modules. - The procedure signature contains
@UID_Task,@object,@SubObject, and@GenProcID; the two dummy parameters are explicitly rejected when they are not-1111with an obsolete-parameters error. - When
@GenProcIDis empty, the source logs anempty GenProcIDdiagnostic throughQBM_PJournaland falls back todbo.QBM_FGISessionContext(''). - The procedure creates a
QBM_YDBQueueRawtable variable, inserts one row(Object, SubObject, GenProcID), and delegates toQBM_PDBQueueInsert_Bulk @UID_Task, @DBQueueElements_01. - Generated source-index flags show
HasDBQueueInsertSingle=1,HasDBQueueInsertBulk=1,HasChangeLimit=0, andHasQbmPJobCreate=0; the source index found 164 SQL modules referencing this procedure.
Operational meaning: This routine is the single-object convenience wrapper for DBQueue insertion. It does not itself write the final queue row in the verified source; it normalizes one object/subobject/genprocid into `QBM_YDBQueueRaw` and hands processing to the bulk path.
Relations
- Single DBQueue insert -> W at line 1
- Bulk DBQueue insert -> T at line 1
- Bulk DBQueue insert -> T at line 7
- References QBM_PDBQueueInsert_Single
- References QBM_PDBQueueInsert_Bulk
Typed Edges
- queues DBQueue task W at line 1 Single DBQueue insert -> W at line 1
- queues DBQueue task T at line 1 Bulk DBQueue insert -> T at line 1
- queues DBQueue task T at line 7 Bulk DBQueue insert -> T at line 7
- references source dbo.QBM_FGISessionContext source text reference
- references source dbo.QBM_FGISessionErrorRethrow source text reference
- references source dbo.QBM_PDBQueueInsert_Bulk source text reference
- references source dbo.QBM_PJournal source text reference
- references source dbo.QBM_PSessionErrorAdd source text reference
- queues DBQueue task W -> unresolved procedure QBM_PDBQueueInsert_Single (@UID_Task varchar(38), @object varchar(38), @SubObject varchar(38), @GenProcID varchar(38) , @Dummy_no_Check_For_Existing int = -1111 , @Dummy_Sort_Order int = -1111 ) as begin declare @DebugStartTime datetime = …
- queues DBQueue task T -> unresolved procedure QBM_PDBQueueInsert_Bulk @UID_Task , @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: exe…
References
- dbo.QBM_FGISessionContext
- dbo.QBM_FGISessionErrorRethrow
- dbo.QBM_PDBQueueInsert_Bulk
- dbo.QBM_PJournal
- dbo.QBM_PSessionErrorAdd
Referenced By
- dbo.QBM_FSQTriggerWatchSemaphor
- dbo.ADS_PAfterMigrationTasks
- dbo.ADS_ZBaseTreeOwnsObjectPrepair
- dbo.ADS_ZGroupInADSGroup
- dbo.ATT_PAfterMigrationTasks
- dbo.ATT_PAttestationCaseDeleteOld
- dbo.ATT_PAttestationHelperFill
- dbo.ATT_ZAllForPersonInBaseTree
- dbo.CPL_PAfterMigrationTasks
- dbo.CPL_ZAllForPersonInBaseTree
- dbo.CPL_ZComplianceCheckMakeProc
- dbo.LDP_PAfterMigrationTasks
- dbo.LDP_ZBaseTreeOwnsObjectPrepair
- dbo.LDP_ZGroupInLDAPGroup
- dbo.QBM_PDBQCS_CurrentRestore
- dbo.QBM_PDBQueueInsert_Int
- dbo.QBM_PDBQueueInsert_WaitForComp
- dbo.QBM_PDBQueuePrepareForCompiler
- dbo.QBM_PIndexRebuild
- dbo.QBM_PMigrationNotReadyForComp
- dbo.QBM_PPrePropCheckSyntax
- dbo.QBM_PTableReload
- dbo.QBM_PWatchDogPrepare
- dbo.QBM_PWorkSchedule
- dbo.QBM_ZBufferTProcessDelete
- dbo.QBM_ZBufferTProcessModule
- dbo.QBM_ZBufferTProcessModulePU
- dbo.QBM_ZCheckRIChild
- dbo.QBM_ZConstraintEnable
- dbo.QBM_ZDashBoardContentCalculate
- dbo.QBM_ZDeferredOperationExecute
- dbo.QBM_ZGroupNumber
- dbo.QBM_ZPrePropAll
- dbo.QBM_ZPrepropGenerateFunction
- dbo.QBM_ZPrePropGroup
- dbo.QBM_ZRecalculate
- dbo.QBM_ZTaskForInactiveTrigger
- dbo.QBM_ZTriggerWatchCreate
- dbo.QER_PAfterMigrationTasks
- dbo.QER_PITShopCheckMethodBO
- dbo.QER_PITShopHelperFill_Recalc
- dbo.QER_PITShopProductNodeCheck
- dbo.QER_POrderUnreachableClose
- dbo.QER_ZAllForPersonInBaseTree
- dbo.QER_ZDynGroupSingleBasic
- dbo.QER_ZITShopCheckMethodPR
- dbo.QER_ZITShopDeleteClosed
- dbo.QER_ZITShopProductNodeCheck
- dbo.QER_ZOrgInherite
- dbo.TSB_PAfterMigrationTasks
- dbo.TSB_ZBaseTreeOwnsObjectPrepair
- dbo.TSB_ZUNSGroupB1InUNSGroupB1
- dbo.TSB_ZUNSGroupB2InUNSGroupB2
- dbo.TSB_ZUNSGroupB3InUNSGroupB3
- dbo.TSB_ZUNSGroupBInUNSGroupB
- dbo.ADS_TUAdsGroup
- dbo.ATT_TUBaseTree
- dbo.ATT_TUDialogConfigParm
- dbo.ATT_TUOrgRoot
- dbo.ATT_TUPerson
Complete Source
1CREATE PROCEDURE QBM_PDBQueueInsert_Single(2 @UID_Task varchar(38),3 @object varchar(38),4 @SubObject varchar(38),5 @GenProcID varchar(38),6 @Dummy_no_Check_For_Existing int = -1111,7 @Dummy_Sort_Order int = -11118)9AS10BEGIN11 DECLARE @DebugStartTime datetime = getutcdate()12 DECLARE @Debuglevel char(1) = 'W'13 DECLARE @ErrorMessage nvarchar(4000)14 DECLARE @ErrorSeverity int15 DECLARE @ErrorState int16 SET XACT_ABORT OFF17 BEGIN TRY18 IF isnull(@Dummy_no_Check_For_Existing,19 0) <> -1111 OR isnull(@Dummy_Sort_Order,20 0) <> -111121 BEGIN22 SET XACT_ABORT23 ON24 RAISERROR('#LDS#Obsolete parameters used.|',25 18,26 1)27 WITH NOWAIT28 END29 IF isnull(@GenProcID,30 '') = ''31 BEGIN32 SELECT33 @ErrorMessage = CONCAT('empty GenProcID, Task = ',34 isnull(@UID_Task, '<no>'),35 ' Object = ',36 isnull(@object, '<no>'))37 EXEC QBM_PJournal @ErrorMessage,38 @@ProcID,39 'D',40 @DebugLevel41 SELECT @GenProcID = dbo.QBM_FGISessionContext('')42 END43 DECLARE @DBQueueElements_01 QBM_YDBQueueRaw44 INSERT INTO @DBQueueElements_01(Object,45 subobject,46 Genprocid)47 VALUES(@object,48 @SubObject,49 @GenProcID)50 EXEC QBM_PDBQueueInsert_Bulk @UID_Task,51 @DBQueueElements_0152 END TRY53 BEGIN CATCH54 EXEC QBM_PSessionErrorAdd DEFAULT55 DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()56 RAISERROR(@Rethrow,57 18,58 1)59 WITH NOWAIT60 END CATCH61 endLabel:62 EXEC QBM_PJournal @Debugstarttime,63 @@procid,64 'T',65 @Debuglevel66 RETURN67ENDOpen raw exported source
1 create procedure QBM_PDBQueueInsert_Single (@UID_Task varchar(38), @object varchar(38), @SubObject varchar(38), @GenProcID varchar(38) , 2@Dummy_no_Check_For_Existing int = -1111 , @Dummy_Sort_Order int = -1111 ) as begin declare @DebugStartTime datetime = getutcdate() declare @Debuglevel3 char(1) = 'W' declare @ErrorMessage nvarchar(4000) declare @ErrorSeverity int declare @ErrorState int SET XACT_ABORT OFF BEGIN TRY if isnull(@Dummy_no_Check_For_Existing4, 0) <> -1111 or isnull(@Dummy_Sort_Order, 0) <> -1111 begin set XACT_ABORT ON RAISERROR ('#LDS#Obsolete parameters used.|', 18, 1) WITH NOWAIT end if5 isnull(@GenProcID, '') = '' begin select @ErrorMessage = concat('empty GenProcID, Task = ' , isnull(@UID_Task, '<no>') , ' Object = ' , isnull(@object6, '<no>') ) exec QBM_PJournal @ErrorMessage, @@ProcID, 'D', @DebugLevel select @GenProcID = dbo.QBM_FGISessionContext('') end declare @DBQueueElements_017 QBM_YDBQueueRaw insert into @DBQueueElements_01 (Object, subobject, Genprocid) values( @object, @SubObject, @GenProcID) exec QBM_PDBQueueInsert_Bulk @UID_Task8, @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR9 (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: exec QBM_PJournal @Debugstarttime, @@procid, 'T', @Debuglevel return end 10