You are viewing limited content. For full access, please sign in.

Question

Question

How do i set a concurrence limit for Workflow instances ?

Workflow Administration Import Agent
Updated July 10, 2019
asked on July 4, 2019

Greetings.

I'm working on a set of WF's/BPM's for a massive indexation of LF entries based in Database Queries. 

I created a folder for each document template to use with its own WF/BPM for entry indexation.

When i move +600 files to any of these folders. WF server creates a new instance of the corresponding workflow, and each instance creates it's own database connection to Database, when the limit of concurrents connections to database is exceeded, all workflows starts to fail.

This issue makes me think if exist a way to limit the number of concurrent workflow execution. 
Is there a workaround to this issue?

i'll be attentive to your feedback.

 



 

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on July 5, 2019

Hi Marcos,

By default, Workflow runs database activities in separate external processes. I recall that each opens its own DB connection. Try unchecking that option so Workflow runs the database activities in-process. Note that changing this setting may cause Workflow to use more server resources.

https://www.laserfiche.com/support/webhelp/Laserfiche/10/en-US/administration/#../Subsystems/LFWorkflow/Content/Resources/Admin%20Console/Advanced%20Server%20Options%20Activity%20Performance.htm

1 0
replied on July 8, 2019

Hi Samuel.

Thanks a lot for you reply. I'm gonna try this solution. I'll feedback the result later.

 

1 0
replied on July 10, 2019

Greetings Samuel.

Your recommendation works perfectly!

We tried your solution with 1k and it works, then we tried +6k and still works.

Thanks!

0 0
replied on July 10, 2019

Great to hear! Thanks for the update.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...