No options available for database table to export to.

Question

question

Gerald asked Jun 26, '23 Borja Lorenzo edited Oct 9, '24

No options available for database table to export to.

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.

Software Version:

FlexSim 22.2.0

database database connector

· 2

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Kavika F ♦ commented · Jun 26, 2023 at 05:42 PM

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?

0 ·

1687801326860.png (39.6 KiB)

Julie Weller commented · Jun 29, 2023 at 07:30 PM

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.

0 ·

Answer 1 · 2023-06-29T21:33:38Z

Jordan Johnson answered Jun 29, '23 Borja Lorenzo edited Oct 9, '24

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.

· 3

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Borja Lorenzo commented · Oct 01 at 09:47 AM

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.

0 ·

export-from-flexsim-2.jpg (95.6 KiB)

Jordan Johnson ♦♦ Borja Lorenzo commented · Oct 09 at 08:25 PM

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

1 ·

Borja Lorenzo Jordan Johnson ♦♦ commented · Oct 09 at 08:42 PM

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.

0 ·

question