Bulk update of repository connection profile in all Forms BP

asked on September 20, 2022

Hi,

Is there a way to update Save to Repository (Repo Profile) and Workflow Service Task with new server details in bulk for all Forms BP's?

Scenario is that I've more than 100 Forms BP which I would like to update repository profile (Server Name) in the Save To Repository Service task and Workflow Server name in the Workflow service task.

My understanding is that if I delete the current workflow server from the Forms Config and add a new workflow server, this will update all workflow service task with this new workflow server in Forms BP's. Is this correct?

Not sure how I can update the Save to Repo service task in bulk with new LF Server details. I'm thinking of adding a DNS entry for the old server resolving with the new server.

Any help or suggestions would be much appreciated.

TIA

0 0

replied on September 21, 2022

For Workflow Server, you can edit the name directly from the Forms Configuration site, you should not delete the Workflow Server then add a new one, as the workflow service task won't be updated automatically to use the new one(also you won't be able to delete one if there are workflow service tasks using it).

For Laserfiche Server profiles, you can update them in the database. The profiles are stored in the cf_bp_lfrepo_profiles table. You can back up the data in that table first then run query such as following(replace the {new server name} and {old server name} with the proper value).

  update [cf_bp_lfrepo_profiles] set server='{new server name}' where server='{old server name}'

1 0

replied on February 15, 2024

Are there any risks to this approach? I tested it and it works perfectly!

0 0

replied on February 15, 2024

Forms 11 Update 5 introduced system-level repository profiles so you only have to update it one place. Might look at upgrading.

2 0

replied on February 16, 2024 • Show version history

We actually started to do it that way, but with 500 forms, I would rather script it for now and do the manual update to a global profile later vs. having more downtime during the upgrade window. That works really well too and is a WAY overdue feature. Now if only there was a way to avoid updating all the workflow at once as well...

0 0

Question

Question

Bulk update of repository connection profile in all Forms BP

Replies

Sign in to reply to this post.