topic Re: SqlQuery exception with Process Flow zone tokens in FlexSim Forum

SqlQuery exception with Process Flow zone tokens

jon_abbott — Tue, 11 Feb 2020 01:04:27 GMT

[ FlexSim 20.0.2 ]

I am getting the following error in the System Console when I click on a Process Flow zone token count:

exception: SqlQuery - Unkown error in: SELECT $2 AS RowNum, $3 AS Time FROM $1 ORDER BY Time

The active token window shows 0 tokens active, even though there are 8 showing in the zone:

Does anyone have suggestions on what to try in order to fix this? It only happens with zones, not with resources, lists, or activities. I have attached an example model with steps to reproduce the issue included in the model. Thanks in advance for your assistance.

zone-sqlquery-exception.fsm

Re: SqlQuery exception with Process Flow zone tokens

joerg_vogel_HsH — Tue, 11 Feb 2020 06:23:09 GMT

@Jon Abbott, can you add the complete query clause! I don’t know, what $1, $2, $3 are replaced with. Can you reproduce the error in a smaller model you can share? And additionally why do you want to get data from a zone, while the model is running? Perhaps there is a workaround to get your data? Regards Jörg

Re: SqlQuery exception with Process Flow zone tokens

jon_abbott — Tue, 11 Feb 2020 18:01:06 GMT

Hi @Jörg Vogel

Thank you for your reply. In response to your questions:

The query that is shown is not mine – it appears to be internal to FlexSim, and it runs whenever I click on the active token counter for the zone. I don’t know what $1, $2, or $3 are being replaced with either.
I have attached an example model with steps to reproduce the issue included in the model. Please let me know if this helps. Note that after the error happens, FlexSim seems to become unstable and will sometimes crash if the model is reloaded. I have to close FlexSim entirely and reopen the model to further diagnose this issue to avoid the crashing from happening.
I want to get data from the zone to see the token labels for the tokens that are actively in the zone. I can tell from the Zone object that there are tokens actively in the zone, as well as tokens waiting to enter the zone, but when I click on the token counter to show the detailed list, it does not work properly.

Thanks again for your assistance.

zone-sqlquery-exception.fsm

Re: SqlQuery exception with Process Flow zone tokens

JordanLJohnson — Tue, 11 Feb 2020 19:32:27 GMT

This appears to be a bug with the query engine in FlexSim. I'll put it on the dev list. Unfortunately, I don't have a good way to work around it right now.

Re: SqlQuery exception with Process Flow zone tokens

jon_abbott — Tue, 11 Feb 2020 23:05:13 GMT

Thanks for the update, @jordan.johnson. Is there a way for me to be notified on the forum once this has been resolved? Thanks again.

Re: SqlQuery exception with Process Flow zone tokens

JordanLJohnson — Tue, 11 Feb 2020 23:26:23 GMT

I will put a note on the issue to be sure to update this post.

Re: SqlQuery exception with Process Flow zone tokens

jon_abbott — Tue, 11 Feb 2020 23:28:05 GMT

Awesome, thanks @jordan.johnson!