topic RE: An error occurred whilst configuring Blue Prism localdb. in Product Forum

An error occurred whilst configuring Blue Prism localdb.

SureshRajendran — Fri, 03 Jan 2020 06:03:00 GMT

Please help me to resolve the below issue.

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 AutomateUI.BPApplication.Start(String[] args)

------------------------------
Suresh R
Senior Process Associate
Tata Consultancy Services
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

UdayNimmala23 — Fri, 03 Jan 2020 06:21:00 GMT

Hey Suresh Gone through the issue.

Could you please provide more information when exactly you encountered this error while creating database or getting connected to the existing database. please provide the information to give you resolution.

Regards,
Uday Nimmala

------------------------------
Uday Teja
Consultant
Capgemini
Asia/Kolkata
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

SureshRajendran — Fri, 03 Jan 2020 06:31:00 GMT

Hi Uday,

At the time of BluePrism installation.

------------------------------
Senior Process Associate
Tata Consultancy Services
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

NunoSilva — Sat, 04 Jan 2020 12:55:00 GMT

Hello all,

I have that issue when configured my first local and made something different and I will share with you:

Open SQLMS like administrator and go to the instance what you want to create database;
Go to Database on navigation tree and create a DB with same name as you want to create on BluePrism installation;
after DB created, go to Security on Navigation Tree and on username that will work with BluePrism, make that DB as DefaultDB for user;
After attributed dB to the user, open BluePrism installation and now you can create DB with drop existing other.

good luck

------------------------------
Nuno Silva
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

chris.strong — Tue, 07 Jan 2020 12:04:00 GMT

Hello Suresh,

Question: Have you previously had Blue Prism setup and running on this computer?

Rationale for asking: This error has been reported a few times and up to now we've been unable to replicate to prevent it happening. It seems to occur when someone setups up Blue Prism Trial or Learning Edition, then removes some of it and attempts to install it again. The reason for my question is to understand whether you have received the error is a similar way to other people or there is something else causing the issue.

To resolve the issue, the following steps seems to have resolved for other people:

To completely remove Blue Prism from your system:

We've included steps at the back of the Getting Started Guide - Blue Prism Trial and Learning Edition guide.

As its previously worked, I suspect when you clear down and reinstall, everything should work again. I suspect that Microsoft SQL Server 2017 LocalDB thinks the Blue Prism instance and database is still there, but you have removed them from the file system.

It would be good for the community if you let us know how you get on. This will help the next person who sees this error.

Tip: Another thread where I have mentioned the same resolution – Issue installing Microsoft LocalDB with Blue Prism Trial and / or Learning Edition

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

RE: An error occurred whilst configuring Blue Prism localdb.

NeyaraRadwan — Fri, 31 Jul 2020 10:35:00 GMT

Hello Chris

I m facing the same problem.
I did as you suggested. I removed the blue prism then installed it again. The same message appeared. I searched on the internet to understand why this problem happened.
To solve that issue, I need to create an administrator password but this screen no longer appears to me. It appeared only once when I was uploading the software for the first time.

I appreciate someone to suggest the solution

Regards
Neyara

------------------------------
Neyara Radwan
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

NeyaraRadwan — Fri, 31 Jul 2020 10:39:00 GMT

Hello Silva

I appreciate to guide me (by details ) to solve that problem

Thanks,
Neyara

------------------------------
Neyara Radwan
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

chris.strong — Fri, 31 Jul 2020 15:20:00 GMT

Hello Neyara

It doesn't sound like the you have completely stripped Blue Prism and supported database from your computer. If you had, you would have been presented with the option to enter a password for your Blue Prism admin user account.

We do not prompt for the creation of a admin password, of there is already a database in place. So, I suspect you'd see the steps to strip back the database files too. (See Page 6 of the guide)

I'll repeat the advice earlier for you to double check:

To completely remove Blue Prism from your system:

We've included steps at the back of the Getting Started Guide - Blue Prism Trial and Learning Edition guide.

When you reinstall, make sure you are installing as a user with admin rights. If that doesn't work, Nuno has provided different suggestions above.

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

RE: An error occurred whilst configuring Blue Prism localdb.

AlanHargrove — Wed, 26 Aug 2020 00:03:00 GMT

I am also experiencing this error on my first attempt to install Learning Edition, and again on my 2nd attempt after following the uninstall steps described above, from the Getting Started Guide - Blue Prism Trial and Learning Edition. I assume the complete uninstall was successful because I did get the first-time login screen with the option to enter a password for the Blue Prism admin user account. I am not able to follow steps provided by Nuno above because I am not a technical user. I am lost at the first step regarding SQLMS.. don't know what that is, whether it's on my laptop, nor do I know how to administer databases using that tool.

Thanks for any assistance,
James

I'm running 64-bit Win 10 on a Lenovo T470s. My local user account has admin rights to install software.

Here is a screenshot of the error:

------------------------------
Alan Hargrove
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

AlanHargrove — Thu, 27 Aug 2020 16:51:00 GMT

Even though I tried re-downloading the install file several times, for some reason when I re-downloaded the install file today, I was able to successfully install the Learning Edition and activate the license.

Regarding the uninstall instructions in the Getting Started Guide, I was not able to "run the following commands to stop and remove the local database instance" because I don't have any sub-directory "sqllocaldb" under the Binn directory. Even after successful install, I don't have the sqllocaldb folder, I just see sqllocaldb.exe. See inserted image of my folders. I only have a Resource sub folder and sqllocaldb.exe.

I could not do these two uninstall steps from the Getting Started guide:

• "C:\Program Files\Microsoft SQL Server\140\Tools\Binn\sqllocaldb" stop blueprismlocaldb
• "C:\Program Files\Microsoft SQL Server\140\Tools\Binn\sqllocaldb" delete blueprismlocaldb

------------------------------
Alan Hargrove
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

chris.strong — Fri, 28 Aug 2020 06:09:00 GMT

Hello Alan,

Thank you for sharing, it's good to hear you're up and running.

On the face of it, it's extremely unlikely that re-download would have been the resolution. If we'd have had a bad download, which is always possible, then the whole file would have been corrupted and we wouldn't have been able to run it. However, maybe downloading to a different location may have given slightly different permissions / behaviour.

Re: I could not do these two uninstall steps from the Getting Started guide

My first thought was, "Yes, you're right. Why we've done that and how's it been like that for a year without anyone noticing?"
But, the 2 lines are intended to be ran (copied or retyped) into the Windows Command Line / Prompt.
I knew you were right with the SqlLocalDB.exe file being in the Binn directory.
So, I double checked, and the way Windows Command Prompt works is it knew that last part of the path was the executable (.exe application). I've included a screenshot below, we could also put the .exe into the path too.
- Really appreciate the feedback there, I'll mention to our Technical Author team who do a great job in providing content and see if we should change it to include the .exe in the path.

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

RE: An error occurred whilst configuring Blue Prism localdb.

chris.strong — Tue, 01 Sep 2020 15:58:00 GMT

Hello Alan,

A final note to add that our Technical Authors have approved and published the change to the uninstall steps to include the .exe part to help prevent future confusion.

Again, thank you for sharing your thoughts.

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

RE: An error occurred whilst configuring Blue Prism localdb.

MartinCabrera — Mon, 28 Dec 2020 16:53:00 GMT

Chris,

I came across the same error

"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)

I had BluePrism installed, this error appeared so I uninstalled it following the guide, everything moved ok while uninstalling but once I installed it again the same error appeared.

Can you let me know what may be happening?

Thanks,

------------------------------
Martin Cabrera
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

MartinCabrera — Wed, 30 Dec 2020 22:58:00 GMT

I solved the issue myself.
The local db was not creating so had to go with:
C:\Program Files\Microsoft SQL Server\140\Tools\Binn\sqllocaldb create blueprismlocaldb
and then
C:\Program Files\Microsoft SQL Server\140\Tools\Binn\sqllocaldb start blueprismlocaldb

The issue I have now is before opening the program I have to go to the CMD and start the blueprismlocaldb with the last commend above. Cannot find how to leave it fix to be kept running while the computer is on, and to start everytime I turn on the PC. Will dig around the community see if I can find the solution

------------------------------
Martin Cabrera
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

MathuSridhar — Wed, 27 Oct 2021 13:01:00 GMT

Hello Chris,
Thanks for sharing your ideas and troubleshooting steps. I am facing the same issue (highlighted in 1st message by Suresh).
The Learning edition was working fine, until my Operating system is upgraded from Win10 (Home) to Windows 11 Home 64-bit (10.0, Build 22000). Is it compatible with Windows 11? I tried re-installing as per the instructions provided in uninstalling manual. However, I am getting an error message (highlighted in 9th message by Alan) and was not able to install & launch the application.

Your insights are much appreciated.

-----------------------------
Mathu Sridhar
Techno Functional Analyst
-----------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

MickaelGameiro — Sun, 05 Dec 2021 19:53:00 GMT

I remember 2 years ago when first got this issue. Solved back then because I was working with IT guys... It's incredible that It stills happens for a simple learning software. It should not be so technical in my opinion.

The error that I get after creating user and password with admin as user is the same as the others:

BluePrism.AutomateAppCore.LocalDatabaseInstaller.get_a()
em BluePrism.AutomateAppCore.LocalDatabaseInstaller.get_DatabaseExists()
em BluePrism.AutomateAppCore.LocalDatabaseInstaller.FullInstall(String username, SafeString password)
em AutomateUI.WelcomeWizard.j(Object sender, DoWorkEventArgs e)

So in order to solve this we need to install SQLMS and do the steps that Nuno suggested. Not very straight forward but I'll try.

------------------------------
Mickael Gameiro
BNP Paribas
BNP Paribas
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

VEERA_GOWTHAM_K — Thu, 29 Sep 2022 00:36:00 GMT

Hello Mr. Martin Cabrera

also facing the same problem from a week I go with all the possibilities but I not able to solve this problem , And I also try with the solution that you given above but I not able to solve this problem .I actually facing the problem is that ,UNABLE TO START THE DATABASE . In this I'm can creating database but not able to start that database, just have a look below I pasted the error while I'm trying to start localdb

This is the error that I got , can you help me with this

-------------------
Gowtham Kumar
-------------------

------------------------------
VEERA GOWTHAM KUMAR NANDIKOLLA
------------------------------

RE: An error occurred whilst configuring Blue Prism localdb.

Sasank — Mon, 17 Oct 2022 13:34:00 GMT

Just after I set Admin Credentials. I get following error
There was no previous of instance of sql present and MS Sql 2017 localDB is installed in pc
I have created db using above instructions in link

------------------------------
Sasank Sai Mekala
Developer
Tata Consultancy Services
Asia/Kolkata
------------------------------

Re: An error occurred whilst configuring Blue Prism localdb.

nicknivro — Thu, 23 May 2024 18:45:40 GMT

Hi everyone,

I recently encountered the same issue and I figured that the reason for this issue is that my antivirus software interrupted BluePrism and added it to quarantine as it considered it malware

This led to the corruption of the SQL LocalDB database (BluePrismLocalDb) during creation.

Here’s the step-by-step process I followed to resolve it:

If the following commands dont work for you try to open Command Prompt (CMD) as an Administrator

1) Navigate to the path where SqlLocalDB.exe is located.

In my case, the command was:
cd "C:\Program Files\Microsoft SQL Server\140\Tools\Binn"

2) Get Information About LocalDB Instances:

Run the following command to list all LocalDB instances:
SqlLocalDB.exe info

Identify the corrupted database instance from the list and make sure that BluePrismLocalDb is listed

3) Delete the Corrupted LocalDB Instance:

.\SqlLocalDB.exe delete BluePrismLocalDb

4) Exclude BluePrism from Antivirus Scans:

Before running BluePrism again, ensure you exclude the BluePrism application from your antivirus software to prevent future corruption.

This approach resolved the issue for me, and I hope it helps others facing the same problem. If you have any questions or need further assistance, feel free to ask!

Best regards,

Nick