Openbravo Issue Tracking System - Retail Modules
View Issue Details
0030524Retail ModulesRetail Configurationpublic2015-07-28 13:452015-09-03 13:10
plujan 
jorge-garcia 
urgentcriticalhave not tried
closedfixed 
5
main 
RR15Q3RR15Q3 
marvintm
No
QA functional test
main
No
0030524: Error shown about duplicate insertion on c_order table when building the system via GUI
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.
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.
No tags attached.
blocks defect 0030438pi closed jorge-garcia Error shown about duplicate insertion on c_order table when building the system via GUI 
Issue History
2015-08-07 14:28jorge-garciaTypedefect => backport
2015-08-07 14:28jorge-garciaTarget Versionpi => RR15Q3
2015-08-10 08:58guilleaerNote Added: 0079268
2015-08-10 08:58guilleaerStatusscheduled => resolved
2015-08-10 08:58guilleaerFixed in Version => RR15Q3
2015-08-10 08:58guilleaerResolutionopen => fixed
2015-08-12 10:44marvintmReview Assigned To => marvintm
2015-08-12 10:44marvintmStatusresolved => closed
2015-09-03 13:10jorge-garciaSummary[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

Notes
(0079268)
guilleaer   
2015-08-10 08:58   
Resolved by this commit

http://code.openbravo.com/retail/backports/3.0RR15Q3/org.openbravo.mobile.core/rev/afd196d6fa44957ee17c4b153f9f2c06367ca22d [^]