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.
Im wondering what could be causing this error, and it its perhaps a known issue when using Import from File from Excel? It doesnt 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 doesnt change).
Any advice is appreciated
Thank you,
Matthew