Upgrading Orchestrator 2020.4 to 2022.10.3 encounter some error(s)

[mita29 (Avirot Mitamura)]

Please kindly assist on this issue.
(1) An error occured while installing
System.Exception: Migration failed: There is already an object named ‘TaskActivities’ in the database.
Microsoft.Data.SqlClient.SqlException (0x80131904): There is already an object named ‘TaskActivities’ in the database.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

(2) Error Occured while reverting to the previous version of database.
System.Exception: Migration failed: Invalid object name ‘dbo.SystemJobsSchedules’.
System.Data.SqlClient.SqlException (0x80131904): Invalid object name ‘dbo.SystemJobsSchedules’.
at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task`1 result)

[pravallikapaluri]

Hi @mita29

Check the below thread

DB error when installing Orchestrator 2021.10

I had the same issue and i fixed by adding: TrustServerCertificate=True; to the connection string

[mkankatala (Mahesh Kankatala)]

Hi @mita29

Can you check the below thread, it would be helpful for your problem,

Error: &#39;packages migration has failed&#39; when upgrading Orchestrator

Issue Description: When upgrading Orchestrator from v2020.4.3 to v.20.10.8 we are getting an error saying that "packages migration has failed". The following error is recorded in the logs: 'System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.__PackagesMigration'. Most likely, there is an issue with the specific user with which the upgrade is being run. To overcome this issue, create a new login, with user and password, in SQL. The following files have to be edited wi…

Hope it helps!!

[mita29 (Avirot Mitamura)]

Thank you very much for your reply, but seem that by adding: TrustServerCertificate=True; to the connection string would not the cause of my error. cheer

[pravallikapaluri]

@mita29

Have you tried by downgrading the packages by making runtime rule as lowest applicable

Regards

[mita29 (Avirot Mitamura)]

More Detail of Exception:

• Installation of Orchestrator 2022.10.3
  ||+ SQL: XXXX-RPA-OCH|
  ||+ DB : UiPath_Orchestrator|
  ||+ SQL authen mode : SQL Server authentication|
  ||+ User: RPAXXX|
  ||+ Pass: *******|

• Error Occured
  System.Exception: Migration failed: There is already an object named ‘Table::TaskActivities’ in the database.
  Microsoft.Data.SqlClient.SqlException (0x80131904): There is already an object named ‘TaskActivities’ in the database.
  at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
  at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
  at Microsoft.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean isAsync, Int32 timeout, Boolean asyncWrite)
  at Microsoft.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry, String methodName) at Microsoft.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<>c.<NonQuery>b__4_0(DbCommand t, DbCommandInterceptionContext1 c)
  at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func3 operation, TInterceptionContext interceptionContext, Action3 executing, Action3 executed)
  at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext)
  at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteNonQuery()
  at System.Data.Entity.Migrations.DbMigrator.ExecuteSql(MigrationStatement migrationStatement, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext)
  at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable1 migrationStatements, DbConnection connection, DbTransaction transaction, DbInterceptionContext interceptionContext) at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinTransaction(IEnumerable1 migrationStatements, DbTransaction transaction, DbInterceptionContext interceptionContext)
  at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsWithinNewTransaction(IEnumerable1 migrationStatements, DbConnection connection, DbInterceptionContext interceptionContext) at System.Data.Entity.Migrations.DbMigrator.ExecuteStatementsInternal(IEnumerable1 migrationStatements, DbConnection connection)
  at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClass61_0.b__0()
  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass2_0.b__0() in /_/src/ErikEJ.EntityFramework.SqlServer/DefaultSqlExecutionStrategy.cs:line 32
  at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func1 operation) in /_/src/ErikEJ.EntityFramework.SqlServer/DefaultSqlExecutionStrategy.cs:line 43 at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Action operation) in /_/src/ErikEJ.EntityFramework.SqlServer/DefaultSqlExecutionStrategy.cs:line 29 at System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable1 migrationStatements, DbTransaction existingTransaction)
  at System.Data.Entity.Migrations.DbMigrator.ExecuteStatements(IEnumerable1 migrationStatements) at System.Data.Entity.Migrations.Infrastructure.MigratorBase.ExecuteStatements(IEnumerable1 migrationStatements)
  at System.Data.Entity.Migrations.DbMigrator.ExecuteOperations(String migrationId, VersionedModel targetModel, IEnumerable1 operations, IEnumerable1 systemOperations, Boolean downgrading, Boolean auto)
  at System.Data.Entity.Migrations.DbMigrator.ApplyMigration(DbMigration migration, DbMigration lastMigration)
  at System.Data.Entity.Migrations.DbMigrator.Upgrade(IEnumerable1 pendingMigrations, String targetMigrationId, String lastMigrationId) at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Upgrade(IEnumerable1 pendingMigrations, String targetMigrationId, String lastMigrationId)
  at System.Data.Entity.Migrations.DbMigrator.UpdateInternal(String targetMigration)
  at System.Data.Entity.Migrations.DbMigrator.<>c__DisplayClass42_0.b__0()
  at System.Data.Entity.Migrations.DbMigrator.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
  at System.Data.Entity.Migrations.Infrastructure.MigratorBase.EnsureDatabaseExists(Action mustSucceedToKeepDatabase)
  at System.Data.Entity.Migrations.DbMigrator.Update(String targetMigration)
  at System.Data.Entity.Migrations.Infrastructure.MigratorBase.Update()
  at UiPath.Orchestrator.DataAccess.Common.UiDbInitializerBase2.InitializeDatabase(TContext context) in C:\or-bld-ag-41aa3c83-we\_work\1\s\src\DataAccess\Common\UiDbInitializer.cs:line 51 at UiPath.Orchestrator.DataAccess.EntityFramework.EntityFramework.UiPathDatabaseInitializer.InitializeDatabase(UiPathDbContext context) in C:\or-bld-ag-41aa3c83-we\_work\1\s\src\DataAccess\EntityFramework\EntityFramework\UiPathDatabaseInitializer.cs:line 30 at System.Data.Entity.Internal.InternalContext.<>c__DisplayClass66_01.b__0()
  at System.Data.Entity.Internal.InternalContext.PerformInitializationAction(Action action)
  at System.Data.Entity.Internal.InternalContext.PerformDatabaseInitialization()
  at System.Data.Entity.Internal.LazyInternalContext.<>c.b__58_0(InternalContext c)
  at System.Data.Entity.Internal.RetryAction1.PerformAction(TInput input) at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabaseAction(Action1 action)
  at System.Data.Entity.Internal.LazyInternalContext.InitializeDatabase()
  at System.Data.Entity.Internal.InternalContext.Initialize()
  at System.Data.Entity.Internal.InternalContext.ForceOSpaceLoadingForKnownEntityTypes()
  at System.Data.Entity.DbContext.System.Data.Entity.Infrastructure.IObjectContextAdapter.get_ObjectContext()
  at Abp.EntityFramework.AbpDbContext.RegisterToChanges() in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Abp\Abp.EntityFramework\EntityFramework\AbpDbContext.cs:line 147
  at Abp.EntityFramework.AbpDbContext.InitializeDbContext() in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Abp\Abp.EntityFramework\EntityFramework\AbpDbContext.cs:line 142
  at Abp.EntityFramework.AbpDbContext…ctor(String nameOrConnectionString) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Abp\Abp.EntityFramework\EntityFramework\AbpDbContext.cs:line 91
  at Abp.Zero.EntityFramework.AbpZeroCommonDbContext3..ctor(String nameOrConnectionString) in C:\or-bld-ag-41aa3c83-we\_work\1\s\src\Abp\Abp.ZeroCore.EntityFramework\Zero\EntityFramework\AbpZeroCommonDbContext.cs:line 159 at Abp.Zero.EntityFramework.AbpZeroDbContext4…ctor(String nameOrConnectionString) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Abp\Abp.ZeroCore.EntityFramework\Zero\EntityFramework\AbpZeroDbContext.cs:line 65
  at UiPath.Orchestrator.DataAccess.EntityFramework.EntityFramework.UiPathDbContext…ctor(String nameOrConnectionString) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\DataAccess\EntityFramework\EntityFramework\UiPathDbContext.cs:line 184
  at UiPath.Orchestrator.DataAccess.EntityFramework.EntityFramework.UiPathDbContext.Create(String connectionString, IConfiguration configuration) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\DataAccess\EntityFramework\EntityFramework\UiPathDbContext.cs:line 497
  at UiPath.Orchestrator.DataAccess.EntityFramework.Migrations.Factory.SqlDatabaseMigrator.CreateDbContext() in C:\or-bld-ag-41aa3c83-we_work\1\s\src\DataAccess\EntityFramework\Migrations\Factory\SqlDatabaseMigrator.cs:line 48
  at UiPath.Orchestrator.DataAccess.EntityFramework.Migrations.Factory.SqlDatabaseMigrator.InstallOrUpdateDatabase() in C:\or-bld-ag-41aa3c83-we_work\1\s\src\DataAccess\EntityFramework\Migrations\Factory\SqlDatabaseMigrator.cs:line 34
  at UiPath.Orchestrator.Setup.DatabaseMigration.Helpers.DatabaseMigratorBase3.InstallOrUpdateDatabase() in C:\or-bld-ag-41aa3c83-we\_work\1\s\src\Setup\DatabaseMigration\Helpers\DatabaseMigratorBase.cs:line 23 at UiPath.Orchestrator.Cli.Database.DatabaseOperationsManager.UpdateToLatestAsync(String hostAdminPass, Nullable1 changeHostAdminPass, String tenantAdminPass, Nullable`1 changeTenantAdminPass) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Setup\Cli\Database\DatabaseOperationsManager.cs:line 59
  at UiPath.Orchestrator.Cli.Database.DatabaseCommandHandler.HandleDatabaseUpgradeAsync(DatabaseUpgradeOptions options) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Setup\Cli\Database\DatabaseCommandHandler.cs:line 50
  at UiPath.Orchestrator.Cli.Database.DatabaseCommandHandler.HandleAsync(Parser parser, String args) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Setup\Cli\Database\DatabaseCommandHandler.cs:line 16
  ClientConnectionId:68b0f0bc-64e8-479a-961f-091c5cd9713f
  Error Number:2714,State:6,Class:16

  at UiPath.Orchestrator.Setup.Configuration.Database.DbMigratorWrapper.RunTool()
  at UiPath.Orchestrator.Setup.Configuration.Database.DbMigratorWrapper.InstallOrUpdateDatabase()
  at UiPath.OrchestratorCAs.DatabaseManager.ApplyOrchestratorDbMigrations()
  at UiPath.OrchestratorCAs.DatabaseManager.ApplyDbMigrations()
  at UiPath.OrchestratorCAs.CustomActions.Deferred.UpdateConfigurationAndDatabasesAction.Execute()
  at UiPath.OrchestratorCAs.CustomActions.Base.BaseCustomAction.InternalExecute()

• Error Occured while reverting to the previous version of database.
  System.Exception: Migration failed: Invalid object name ‘dbo.SystemJobsSchedules’.
  System.Data.SqlClient.SqlException (0x80131904): Invalid object name ‘dbo.SystemJobsSchedules’.
  at System.Data.SqlClient.SqlCommand.<>c.b__126_0(Task1 result) at System.Threading.Tasks.ContinuationResultTaskFromResultTask2.InnerInvoke()
  at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj)
  at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  — End of stack trace from previous location —
  at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
  — End of stack trace from previous location —
  at UiPath.Scheduler.Core.DataAccess.SqlQueryExecutor.<>c__DisplayClass8_01.<<LoadListAsync>b__0>d.MoveNext() --- End of stack trace from previous location --- at UiPath.Scheduler.Core.DataAccess.SqlQueryExecutor.ExecuteDbActionAsync(Func3 doExecute, CancellationToken ct)
  at UiPath.Scheduler.Core.DataAccess.SqlQueryExecutor.LoadListAsync[T](SqlQuery query, CancellationToken ct)
  at UiPath.Orchestrator.Scheduling.BackgroundTasks.SystemSchedulesManager.ExecuteInTransactionAsync[TResult](IUnitOfWorkProvider unitOfWorkProvider, Func1 func, TransactionOption option) in C:\or-bld-ag-41aa3c83-we\_work\1\s\src\Core\Scheduling\BackgroundTasks\SystemSchedulesManager.cs:line 290 at UiPath.Orchestrator.Scheduling.BackgroundTasks.SystemSchedulesManager.GetSystemSchedulesAsync(CancellationToken ct) in C:\or-bld-ag-41aa3c83-we\_work\1\s\src\Core\Scheduling\BackgroundTasks\SystemSchedulesManager.cs:line 283 at UiPath.Orchestrator.Scheduling.BackgroundTasks.SystemSchedulesManager.DeleteNonExistingSystemSchedulesAsync(IEnumerable1 systemJobDescriptors, CancellationToken ct) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Core\Scheduling\BackgroundTasks\SystemSchedulesManager.cs:line 201
  at UiPath.Orchestrator.Scheduling.BackgroundTasks.SystemSchedulesManager.ClearSystemSchedulesAsync(CancellationToken ct) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Core\Scheduling\BackgroundTasks\SystemSchedulesManager.cs:line 70
  at Nito.AsyncEx.Synchronous.TaskExtensions.WaitAndUnwrapException(Task task)
  at Nito.AsyncEx.AsyncContext.<>c__DisplayClass15_0.b__0(Task t)
  at System.Threading.Tasks.ContinuationTaskFromTask.InnerInvoke()
  at System.Threading.Tasks.Task.<>c.<.cctor>b__272_0(Object obj)
  at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  — End of stack trace from previous location —
  at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
  at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
  — End of stack trace from previous location —
  at Nito.AsyncEx.Synchronous.TaskExtensions.WaitAndUnwrapException(Task task)
  at Nito.AsyncEx.AsyncContext.Run(Func1 action) at Abp.Threading.AsyncHelper.RunSync(Func1 action) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Abp\Abp\Threading\AsyncHelper.cs:line 33
  at UiPath.Orchestrator.Setup.DatabaseMigration.DatabaseMigrator.ClearInternalJobs() in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Setup\DatabaseMigration\DatabaseMigrator.cs:line 58
  at UiPath.Orchestrator.Cli.Database.DatabaseOperationsManager.ClearInternalJobsAsync() in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Setup\Cli\Database\DatabaseOperationsManager.cs:line 112
  at UiPath.Orchestrator.Cli.Database.DatabaseCommandHandler.HandleClearInternalJobsAsync(ClearInternalJobsOptions options) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Setup\Cli\Database\DatabaseCommandHandler.cs:line 123
  at UiPath.Orchestrator.Cli.Database.DatabaseCommandHandler.HandleAsync(Parser parser, String args) in C:\or-bld-ag-41aa3c83-we_work\1\s\src\Setup\Cli\Database\DatabaseCommandHandler.cs:line 16
  ClientConnectionId:5a59dc8c-7d44-46c5-a33a-685ad4862f2c
  Error Number:208,State:1,Class:16

  at UiPath.Orchestrator.Setup.Configuration.Database.DbMigratorWrapper.RunTool()
  at UiPath.Orchestrator.Setup.Configuration.Database.DefaultDbMigratorWrapper.ClearInternalJobs()
  at UiPath.OrchestratorCAs.DatabaseManager.RollbackOrchestratorDbMigrations(String migrationToRollbackTo)
  at UiPath.OrchestratorCAs.CustomActions.Rollback.RollbackDbMigrationsAction.Execute()
  at UiPath.OrchestratorCAs.CustomActions.Base.BaseCustomAction.InternalExecute()

[Anil_G (Anil Gorthi)]

@mita29

Can you first confirm your versions properly as 2010 is a wrong one I believe…because there is a compatibility matrix as well to show

https://docs.uipath.com/overview/other/latest/overview/orchestrator-upgrade-paths

Cheers

[mita29 (Avirot Mitamura)]

Thank you for your reply, here the detail of installation log
Installation Date: 24-Jun-2020
Install version: 2020.04
SQL Server 2019

actually, we intend to upgrade to version 2023.10 (or latest) but encounter classic folder issue. so by upgrading version 2020.4.x to 2022.10.x, there is no incompatibility lol.

[Anil_G (Anil Gorthi)]

@mita29

According to matrix it is compatible to upgrade from 2020.4 to 22.10…but there are many changes from the version you are upgrading from to the to version…are you following all the installation instructions from the official pages? As the components are different from 2020.10 and higher there would be more steps involved…did you check allt he prereqs?

Please check this doc

Orchestrator - About Updating and Migrating

Cheers

[mita29 (Avirot Mitamura)]

Hi, there, thank you for your reply and help.
I have read thru the installation guide and try to confirm any pre-requisite per below.

Requirements

Windows Server 2016, >2019<, 2022
SQL Server 2014, 2016, 2017, >2019 64bits< , 2022 Standard or Enterprise Edition
Elasticsearch 7.0 - 8.x
Check the official Elasticsearch End-of-Life dates and support matrix.
Kibana 7.0 - 8.x
WebDeploy >3.5+ (64bit version)<
Please note that this is required only for PowerShell script installations, such as the Azure one.
Windows PowerShell 5.1+ >n/a<
To download Windows PowerShell version 5.1, visit this link
MS.NET Framework 4.7.2+ > 6.0.21 x64<
ASP.NET Core Module 6.0.x, 8.0.x > Runtime 8.0.7.24314 <
IIS > 10.0.17763.1<
IIS Modules - URL Rewrite 2.1+ > v2 Module 2 7.2.1952<
Network/Firewall
TCP/1433 SQL
TCP/10000 HAA
TCP/9200 Elasticsearch server
TCP/9300 Elasticsearch nodes
TCP/5601 Kibana server
TCP/443, TCP/80 Webhooks web service
TCP/3389 RDP & HD Robots

[Anil_G (Anil Gorthi)]

@mita29

1. Are you using the upgrade tool? Or azure scripts?
2. What steps are done and on which step you are getting the issues?

Cheers

[mita29 (Avirot Mitamura)]

Hi, yes i’m using windows installation tools (v2022.10), not the script one. Cheer