Bug of Limits in Databases

Bug reports
1

Hey

I’m having a problem using Limits in Databases.

i’m doing a process of enabling a database and loading only a part of it based on a Runtime Database

looks like it is ignoring My limit by loading everything

Here is my exemple. you can see that my DB is loading much more than the limit that i mentionned ( 300 )

Any idea of what is happening ?

image
image1257×384 59.6 KB

Updates : seems like it’s a parralel Block Problem

it is different with or without it

Those 4 databases depends on the objects in my Item Variant (Inventory Linked )
image

i thought that it can be nice to launch them at the same time to trigger only one fomula calculation on my item variant. look like it breaks it :confused:

2

Hi Yassine,

Is it working as expected when you run the action in sequential order rather than in parallel?

If the issue persists, could you provide more context about the setup, such as the entire action and dependencies between the data sources?

-Isabel

3

Yes it works as expected when it is sequential block ( no issue on that side )

to put a bit the context : here is what i have

  • Inventory ( in a runtime property )
  • i read all the items related to my inventory in a runtime property using aggregate ( much faster since it is a high number
  • a table “item” that is initially set limit to 300 ( this table will be used for pagination. so each time we change a page , we define limit with a app variable and skip that number for each page , for exemple in page 2 , limit will be 300 and skip will be 300 so we can display the next 300 items)
  • We have 3 tables wich are the same table (Inventory Items). the only difference is displaying different origine of the dame ( adjustment , scan and stock). all has the same rule ( item exist in our pagination table item )
  • another last table “Inventory Adjustment” that also depends by the items that exist in my pagination table “item”

since the 3 tables does not depend on each other, i thought about setting them at the same time ( using parrallel block ) and then do some calculation in “item” for additionnal info (sums and stuff like this )

it works good when it is sequential and that’s what we are doing right now.

Also another problem is happening to me when calculating our additionnal info

image
image1159×303 25.1 KB

it is very random. it’s like appfarm wasn’t waiting for the data to be loaded to do the calculation.

hope this helps

Best regards :smiley:

4

Found a workaround :

Just disabling and enabling the main database fixes everything.