Trials

Expand all | Collapse all

Getting error msg when installing Blue Prism Trial and Learning Edition

  • 1.  Getting error msg when installing Blue Prism Trial and Learning Edition

    Posted 08-11-2020 15:58
    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
    ------------------------------


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

    Posted 08-14-2020 04:45

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



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

    Posted 08-14-2020 10:56
    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?

    image.png

    --
    Steve Feldman
    +1 908 672-5584 (mobile)





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

    Posted 08-14-2020 15:24
    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
    ------------------------------



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

    Posted 08-15-2020 03:03

    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.

    Blue Prism Sign in screenshot


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



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

    Posted 08-15-2020 07:46
    Chris,

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

    image.png
    Then, after about 10 seconds or so:
    image.png
    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.

    image.png

    image.png
    --
    Steve Feldman
    +1 908 672-5584 (mobile)





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

    Posted 08-17-2020 03:34

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



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

    Posted 08-17-2020 07:37
    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
    "Delivering Value & Vision through Customer Experience Solutions"





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

    Posted 08-17-2020 12:06
    Edited by Chris Strong 08-17-2020 12:09

    Hello Steven,

     

    Oh no, sorry I misunderstood your post.

     

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

    1. Microsoft SQL Server 2017 LocalDB is not working on your computer (we keep seeing error messages when attempting to connect to it)
    2. You have installed Microsoft SQL Server Express (I don't know which version, but that shouldn't matter here)
    3. You have created a new Blue Prism database:
      • Database Server: localhost\SQLExpress
      • Database Name: BluePrism
    4. You have added a Connection to the Blue Prism application and called it BPConnection
    5. 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:

    1. You should now be able to open Blue Prism and be presented with Sign in to Blue Prism (I've created a screenshot below)
    2. Based on your screenshot, I expect you to have a drop down listing LocalDB Connection and BPConnection
    3. If you select BPConnection (the one you manually created), by default, the username will be admin and the password will be admin
    4. 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)
    5. 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.


    Blue Prism Sign in screen screenshot


    Reset Password screenshot

    Activate Blue Prism screenshot

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



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

    Posted 08-17-2020 12:13
    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:

    image.png
    Then, after about 10 seconds or so:
    image.png
    So, I never get a screen that allows me to log in and complete the remaining tasks.






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

    Posted 08-17-2020 12:34

    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:

     

    1. With Blue Prism closed
    2. Uninstall Microsoft SQL Server 2017 LocalDB from Add / Remove programs
    3. Open your Windows registry
    4. Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Blue Prism Limited\Automate
    5. Rename LocalDB to LocalDBold
      • Tip: Right-click LocalDB and select Rename and click away to save your change.
    6. 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. 

    Microsoft SQL Server 2017 LocalDB in Add Remove Programs screenshot



    Rename Registry Key screenshot





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



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

    Posted 08-17-2020 13:20
    Chris,

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

    image.png






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

    Posted 08-17-2020 14:23

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



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

    Posted 08-17-2020 14:34
    Done... Thank you, Chris. It's now activated.

    image.png






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

    Posted 27 days ago
    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
    ------------------------------



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

    Posted 26 days ago
    Hi Chris,
    I am still attempting to launch BP and here is my screen shot.
    Error message


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



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

    Posted 26 days ago

    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:

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