question

Keith H3 avatar image
0 Likes"
Keith H3 asked Phil BoBo edited

SQL Query Error - Flexsim 19.2

My colleague and I are having flexsim exceptions thrown with SQL queries in the new update. My colleague emailed about this, and the response was that the exception was not reproduced and to reinstall. We have both reinstalled and get the same error.

The attached model contains a simple test with a query in the script window. Upon opening the model and running the script, everything works fine and the result is correctly printed to the output console. However, if you instead debug the script and step through with breakpoints, the execption arises and persists even using the run button again.

I tested this in process flow with a custom code block instead and had the same result: initially works fine, after placing a breakpoint on the query line, exception thrown which persists after breakpoints are removed and code window is closed.

test-query.fsm

@phil.bobo

FlexSim 19.2.0
error messagesql
test-query.fsm (23.7 KiB)
· 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.

Keith H3 avatar image Keith H3 commented ·

Edit: I am only getting this exception when the code window containing the query is open and I am debugging. It does not persist after all breakpoints are removed.

0 Likes 0 ·

1 Answer

Phil BoBo avatar image
0 Likes"
Phil BoBo answered Phil BoBo edited

This looks like a bug with the debugger. I'll add a case to the dev list with these replication steps to see what we can do about this.

In the meantime, don't use breakpoints in functions that call Table.query().

(Your colleague's email didn't mention anything about breakpoints or the debugger. Thank you for accurate replication steps.)

5 |100000

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