topic Re: No options available for database table to export to. in FlexSim Forum

No options available for database table to export to.

gjones1911 — Mon, 26 Jun 2023 16:43:21 GMT

[ FlexSim 22.2.0 ]

I am attempting to push a global table to a Microsoft SQL studio database using a successfully connected Database connector. I use Flexscript to push the table at the end of the simulation, but I have realized I should be able to set this up using the connector only and the export tab. However, the list shows no options when attempting to set up the table that will be pushed to the database. It suggests testing the connection, which I have done successfully, but no table options are showing up. Any help will be greatly appreciated.

Re: No options available for database table to export to.

kavika_faleumu — Mon, 26 Jun 2023 17:42:41 GMT

Hey @Gerald, from what I understand, you were able to successfully connect your SQL Database to FlexSim; however, you can't see any Global Tables in the export tab? What happens when you go to the Database Connector > Export tab and click the Green + button to add a Global Table? Do any show up?

Re: No options available for database table to export to.

julie_weller — Thu, 29 Jun 2023 19:30:06 GMT

Hi @Gerald,

We haven't heard back from you. Were you able to solve your problem? If so, please add and accept an answer to let others know the solution. Or please respond to the previous comment so that we can continue to help you.

If we don't hear back in the next 3 business days, we'll assume you were able to solve your problem and we'll close this case in our tracker. You can always comment back at any time to reopen your question, or you can contact your local FlexSim distributor for phone or email help.

Re: No options available for database table to export to.

JordanLJohnson — Thu, 29 Jun 2023 21:33:38 GMT

Based on the code found in the library:

MAIN:/project/library/DatabaseConnector>behaviour/includebody, L165

It looks like we only generate the list of possible tables for MySQL, Oracle, SQLite, and PostgreSQL. It looks also like there's a default query that it tries, if the connection is other than one of those types. So it's very possible that the queries that generate the list of tables/columns for that button aren't correct given your connection type.

However, if you already generated the query you need, you can just use that query in the export tab. The list of tables/columns is not required for a successful connection.

Re: No options available for database table to export to.

borja_lorenzo — Tue, 01 Oct 2024 09:47:38 GMT

Hello @Jordan Johnson

The same thing happens to me with a MySQL Database version 8.0.26. As you can see in the image, it does not load the tables that I do have in the Database. The connectivity test is correct and the import works fine. The export with the command Database.Connection | .connect() | .query() executed from Script does confirm that there is a connection and I can write to the table with the query. The problem is that from the FlexSim Connection tool I cannot select the tables. What could be happening?

Thank you in advance.

Re: No options available for database table to export to.

JordanLJohnson — Wed, 09 Oct 2024 20:25:20 GMT

That does seem like a bug, I'll add something to the dev list.

Re: No options available for database table to export to.

borja_lorenzo — Wed, 09 Oct 2024 20:42:43 GMT

Hello Jordan

Thank you very much for your response. I was going crazy. In this question that I have open, I have left more details: https://answers.flexsim.com/questions/171152/export-a-global-table-from-flexsim-to-badedate-mys.html.
Currently, I have resolved the export through the API, but the Export tool of the DBConnector is certainly more practical.

Again, thank you very much, and I will be attentive to any updates on this matter.

Re: No options available for database table to export to.

jonah_kendellR47TC — Wed, 18 Dec 2024 18:15:05 GMT

This issue has been fixed in the latest bug fix releases 24.0.7 and 24.2.3.