Service Virtualization

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Tables to be recovered after the cleanup of Enterprise Dashboard DB

  • 1.  Tables to be recovered after the cleanup of Enterprise Dashboard DB

    Posted Jun 18, 2019 10:36 AM
    Hi,

             We are using DevTest 10.3v whose Enterprise Dashboard is connected to Oracle SQL developer. We could see 502 Bad Gateway Error sometimes in the logs. And hence we have planned to do a cleanup of the DB to which the dashboard is connected to. We are planning to create a fresh schema by deleting the old records. Could someone suggest what are all the tables that have to recovered after this cleanup process?


  • 2.  RE: Tables to be recovered after the cleanup of Enterprise Dashboard DB
    Best Answer

    Broadcom Employee
    Posted Jun 20, 2019 06:45 PM
    Hello Varun - the enterprise dashboard database contains info on the usage/audit data that is the only source in determining the usage by your corporations/teams. I would keep this database on the side and it delete/purge it or at least please take the 'Audit Report' from the dashboard and save it which will be useful for compliance reasons. Then you could backup your existing database and then delete it and then restart dashboard service. That way your older dTa would've saved while new database will be used moving forward.
    Original Message