BPA Workflow - result set exceeds row limit for the Query Collection

Hi,

You will encounter the specified error message if the read query exceeds the Row or Character limit.
Here we configured query collection row limit as 10000 and query collection char limit as 2097152 (2GB).

Workaround to reduce row limit
1) Add Parameters
2) Define Filters

Workaround to reduce column limit
1) Use $select

You can learn more about $select by referring to the following resource.

IFS API - Technical Documentation For IFS Cloud

Thank you.

Dinelka

Thanks @dinelka. I just checked and there are 4908 rows fetched in the Collection. So probably I’ll just use $select to specify just the columns I need for my calculation. Thanks a lot!

@dinelka it seems I hit another limitation. I can’t use Parameters and Filter at the same time.

I would need the filter so I don’t go above 10000 rows and I also need the $select Parameter to not go above the char limit as 2097152 (2GB).

Anyways, to me it seems strange that less than 5000 rows will have more than 2 GB and exceed the char limit. Isn’t it?

This is a validation from workflow side. 

Option 1:

If possible, you can try with an option of breaking the “Get count Results” API task into multiple tasks using filters and then join the collection into a single collection inside the workflow using a script task

var ArrayList = Java.type('java.util.ArrayList');
var list = new ArrayList();
list .addAll(Reference_CountingReportLine_Set2);
list .addAll(Reference_CountingReportLine_Set2);
execution.setVariable("YearCountingReportLine", list )

as a downside you wont be able to use $select here due to the above validation

option 2:

Since you are interested with year of the data, you could try to create a custom attribute to the CountingReportLine entity where you extract the year from the LastCountDate attribute. 

Then that attribute is available inside workflow as a new attribute. you can use that to use filtering of data and also use $select  

reference: 020 add edit readonly attribute - Technical Documentation For IFS Cloud