GabrielTorres avatar image
GabrielTorres asked Jason Lightfoot commented

My model is throwing an exception error after running for a while

When I run my model for a while, usually after the inute 400 it throws me the following error:

time: 239.727797 exception: FlexScript exception: MODEL:/Tools/StorageSystem>variables/itemQueries/2/flexScriptCallbacks/1/codeNode

time: 239.727797 exception: SQL Evaluation Exception: FlexScript exception thrown in evaluation of code. Code is: param(1).as(Storage.Slot.Item).slot.area. Forwarding throw.

time: 239.727797 exception: SqlQuery - FlexScript Exception in: WHERE Tipo == $1.TipoProducto AND item.slot.area == 2.

I have tried bypassing the error if the reference didn´t exist whith a decide and a max wait timer in one find, but I don´t realli know what is causing the problem.


FlexSim 23.2.2
racksprocesss flowqueries
completo13.fsm (5.6 MiB)
· 1
5 |100000

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

Jason Lightfoot avatar image Jason Lightfoot ♦ commented ·

Hi @GabrielTorres, was Felix Möhlmann's answer helpful? If so, please click the "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 comment back to reopen your question.

0 Likes 0 ·

1 Answer

Felix Möhlmann avatar image
1 Like"
Felix Möhlmann answered Jason Lightfoot edited

You have a lot of errors in your model, because at many points you assign or read values to/from labels that do not exist. Your model seems to have a bug that causes the system console to not automatically open for all errors. Some of those relate to Find Slot activities, so they might be the cause of the sql exception.


I suggest you run your model with the console window open and try to fix all other exceptions first. Once you have done that and the sql exception persists, post your model again.

1700033661133.png (16.0 KiB)
· 2
5 |100000

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

GabrielTorres avatar image GabrielTorres commented ·

Thank you very much, your reply helped me a lot. I used the console window and I think I found the error, it was a bad reference in a task sequence. Now I am not getting that type of error. Just these errors, just showing the sql query exception.1700061190881.png

I think the problem lies in this line of code to assign the slot adress to a label rack. I am really new to Flexsim, have been using it for two weeks or so and there is no much informatioon on how to use this slot references.


I think the problem lies in the rack label value.

Here is the model again. Again thank you for your time and guidance.


0 Likes 0 ·
1700061190881.png (36.1 KiB)
1700061365052.png (40.0 KiB)
completo13.fsm (5.6 MiB)
Jason Lightfoot avatar image Jason Lightfoot ♦ GabrielTorres commented ·

You're still trying to assign the slot to token.pallet, but the label pointing to the created pallet for intial stock is token.IDPALLET. This gives you exceptions at the start.

Next - your model doesn't seem to be repeatable so you should check the start positions of operators are resetting correctly along with any label values you're setting. You can also search this site for help and links about repeatability issues.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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