orchestrator
2024.10
true
UiPath logo, featuring letters U and I in white
Orchestrator 安装指南
Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated 2024年12月4日

升级前

请务必在从 2023.4 升级到 2023.4 以上的版本之前执行这些步骤。它们有助于确保在升级完成后,您可以立即开始使用,且不会有问题。

  1. 备份数据库以消除任何数据丢失风险。
  2. 运行下面的升级前数据库维护脚本。
    此脚本会从数据库中删除所有过期或已消耗的授权。这有助于 加快 [identity].[PersistedGrants] 主键和索引的 重新创建速度,从而加快 数据库迁移的速度。
    DECLARE @Now DATETIME2 = GETUTCDATE()
    DECLARE @ConsumedGrantsGracePeriod DATETIME2 = DATEADD(hour, -2, @Now)
    
    DECLARE @ConsumedDeleted int = 1
    DECLARE @ExpiredDeleted int = 1
    DECLARE @BatchSize int = 500
    DECLARE @ConsumedBatchesDeleted int = 0
    DECLARE @ExpiredBatchesDeleted int = 0
    
    SET LOCK_TIMEOUT 0
    SET DEADLOCK_PRIORITY LOW
    
    WHILE (@ConsumedDeleted=1 OR @ExpiredDeleted=1)
    BEGIN
    
      IF @ConsumedDeleted=1
      BEGIN
        BEGIN TRY
          DELETE TOP(@BatchSize) FROM [identity].[PersistedGrants] WHERE [ConsumedTime] IS NOT NULL AND [ConsumedTime] < @ConsumedGrantsGracePeriod AND [Type] <> 'reference_token'
          IF @@ROWCOUNT = 0
            SET @ConsumedDeleted=0
    	  ELSE
    	    SET @ConsumedBatchesDeleted = @ConsumedBatchesDeleted + 1
    	END TRY
    	BEGIN CATCH
    	  PRINT 'Failed to delete consumed grants'
    	END CATCH
      END
    
      IF @ExpiredDeleted=1
      BEGIN
        BEGIN TRY
          DELETE TOP(@BatchSize) FROM [identity].[PersistedGrants] WHERE [Expiration] < @Now AND [Type] <> 'reference_token'
    	  IF @@ROWCOUNT = 0
    	    SET @ExpiredDeleted=0
    	  ELSE
    	    SET @ExpiredBatchesDeleted = @ExpiredBatchesDeleted + 1
    	END TRY
    	BEGIN CATCH
    	  PRINT 'Failed to delete expired grants'
    	END CATCH
      END
    
      PRINT 'Consumed batches deleted: ' + CONVERT(nvarchar(32), @ConsumedBatchesDeleted)
      PRINT 'Expired batches deleted: ' + CONVERT(nvarchar(32), @ExpiredBatchesDeleted)
    
      -- Wait for 10 seconds between deletes
      IF (@ExpiredDeleted=1 OR @ConsumedDeleted=1)
        WAITFOR DELAY '00:00:05.000'
    
    ENDDECLARE @Now DATETIME2 = GETUTCDATE()
    DECLARE @ConsumedGrantsGracePeriod DATETIME2 = DATEADD(hour, -2, @Now)
    
    DECLARE @ConsumedDeleted int = 1
    DECLARE @ExpiredDeleted int = 1
    DECLARE @BatchSize int = 500
    DECLARE @ConsumedBatchesDeleted int = 0
    DECLARE @ExpiredBatchesDeleted int = 0
    
    SET LOCK_TIMEOUT 0
    SET DEADLOCK_PRIORITY LOW
    
    WHILE (@ConsumedDeleted=1 OR @ExpiredDeleted=1)
    BEGIN
    
      IF @ConsumedDeleted=1
      BEGIN
        BEGIN TRY
          DELETE TOP(@BatchSize) FROM [identity].[PersistedGrants] WHERE [ConsumedTime] IS NOT NULL AND [ConsumedTime] < @ConsumedGrantsGracePeriod AND [Type] <> 'reference_token'
          IF @@ROWCOUNT = 0
            SET @ConsumedDeleted=0
    	  ELSE
    	    SET @ConsumedBatchesDeleted = @ConsumedBatchesDeleted + 1
    	END TRY
    	BEGIN CATCH
    	  PRINT 'Failed to delete consumed grants'
    	END CATCH
      END
    
      IF @ExpiredDeleted=1
      BEGIN
        BEGIN TRY
          DELETE TOP(@BatchSize) FROM [identity].[PersistedGrants] WHERE [Expiration] < @Now AND [Type] <> 'reference_token'
    	  IF @@ROWCOUNT = 0
    	    SET @ExpiredDeleted=0
    	  ELSE
    	    SET @ExpiredBatchesDeleted = @ExpiredBatchesDeleted + 1
    	END TRY
    	BEGIN CATCH
    	  PRINT 'Failed to delete expired grants'
    	END CATCH
      END
    
      PRINT 'Consumed batches deleted: ' + CONVERT(nvarchar(32), @ConsumedBatchesDeleted)
      PRINT 'Expired batches deleted: ' + CONVERT(nvarchar(32), @ExpiredBatchesDeleted)
    
      -- Wait for 10 seconds between deletes
      IF (@ExpiredDeleted=1 OR @ConsumedDeleted=1)
        WAITFOR DELAY '00:00:05.000'
    
    END
  3. 将传统文件夹迁移 到新式文件夹,以确保执行不中断。

    这些 是您目前在传统文件夹删除流程中可以预期的更改。

此页面有帮助吗?

获取您需要的帮助
了解 RPA - 自动化课程
UiPath Community 论坛
Uipath Logo White
信任与安全
© 2005-2024 UiPath。保留所有权利。