topic Re: List with "SELECT" keyword as values assigned throws exception in FlexSim Forum

List with "SELECT" keyword as values assigned throws exception

pcneo — Fri, 30 Apr 2021 10:34:21 GMT

[ FlexSim 21.1.1 ]

select_error.fsmI am learning on List and craft a small example as attached but it is throwing exception with the addition of "SELECT litres" clause. Is this a bug? Or I have some done something wrong?

Re: List with "SELECT" keyword as values assigned throws exception

joerg_vogel_HsH — Fri, 30 Apr 2021 12:18:31 GMT

There are some conditions using a SELECT clause. The most important is, it MUST be a global list.

Re: List with "SELECT" keyword as values assigned throws exception

pcneo — Fri, 30 Apr 2021 14:07:54 GMT

Thanks for the quick reply.

I've tried using global list and the same issue is seen. Furthermore, if the List properties has both "SELECT as quantifier" and "Assign SELECT..." checked the attached model works without error.

In regards to the requirements of the use of "SELECT" clause, the user manual has mentioned as below but they are not violated in this example too, even though this example is not using "SELECT" clause as quantifier.

The clause references a dynamic label field.
The clause references a label that is not explicitly defined as a field on the list.
The clause references a non-dynamic field.

Hope to get more inputs/advice.

Re: List with "SELECT" keyword as values assigned throws exception

jason_lightfoot_adsk — Fri, 30 Apr 2021 15:34:03 GMT

If you add 'litres' and 'Type' as fields to your list you will not get the exception:

Re: List with "SELECT" keyword as values assigned throws exception

pcneo — Mon, 03 May 2021 04:48:16 GMT

@jason.lightfootI have tried your suggestion (using both internal list and global list) but the exception is still seen. 😞

Re: List with "SELECT" keyword as values assigned throws exception

arunTTT2P — Mon, 03 May 2021 09:00:05 GMT

Checking the "Use First Select Value As Quantifier" eliminates the exception. Check the attached model. Also added fields as @jason.lightfoot was suggesting.

Regards,

Arun KRselect-error.fsm

Re: List with "SELECT" keyword as values assigned throws exception

joerg_vogel_HsH — Mon, 03 May 2021 09:40:15 GMT

Without this option it does work as long as there are enough values to access on the list.

List_pull_SELECT.fsm

Re: List with "SELECT" keyword as values assigned throws exception

pcneo — Mon, 03 May 2021 10:34:57 GMT

@Jörg VogelIn my attached model, it throws exception without the option. I wonder what mistake that I have made in my attached model to result in the exception?

@Arun KRIn my attached model, the behaviour will be different if the "SELECT ..quantitfier" is checked, and it will not meet the intended purpose which is only to read the value and write it as a label onto the puller token.

Re: List with "SELECT" keyword as values assigned throws exception

pcneo — Mon, 03 May 2021 10:36:07 GMT

@Jörg Vogel Oh, l have tried changing the list to "global list" using my attached model. But it still throws exception.

Re: List with "SELECT" keyword as values assigned throws exception

joerg_vogel_HsH — Mon, 03 May 2021 10:39:46 GMT

@pc neo, I know. It hasn't got to do with the SELECT clause it is more the fact that there aren't anything to pull and thus to assign a label to it.

Re: List with "SELECT" keyword as values assigned throws exception

pcneo — Tue, 04 May 2021 02:19:43 GMT

@Jörg VogelIf there aren't anything to pull the token will wait at the "Pull from List". But it is now throwing exception. This sounds like a bug?

Re: List with "SELECT" keyword as values assigned throws exception

joerg_vogel_HsH — Tue, 04 May 2021 06:06:05 GMT

Hi @pc neo, as I tested it, the problem occurs only if a backorder is issued. The mechanism tries to set labels for selected field values to the list main value. Because there is only a backorder and not an item to assert a label to, there is the throwing exception. If you allow a select clause be processed to lists returning successfully items, then you‘ll see that the mechanism works as intended. If you think, that the limits of the select clause is a bug, then it is a bug.

I tried to combine select and sum clause to get the total of a query, but that doesn’t work either, even if I tried to have a successful query. A successful select query returns only an array.

Re: List with "SELECT" keyword as values assigned throws exception

Ben_WilsonADSK — Thu, 06 May 2021 18:00:47 GMT

Hi @pc neo, was jason.lightfoot's answer helpful? If so, please click the red "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

Re: List with "SELECT" keyword as values assigned throws exception

pcneo — Fri, 07 May 2021 02:46:07 GMT

hi @Ben Wilson the suggestion from @jason.lightfoot does not resolve my issue. After getting inputs from many others particularly from @Jörg Vogel I believe it may be a bug and I will send an email to dev@flexsim.com.

Thank you 🙂

Re: List with "SELECT" keyword as values assigned throws exception

pcneo — Fri, 07 May 2021 02:49:47 GMT

@Jörg Vogel thank you for your input. I will email to dev@flexsim.com on this. Though it is not a critical issue for me now.