working with pull with list in 3D objects

Question

question

pc neo asked Feb 6, '20 pc neo commented Feb 8, '20

working with pull with list in 3D objects

sample-query-listorderby.fsmIn the attached model, I needed to first populate many flowitems into a list then have a 3D object to pull a flowitem with the lowest value for label START_LOC_SEQ from list. But I am not able to achieve it.

description of the model

a) 2 sources are used to populate 2 racks with 100 flowitems each. These flowitems are pushed into list through "send to port -> use list". RackA set its flowitems to have label START_LOC_SEQ to be 2, RackB to be 1. All flowitems has label CAS_STATUS to be "EMPTY".

b) A queue is configured to pull a flowitem from the list using query "

WHERE CAS_STATUS = "EMPTY" order by START_LOC_SEQ ASC"

c) It is observed that sequence of population of flowitems into list is first RackA followed by RackB.

Result: I expect that queue will get a flowitem from rackB base on the query, but it gets a flowitem from rackA instead. So, I reason that in the midst that the list is being populated, 100 flowitems from each rack, the queue pull "successfully" a flowitem which is from rackA.

d) Set the query in the queue to be "WHERE CAS_STATUS = "DUMMY" order by START_LOC_SEQ ASC" which will not be able to match any flowitem in the list while it gets populated.

e) At a later time (1 sec) the query is change to "WHERE CAS_STATUS = "EMPTY" order by START_LOC_SEQ ASC".

f) Added a 5 sec time interval "back order evaluation event" on the list. As I reason that the change in the query will not take effect since there is no more opportunities to evaluate back order on the list.

Result: I expected that that queue will get a flowitem from rackB, but it still gets a flowitem from rackA.

Any advise on how to solve this issue? I understand using processflow works (which is my current workaround) but is there any way to use 3D pull to make it work?

Software Version:

FlexSim 20.0.2

pull strategy pull with requirement from rack

sample-query-listorderby.fsm (60.9 KiB)

· 5

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Joerg Vogel commented · Feb 06, 2020 at 03:08 AM

I look later in your model, but I think it is mere a problem with warehousing. Probably the connections of your queue to the racks dont take into account that you want a different treatment in send to port by a slot label.
Or you pull as fast from the list as you push from the list. Then there is only a small number of entries on the list. And if you pull from list you have got only START_LOC_SEQ values of 2 rather than a mixture of 1 and 2.

Have you tried to pull from a table to dump the result to another table? Then you can figure out how your query works.

0 ·

Show more comments

Answer 1 · 2020-02-07T22:15:58Z

Matthew Gillespie answered Feb 7, '20 pc neo commented Feb 8, '20

So this does look like it might be a bug; however, it's also a very round about way of getting the result you're looking for. I'll add a case to the dev list to look into this, but here's a simpler way to configure your model. You want all the items to be pushed on the list before the back order is fulfilled so that the ORDER BY statement will be able to evaluate all the items. Well, since you're pushing all the items onto the list at the same model time we can check a box on the list that's meant just for cases like this, the Allow Multiple Pushes Before Back Order Fulfillment box:

You can read more about what that checkbox does here, but basically it makes a new event that puts the back order fulfillment at the end of all the other events happening at the current time.

See the attached model:

allowmultiplepushes.fsm

checkbox.png (4.7 KiB)

allowmultiplepushes.fsm (59.9 KiB)

· 1

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

pc neo commented · Feb 08, 2020 at 09:58 AM

I thought I have tried that option .... now I think my eye trick me previously :p

thank you @Matthew Gillespie for putting into devlist for consideration, as similar approach will be use in other parts of the model to only extract flowitems at some "special time".

0 ·

question