I am using a combination of Import from Database for the Cases & Activities tables with Import from File third file (an Excel file with a primary key connecting to the Cases table).
This works perfectly, as expected. However, after a couple of hours, all my Variant & Process Explorers stop working with the following error:
Undefined exception occurred. Could not open swap file: 7e2f96…
Clicking Reload from Cache in the data model resolves this, and the dashboard works again perfectly. But in another few hours, it breaks again with the same error.
I’m wondering what could be causing this error, and it it’s perhaps a known issue when using Import from File from Excel? It doesn’t make any sense to me that it would work, then stop working with an undefined error, then start working again when the cache is refreshed (since the data doesn’t change).
Any advice is appreciated