Odoo Help
Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM
|
e-Commerce
|
Accounting
|
Inventory
|
PoS
|
Project management
|
MRP
|
etc.
Error "current transaction is aborted.." on import CSV in v7
Hello..
i'm trying to import this dl.dropboxusercontent. com/u/57978373/sample.partner.csv
But keep getting this error current transaction is aborted, commands ignored until end of transaction block
.
What should I do? Thanks
You are seeing a PostgreSQL database error. OpenERP began an insert
transaction which then failed. It ignored that failure and continued trying to use the SAME TRANSACTION to run another insert
. PostgreSQL threw the exception on the second, correctly formed insert
because OpenERP tried using a broken transaction to do additional work. Correctly, PostgreSQL does not allow this.
I think it is certain that your file sample.partner.csv
contains illegal Comma Separated Value (CSV) formatting that OpenERP fails to notice. (A bug! You should report it.)
Solution : Divide and conquer! Try removing rows and columns until you get a succesfull load. That will help you pin point the culprit.
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.
RegisterOdoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.
Test it nowQuestion tools
Stats
Asked: 4/12/13, 10:02 PM |
Seen: 4532 times |
Last updated: 4/7/17, 11:20 AM |