Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0050016 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] French Fiscal | major | always | 2022-08-19 16:01 | 2022-09-05 17:07 | |||
| Reporter | jose_duque | View Status | public | |||||
| Assigned To | Triage Omni OMS | |||||||
| Priority | high | Resolution | no change required | 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 | |||||||
| Regression date | ||||||||
| Regression introduced by commit | ||||||||
| Regression level | ||||||||
| Review Assigned To | aferraz | |||||||
| Regression introduced in release | ||||||||
| Summary | 0050016: Error when paying a cancel and replace with another ticket using pay open tickets | |||||||
| Description | We get an error when paying two open tickets, one a cancel and replace and a normal one. Basically because there is no update of a seq number related to taxes. Error: Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into OBCFR_TicketTax (AD_Client_ID, AD_Org_ID, Isactive, Created, Createdby, Updated, Updatedby, Obcfr_Ticket_ID, Obpos_Applications_ID, Taxrate, Taxbase, Taxamt, Prevhash, Hash, Hashtime, Documentno, Terminal, Seqno, Export, Obcfr_Tickettax_ID) values ('wwwwwwwwwwwwwwwww', 'xxxxxxxxxxxxxxx', 'Y', '2022-08-02 11:35:19.218+02', 'yyyyyyyyyyyyyy', '2022-08-02 11:35:19.218+02', 'zzzzzzzzzzzzzzzz', 'rrrrrrrrrrrrrrrrrrr', 'bbbbbbbbbbbbbbbbbbb', '20', '4.93', '0.98', 'aaaaaaaaaaaaaa', 'cccccccccccccccccc', 1659432919210, 'C0016A05/0000135', 'C0016A05', 154, 'N', 'ggggggggggggggggggg') was aborted: ERROR: duplicate key value violates unique constraint "obcfr_tickettax_term_seq" Detail: Key (obpos_applications_id, seqno)=(zzzzzzzzzzzzzzzzzzzzzzzzzzzz, 154) already exists. Call getNextException to see other errors in the batch. | |||||||
| Steps To Reproduce | Install module org.openbravo.certification.france - Create and complete an order - Load the order created in the POS - Make a cancel and replace - Add a product to the order - Create a new ticket - Pay both orders using Pay open tickets Check related issue for more details | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
Notes |
|
|
(0140503) aaroncalero (developer) 2022-08-30 13:22 |
Adding a bit more context: The issue is reproducible only in older Openbravo versions (20Q3 and earlier) since the synchronization mechanism was changed (the issue only occurs when there are multiple orders in the same import entry, which is no longer the case). In older versions: If, during the processing of multiple orders, a C&R order is processed before the other orders, this method [1] fails to store the new sequence when processing the negative ticket of the C&R and ends up duplicating it. As a workaround, on the client environment we have added a hook during the synchronization process to reorder the receipts within the import entry, to ensure that the Cancel and Replace order is always sent in the last position, therefore avoiding the problem in the certification code. [1] https://gitlab.com/openbravo/ci/modules/org.openbravo.certification.france.dev/-/blob/master/src/org/openbravo/certification/france/ticket/TicketUtils.java#L87 [^] |
|
(0140719) aferraz (manager) 2022-09-05 17:07 |
No change is required because workaround is working fine. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2022-08-19 16:01 | jose_duque | New Issue | |
| 2022-08-19 16:01 | jose_duque | Assigned To | => Retail |
| 2022-08-19 16:01 | jose_duque | Triggers an Emergency Pack | => No |
| 2022-08-19 16:01 | jose_duque | Issue generated from | 0049791 |
| 2022-08-19 16:02 | jose_duque | Relationship added | related to 0049770 |
| 2022-08-21 08:00 | marvintm | Assigned To | Retail => Triage Omni OMS |
| 2022-08-23 12:33 | vmromanos | Project | Retail Modules => Modules |
| 2022-08-23 12:33 | vmromanos | Category | Web POS => French Fiscal |
| 2022-08-23 12:33 | vmromanos | version | RR20Q3.4 => |
| 2022-08-23 12:33 | vmromanos | Status | new => acknowledged |
| 2022-08-30 13:22 | aaroncalero | Note Added: 0140503 | |
| 2022-09-05 17:06 | aferraz | Sticky Issue | No => Yes |
| 2022-09-05 17:06 | aferraz | Sticky Issue | Yes => No |
| 2022-09-05 17:06 | aferraz | Status | acknowledged => scheduled |
| 2022-09-05 17:07 | aferraz | Review Assigned To | => aferraz |
| 2022-09-05 17:07 | aferraz | Note Added: 0140719 | |
| 2022-09-05 17:07 | aferraz | Status | scheduled => closed |
| 2022-09-05 17:07 | aferraz | Resolution | open => no change required |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |