Question

Workflow Error 719 - Only 20 Collection or Table Fields Can Be Retrieved At One TIme

Workflow

Updated June 1, 2020

asked on May 29, 2020

Morning Folks - I'm running into a workflow error when I try to publish a workflow. I've been able to isolate the issue to when I retrieve my LF Form content through the Retrieve Business Process Variables. The form I'm retrieving from is pretty large, but I wouldn't say massive.

I get the following message code:

Any idea of potential workarounds? I'm on workflow designer version 10.2.0.216.

Thanks in advance!

1 0

Answer

SELECTED ANSWER

replied on May 29, 2020

Expanding on this, is the limit applying to the entire workflow, or just the activity?

The reason I ask is that you could always try using more than one Retrieve Business Process variables activity.

When dealing with larger forms, I typically break things up and only retrieve variables as-needed in the interest of efficiency.

For example, if selecting "Yes" on an option shows a table, then I'll have a conditional decision/sequence branch that checks if that value was "Yes" or "No"

If the value is "No" I just move on, if it was "Yes" I retrieve the variable inside that branch and do whatever I need to do with the values.

3 0

Replies

replied on May 29, 2020

Hi Doug-

The clue is in the top line of that error box "Only 20 collection or table fields can be retrieved at one time". If you have more tables/collections, you'll need to spread them out.

I've worked on a process that included 50 tables; I split it up into multiple workflows with each handling about a dozen of the tables. Then in Forms I called each WF in sequence. You could also daisy-chain them by invoking a new WF at the end of each one, or running them in parallel with multiple invokes.

I'm not positive, but having the fields on multiple forms may confuse this. For example, if you're only trying to pull 10 tables but they appear on 3 separate forms, WF may view those as 30 table fields. As a workaround you can clear them all out and then, when adding, be sure you have only 1 form selected. But it can goof up if you have to add more fields in the future.

2 0

SELECTED ANSWER

replied on May 29, 2020

Expanding on this, is the limit applying to the entire workflow, or just the activity?

The reason I ask is that you could always try using more than one Retrieve Business Process variables activity.

When dealing with larger forms, I typically break things up and only retrieve variables as-needed in the interest of efficiency.

For example, if selecting "Yes" on an option shows a table, then I'll have a conditional decision/sequence branch that checks if that value was "Yes" or "No"

If the value is "No" I just move on, if it was "Yes" I retrieve the variable inside that branch and do whatever I need to do with the values.

3 0

replied on June 1, 2020

Thanks - this worked. Now getting a 'call to Laserfiche Workflow API was not successful.' when i try to submit the form! This form is testing my patience!

0 0

You are not allowed to follow up in this post.

Question

Question

Workflow Error 719 - Only 20 Collection or Table Fields Can Be Retrieved At One TIme

Answer

Replies

Sign in to reply to this post.