Discontinuing execution after computer restart

Question

question

Julian Sundermeier asked May 25, '18 Felix G2 edited Jun 4, '18

Discontinuing execution after computer restart

Hello everyone,

yesterday i made the SQL tutorial successfully. The connection via ODBC worked and the model does exactly what it was suposed to do. Today I wanted to mofify and expand the model but instead i got an error message about a "Discontinuing execution" (see picture below).

Of course i didn't changed anything in the model or the database so far.

I even did the tutorial exactly the same as yesterday (including creating the ODBC connection and the database) but the error message keeps popping up.

Has someone an idea how to fix this?

Software Version:

FlexSim 7.5.4

sql odbc discontinuing execution.

error-sql.jpg (607.0 KiB)

· 3

Emily Hardy ♦ commented · May 29, 2018 at 02:48 PM

If it's possible, could you attach the file and I can see if I can recreate the error? Thank you.

1 ·

Julian Sundermeier Emily Hardy ♦ commented · May 31, 2018 at 11:38 AM

Hey, sure i can.

Let me know if you got any reasons for the problem or -even better- any ideas how to solve it.

sql.fsm

0 ·

sql.fsm (18.0 KiB)

Felix G2 commented · May 31, 2018 at 04:13 PM

Hi,

I am facing exactly the same issue.

I also wonder how to use the information at which instruction the error happens. Where can I see the instructions the program is executing?

Best regards

0 ·

Answer 1 · 2018-06-01T14:49:07Z

Jason Lightfoot answered Jun 1, '18

You don't have to start anything in Windows to access data source names (DSN) through ODBC - but of course any database server it references needs to be started. This doesn't apply to Access/Jet file based databases, or when you're using Excel as a datasource.

18.1 Has native-like connectivity to MySQL which means that you shouldn't need to specify a DSN in the ODBC Data Source Administrator tool with which to then access your database. You specify the connection parameters directly in FlexSim's Database Connector which is found in the Toolbox under Connectivity.

· 1

Julian Sundermeier commented · Jun 01, 2018 at 05:16 PM

Thank your for the hint about the Database Connector.

I entered the connection parameters and now it works! I made a computer restart as well and it's still performing.

One thing i like to mark: you need to make sure that the Authentication Type of the database is not "caching_sha2_password". Obviously flexsim can not decode this type.

2 ·

Answer 2 · 2018-06-04T06:23:38Z

Felix G2 answered Jun 4, '18 Felix G2 edited Jun 4, '18

Hi,

this is what solved it for me:

You get there by viewing the ODBC-Datasources, configure your MySQL Connection, Details and there under the tab "Connection".

After that it worked fine :)

unbenannt.jpg (30.6 KiB)

Answer 3 · 2018-05-31T19:03:11Z

Emily Hardy answered May 31, '18 Emily Hardy converted comment to answer Jun 1, '18

When you restart your computer, the ODBC server doesn't automatically start up. After a restart, you need to make sure your ODBC server is started and you have to reconfigure it like you did the first time.

Additionally, 18.1 will work better for database support so if it's possible to use that, I would recommend upgrading your software.

· 1

Julian Sundermeier commented · Jun 01, 2018 at 02:16 PM

I checked the things you mentioned.

Therefore, i downloaded an express version of FlexSim 18.1, reinstalled MySQL and configured a database as it was specified in the tutorial.

Attached you can see a picture with all my settings and the model itself.

The message in the system console changed a bit (i think due to the upgraded version) but in the end the simulation doesn't work at all.

sql.fsm

0 ·

sql.fsm (19.8 KiB)

sql-error-new.jpg (597.7 KiB)

question