Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi,
i'm using Odoo v8 since a year and now i'm getting the following Integrity Error during the creation of a Quotation:
Integrity Error
The operation cannot be completed, probably due to the following:
- deletion: you may be trying to delete a record while other records still reference it
- creation/update: a mandatory field is not correctly set
[object with reference: access_token - access.token]
Does anybody know what's the reason for this error and how I can resolve it?
I checked the log of the PostgreSQL and it shows the following:
ERROR: null value in column "access_token" violates not-null constraint
DETAIL: Failing row contains (186, null, 2017-12-13 08:23:57.746334, 1, null, 2017-12-13 08:23:47, 148, null, null, null, null, null, null, 1, Payment conditions: In case of greater amounts we request a pre-..., draft, 1, 1, null, 2017-12-13 08:23:57.746334, 148, 1, null, null, null, AN-186, 148, manual, direct, null, 1, f, null, null, null, null, null, null, null, null).
STATEMENT: INSERT INTO "sale_order" ("id", "origin", "picking_policy", "order_policy", "campaign_id", "carrier_id", "client_order_ref", "date_order", "partner_id", "fiscal_position", "user_id", "payment_term", "company_id", "note", "state", "pricelist_id", "project_id", "incoterm", "section_id", "warehouse_id", "partner_invoice_id", "name", "medium_id", "partner_shipping_id", "shipped", "source_id", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('sale_order_id_seq'), NULL, 'direct', 'manual', NULL, NULL, NULL, '2017-12-13 08:23:47', 148, NULL, 1, NULL, 1, 'Payment conditions: In case of
', 'draft', 1, NULL, NULL, NULL, 1, 148, 'AN-186', NULL, 148, false, NULL, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
How you done any customization in the database ?
Normally we get this error when the value for the required field is not given either directly or through the code. Check it
Yes, we deleted an invoice. I know it's not perfect to do it with the invoice_cancel application. But could this be the reason?