How do Views get corrupted?
We have often see that all the tables in the views are getting deleted somehow and due to this reports are not working. We are not sure how this corruption is happening, are there any possibilities for this or to avoid this issues in future?
I have checked on the reportview table in DB, searched with the viewname and I see only one entry with status Open which means the view is active. However, from the application side, the view does not open or edit, it throws the error "oh no an error has occurred".
We did a DB restore, but that did not help too. Finally, we had to migrate the corrupted views from working system.
May I know why it happens and how to avoid this happening in future again?