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...
If you do not use report manager than you can intialize the database. All reporting data would be lost and rebuilt from DDMDB
I tried that already but some tables are not found, the script returns errors and stops.
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?
stop mysql & tomcat rename reporting directoryrename reporting directorystart mysql & tomcat This should allow oneclick to build the reporting tables.
No, the OC didn't build the reporting database.
BTW: OneClick 9.4.1
Well, I should create reporting database before start OC.
Yes, it recreated the db!
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.
This does not work at all! sorry - have to unmark this as a "Correct Answer". - Joerg -
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