Is it possible to clean the execution logs in ODX Server?

Question

Hi all,I have some customers that are reloading data every x minutes in ODX Server (V20.10.x). This generates a lot of execution log entries. When I open the Execution Log in the ODX Server, it takes a long time. I think that removing old execution logs will improve the speed of opening this execution log overview window. I have no idea if it is possible to delete old execution log entries?Another option could be that the execution log view first shows the datetime range you like to see logs and then opens the overview.

Thomas Lind · Accepted Answer

Hi @bas.hopstakenIt is possible to delete the logs, but it is not something you can do. We can at times go in and remove old log files if it is deemed necessary.The Backlog file is only a copy of the actual cloud database, so deleting the logs in that will not affect the actual log.In version 20.10 your logs will be deleted after 90 days, but if you have a lot of data sources running scheduled tasks multiple times a day you can generate a lot of logging.

rogier.helmus · Answer

Hi @bas.hopstaken,I’ve not tested it myself, but thearticle underneath describes how you can connect to the ODX server SQLite database for analysis purposes. The article mentions that the database file should be copied otherwise you can interfere with the ODX Server service. If you stop the ODX Server service, make a backup and then connect directly to the file you’re probably able to empty the Execution log table using a SQL statement.https://legacysupport.timextender.com/hc/en-us/articles/360054444552-How-to-Query-ODX-local-Backlog-SQLite-databaseAt the bottom of the article is a SQL script for querying the execution log.

Is it possible to clean the execution logs in ODX Server?

3 replies

Reply

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded