I noticed that in the Funnelback/admin/reports/ directory there are multiple dll files created - one for each time the analytics job is updated. Is there a reason for this?
Is it a support interface to query the sqlite db directly rather than going through the REST API? I did have a look at the DB schema and actual noticed that my connection to the DB prevented the analytics job from completing successfully (assume a temp DB is created and then overwritten on top of the reporting db) - so it looks like this isn’t the best way to query reporting data.
I noticed that in the Funnelback/admin/reports/ directory there are multiple dll files created - one for each time the analytics job is updated.
Are you only seeing these .dll files during the time the analytics job is updating?
Is it a support interface to query the sqlite db directly rather than going through the REST API?
This is not an officially-supported method, no. Only the APIs and the Marketing Dashboard UI are regarded as ‘official’, providing a separation between the interfaces and the underlying analytics datastore.
The DLLs are created automatically by SQLite. What version of Funnelback are you running? In more recent Funnelback versions, it has been changed so the the libraries are deleted at the end of the update process.
A new dll file is created each time the reports are updated. I upgraded to 15.10 yesterday so ran another update to the analytics this morning - it still created a new dll. Is it ok to delete these? My concern would be that at 700K each these would rapidly fill up the disk.
I have raised this with the products team so that it can be addressed in upcoming releases. In the meantime, I can confirm that it is safe to delete these dlls after the reports have finished updating.