dbo.QBM_PMigrationNotReadyForComp

1        create   procedure QBM_PMigrationNotReadyForComp  ( @UID_Task varchar(38) = 'QBM-K-CommonWaitForCompiler' , @WithTaskInsert bit = 1 ) as
2 begin declare @notReady int = 1 declare @exists int   declare @CutOffTaskLevel int declare @GenProcID varchar(38) = newid() declare @DebugSwitch int =
3 0 declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('') declare @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext('XUser') SET XACT_ABORT OFF
4 BEGIN TRY if isnull(@UID_Task, '###') not in ('QBM-K-CommonWaitForCompiler', 'QBM-K-BaseMigrationReady') begin raiserror ('#LDS#Invalid @UID_Task used.|'
5, 18, 1) with nowait end select @exists = dbo.QBM_FGICutOffTaskExists(@UID_Task) if @exists = 1  begin exec QBM_PWaitForSeconds 0.75 select @exists = dbo.QBM_FGICutOffTaskExists
6(@UID_Task) if @exists = 1 begin exec QBM_PWaitForSeconds 0.75 select @exists = dbo.QBM_FGICutOffTaskExists(@UID_Task) end end if @exists = 0   and @WithTaskInsert
7 = 1 begin if exists (select top 1 1 from DialogDatabase d with (readpast) where d.UID_CutOffTask is null and d.IsMainDatabase = 1 ) begin exec QBM_PDBQueueInsert_Single
8 @uid_task, '', '', @GenProcID goto endLabel end end select @notReady = case @exists when 0 then 1  when -1 then 1  else  0  end END TRY BEGIN CATCH exec
9 QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel:
10 exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R exec QBM_PSessionContextSet 'XUser', @XUser_R return (@notReady) end 
11