[Adempiere-trackers] [ adempiere-Bugs-2002234 ] MRP error after Calculate Distribution Plan

[SourceForge.net <no...@so...>]

Bugs item #2002234, was opened at 2008-06-25 06:55
Message generated for change (Comment added) made by hgsiebert
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=879332&aid=2002234&group_id=176962

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Manufacturing Order
Group: v3.5.1
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Heinz-Guenter Siebert (hgsiebert)
Assigned to: Nobody/Anonymous (nobody)
Summary: MRP error after Calculate Distribution Plan

Initial Comment:
OS: W2K
Java: Java 1.6.0_06
DBMS: PostgreSQL 8.2.7 with pljava 1.3
Adempiere: branches/stable revision 5513

Calculate Distribution Plan give some errors as attached.

----------------------------------------------------------------------

>Comment By: Heinz-Guenter Siebert (hgsiebert)
Date: 2008-06-30 13:05

Message:
Logged In: YES 
user_id=548149
Originator: YES

DB.executeUpdate: DELETE FROM PP_Order_Node WHERE PP_Order_Node_ID=1000000
[SvrProcess_5a59ae43-3b94-489c-a098-601893db5621] [66]
org.postgresql.util.PSQLException: ERROR: update or delete on table
"pp_order_node" violates foreign key constraint
"ppordernode_ppordernodenext" on table "pp_order_nodenext"
  Detail: Key (pp_order_node_id)=(1000000) is still referenced from table
"pp_order_nodenext".; State=23503; ErrorCode=0

Bug was based on user error, when updaating the database via screened
migration scripts.
Manual delete of foreign key value solves problem. 

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=879332&aid=2002234&group_id=176962