SQL query problem after update of model version

Question

question

martin.j asked Feb 18, '19 Jordan Johnson commented Sep 11, '19

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

Software Version:

FlexSim 18.2.2

updates sql join

querytest.fsm (20.3 KiB)

Answer 1 · 2019-02-18T15:38:06Z

Jordan Johnson answered Feb 18, '19 Jordan Johnson commented Sep 11, '19

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

Lars Christian J2 commented · Sep 11, 2019 at 11:24 AM

Have this error been re-introduced in version 19.2.0?

0 ·

tannerp Lars Christian J2 commented · Sep 11, 2019 at 06:39 PM

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

0 ·

Jordan Johnson ♦♦ Lars Christian J2 commented · Sep 11, 2019 at 06:41 PM

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 ·

question