SqlQuery exception with Process Flow zone tokens

Question

question

Jon Abbott asked Feb 11 2020 at 1:04 AM Jon Abbott commented Feb 11 2020 at 11:28 PM

SqlQuery exception with Process Flow zone tokens

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

Software Version:

FlexSim 20.0.2

process flow error message sql zone exception

screen-shot-2020-02-10-at-45757-pm.png (13.2 KiB)

zone-sqlquery-exception.fsm (11.3 KiB)

· 2

Joerg Vogel commented · Feb 11 2020 at 6:23 AM

@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

0 ·

Jon Abbott Joerg Vogel commented · Feb 11 2020 at 6:01 PM

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

1 ·

zone-sqlquery-exception.fsm (11.3 KiB)

Answer 1 · 2020-02-11T19:32:27Z

Jordan Johnson answered Feb 11 2020 at 7:32 PM Jon Abbott commented Feb 11 2020 at 11:28 PM

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.

· 3

Jon Abbott commented · Feb 11 2020 at 11:05 PM

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.

0 ·

Jordan Johnson ♦♦ Jon Abbott commented · Feb 11 2020 at 11:26 PM

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

0 ·

Jon Abbott Jordan Johnson ♦♦ commented · Feb 11 2020 at 11:28 PM

Awesome, thanks @jordan.johnson!

0 ·

question