Error during Orchestrator Start up

Help
1

Dear All,

I got error when try to start the Orchestrator login page.

Error during Orchestrator start-up System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: Cannot open database "UiPath" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\UiPath Orchestrator'.
   at bool System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, uint waitForMultipleObjectsTimeout, bool allowCreate, bool onlyOneCheckConnection, DbConnectionOptions userOptions, out DbConnectionInternal connection)
   at bool System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource<DbConnectionInternal> retry, DbConnectionOptions userOptions, out DbConnectionInternal connection)
   at bool System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource<DbConnectionInternal> retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, out DbConnectionInternal connection)
   at bool System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource<DbConnectionInternal> retry, DbConnectionOptions userOptions)
   at bool System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource<DbConnectionInternal> retry)
   at bool System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource<DbConnectionInternal> retry)
   at Task System.Data.SqlClient.SqlConnection.OpenAsync(CancellationToken cancellationToken)
   at void System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy+<>c__DisplayClass4+<<ExecuteAsync>b__3>d__6.MoveNext()
   at async Task<TResult> System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.ExecuteAsyncImplementation<TResult>(Func<Task<TResult>> func)
   at async Task System.Data.Entity.Core.EntityClient.EntityConnection.OpenAsync(CancellationToken cancellationToken)
   --- End of inner exception stack trace ---
   at async Task System.Data.Entity.Core.EntityClient.EntityConnection.OpenAsync(CancellationToken cancellationToken)
   at async Task System.Data.Entity.Core.Objects.ObjectContext.EnsureConnectionAsync(bool shouldMonitorTransactions, CancellationToken cancellationToken)
   at async Task<T> System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransactionAsync<T>(Func<Task<T>> func, IDbExecutionStrategy executionStrategy, bool startLocalTransaction, bool releaseConnectionOnSuccess, CancellationToken cancellationToken)
   at async Task<TResult> System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.ExecuteAsyncImplementation<TResult>(Func<Task<TResult>> func)
   at T System.Data.Entity.Utilities.TaskExtensions+CultureAwaiter<T>.GetResult()
   at async Task<ObjectResult<T>> System.Data.Entity.Core.Objects.ObjectQuery<T>.GetResultsAsync(Nullable<MergeOption> forMergeOption, IDbExecutionStrategy executionStrategy, CancellationToken cancellationToken)
   at T System.Data.Entity.Utilities.TaskExtensions+CultureAwaiter<T>.GetResult()
   at async Task<bool> System.Data.Entity.Internal.LazyAsyncEnumerator<T>.FirstMoveNextAsync(CancellationToken cancellationToken)
   at async Task System.Data.Entity.Infrastructure.IDbAsyncEnumerableExtensions.ForEachAsync<T>(IDbAsyncEnumerator<T> enumerator, Action<T> action, CancellationToken cancellationToken)
   at async Task<List<TEntity>> Abp.EntityFramework.Repositories.EfRepositoryBase<TDbContext, TEntity, TPrimaryKey>.GetAllListAsync(Expression<Func<TEntity, bool>> predicate)
   at async Task<T> Abp.Threading.InternalAsyncHelper.AwaitTaskWithPostActionAndFinallyAndGetResult<T>(Task<T> actualReturnValue, Func<Task> postAction, Action<Exception> finalAction)
   at async Task<List<SettingInfo>> Abp.Configuration.SettingStore.GetAllListAsync(Nullable<int> tenantId, Nullable<long> userId)
   at async Task<T> Abp.Threading.InternalAsyncHelper.AwaitTaskWithPostActionAndFinallyAndGetResult<T>(Task<T> actualReturnValue, Func<Task> postAction, Action<Exception> finalAction)
   at async Task<Dictionary<string, SettingInfo>> Abp.Configuration.SettingManager.GetApplicationSettingsAsync()+(?) => { }
   at void Abp.Runtime.Caching.CacheExtensions+<>c__DisplayClass5_0<TKey, TValue>+<<GetAsync>b__0>d.MoveNext()
   at async Task<object> Abp.Runtime.Caching.CacheBase.GetAsync(string key, Func<string, Task<object>> factory)
   at async Task<TValue> Abp.Runtime.Caching.CacheExtensions.GetAsync<TKey, TValue>(ICache cache, TKey key, Func<TKey, Task<TValue>> factory)
   at async Task<Dictionary<string, SettingInfo>> Abp.Configuration.SettingManager.GetApplicationSettingsAsync()
   at async Task<SettingInfo> Abp.Configuration.SettingManager.GetSettingValueForApplicationOrNullAsync(string name)
   at async Task<string> Abp.Configuration.SettingManager.GetSettingValueInternalAsync(string name, Nullable<int> tenantId, Nullable<long> userId, bool fallbackToDefault)
   at async Task UiPath.Application.Services.SettingsService.SynchronizeAppSettingsAsync()
   at async Task Abp.Threading.InternalAsyncHelper.AwaitTaskWithPostActionAndFinally(Task actualReturnValue, Func<Task> postAction, Action<Exception> finalAction)
   at void Nito.AsyncEx.Synchronous.TaskExtensions.WaitAndUnwrapException(Task task)
   at void Nito.AsyncEx.Synchronous.TaskExtensions.WaitAndUnwrapException(Task task)
   at void Nito.AsyncEx.AsyncContext.Run(Func<Task> action)
   at void UiPath.Web.UiPathWebModule.PostInitialize()
   at void System.Collections.Generic.List<T>.ForEach(Action<T> action)
   at void Abp.AbpBootstrapper.Initialize()
   at void UiPath.Web.MvcApplication.Application_Start(object sender, EventArgs e)
System.Data.SqlClient.SqlException (0x80131904): Cannot open database "UiPath" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\UiPath Orchestrator'.
   at bool System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, uint waitForMultipleObjectsTimeout, bool allowCreate, bool onlyOneCheckConnection, DbConnectionOptions userOptions, out DbConnectionInternal connection)
   at bool System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource<DbConnectionInternal> retry, DbConnectionOptions userOptions, out DbConnectionInternal connection)
   at bool System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource<DbConnectionInternal> retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, out DbConnectionInternal connection)
   at bool System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource<DbConnectionInternal> retry, DbConnectionOptions userOptions)
   at bool System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource<DbConnectionInternal> retry)
   at bool System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource<DbConnectionInternal> retry)
   at Task System.Data.SqlClient.SqlConnection.OpenAsync(CancellationToken cancellationToken)
   at void System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy+<>c__DisplayClass4+<<ExecuteAsync>b__3>d__6.MoveNext()
   at async Task<TResult> System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.ExecuteAsyncImplementation<TResult>(Func<Task<TResult>> func)
   at async Task System.Data.Entity.Core.EntityClient.EntityConnection.OpenAsync(CancellationToken cancellationToken)
ClientConnectionId:1d5ce604-4595-4984-8828-f0e31710a6e1
Error Number:4060,State:1,Class:11

please help me. Thanks in advance

2

Can you explain how you are providing credentials for SQL server db? @irahmat

3

Hi Hareesh,

thanks for your response. I already solve it by re-install orchestrator and selecting “Custom account” on Pool setting also use an account same as windows authentication

the error occurred is because I used “Application Pool Identify” that User hasn’t created for accessing UiPath Database.

Cheers,
Indra

4

Great @irahmat

If you have time, please post the steps you did in the entire process while installing the orchestrator so that people will look into it if they have the same problem.

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.