Openbravo Issue Tracking System - Retail Modules | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0027199 | Retail Modules | Web POS | public | 2014-07-25 12:32 | 2016-03-08 20:40 | |||||||
| Reporter | Orekaria | |||||||||||
| Assigned To | marvintm | |||||||||||
| Priority | normal | Severity | major | Reproducibility | always | |||||||
| Status | closed | Resolution | unable to reproduce | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | Orekaria | |||||||||||
| OBNetwork customer | ||||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0027199: Backend ERROR: org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into OBPOS_App_Cashup (...) was aborted | |||||||||||
| Description | Shown 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 Reproduce | This error is consistently reproduced by the CashupWithSaleAndReturn test at pi-mobile | |||||||||||
| Proposed Solution | These 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 | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2014-07-25 12:32 | Orekaria | New Issue | ||||||||||
| 2014-07-25 12:32 | Orekaria | Assigned To | => marvintm | |||||||||
| 2014-07-25 12:32 | Orekaria | Triggers an Emergency Pack | => No | |||||||||
| 2014-07-25 12:33 | Orekaria | Description Updated | bug_revision_view_page.php?rev_id=6171#r6171 | |||||||||
| 2014-07-25 13:27 | Orekaria | Summary | ret-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:27 | Orekaria | Description Updated | bug_revision_view_page.php?rev_id=6172#r6172 | |||||||||
| 2014-07-25 13:28 | Orekaria | Description Updated | bug_revision_view_page.php?rev_id=6173#r6173 | |||||||||
| 2014-07-25 13:32 | Orekaria | Description Updated | bug_revision_view_page.php?rev_id=6174#r6174 | |||||||||
| 2014-07-25 16:03 | Orekaria | Proposed Solution updated | ||||||||||
| 2014-07-29 08:37 | Orekaria | Reproducibility | have not tried => always | |||||||||
| 2014-07-29 08:37 | Orekaria | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=6203#r6203 | |||||||||
| 2014-08-14 13:23 | Orekaria | Relationship added | blocks 0027337 | |||||||||
| 2016-03-08 20:40 | Orekaria | Review Assigned To | => Orekaria | |||||||||
| 2016-03-08 20:40 | Orekaria | Note Added: 0084838 | ||||||||||
| 2016-03-08 20:40 | Orekaria | Status | new => closed | |||||||||
| 2016-03-08 20:40 | Orekaria | Resolution | open => unable to reproduce | |||||||||
| Notes | |||||
|
|
|||||
|
|
||||