topic RE: Getting error msg when installing Blue Prism Trial and Learning Edition in Product Forum

Getting error msg when installing Blue Prism Trial and Learning Edition

StevenFeldman — Tue, 11 Aug 2020 19:58:00 GMT

An error occurred whilst configuring Blue Prism localdb.
BluePrism.DatabaseInstaller.DatabaseInstallerException: Unable to determine whether database exists - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start.
)
at BluePrism.DatabaseInstaller.Installer.CheckDatabaseExists()
at BluePrism.AutomateAppCore.LocalDatabaseInstaller.get_DatabaseExists()
at BluePrism.AutomateAppCore.LocalDatabaseInstaller.get_UpgradeOnly()
at AutomateUI.BPApplication.Start(String[] args)

------------------------------
Steven Feldman
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

chris.strong — Fri, 14 Aug 2020 08:45:00 GMT

Hello Steven,

We saw this back in October 2019 on another thread (Learning Edition - Cannot find DB error) and it seemed the root cause of the issue was down to not having the right permission to install and setup Microsoft SQL Server LocalDB 2017.

I'll stick to the previous guidance, which was confirming whether Microsoft SQL Server LocalDB 2017 is already installed, if not, attempt to install it manually outside Blue Prism. Based on this information, we provided some further troubleshooting steps.

Tip: See the comments on 11 October and 27 November 2019.

In Summary: We're seeing a Microsoft SQL Server LocalDB error, we're trying to determine whether that same issue appears without Blue Prism being involved, this will help troubleshoot.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

StevenFeldman — Fri, 14 Aug 2020 14:56:00 GMT

Chris,

I am still struggling with resolving this issue. When I walk through the installer it does allow me to get to these steps of Configuring and activating. MS SQL 2017 is installed on my PC. Since I am very technical I am not sure what I need to do next? Are you, by chance, available for a 15-minute telephone conversation?

Steve Feldman

+1 908 672-5584 (mobile)

sdfeldman54@gmail.com

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

StevenFeldman — Fri, 14 Aug 2020 19:24:00 GMT

Chris,

Have made some progress. I was able to correct a couple of MS SQL 2017 configuration parameters and was able for the Blue Prism installer to create the database, etc. Looks like the last issue is installing the license file. The big issue that I have is when I open the BluePrism application, it does not present me with a login screen nor any mechanism to administer (e.g. add a license file) the application any further.

The only time the BluePrism installer prompted me for a login and password was after I removed MS SQL 2017 off of my computer and attempted to reinstall BluePrism.

What I am experiencing does not follow the installation guide. Any help is appreciated.

Regards,

Steve
+1 908 672-5584 (mobile)
sdfeldman54@gmail.com

------------------------------
Steven Feldman
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

chris.strong — Sat, 15 Aug 2020 07:03:00 GMT

Hello Steven,

Sorry to hear you are still struggling.

When you open Blue Prism, what do you see?

I expect you to be able to see, a Blue Prism login screen (screenshot) below. On here you can enter the user name admin and the password that you created yourself (just before we create the database for you).

Then, once you login, Blue Prism will detect that you don't have a license and then guide you through applying a license to your copy of either Blue Prism Trial or Learning Edition.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

StevenFeldman — Sat, 15 Aug 2020 11:46:00 GMT

Chris,

No. The login screen never appears. First I get the Blue Prism screen:

Then, after about 10 seconds or so:

I resolved some of the MS SQL 2017 settings issues on my own. I then had to use Windows File Explorer to navigate to the "SQLLocalDB" and "Automate Config" installation files. I clicked on it, put in the proper settings, and was able to create the database and establish connectivity to it.

Steve Feldman

+1 908 672-5584 (mobile)

sdfeldman54@gmail.com

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

chris.strong — Mon, 17 Aug 2020 07:34:00 GMT

Hello Steve,

Thank you for letting us know you worked around the issue. Looking at your screenshots, I think you've switched to using MS SQL Server Express, rather than LocalDB. That will work.

We made a conscious decision to keep the Learning Edition simple for non-techie people, that's why we choose to use LocalDB, as we can (should be able to) deploy and setup automatically, without complex configuration.

Now you're up and running, I hope you enjoy your learning experience.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

StevenFeldman — Mon, 17 Aug 2020 11:37:00 GMT

Chris,

Actually, I'm not out of the woods yet. Still having issues. I can't log onto BluePrism. No mechanism to install license.

Sent from my iPhone

Steve Feldman Innovation and Customer Experience

Group - Self Service Practice Leader

+1 908 953-6436 office +1 908 672-5584 mobile

sdfeldman@Avaya.com

"Delivering Value & Vision through Customer Experience Solutions"

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

chris.strong — Mon, 17 Aug 2020 16:06:00 GMT

Hello Steven,

Oh no, sorry I misunderstood your post.

Let's first check if I've followed, this is what I think you have:

Microsoft SQL Server 2017 LocalDB is not working on your computer (we keep seeing error messages when attempting to connect to it)
You have installed Microsoft SQL Server Express (I don't know which version, but that shouldn't matter here)
You have created a new Blue Prism database:
- Database Server: localhost\SQLExpress
- Database Name: BluePrism
You have added a Connection to the Blue Prism application and called it BPConnection
You have not logged into to you BPConnection Blue Prism database

If I've understood / assumed correctly, this is the behaviour I expect you'd see:

You should now be able to open Blue Prism and be presented with Sign in to Blue Prism (I've created a screenshot below)
Based on your screenshot, I expect you to have a drop down listing LocalDB Connection and BPConnection
If you select BPConnection (the one you manually created), by default, the username will be admin and the password will be admin
Once you login using admin / admin, you will be asked to give the admin username and new password (so that it doesn't stay at the default)
Once you change the password, Blue Prism will detect that there is not a license within your new database and prompt you to license it.
- Note: Each database is licenses individually, you will not be prompted to license the Blue Prism database until you've opened it within the application.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

StevenFeldman — Mon, 17 Aug 2020 16:13:00 GMT

Chris,

The issue that remains is that when I click on the Blue Prism application icon on my desktop the login screen never appears. First I get the Blue Prism screen:

Then, after about 10 seconds or so:

So, I never get a screen that allows me to log in and complete the remaining tasks.

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

chris.strong — Mon, 17 Aug 2020 16:34:00 GMT

Hello Steven,

OK, I see, one of the screenshots threw me. The Database Connection window is also available via the Login screen (which you'll see in a minute).

Let's try a workaround and "switch off" the Microsoft LocalDB check.

The following will remove Microsoft SQL Server 2017 LocalDB from your computer and also stop Blue Prism checking for it:

With Blue Prism closed
Uninstall Microsoft SQL Server 2017 LocalDB from Add / Remove programs
Open your Windows registry
- Tip: See Microsoft Help Topic - How to open Registry Editor in Windows 10
Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Blue Prism Limited\Automate
Rename LocalDB to LocalDBold
- Tip: Right-click LocalDB and select Rename and click away to save your change.
After renaming the LocalDB Registry key, open Blue Prism

I'm now expecting you to be presented with the Login screen. However, we're in untested territory so if you get the error again, I'm also going to ask you to remove your LocalDB Connection from your configuration.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

StevenFeldman — Mon, 17 Aug 2020 17:20:00 GMT

Chris,

Looks like success.. Your suggestions seemed to work. Thank you

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

chris.strong — Mon, 17 Aug 2020 18:23:00 GMT

Hello Steven,

Excellent, that's more like it.

I can see from your screenshot that your Learning Edition license isn't yet Activated. You should have been guided through the License Activation by way if a step by step wizard.

Not to worry, simply select Not Activated within the Activation Status field. (It's within System > License)

Tip: As a part of the process, you'll be guided to our License Activation page on our website. This is normal and expected.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

StevenFeldman — Mon, 17 Aug 2020 18:34:00 GMT

Done... Thank you, Chris. It's now activated.

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

AmyLim-Applefor — Sun, 23 Aug 2020 13:46:00 GMT

Hi Chris, I am having similar problem with Steven Feldman and have followed your instructions re SQL etc but still unable to sign into Blue Prism with this error message:
Error: Could not connect to 'LocalDB Connection'.
Unable to determine whether database exists - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Error occurred during LocalDB instance startup: SQL Server process failed to start.
)

------------------------------
Amy Lim-Appleford
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

AmyLim-Applefor — Mon, 24 Aug 2020 00:03:00 GMT

Hi Chris,
I am still attempting to launch BP and here is my screen shot.

------------------------------
Amy Lim-Appleford
------------------------------

RE: Getting error msg when installing Blue Prism Trial and Learning Edition

chris.strong — Mon, 24 Aug 2020 07:47:00 GMT

Hello Amy,

Your error looks similar although, from your screenshot, seems to be occurring when Blue Prism is attempting to install Microsoft SQL Server LocalDB 2017. Things to consider, do you have full admin rights to your computer, what happens when you install the Microsoft application outside of Blue Prism etc.

I'll repeat my original reply to Steven:

Tip: See the comments on 11 October and 27 November 2019.

In Summary: We're seeing a Microsoft SQL Server LocalDB error, we're trying to determine whether that same issue appears without Blue Prism being involved, this will help troubleshoot.

------------------------------
Chris Strong
Product Manager
Blue Prism
------------------------------