question

kauan pedroso avatar image
0 Likes"
kauan pedroso asked Jeanette F commented

Limit of data to be pulled from a database

Good Morning guys !

I have a project where I pull several data from a DBConnector that supplies several globaltables, but in some of them the data ends up not being loaded, how do I make this loading lighter. I think that might be the problem.

1681743111563.png

1681743132778.png

busca-de-dados-3-autosave-jl3_autosave.fsm

FlexSim 21.2.4
global tabledatabasesql server
· 4
5 |100000

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

1 Answer

Yasmin avatar image
1 Like"
Yasmin answered Yasmin edited

Hello, Kauan!

Please let us know if your answer was replied!

If this query already worked on other import, I believe your problem is in your database. I higlhy recommend you to read the documentation about Database Connector (https://docs.flexsim.com/en/22.2/Reference/Tools/DatabaseConnectors/DatabaseConnectors.html#page-header).


Looking there I saw that some database requires you to enter the full database connection string (picture below)

1681995744727.png

Hope it can help!


1681995744727.png (22.6 KiB)
5 |100000

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