question

martin.j avatar image
0 Likes"
martin.j asked Jordan Johnson commented

SQL query problem after update of model version

I stared making a tankplanning model in Flexsim 2018.2.2 and later decided to update to Flexsim 2019 when that came out of beta. But as it turns out my SQL queries no longer work after the update, and I can't seem to figure out why.

What seem even stranger is that if I reduce the TimingPlan table down to 14 rows it seems to work, but it doesnt matter which lines I delete, only that I get below 14 rows...

The attached model contains a single script that gets data from two tables and stores it in a third. It is made in Flexsim 2018.2 but when opened in Flexsim 2019 it no longer works. What changed?

querytest.fsm

FlexSim 18.2.2
updatessql join
querytest.fsm (20.3 KiB)
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.

1 Answer

Jordan Johnson avatar image
1 Like"
Jordan Johnson answered Jordan Johnson commented

This is a bug that was introduced in 19.0, and has since been fixed. It will be released in the next bug fix version.

· 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.

Lars Jacobsen avatar image Lars Jacobsen commented ·

Have this error been re-introduced in version 19.2.0?

0 Likes 0 ·
tannerp avatar image tannerp Lars Jacobsen commented ·

Could you post the 19.2 model you've found the bug in?

0 Likes 0 ·
Jordan Johnson avatar image Jordan Johnson ♦♦ Lars Jacobsen commented ·

If you are experiencing issues with this (or any) model in 19.2.0, please report the error. I opened this model in 18.2.3 and in 19.2.0. Neither version seemed to have the problem described above, and appeared to work correctly.

0 Likes 0 ·