topic RE: Update Environment Variable by updating BP database in Product Forum

Update Environment Variable by updating BP database

mary_angeliquea — Thu, 23 Feb 2023 11:07:00 GMT

Hi,

I am trying to find a way to update an environment variable other than using the BP GUI. I can make the CLI /setev method work but if the value of the variable contains numerous lines and characters requiring escape, it fails. I read that the update can be made directly using the Data - SQL Server VBO but I think it's only applicable if the connection is based off SQL server. We are currently using the Blue Prism server ( https://bpdocs.blueprism.com/bp-6-9/en-us/helpConnections.htm?tocpath=Interface%7CAdvanced%20options%7C_____3 )so I could not identify and not really sure which database I should be updating. In my current configuration, I can only see the Server Name, Connection Mode, Port, etc. Hoping to get some answers here..

------------------------------
mary angelique acuna
------------------------------

RE: Update Environment Variable by updating BP database

Tejaskumar_Darji — Thu, 23 Feb 2023 17:27:00 GMT

It would not be a good approach to touch and update the BluePrism DB directly to change EVs.

I would suggest using an alternative approach such as the use of Configuration Files. Config files are really helpful when you expect values to be updated with the passage of time.

Check out this #BPTechTips on the same if that helps.

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

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------

RE: Update Environment Variable by updating BP database

Tejaskumar_Darji — Thu, 23 Feb 2023 17:36:00 GMT

And the table name of the Environment Variable is "BPAEnvironmentVar" within the Blue Prism SQL database.

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

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------