question

Julian Sundermeier avatar image
0 Likes"
Julian Sundermeier asked Felix G2 edited

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?

FlexSim 7.5.4
sqlodbcdiscontinuing execution.
error-sql.jpg (607.0 KiB)
· 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.

Emily Hardy avatar image Emily Hardy ♦ commented ·

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

1 Like 1 ·
Julian Sundermeier avatar image Julian Sundermeier Emily Hardy ♦ commented ·

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 Likes 0 ·
sql.fsm (18.0 KiB)
Felix G2 avatar image Felix G2 commented ·

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 Likes 0 ·

3 Answers

Jason Lightfoot avatar image
1 Like"
Jason Lightfoot answered

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

Julian Sundermeier avatar image Julian Sundermeier commented ·

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 Likes 2 ·
Felix G2 avatar image
0 Likes"
Felix G2 answered Felix G2 edited

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

Emily Hardy avatar image
0 Likes"
Emily Hardy answered Emily Hardy converted comment to answer

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

Julian Sundermeier avatar image Julian Sundermeier commented ·

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 Likes 0 ·
sql.fsm (19.8 KiB)
sql-error-new.jpg (597.7 KiB)