question

Urvi Sukharamwala avatar image
0 Likes"
Urvi Sukharamwala asked Urvi Sukharamwala commented

database exception

Hello, I tried exporting data from flexSim to database, however I am getting exception error for specific model only. Error: time: 88.543086 exception: Exception thrown in database export:

Is it possible to include try and catch code. If yes please give the syntax for it.


1707325615104.png

FlexSim 24.0.1
exception errordatabaseexport data
1707325615104.png (3.9 KiB)
· 1
5 |100000

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

Jason Lightfoot avatar image Jason Lightfoot ♦♦ commented ·

Hi @urvi-sukharamwala,

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

1 Answer

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Urvi Sukharamwala commented

Can you show us what you have implemented along with the table definitions you have in both FlexSim and the external DB?

The exception message printed in the catch of corresponding try section for exportSingle/exportAll and both call the same function to export the data, which is essentially DELETE FROM if not appending and then INSERT INTO.

Can you try performing the same INSERT INTO operations yourself in FlexScript or another application to check that it's possible? Does the target table have foreign keys and does your login have the correct permissions to add/remove records to/from the target table?

· 2
5 |100000

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

Urvi Sukharamwala avatar image Urvi Sukharamwala commented ·

Hi,

I apologize for not responding. However I was able to solve the issue with above given answer. Thank you for the help.

1 Like 1 ·
Jason Lightfoot avatar image Jason Lightfoot ♦♦ Urvi Sukharamwala commented ·
Thanks for letting us know.
0 Likes 0 ·