I have a database that apparently has some corruption somewhere inside it. In this database, I'm unable to view stock picking reports. If I create a new, clean database, this function works just fine, so it must be a problem with the first DB. However, if you do a simple DB copy from the database manager, restoring to a new database, the problem is migrated along with all the data. I have tried doing data-only dumps using psql and pg_dump from the command line, but restoring always errors out or leaves me with a database that can be seen from the Odoo DB selection screen, but doesn't show any of the modules/apps as installed. How do others solve issues like this? I'm really hoping to avoid having to do table by table export/import via the Odoo interface. What a pain in the butt that would be! Any suggestions?
It sounds to mie like you have issue with inconsistent data in the DB. Best approach is to figure out which table is causing the problems.
Try analysing the log file if there are exceptions. If required, you can increase the log-level to log the SQL statements (--log-sql). Once you had identified the table, you can try to fixing the data in that table. Here the tables from a clean database can be handy.
Hope this will help you find the problem.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 2/13/15, 4:53 PM|
|Seen: 650 times|
|Last updated: 3/16/15, 8:10 AM|