topic Re: RE: Blue Prism Archiver Setup in Digital Exchange

Blue Prism Archiver Setup

David-Dinh — Thu, 06 Jul 2023 19:03:00 GMT

Blue Prism Archiver is a DX asset created to move WQI and Logs out of a BP database into an Archive DB. The asset will be released in August. This discussion was created for support related questions as the asset is not formally supported by BP. Support will be provided by the original author and BP communities unless notice is provided otherwise.

------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------

RE: Blue Prism Archiver Setup

Tejaskumar_Darji — Fri, 07 Jul 2023 10:50:00 GMT

Ideally, this should be added in the System settings itself because everyone would need this at some point.

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/
Technical Lead
------------------------------

RE: Blue Prism Archiver Setup

Neel1 — Fri, 07 Jul 2023 18:32:00 GMT

will be curious to know more about this tool and how this works .

------------------------------
Neeraj Kumar
------------------------------

RE: Blue Prism Archiver Setup

Mukeshh_k — Mon, 10 Jul 2023 10:39:00 GMT

Thanks for sharing this David, looking forward to it - we have struggled with archiving activities in the past and during migrations as well, I'd be highly interested in testing this DX asset out.

------------------------------
Kindly up vote this as "Best Answer" if it adds value or resolves your query in anyway possible, happy to help.

Regards,

Mukesh Kumar - Senior Automation Developer

NHS, England, United Kingdom, GB
------------------------------

RE: Blue Prism Archiver Setup

David-Dinh — Tue, 11 Jul 2023 12:45:00 GMT

I am providing a preview of the asset if anyone is interested. Please try it out and provide feedback for the final release.

------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------

RE: Blue Prism Archiver Setup

David-Dinh — Tue, 08 Aug 2023 21:00:00 GMT

There is a new version on the DX.

------------------------------
David Dinh
Software Support Engineer
Blue Prism
America/Chicago
------------------------------

RE: Blue Prism Archiver Setup

siriPolam — Tue, 10 Oct 2023 16:42:00 GMT

Hi David,

I am currently working on archiving of BP queue data. I have gone through your approach. I have couple of questions to start with. So, we have our BP production database on a different SQL server which is connected to BP IC server. So according to BP archiver method, we have to create a new archiver db in the sql server and run the scripts to create virtual db's. correct me if i am wrong.

------------------------------
siri Polam
------------------------------

Re: Blue Prism Archiver Setup

herbert.asor.tnb — Mon, 20 Jan 2025 10:23:10 GMT

has anyone successfully implemented this already? I'm considering implementing this in our system.

Re: Blue Prism Archiver Setup

johny.jain — Mon, 28 Apr 2025 06:16:47 GMT

Hi @David-Dinh We had successfully implemented the Database Archiver solution in Dev and Qual. In Production we are getting an error Exception : The INSERT statement conflicted with the FOREIGN KEY constraint "FK_BPAWorkQueueItemTag_BPATag". The conflict occurred in database "BP_ARCHIVES_PROD", table "dbo.BPATag", column 'id'. " . Could you please suggest how we can resolve this issue?

Re: RE: Blue Prism Archiver Setup

David-Dinh — Tue, 29 Apr 2025 13:52:51 GMT

Hi Neel, Here is a video of a demo.

https://youtu.be/SM00uRdp-bs

Re: RE: Blue Prism Archiver Setup

David-Dinh — Tue, 29 Apr 2025 13:53:53 GMT

Please dont use this version. There are performace efficiency issues. Use the lastest version.

Re: RE: Blue Prism Archiver Setup

David-Dinh — Tue, 29 Apr 2025 13:56:23 GMT

The DX is having issues, and I can not upload the latest version. Please email me for the latest version for the time being. David.dinh@sscinc.com

Re: RE: Blue Prism Archiver Setup

David-Dinh — Tue, 29 Apr 2025 13:58:21 GMT

The DX is having issues, and I can not upload the latest version. Please email me for the latest version for the time being. David.dinh@sscinc.com or create a support ticket and note to assign to David Dinh.

Re: RE: Blue Prism Archiver Setup

David-Dinh — Tue, 29 Apr 2025 14:00:18 GMT

Correct, the Archive database is its own database. You need to use the IC to create a BP database first, then run the 100 script to modify the schema. If you need help setting this up, please send me an email or open a support ticket and I will schedule a meeting.

Also, the DX is having issues, and I cannot upload the latest version. Please email me for the latest version for the time being. David.dinh@sscinc.com or create a support ticket and note to assign to David Dinh.

Re: Blue Prism Archiver Setup

David-Dinh — Tue, 29 Apr 2025 14:01:40 GMT

We have several large clients using this. Please open a support ticket if you wish to see a demo.

Here is a video link. https://youtu.be/SM00uRdp-bs

Re: Blue Prism Archiver Setup

David-Dinh — Tue, 29 Apr 2025 14:03:19 GMT

Hello, My apologies, but you may be using an older version. Can you send me an email, and I will get you the latest one. The DX is having an issue updating assets. David.Dinh@sscinc.com

Thanks

David

Re: Blue Prism Archiver Setup

upalpatel22 — Thu, 04 Jun 2026 21:11:54 GMT

Hi Team,

We are currently implementing BP Archiver PLUS in our Blue Prism 7.1.1 environment and have encountered an issue while connecting to the Archive Database through the Blue Prism Interactive Client.

We would appreciate any guidance or recommendations from anyone who has worked with a similar architecture.

Environment Details

Blue Prism Version: 7.1.1
Production SQL Server: P1RPABPDB
Production Database: BluePrism DB_Prod
Archive SQL Server: P1RPABPDB03
Archive Database: BP_ARCHIVES
Linked Server Name: P1RPABPDB

Configuration:
- The Archive database is connected to the Production database through a SQL Linked Server.
- Production and Archive databases are hosted on separate SQL Servers.
- BP Archiver scripts were modified to reference the Production database via the linked server.

Activities Completed

1. Created a fresh BP_ARCHIVES database using the Blue Prism Interactive Client.
2. Updated the Archiver scripts to reference the Production database through the linked server:
[P1RPABPDB].[BluePrism DB_Prod]

3. Successfully executed:
- ARCH_100
- ARCH_110
- ARCH_120

4. Verified linked server connectivity from the Archive SQL Server to the Production SQL Server.
5. Confirmed that the Archive login can read Production tables through the linked server.
6. Validated Archive database synonyms, local tables, and views using SQL queries.
7. All SQL read tests completed successfully from SSMS.

Current Issue

When attempting to connect to BP_ARCHIVES using the Blue Prism Interactive Client, the following error is displayed:

"Could not read from database. Please check you have permission to read from the database or edit the connection setting."

Event Viewer Error

The Event Viewer logs show the following SQL error:

SQL Error 7420
"Remote access is not supported for transaction isolation level SNAPSHOT."

Queries Referenced in the Error Logs:

1. BPADataTracker
2. BPAActiveDirectoryDomains

Both objects are configured as synonyms within BP_ARCHIVES and point back to the Production database through the linked server.

Troubleshooting Performed

- Tested with elevated SQL permissions, including db_owner and sysadmin but the issue persists regardless of permissions.
- Based on our findings, this does not appear to be a permissions issue. It seems more likely that the Blue Prism Interactive Client is attempting to use SNAPSHOT isolation, which is not supported when accessing remote objects through SQL Linked Server synonyms.

Questions

1. Is BP Archiver PLUS Archive Interactive Client access is supported when Production and Archive databases are hosted on different SQL Servers and connected through a SQL Linked Server?

2. Has anyone encountered SQL Error 7420 in a BP_ARCHIVES environment where synonyms reference a remote Production database through a linked server?

3. Is there a recommended workaround or best practice for enabling Archive Interactive Client access in this architecture?

Any insights, recommendations, or confirmation of supported architecture would be greatly appreciated.

Thank you for your time and assistance.