Error " System.Exception: Migration failed: Init Database" Thrown On Orchestrator Upgrade

Error fix for "System.Exception: Migration failed: Init Database: An exception occurred while initializing the database." thrown during upgrading Orchestrator.

Perform the below steps and validate :

  • Verify if AuditLogEntries.AuditLogId shows a value unavailable in dbo.AuditLogs.Id
  • And if such records exist, remove them or change the AuditLogId to be consistent with AuditLogs.Id
  • Run the installer using command-line arguments with verbose level logging to collect logs:

The exe installer does not support command line arguments . Download. MSI, it supports the command line arguments: UiPathOrchestrator.msi /l*vx log.txt - This would generate the verbose logs in the installation location. Copy the same and share.

  • Ensure the user you are using from the installer has the DB owner access to the database
  • Check the total count of Dbo.QueueItems, Dbo.UserNotifications and other tables. Note that it is suggested to archive the exceeding data as per Maintenance-considerations .
  • Please verify once if the total row count of tables mentioned in the document is within range . Please do perform the necessary clean up if required using Maintenance-considerations .