pxl_rene Posted March 31, 2014 Report Share Posted March 31, 2014 Heya folks, recently some customers reported errors with the Revive Adserver, providing me with screenshots like this https://drive.google.com/file/d/0B_nxS34MJR2BbDFVRlNhcmc0U1k/edit?usp=sharing Using the workbench, i can verify that the table is broken. What really strange is, that if i want to start the table maintenance, the workbench tells me that oa_data_intermediate_ad is a view and not a table anymore. I restored a database from an old snapshot and there it says that oa_data_intermediate_ad is a table. So what do to now? And yeah, my daily backup wasnt working properly after upgrading the db, dooh. So restoring the table from an backup is unfortunately not an option. thanks in advance and sorry for my 'its not my first language' english, pxl-rene Quote Link to comment Share on other sites More sharing options...
Eliza0406 Posted March 31, 2014 Report Share Posted March 31, 2014 Hi pxl_rene, Optimize your table "oa_data_intermediate_ad" and then re-check it. It will assist you to solve your issue. Quote Link to comment Share on other sites More sharing options...
pxl_rene Posted March 31, 2014 Author Report Share Posted March 31, 2014 Hey Eliza, thanks for the advice. This is what i already tried in the meantime, but i wasn't able to use the table maintenance because it didn't even show me the 'oa_data_intermediate_ad' in the table column, but in the view column, like i stated in the entry post. I launched a snapshot of the last working day, dumped the table and reimported it into the live database. But it would be nice, to have a better workaround for this or even prevent things like that in the future.. greetings, pxl_rene. 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.