Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0027199 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2014-07-25 12:32 | 2016-03-08 20:40 | |||
| Reporter | Orekaria | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | unable to reproduce | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | Orekaria | |||||||
| 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() | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
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 | View Revisions |
| 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 | View Revisions |
| 2014-07-25 13:28 | Orekaria | Description Updated | View Revisions |
| 2014-07-25 13:32 | Orekaria | Description Updated | View Revisions |
| 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 | View Revisions |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |