sikjoy Posted March 8, 2018 Report Share Posted March 8, 2018 I am locked out of our Revive Adserver receiving the following message during login attempts: "An error occurred while accessing the databaseDue to a problem with the database Revive Adserver couldn't retrieve or store data." I noticed that the rv_audit table has maxed out with 8388607 rows. Is it OK to truncate this table? Is the data here mission critical? Thanks, Kevin Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted March 8, 2018 Report Share Posted March 8, 2018 Yes, that table should be safe to truncate. Check your database server logs & use the appropriate DB diagnostic tools first, though, to make sure that is the issue before you start truncating data. (And always take a backup before you do anything!) Quote Link to comment Share on other sites More sharing options...
sikjoy Posted March 9, 2018 Author Report Share Posted March 9, 2018 Thank you. As soon as I truncated the table everything started functioning normally. andrewatfornax 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.