0030438: Error shown about duplicate insertion on c_order table when building the system via GUI

Description

Installing/updating a module or every task related with a system rebuild is broken because of an error shown on the Initial Build Validation step on the rebuilding GUI window. See screenshot with the error.

Steps To Reproduce

The root causes for firing this issue are not known, but it can be seen just by trying to install any module or updating an existent one.
On the very start of the build, the first step, Build Validation, fails and an error is shown.
The error looks like this:

2015-07-27 19:34:33,040 [Import Entry - 1] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into C_Order (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, IsSOTrx, DocumentNo, DocStatus, DocAction, Processing, Processed, C_DocType_ID, C_DocTypeTarget_ID, Description, IsDelivered, IsInvoiced, IsPrinted, IsSelected, SalesRep_ID, DateOrdered, DatePromised, DateAcct, C_BPartner_ID, BillTo_ID, C_BPartner_Location_ID, IsDiscountPrinted, C_Currency_ID, PaymentRule, C_PaymentTerm_ID, InvoiceRule, DeliveryRule, FreightCostRule, DeliveryViaRule, ChargeAmt, PriorityRule, TotalLines, GrandTotal, M_Warehouse_ID, M_PriceList_ID, IsTaxIncluded, Posted, AD_User_ID, CopyFrom, IsSelfService, Generatetemplate, CopyFromPO, FIN_Paymentmethod_ID, RM_PickFromShipment, RM_ReceiveMaterials, RM_CreateInvoice, RM_AddOrphanLine, Calculate_Promotions, Convertquotation, Create_POLines, EM_Obdisc_Addpack, Iscashvat, RM_Pickfromreceipt, EM_APRM_AddPayment, EM_Obpos_Applications_ID, EM_Obpos_App_Cashup_ID, EM_Obpos_Sendemail, EM_Obpos_Createdabsolute, EM_OBPOS_NotInvoiceOnCashUp, C_Order_ID) values ('39363B0921BB4293B48383844325E84C', 'D270A5AC50874F8BA67A88EE977F8E3B', 'Y', '2015-07-25 08:38:16.000000 +00:00:00', '3073EDF96A3C42CC86C7069E379522D2', '2015-07-27 19:34:33.012000 +00:00:00', '3073EDF96A3C42CC86C7069E379522D2', 'Y', 'VBS1/0000120', 'CO', '--', 'N', 'Y', '511A9371A0F74195AA3F6D66C722729D', '511A9371A0F74195AA3F6D66C722729D', '', 'N', 'N', 'Y', 'N', '3073EDF96A3C42CC86C7069E379522D2', '2015-07-25 00:00:00.000000 +00:00:00', '2015-07-25 00:00:00.000000 +00:00:00', '2015-07-25 00:00:00.000000 +00:00:00', 'ABD91C9D3BC94175B876FBBE9CACA008', '2AA7EADDF7EC405899262DDA3E572436', '2AA7EADDF7EC405899262DDA3E572436', 'N', '102', 'B', '8FA47FB95432495596F11D59B686ACEC', 'I', 'A', 'I', 'P', '0', '5', '124.38', '150.50', 'CE7AB151695342FF879938F837F12E6E', '496CF965DF9744D2A41248392D1DE407', 'Y', 'N', '032576220FC44B0DA80145B3265E4D9A', 'N', 'N', 'N', 'N', '45A202BF44884F05B8A1BF741E2063B6', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', '9104513C2D0741D4850AE8493998A7C8', '516157425D119B9E6327A1D34CD6812C', 'N', '2015-07-25 10:38:16.000000 +00:00:00', 'N', '09456D2984F7CC29E6D4BAFA3C611446') was aborted. Call getNextException to see the cause.
2015-07-27 19:34:33,041 [Import Entry - 1] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: current transaction is aborted, commands ignored until end of transaction block
2015-07-27 19:34:33,044 [Import Entry - 1] WARN org.openbravo.mobile.core.process.DataSynchronizationProcess - Record in process org.openbravo.retail.posterminal.OrderLoader duplicated with id: 09456D2984F7CC29E6D4BAFA3C611446 Error not saved.

Tags

No tags attached.

Attached Files

Untitled.jpg [^] (145,589 bytes) 2015-07-28 13:45

Relationships [ Relation Graph ] [ Dependency Graph ]

depends on	backport	0030524	RR15Q3	closed	jorge-garcia	Error shown about duplicate insertion on c_order table when building the system via GUI
related to	defect	0030482	pi	closed	jorge-garcia	Wrong error logging makes the disk full in a short period of time

Notes
(0079377) dmitry_mezentsev (viewer) 2015-08-17 09:57	Similar here guys. If this is PI issue it must have 2 backports (btw they should have "Approved" tag or RM will ignore them) to Q2 and Q3.

(0080049) jorge-garcia (viewer) 2015-09-03 13:41	Fixed by this issue: https://issues.openbravo.com/view.php?id=30482 [^]

Issue History
Date Modified	Username	Field	Change
2015-07-28 13:45	plujan	New Issue
2015-07-28 13:45	plujan	Assigned To	=> alostale
2015-07-28 13:45	plujan	File Added: Untitled.jpg
2015-07-28 13:45	plujan	OBNetwork customer	=> No
2015-07-28 13:45	plujan	Regression level	=> QA functional test
2015-07-28 13:45	plujan	Regression introduced in release	=> main
2015-07-28 13:45	plujan	Triggers an Emergency Pack	=> No
2015-07-28 13:46	alostale	Assigned To	alostale => Retail
2015-08-03 12:37	plujan	Relationship added	related to 0030482
2015-08-07 14:27	jorge-garcia	Target Version	RR15Q3 => pi
2015-08-07 14:28	jorge-garcia	Assigned To	Retail => jorge-garcia
2015-08-07 14:28	jorge-garcia	Status	new => scheduled
2015-08-17 09:57	dmitry_mezentsev	Note Added: 0079377
2015-09-03 13:10	jorge-garcia	Summary	[RR15Q3] Error shown about duplicate insertion on c_order table when building the system via GUI => Error shown about duplicate insertion on c_order table when building the system via GUI
2015-09-03 13:41	jorge-garcia	Review Assigned To	=> jorge-garcia
2015-09-03 13:41	jorge-garcia	Note Added: 0080049
2015-09-03 13:41	jorge-garcia	Status	scheduled => closed
2015-09-03 13:41	jorge-garcia	Resolution	open => no change required