Back to OIM Explorer

dbo.QBM_ZBufferTProcessDelete

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QBM-K-BufferTProcessDelete / QBM_ZBufferTProcessDelete at line 10; Single DBQueue insert -> QBM-K-FillModelFinished / QBM_ZDBQueueVoidTask at line 10; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 1.721 characters

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.

Relations

  • Single DBQueue insert -> QBM-K-BufferTProcessDelete / QBM_ZBufferTProcessDelete at line 10
  • Single DBQueue insert -> QBM-K-FillModelFinished / QBM_ZDBQueueVoidTask at line 10
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QBM_ZBufferTProcessDelete at line 10 Single DBQueue insert -> QBM-K-BufferTProcessDelete / QBM_ZBufferTProcessDelete at line 10
  • queues DBQueue task QBM_ZDBQueueVoidTask at line 10 Single DBQueue insert -> QBM-K-FillModelFinished / QBM_ZDBQueueVoidTask at line 10
  • references source dbo.QBM_PDBQCS_CurrentRestore source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PJournal source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-BufferTProcessDelete -> QBM_ZBufferTProcessDelete QBM_PDBQueueInsert_Single 'QBM-K-BufferTProcessDelete', @uid_Module, '', @GenProcID end else begin exec QBM_PDBQueueInsert_Single 'QBM-K-FillModelFinished' , '', '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAIS…
  • queues DBQueue task QBM-K-FillModelFinished -> QBM_ZDBQueueVoidTask QBM_PDBQueueInsert_Single 'QBM-K-FillModelFinished' , '', '', @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL83 lines
1CREATE PROCEDURE QBM_ZBufferTProcessDelete(2  @SlotNumber int,3  @uid_Module varchar(38),4  @Dummy2 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @ModuleName varchar(3)10  DECLARE @Message nvarchar(1000)11  DECLARE @DebugStarttime datetime = getutcdate()12  DECLARE @DebugLevel char(1) = 'W'13  DECLARE @TasksToCheck TABLE(UID_Task varchar(38) collate database_default)14  DECLARE @UID_Task varchar(38)15  DECLARE @lastFillDummy datetime16  SET XACT_ABORT OFF17  BEGIN TRY18    SELECT @ModuleName =19    LEFT(@uid_module,20    3)21    INSERT INTO @TasksToCheck(uid_Task)22    VALUES('QBM-K-BufferTProcessModulePU'),23    ('QBM-K-BufferTProcessModule'),24    ('QBM-K-BufferTProcessTablePU'),25    ('QBM-K-BufferTProcessTable')26    IF EXISTS(27      SELECT TOP 1 128      FROM @TasksToCheck t29      JOIN DialogDBQueue q30      WITH(readpast)31      ON t.UID_Task = q.UID_Task32    WHERE33      q.Generation >= 0) OR EXISTS(34    SELECT TOP 1 135    FROM @TasksToCheck t36    JOIN QBMDBQueueCurrent q37      WITH(readpast)38      ON t.UID_Task = q.UID_Task39    WHERE40      q.SlotNumber <> 0)41    BEGIN42      SELECT43        @Message = '#LDS#Found active Tasks while executing {0}.|' + 'QBM_ZBufferTProcessDelete' + '|'44      EXEC QBM_PJournal @Message,45        @@PROCID,46      'W',47        @DebugLevel48      WHILE EXISTS(49      SELECT TOP 1 150      FROM @TasksToCheck)51      BEGIN52        SELECT TOP 1 @UID_Task = UID_Task53        FROM @TasksToCheck54        EXEC QBM_PDBQCS_CurrentRestore @ExecutionType = 0,55          @IgnoreGeneration = 1,56          @UID_TaskPattern = @UID_Task57        DELETE @TasksToCheck58        WHERE59          UID_Task = @UID_Task60      END61      EXEC QBM_PDBQueueInsert_Single 'QBM-K-BufferTProcessDelete',62        @uid_Module,63      '',64        @GenProcID65    END66    ELSE67    BEGIN68      EXEC QBM_PDBQueueInsert_Single 'QBM-K-FillModelFinished',69      '',70      '',71        @GenProcID72    END73  END TRY74  BEGIN CATCH75    EXEC QBM_PSessionErrorAdd DEFAULT76    RAISERROR('',77    18,78    1)79      WITH NOWAIT80  END CATCH81  ende:82  RETURN83END
Open raw exported source
SQL · Raw12 lines
1  create   procedure QBM_ZBufferTProcessDelete (@SlotNumber int , @uid_Module varchar(38) , @Dummy2 varchar(38) , @GenProcID varchar(38) ) AS begin2 declare @ModuleName varchar(3) declare @Message nvarchar(1000) declare @DebugStarttime datetime = getutcdate() declare @DebugLevel char(1) = 'W' declare3 @TasksToCheck table (UID_Task varchar(38) collate database_default ) declare @UID_Task varchar(38) declare @lastFillDummy datetime SET XACT_ABORT OFF 4BEGIN TRY  select @ModuleName = LEFT(@uid_module, 3) insert into @TasksToCheck (uid_Task) values ('QBM-K-BufferTProcessModulePU' ) , ('QBM-K-BufferTProcessModule'5) , ('QBM-K-BufferTProcessTablePU') , ('QBM-K-BufferTProcessTable')  if exists (select top 1 1 from @TasksToCheck t join DialogDBQueue q with (readpast6) on t.UID_Task = q.UID_Task where q.Generation >= 0 ) or exists (select top 1 1 from @TasksToCheck t join QBMDBQueueCurrent q with (readpast) on t.UID_Task7 = q.UID_Task where q.SlotNumber <> 0 ) begin select @Message = '#LDS#Found active Tasks while executing {0}.|' + 'QBM_ZBufferTProcessDelete' + '|' exec8 QBM_PJournal @Message,@@PROCID, 'W', @DebugLevel while exists (select top 1 1 from @TasksToCheck ) begin select top 1 @UID_Task = UID_Task from @TasksToCheck9   exec QBM_PDBQCS_CurrentRestore @ExecutionType = 0 , @IgnoreGeneration = 1 , @UID_TaskPattern = @UID_Task delete  @TasksToCheck  where UID_Task = @UID_Task10 end  exec QBM_PDBQueueInsert_Single 'QBM-K-BufferTProcessDelete', @uid_Module, '', @GenProcID   end else begin  exec QBM_PDBQueueInsert_Single 'QBM-K-FillModelFinished'11, '', '', @GenProcID end    END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 12