I have a function which creates 100s of records in a model running in a loop. However, I have noticed that many times, not all the records are created and some have been skipped. If I try again, it works, but the issue seems to be random. I assumed that overloading the create record statements caused the postgres server error out, but I have no idea. The logs also do not mentioned any issues. Could someone please tell me if there is any way of verifying that each record is created before continuing the iteration?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project
- MRP
This question has been flagged
2
Replies
4848
Views
Hi, Shawn
Thanks for posting the above question. You can use "self._cr.commit()" by end of every iteration. Like below example,
for data in listdata:
self.env['model'].create(data)
self._cr.commit()
Thanks,
Ashish Singh (Team Lead)
Webkul Software Private Limited
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
Error Restoring database
Solved
|
|
1
Oct 15
|
25645 | |
|
0
Mar 15
|
5218 | ||
|
0
Mar 16
|
5162 | ||
|
1
Mar 15
|
7132 | ||
|
3
Jul 25
|
8789 |
could you pls post your code, I'm creating records by code, varying in numbers, max number I created was 25 with no fail. let us check your code to get more insight into your problem