learning license expired and installed new version but lost all my old process and objects

[hanuman_gorana]

Hi team,

My learning edition got expired today so i downloaded new version of learning edition and installed on my local machine, but after installing with new learning  licensing key, my all the old process and objects are all lost.

Can you please help me restore my old process and objects on my blue prism as i had not created any release packages for backup.

[SouravSaha · Accepted solution]

Hi @hanuman_gorana,

Your old processes and objects should be recoverable unless any changes or deletions were made directly in the database. If you only worked within Blue Prism and didn’t modify the database, there’s a 99% chance everything can be restored.

Could you please confirm whether you made any changes to the database? Once I have your confirmation, I’ll proceed with the next steps.

[hanuman_gorana]

Hi Saurav,

Thank you for replying me.

I have not made any modification or  changes in the database of blue prism.

Could you please help in restoring my all the old process and objects which I had worked upon asap, I need work on them.

Thank you for your assistance.

Hanuman Gorana 

[SouravSaha]

Hi @hanuman_gorana,

Please follow the steps below to retrieve your old data-

Step 1: Open SQL Server Management Studio (SSMS)

1. Launch SQL Server Management Studio on your machine or server.
2. Connect to the SQL Server instance.

Step 2: Identify the Blue Prism Database

1. Right click on the Server -> New Query
2. Paste the following query and execute - SELECT name FROM sys.databases;
3. Look for results with names like: BluePrism, BluePrismDB, BP_Prod, BP_Test, etc. If you find something like this, that is your Blue Prism database name. Note it down somewhere.

Step 3: Configure Blue Prism Connection

1. Open Blue Prism → System tab → System > Connections
2. Click New Connection- Connection Name: Anything like “Production Database” or “Old Database”.
- Connection Type: SQL Server
- Server Name: Your SQL Server instance name (same as SSMS connection).
- Database Name: The database name you found in Step 2.
- Authentication Mode: Windows Authentication (if your account has access).

3. Test Connection → Should show Success.
4. Click OK.

Step 4: Login to Blue Prism

1. Use your old Blue Prism credentials (since users are also stored in DB).
2. Upon login, you should see all your old processes and objects.

[hanuman_gorana]

Hi Sourav,

Thank you for your reply and providing step by step solution but I was not able to connect to SQL Server, I need your help in restoring the old data, 

Could you please let me know if you can we available on zoom call today, it will be really helpful.

Thank you for your assistance once again.

Regards,

Hanuman

[Tejaskumar_Darji]

Hi Hanuman, you need to find a way to connect to SQL server to get the data. Please explore and connect to SQL server. You can use SQL Server Management Studio SSMS for the same. Once done let us know what is error you are facing. Please share snaps if possible so that we can help you better.

[hanuman_gorana]

Hi Tejas,

Thank you for your reply.

Please find the snapshots of SSMS and my blueprism data connection configuration, even the current BluePrism database is not visible in SSMS.

Coud you please help me on this, do we need to create a new database and work on it to restore my old process and objects, can we please connect on zoom to resolve this issue.

Thank you for your assistance.

Regards,

Hanuman

[Tejaskumar_Darji]

Not inside the system database collapse it and you should see like this.

[Tejaskumar_Darji]

And as you have previous connection details already, could you please create a new connection in BP with the same exact details? That should also work, and it will be an easy option.

It will use same credentials as earlier. Try this first

[hanuman_gorana]

Hi Tejas,

I tried to create new connection in BP but its saying if you create new connection with same/old database name it will overwrite with new database and also getting the below error message