question

Jon Abbott avatar image
1 Like"
Jon Abbott asked Jon Abbott commented

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

FlexSim 20.0.2
process flowerror messagesqlzoneexception
screen-shot-2020-02-10-at-45757-pm.png (13.2 KiB)
zone-sqlquery-exception.fsm (11.3 KiB)
· 2
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Joerg Vogel avatar image Joerg Vogel commented ·

@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 Likes 0 ·
Jon Abbott avatar image Jon Abbott Joerg Vogel commented ·

Hi @Jörg Vogel

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

  1. 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.
  2. 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.
  3. 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 Like 1 ·
zone-sqlquery-exception.fsm (11.3 KiB)

1 Answer

Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered Jon Abbott commented

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
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

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

Jon Abbott avatar image Jon Abbott commented ·

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 Likes 0 ·
Jordan Johnson avatar image Jordan Johnson ♦♦ Jon Abbott commented ·

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

0 Likes 0 ·
Jon Abbott avatar image Jon Abbott Jordan Johnson ♦♦ commented ·

Awesome, thanks @jordan.johnson!

0 Likes 0 ·