Blue Prism Archiver Setup

[David-Dinh]

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

[David-Dinh]

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

[David-Dinh]

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

[David-Dinh]

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.

[David-Dinh]

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.

[David-Dinh]

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

[David-Dinh]

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

[upalpatel22]

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.