Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027199Retail ModulesWeb POSpublic2014-07-25 12:322016-03-08 20:40
ReporterOrekaria 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToOrekaria
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027199: Backend ERROR: org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into OBPOS_App_Cashup (...) was aborted
DescriptionShown in the 205 build of ret-test-oracle: https://ci.openbravo.com/view/retail/job/ret-test-oracle/205/artifact/SANDBOX/tomcat-logs/ret-test-oracle.log [^]

2014-07-25 07:51:52,329 [TP-Processor1] INFO org.openbravo.retail.posterminal.CashCloseProcessor - Cash Up Info. Total time: 7. Init: 0. Reconciliation: 5. Cash Up Reconciliation: 1. Payment and Deposit Transactions: 0. Associate Transactions: 1
2014-07-25 07:51:52,337 [TP-Processor1] INFO org.openbravo.retail.posterminal.CashCloseProcessor - Cash Up Info. Total time: 8. Init: 0. Reconciliation: 6. Cash Up Reconciliation: 1. Payment and Deposit Transactions: 0. Associate Transactions: 1
2014-07-25 07:51:52,393 [TP-Processor1] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (RET_TEST_ORACLE.OBPOS_APPCASH_PK) violated
2014-07-25 07:51:52,394 [TP-Processor1] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (RET_TEST_ORACLE.OBPOS_APPCASH_PK) violated
2014-07-25 07:51:52,427 [TP-Processor1] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (RET_TEST_ORACLE.OBPOS_APPCASH_PK) violated
2014-07-25 07:51:52,427 [TP-Processor1] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00001: unique constraint (RET_TEST_ORACLE.OBPOS_APPCASH_PK) violated
2014-07-25 07:51:52,441 [TP-Processor1] WARN org.openbravo.mobile.core.process.DataSynchronizationProcess - Record in process org.openbravo.retail.posterminal.ProcessCashCloseduplicated with id: B7CBF3805AC28D090B1381065086019E Error not saved.
2014-07-25 07:51:52,472 [TP-Processor1] INFO org.openbravo.mobile.core.process.DataSynchronizationProcess - Final total time: 527


Another trace from ret-test-pgsql 368 (https://ci.openbravo.com/job/ret-test-pgsql/368/consoleText [^]):

2014-07-25 11:02:06,474 [TP-Processor12] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into OBPOS_App_Cashup (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Obpos_Applications_ID, Cashupdate, AD_User_ID, Cashupreport, Obpos_App_Cashup_ID) values ('39363B0921BB4293B48383844325E84C', 'D270A5AC50874F8BA67A88EE977F8E3B', 'Y', '2014-07-25 11:02:06.308000 +00:00:00', '3073EDF96A3C42CC86C7069E379522D2', '2014-07-25 11:02:06.308000 +00:00:00', '3073EDF96A3C42CC86C7069E379522D2', '9104513C2D0741D4850AE8493998A7C8', '2014-07-25 11:02:01.000000 +00:00:00', '3073EDF96A3C42CC86C7069E379522D2', 'N', 'C0A2B970623CC80890874119623A8064') was aborted. Call getNextException to see the cause.
2014-07-25 11:02:06,475 [TP-Processor12] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: duplicate key value violates unique constraint "obpos_appcash_pk"
2014-07-25 11:02:06,557 [TP-Processor12] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into OBPOS_App_Cashup (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Obpos_Applications_ID, Cashupdate, AD_User_ID, Cashupreport, Obpos_App_Cashup_ID) values ('39363B0921BB4293B48383844325E84C', 'D270A5AC50874F8BA67A88EE977F8E3B', 'Y', '2014-07-25 11:02:06.308000 +00:00:00', '3073EDF96A3C42CC86C7069E379522D2', '2014-07-25 11:02:06.308000 +00:00:00', '3073EDF96A3C42CC86C7069E379522D2', '9104513C2D0741D4850AE8493998A7C8', '2014-07-25 11:02:01.000000 +00:00:00', '3073EDF96A3C42CC86C7069E379522D2', 'N', 'C0A2B970623CC80890874119623A8064') was aborted. Call getNextException to see the cause.
2014-07-25 11:02:06,557 [TP-Processor12] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: current transaction is aborted, commands ignored until end of transaction block
2014-07-25 11:02:06,573 [TP-Processor12] WARN org.openbravo.mobile.core.process.DataSynchronizationProcess - Record in process org.openbravo.retail.posterminal.ProcessCashCloseduplicated with id: C0A2B970623CC80890874119623A8064 Error not saved.
Steps To ReproduceThis error is consistently reproduced by the CashupWithSaleAndReturn test at pi-mobile
Proposed SolutionThese messages are showing that the logic to check duplicates is working. But, maybe, there is no need to show them as warnings or errors, unless there is a race condition.

Change the flow to show an error only if a race condition is performed.

Check DataSynchronizationProcess.saveRecord()
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0027337 acknowledged Retail Stabilization: No tomcat errors while running the WebPOS 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-07-25 12:32OrekariaNew Issue
2014-07-25 12:32OrekariaAssigned To => marvintm
2014-07-25 12:32OrekariaOBNetwork customer => No
2014-07-25 12:32OrekariaTriggers an Emergency Pack => No
2014-07-25 12:33OrekariaDescription Updatedbug_revision_view_page.php?rev_id=6171#r6171
2014-07-25 13:27OrekariaSummaryret-test-oracle: error org.hibernate.util.JDBCExceptionReporter - ORA-00001 => Backend ERROR: org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into OBPOS_App_Cashup (...) was aborted
2014-07-25 13:27OrekariaDescription Updatedbug_revision_view_page.php?rev_id=6172#r6172
2014-07-25 13:28OrekariaDescription Updatedbug_revision_view_page.php?rev_id=6173#r6173
2014-07-25 13:32OrekariaDescription Updatedbug_revision_view_page.php?rev_id=6174#r6174
2014-07-25 16:03OrekariaProposed Solution updated
2014-07-29 08:37OrekariaReproducibilityhave not tried => always
2014-07-29 08:37OrekariaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=6203#r6203
2014-08-14 13:23OrekariaRelationship addedblocks 0027337
2016-03-08 20:40OrekariaReview Assigned To => Orekaria
2016-03-08 20:40OrekariaNote Added: 0084838
2016-03-08 20:40OrekariaStatusnew => closed
2016-03-08 20:40OrekariaResolutionopen => unable to reproduce

Notes
(0084838)
Orekaria   
2016-03-08 20:40   
Unable to reproduce