Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030438Retail ModulesRetail Configurationpublic2015-07-28 13:452015-09-03 13:41
Reporterplujan 
Assigned Tojorge-garcia 
PriorityurgentSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Versionmain 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned Tojorge-garcia
OBNetwork customerNo
Support ticket
Regression levelQA functional test
Regression date
Regression introduced in releasemain
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030438: Error shown about duplicate insertion on c_order table when building the system via GUI
DescriptionInstalling/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 ReproduceThe 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0030524RR15Q3 closed jorge-garcia Error shown about duplicate insertion on c_order table when building the system via GUI 
related to defect 0030482pi closed jorge-garcia Wrong error logging makes the disk full in a short period of time 
Attached Filesjpg Untitled.jpg (145,589) 2015-07-28 13:45
https://issues.openbravo.com/file_download.php?file_id=8309&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2015-07-28 13:45plujanNew Issue
2015-07-28 13:45plujanAssigned To => alostale
2015-07-28 13:45plujanFile Added: Untitled.jpg
2015-07-28 13:45plujanOBNetwork customer => No
2015-07-28 13:45plujanRegression level => QA functional test
2015-07-28 13:45plujanRegression introduced in release => main
2015-07-28 13:45plujanTriggers an Emergency Pack => No
2015-07-28 13:46alostaleAssigned Toalostale => Retail
2015-08-03 12:37plujanRelationship addedrelated to 0030482
2015-08-07 14:27jorge-garciaTarget VersionRR15Q3 => pi
2015-08-07 14:28jorge-garciaAssigned ToRetail => jorge-garcia
2015-08-07 14:28jorge-garciaStatusnew => scheduled
2015-08-17 09:57dmitry_mezentsevNote Added: 0079377
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
2015-09-03 13:41jorge-garciaReview Assigned To => jorge-garcia
2015-09-03 13:41jorge-garciaNote Added: 0080049
2015-09-03 13:41jorge-garciaStatusscheduled => closed
2015-09-03 13:41jorge-garciaResolutionopen => no change required

Notes
(0079377)
dmitry_mezentsev   
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   
2015-09-03 13:41   
Fixed by this issue:

https://issues.openbravo.com/view.php?id=30482 [^]