Back to OIM Explorer

dbo.ATT_PAfterMigrationTasks

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOFireEvent -> AttestationPolicy.RebuildWhereClause at line 7; HOFireEvent -> AttestationPolicy.RebuildWhereClause at line 13; Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 7; Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 7

Source: sandbox-db sys.sql_modules

Source size: 1.817 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • HOFireEvent -> AttestationPolicy.RebuildWhereClause at line 7
  • HOFireEvent -> AttestationPolicy.RebuildWhereClause at line 13
  • Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 7
  • Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 7
  • Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 13
  • Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 14
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*
  • References QBM_PDBQueueInsert_Single
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • fires event AttestationPolicy.RebuildWhereClause HOFireEvent -> AttestationPolicy.RebuildWhereClause at line 7
  • queues DBQueue task ATT_ZHelperAttestationPolicy at line 7 Bulk DBQueue insert -> ATT-K-HelperAttestationPolicy / ATT_ZHelperAttestationPolicy at line 7
  • queues DBQueue task QER_ZDynamicGroupMakeTrigger at line 7 Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 7
  • queues DBQueue task QER_ZDynamicGroupMakeTrigger at line 13 Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 13
  • queues DBQueue task QER_ZDynamicGroupMakeTrigger at line 14 Single DBQueue insert -> QER-K-DynamicGroupMakeTrigger / QER_ZDynamicGroupMakeTrigger at line 14
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent source text reference
  • references source dbo.QBM_PJobCreate_HOTemplate source text reference
  • references source dbo.QBM_PJobCreate_HOTemplate_B source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task ATT-K-HelperAttestationPolicy -> ATT_ZHelperAttestationPolicy QBM_PDBQueueInsert_Bulk 'ATT-K-HelperAttestationPolicy', @DBQueueElements_01 exec QBM_PJobCreate_HOTemplate_B 'HelperAttestationPolicy', 'UID_AttestationPolicy in (select UID_AttestationPolicy from AttestationPolicy p where p.IsInActive = …
  • queues DBQueue task QER-K-DynamicGroupMakeTrigger -> QER_ZDynamicGroupMakeTrigger QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT E…

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL72 lines
1CREATE PROCEDURE ATT_PAfterMigrationTasks(2  @GenProcID varchar(38)3)4AS5BEGIN6  DECLARE @MyModule varchar(3) = 'ATT'7  DECLARE @XUser nvarchar(64) = object_name(@@procid)8  DECLARE @Xdate datetime = getutcdate()9  DECLARE @AttCasePendingNL QBM_YCursorBuffer10  SET XACT_ABORT OFF11  BEGIN TRY12    INSERT INTO @AttCasePendingNL(UID1)13    SELECT UID_AttestationCase14    FROM AttestationCase15    WHERE16      DataLength(ReportContent) < 1017    UPDATE AttestationCase18    SET ReportContent = NULL,19    XDateUpdated = @Xdate,20    XUserUpdated = @XUser21    FROM AttestationCase ac22    JOIN @AttCasePendingNL h23      ON h.UID1 = ac.UID_AttestationCase24    WHERE25      rtrim(ReportContent) = ''26    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw27    INSERT INTO @DBQueueElements_01(object,28    subobject,29    genprocid)30    SELECT31      x.UID_Element,32      NULL,33      @GenProcID34    FROM(35    SELECT y.UID_AttestationPolicy AS UID_Element36    FROM AttestationPolicy y37    WHERE38      y.UID_AttestationPolicy LIKE '___-%' AND y.XUserUpdated LIKE 'QBM_PBufferT_Process%' AND y.XDateUpdated > GETUTCDATE() -1) AS x39    EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-HelperAttestationPolicy',40      @DBQueueElements_0141    EXEC QBM_PJobCreate_HOTemplate_B 'HelperAttestationPolicy',42    'UID_AttestationPolicy in (select UID_AttestationPolicy43									from AttestationPolicy p44									where p.IsInActive = 045									)46							and DisplayName is null'47    ,48    'DisplayName',49      @GenProcID,50      @AdditionalObjectKeysAffected = DEFAULT,51      @checkForExisting = 152    EXEC QBM_PJobCreate_HOFireEvent 'AttestationPolicy',53    '1=1',54    'RebuildWhereClause',55      @GenProcID,56      @objectKeysAffected = DEFAULT57    EXEC QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger',58    '',59    '',60      @GenProcID61  END TRY62  BEGIN CATCH63    EXEC QBM_PSessionErrorAdd DEFAULT64    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()65    RAISERROR(@Rethrow,66    18,67    1)68      WITH NOWAIT69  END CATCH70  endLabel:71  RETURN72END
Open raw exported source
SQL · Raw17 lines
1  create   procedure ATT_PAfterMigrationTasks (@GenProcID varchar(38) ) as begin declare @MyModule varchar(3) = 'ATT' declare @XUser nvarchar(642) = object_name(@@procid) declare @Xdate datetime = getutcdate() declare @AttCasePendingNL QBM_YCursorBuffer SET XACT_ABORT OFF BEGIN TRY  insert into 3@AttCasePendingNL (UID1) select UID_AttestationCase from AttestationCase where DataLength(ReportContent) < 10 update AttestationCase set ReportContent 4= null  , XDateUpdated = @Xdate , XUserUpdated = @XUser from AttestationCase ac join @AttCasePendingNL h on h.UID1 = ac.UID_AttestationCase where rtrim5(ReportContent) = ''   declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.UID_Element,6 null, @GenProcID from ( select y.UID_AttestationPolicy as UID_Element from AttestationPolicy y where y.UID_AttestationPolicy like '___-%'  and y.XUserUpdated7 like 'QBM_PBufferT_Process%' and y.XDateUpdated > GETUTCDATE() -1 ) as x exec QBM_PDBQueueInsert_Bulk 'ATT-K-HelperAttestationPolicy', @DBQueueElements_018   exec QBM_PJobCreate_HOTemplate_B 'HelperAttestationPolicy', 'UID_AttestationPolicy in (select UID_AttestationPolicy9									from AttestationPolicy p10									where p.IsInActive = 011									)12							and DisplayName is null'13, 'DisplayName', @GenProcID , @AdditionalObjectKeysAffected = default , @checkForExisting = 1  exec QBM_PJobCreate_HOFireEvent 'AttestationPolicy', '1=1'14 , 'RebuildWhereClause', @GenProcID, @objectKeysAffected = default        exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID15 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH16 NOWAIT END CATCH endLabel: return end 17