DX NetOps

  • Private Community
 View Only

  • 1.  What's the impact of reporting database deletion

    Posted Jul 03, 2018 04:55 AM

    Hi!

     

    I am having some troubles with reporting tables. We do not use SRM so, basically what is the impact of reporting db deletion?

     

    Basically the problems are about desregistered InnoDB tables. If we try to update the Spectrum (9.4.1) to the latest version the MySQL doesn't starts, the root cause is identified so, the previous question...

     

    Thanks



  • 2.  Re: What's the impact of reporting database deletion

    Posted Jul 03, 2018 06:33 AM

    If you do not use report manager than you can intialize the database. All reporting data would be lost and rebuilt from DDMDB



  • 3.  Re: What's the impact of reporting database deletion

    Posted Jul 03, 2018 06:38 AM

    I tried that already but some tables are not found, the script returns errors and stops.



  • 4.  Re: What's the impact of reporting database deletion

    Posted Jul 03, 2018 06:42 AM

    I am thinking do some tasks regarding InnoDB tables:
    - extract the structure information from *.frm files
    - stop Tomcat
    - drop these tables
    - delete the files from data\reporting related to these tables
    - start mysql

    - import the first file, the sql structure

    - restart mysql

    - start tomcat

     

    It makes sense?



  • 5.  Re: What's the impact of reporting database deletion

    Posted Jul 03, 2018 06:51 AM

    stop mysql & tomcat
    rename reporting directory
    rename reporting directory
    start mysql & tomcat
    This should allow oneclick to build the reporting tables.



  • 6.  Re: What's the impact of reporting database deletion

    Posted Jul 03, 2018 07:04 AM

    No, the OC didn't build the reporting database.

     

    BTW: OneClick 9.4.1



  • 7.  Re: What's the impact of reporting database deletion

    Posted Jul 03, 2018 09:01 AM

    Well, I should create reporting database before start OC.

    Yes, it recreated the db!

     

    Thank you



  • 8.  Re: What's the impact of reporting database deletion
    Best Answer

    Posted Jul 09, 2018 10:21 AM

    My advice would be to reinstall OC and not to select Report Manager.

    Then it will not be there.  Especially if you do not use it.

    It will just take up resources on the system.

     

    You can copy your custom directory and then reinstall (Uninstall first).

    Then place your custom directory back in place and you are ready to go.



  • 9.  Re: What's the impact of reporting database deletion

    Broadcom Employee
    Posted Jul 11, 2018 10:03 AM

    This does not work at all! sorry - have to unmark this as a "Correct Answer". - Joerg -



  • 10.  Re: What's the impact of reporting database deletion

    Posted Jul 11, 2018 10:06 AM

    It works, I followed and the tables were recreated. We cannot delete the databases but the tables we can.

     

    Note: this is just for an emergency and if we don't use report manager, like I said previously