question

Lucas Matheus avatar image
0 Likes"
Lucas Matheus asked Jeanette F commented

Error exporting results to sqlite via experimenter

While my model is running on Experimenter, an error appears in the system console " exception: query Error cannot commit - no transaction is active". In some models, some results were exported to sqlite. When the error occurs, the task hangs in "recording" status.

What could be causing this error?

1680611438832.png



FlexSim 23.0.3
experimenterresultssqlite
1680611438832.png (17.1 KiB)
· 3
5 |100000

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

Jordan Johnson avatar image Jordan Johnson ♦♦ commented ·

That does seem like an issue. I have some follow-up questions:

  • Is there a model where this happens consistently? If so, can you share it?
  • If you open a new model and run the experiment job, does this error occur? Normally, it doesn't make sense to run an experiment on an empty model like that, but it is a good test.
  • Is that the very first error you see? It feels like this error would come because of a previous error.
  • Is there anything special about your database file? Is it on a network drive, or is some other application attempting to read it at the same time?
0 Likes 0 ·
Lucas Matheus avatar image Lucas Matheus Jordan Johnson ♦♦ commented ·

Hi @Jordan Johnson,

  1. I was unable to replicate the error in a simplified model. Sorry.
  2. This error doesn't occur in a new model.
  3. Yes, it is the first error in the console.
  4. Yes, the database it is on Onedrive.
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @Lucas Matheus, was Jordan Johnson's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always unaccept and comment back to reopen your question.

0 Likes 0 ·

1 Answer

Jordan Johnson avatar image
0 Likes"
Jordan Johnson answered

I suspect having the file in a OneDrive folder is the issue. My theory is that queries that read the database work just fine, but that queries that attempt to write to the database fail. For example, beginning a transaction would require write permission, and that fails quietly. But then finishing the transaction fails loudly for some reason. In any case, I think the answer is to move the database file to somewhere besides the OneDrive folder. You can use a custom path for the file with these options:
1680625828112.png


1680625828112.png (14.8 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.