c2c-oerpscenario team mailing list archive

[cosubo <807525@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

I can't perform a POS REFUND due to this error, what I've been able to
find is posted in the ERP forums (link below):

The error message:

"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: Partner Contact - res.partner.address]"

The server log lines:

"[2011-07-07 19:45:02,331][tst_v6-csb] ERROR:db.cursor:bad query: insert into "stock_picking" (id,"origin","address_id","number_of_packages","date_done","carrier_tracking_ref","carrier_id","volume","pos_order","date","invoice_type_id","location_id","stock_journal_id","purchase_id","backorder_id","name","auto_picking","move_type","sale_id","company_id","invoice_state","note","state","location_dest_id","type",create_uid,create_date) values (3695,E'POS/3925',2608,0,NULL,NULL,NULL,0.0,3047,E'2011-07-07 19:45:01',NULL,NULL,NULL,NULL,NULL,E'POS/3925 (return)',E'True',E'direct',NULL,1,E'none',E'POS notes ',E'draft',NULL,E'in',1,now())
Traceback (most recent call last):
  File "sql_db.pyo", line 131, in execute
IntegrityError: insert or update on table "stock_picking" violates foreign key constraint "stock_picking_address_id_fkey"
DETAIL:  Key (address_id)=(2608) is not present in table "res_partner_address"."

The findings: http://www.openerp.com/forum/post87033.html#p87033

Is this a bug??


Thank you for your help,
n.

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/807525

Title:
  POS REFUND (Integrity Error - res.partner.address)

Status in OpenERP Modules (addons):
  New

Bug description:
  I can't perform a POS REFUND due to this error, what I've been able to
  find is posted in the ERP forums (link below):

  The error message:

  "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: Partner Contact - res.partner.address]"

  The server log lines:

  "[2011-07-07 19:45:02,331][tst_v6-csb] ERROR:db.cursor:bad query: insert into "stock_picking" (id,"origin","address_id","number_of_packages","date_done","carrier_tracking_ref","carrier_id","volume","pos_order","date","invoice_type_id","location_id","stock_journal_id","purchase_id","backorder_id","name","auto_picking","move_type","sale_id","company_id","invoice_state","note","state","location_dest_id","type",create_uid,create_date) values (3695,E'POS/3925',2608,0,NULL,NULL,NULL,0.0,3047,E'2011-07-07 19:45:01',NULL,NULL,NULL,NULL,NULL,E'POS/3925 (return)',E'True',E'direct',NULL,1,E'none',E'POS notes ',E'draft',NULL,E'in',1,now())
  Traceback (most recent call last):
    File "sql_db.pyo", line 131, in execute
  IntegrityError: insert or update on table "stock_picking" violates foreign key constraint "stock_picking_address_id_fkey"
  DETAIL:  Key (address_id)=(2608) is not present in table "res_partner_address"."

  The findings: http://www.openerp.com/forum/post87033.html#p87033

  Is this a bug??

  
  Thank you for your help,
  n.

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/807525/+subscriptions