topic Re: HUB Not Working in Product Forum

HUB Not Working

Ansar_AhmedAtta — Mon, 31 May 2021 14:05:34 GMT

Hello Everyone,
I have installed HUB with all pre-requisite check but when I am trying to access it via browser it is giving me :-

HTTP Error 502.5 - ANCM Out-Of-Process Startup Failure

Common solutions to this issue:

The application process failed to start
The application process started but then stopped
The application process started but failed to listen on the configured port

Troubleshooting steps:

Check the system event log for error messages
Enable logging the application process' stdout messages
Attach a debugger to the application process and inspect

Also, when I checked my event logs I got this,

Application: dotnet.exe
CoreCLR Version: 4.700.20.11803
.NET Core Version: 3.1.3
Description: The process was terminated due to an unhandled exception.
Exception Info: Microsoft.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'.

Application '/LM/W3SVC/2/ROOT' with physical root 'C:\Program Files (x86)\Blue Prism\Authentication Server\' failed to start process with commandline 'dotnet .\ImsServer.Web.dll' at stage 'PostStartCheck', ErrorCode = '0x8027025b', assigned port 16238, retryCounter '1'.

Please help me solve this issue.

Thanks,
Ansar

Re: HUB Not Working

bruce.liu — Tue, 01 Jun 2021 01:10:42 GMT

Hi Ansar,

It is like you do not have permission to create a database on the SQL Server instance, as indicated by "Exception Info: Microsoft.Data.SqlClient.SqlException (0x80131904): CREATE DATABASE permission denied in database 'master'."

To quote the following article https://dba.stackexchange.com/questions/78388/create-database-permission-denied-in-database-master-unable-to-get-the-permis

The user must be a member of dbcreator server role for user to have enough permissions to create a database.

You can execute the following statement to make a user member of dbcreator server role.

EXEC master..sp_addsrvrolemember @loginame = N'Shubhankar', @rolename = N'dbcreator'
GO

Members of sysadmin role are by default members of dbcreator server role therefore they can create databases too.

Hope this helps.

Re: HUB Not Working

Ansar_AhmedAtta — Tue, 01 Jun 2021 03:58:09 GMT

Hi Bruce,
I have already verified, my user has all the necessary permissions, still I am unable to access.

Thanks,

Ansar

Re: HUB Not Working

bruce.liu — Tue, 01 Jun 2021 04:35:37 GMT

Hi Ansar,

In this case, I would suggest you reach out to Blue Prism support to have your case looked at.

Re: HUB Not Working

Ansar_AhmedAtta — Tue, 01 Jun 2021 15:29:56 GMT

Hi Bruce,
For the update, Hub is working fine now; there was issue in application pool in IIS. So now all good in terms of hub. Next, I did was install the control room plugin and did the DB connection as well but I am unable to see any data in my queues section schedule section and all.

What can be the possible issues.?

Thanks,
Ansar

Re: HUB Not Working

bruce.liu — Tue, 01 Jun 2021 23:07:14 GMT

Hi Ansar,

You must now configure Authentication Server and then have your users synced up between Hub and Blue Prism. Do make sure you avoid the use of admin user in the process in case you need to "disconnect" the Authentication Server. Once this is done, check if your Hub user appears in Blue Prism under System > Security > Users. You will then need to assign permissions to your Hub user for relevant section of the screen in the same way as you would do for a native Blue Prism user. This can be done using System > Security > User Roles. For example, if access to Control Room is needed, you must assign Control Room role related permissions to the user.

The baseline is Hub does not have specific permissions controlling user access. It is all done via the permissions around the mapped users in Blue Prism.

Re: HUB Not Working

Ansar_AhmedAtta — Wed, 02 Jun 2021 03:41:42 GMT

Hi Bruce,
I did the same but there is pre-requisite for App Server.

Can't this be done in standalone deployment without app server.?

Thanks,

Ansar

Re: HUB Not Working

bruce.liu — Wed, 02 Jun 2021 06:03:03 GMT

Hi Ansar,

App server is a must before you can provision Authentication Server, which is a pre-requisite for Hub and Blue Prism API. In standalone mode, you can only experience the core Blue Prism product in the same way as v6.

Re: HUB Not Working

Ansar_AhmedAtta — Wed, 02 Jun 2021 14:55:24 GMT

Hi Bruce,
For the update, everything is working fine now. I can login to my blue prism via authentication server and my web-based control room is also working fine.

Thanks,
Ansar

Re: HUB Not Working

bruce.liu — Wed, 02 Jun 2021 23:11:06 GMT

Good to know everything is working for you Ansar.

Re: HUB Not Working

AndreFerreira — Sat, 25 Sep 2021 07:28:13 GMT

Hello Ansar,

I think I'm having the same issue you had at the beginning. Can you please share how you solved the issue in application pool in IIS?

Thanks,
André

Re: HUB Not Working

Anastasiya__Ilgova — Mon, 17 Mar 2025 12:10:10 GMT

Hi both, what was the issue with IIS pool and how did you fix it? We are facing the same problem with installing HUB 5.1. Please give us some hint how did you fix it?