My Cart (0)  |  My Orders  |  My Downloads  |  My Auction  |  My Account  |  Help


Login |Register        Search

Truncate DNN 7.4 Eventlog

                Print      Add To Favorite     Add To Watch List     Contact Author

Creator: host   11/20/2015 4:32:40 AM    Author: Sebastian Leupold   Source: http://www.dnnsoftware.com/community-blog/cid/155180/howto-truncate-your-eventlog-in-dnn-740   Views: 1778    0    0  
Tags:
DNN 7.4 Event Logging

The DNN event log stores each exception and all other registered events in the database. There is a scheduler job you should have enabled to ensure, the table doesn't grow too large. However, if the job is turned off or there were many events between executions of the scheduler, the cleanup job and even a manual deletion command might time out. Or you already reached the size limit of your database, and delete operation fails as well. In this case, Truncate Table is your only option, as it purges all rows from a database table efficiently and without logging.

While it was quite easy to run this command before, in DNN 7.4.0 the Eventlog table was split into 3 tables (don't ask me, why) which are linked by Foreign Key Constraints to implement referential integrity - which prevents you from simply applying Truncate Table. I created a small script, which temporarily drops these constraints, truncates Eventlog and associated tables and re-adds the constraints afterwards. You may download it for free from https://dnnscript.codeplex.com/releases/view/612643


Rating People: 0   Average Rating:     

     DnnModule.com is built to provide DNN quality modules and DNN skins, some of them are free, some not. We wish these stuffs (free or not ) can be useful to you.

     Besides that, we also provide a full range of professional services, ranging from web site build, seo, system management, administration, support, senior consultancy and security services. We act as if your development project or network was ours, with care and respect. We are not satisfied until it works the way you want it to, and we don't silently ignore found issues as somebody else's problem.