Is there a way to update an Environmental Variable in Blue Prism?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-11-20 09:00 AM
Background Info
I have a process that searches for data between two environmental variables StartDate and an EndDate (dd/mm/yyyy). The process can either find data (which results in a successful run) or not (which results in a unsuccessful run).
Simulation
Let's say we use StartDate = 02/11/2020 and EndDate = 06/11/2020. Data has been found so we can say that the process ran successfully on 07/11/2020.
When I want to run the process a second time, I want it to start from the last successful run instead of manually updating the environmental variable.
Unsuccessful runs are being catched.
Question Is there a way to store the last successful run into the environmental variable StartDate ?
--------------------------------------------------Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here Stackoverflow Post, posted by elbo.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-11-20 02:50 PM
- You could persist the end date value to a work queue and the next time the process runs read it from the queue instead of the environment variable.
- Similar to the above you could persist to a file.
- You could write the value to the BP database table responsible for handling environment variables: BPAEnvironmentVar. You must exercise extreme caution with this though as any errors/mis-writes could impact other processes.
- You could develop a VBO that automates the BP client to open it and update the environment variable value through the UI itself.
Cheers,
------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-11-20 03:00 PM
I'm not sure why that command isn't listed in the help docs though.
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-11-20 05:38 PM
Cheers,
------------------------------
Eric Wilson
Director, Partner Integrations for Digital Exchange
Blue Prism
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
13-11-20 05:39 PM
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-08-22 08:07 PM
------------------------------
Bhagavath Singh
Platform Engineer
Johnson and Johnson
Asia/Kolkata
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-08-22 10:01 PM
I've tested on v7.1 with a environment variable of type Date and I was able to successfully set the value using AutomateC. However, what I noticed is the updated value wasn't reflected in the Interactive Client UI until I exited and logged back in. For Date, pay attention to the format I used below. That's the only way I could get it accept it:
** EDIT **
DateTime also works in the following format:
C:\Program Files\Blue Prism Limited\Blue Prism Automate>automatec /user admin [PASSWORD] /setev Test1 DateTime "2022-08-24 12:54:31" Test
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-08-22 03:51 PM
Try to do it directly if it is possible. Login into the database which you use or the BP server uses (Look for VBO and set it up e.g. with Data – SQL Server / or similar C# code etc.). After you get the access to your BP database:
Execute
UPDATE [YOUR_BP_DBname].[dbo].[BPAEnvironmentVar]
SET value='YourNewValue'
WHERE name='NameOfYourEnviromentalVar'
------------------------------
Frantisek Hortai
Senior Consultant
EY - Ernst & Young
Europe/Vienna
------------------------------
