(imported topic written by SystemAdmin)
When openning Web Reports v 7.0.1.376…error, “Background thread threw exception: SQLite error 0-8” then cleared it. I searched and found another SQLite error 0-11, noted in the forum but seems tied to a console issue http://forum.bigfix.com/viewtopic.php?id=1490. Ideas.
(imported comment written by SystemAdmin)
Hi Rasmataz,
Web Reports keeps a local SQL Lite cache to store data the same way the BES Console does and the error message you are seeing can also likely be fixed by clearing the session cache. Basically, the Web Reports and the BES Console use the same underlying data store and implement a different user interface on top of that data.
The Web Reports session cache files (BES 7.0) can be manually deleted by deleting all the files and folders in these folders:
BigFix Enterprise\BES Server\BESReportsData<database dsn>
BigFix Enterprise\BES Server\BESReportsServer\wwwroot\cgi-bin\besreports
Where is the name of the DSN used by web reports to connect to the bfenterprise database (bes_bfenterprise by default).
Please try stopping the web reports service, deleting the listed files and starting the service again. Let the cache load fully and hopefully that will clear the errors for good.