Openbravo Issue Tracking System - POS2
View Issue Details
0055022POS2POSpublic2024-03-21 09:592024-04-18 12:52
ngarcia 
Rajesh_18 
urgentmajorunable to reproduce
closedfixed 
5
 
24Q3 
No
0055022: Data Import Entry of OBPOS2_UpdateTerminalTypeUserConfiguration type in Error if they are processed at the same time
Data Import Entry of OBPOS2_UpdateTerminalTypeUserConfiguration type in Error if they are processed at the same time.

This type of Data Import Entry doesn't include the POS Terminal, so both might be processed together
Two Data Import Entries of OBPOS2_UpdateTerminalTypeUserConfiguration type and for the same ad_user and terminal type should be processed at the same time

The Data Import Entry will be in Error with the following error:

org.openbravo.base.validation.ValidationException: OBPOS_Errors.typeofdata: Property OBPOS_Errors.typeofdata, value (OBPOS2_UpdateTerminalTypeUserConfiguration) is not allowed, it should be one of the following values: [Order, OBPOS_Invoice, GCNV_RevertGiftCardAmount, GCNV_GiftCardCertificate, BusinessPartner, FIN_Finacc_Transaction, OBPOS2_Pop, OBPOS_CancelLayaway, ReprintableDocument, OBPOS2_Keymap, BusinessPartnerLocation, GCNV_CancelGiftCardTransaction, OBPOS_SafeBox, GCNV_ConsumeGiftCardLines, OBPOS_IsOrderCancelled, POSS_Terminal_Sessions, OBPOS_VoidLayaway, GCNV_CancelGiftcard, OBPOS_App_Cashup] but it is value OBPOS2_UpdateTerminalTypeUserConfiguration

The log shows:

2024-03-20 18:17:07,918 [Import Entry - 4] ERROR org.hibernate.engine.jdbc.batch.internal.BatchingBatch - HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 0 insert into obpos2_user_ttype_config (Isactive, Created, Createdby, Updated, Updatedby, AD_User_ID, Obpos_Terminaltype_ID, Thememode, AD_Client_ID, AD_Org_ID, Obpos2_User_Ttype_Config_ID) values ('Y', '2024-03-20 18:17:07.917+01', 'E1B4728048D449CBAA4E9FB66CBE8029', '2024-03-20 18:17:07.917+01', 'E1B4728048D449CBAA4E9FB66CBE8029', 'E1B4728048D449CBAA4E9FB66CBE8029', 'C78BD7FCD4FB4D28A4D57210C8DD9A33', 'lightMode', 'FF10900830F24E57BD135946AC35754C', '6E30862363B04886952339027AE8739F', 'BF43D0C8FFC54EB7BB68941B689CA693') was aborted: ERROR: duplicate key value violates unique constraint "obpos2_userttype_uq"
  Detail: Key (ad_user_id, obpos_terminaltype_id)=(E1B4728048D449CBAA4E9FB66CBE8029, C78BD7FCD4FB4D28A4D57210C8DD9A33) already exists. Call getNextException to see other errors in the batch.], SQL: insert into obpos2_user_ttype_config (Isactive, Created, Createdby, Updated, Updatedby, AD_User_ID, Obpos_Terminaltype_ID, Thememode, AD_Client_ID, AD_Org_ID, Obpos2_User_Ttype_Config_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
No tags attached.
related to defect 0055010 closed Rajesh_18 OBPOS2_UpdateTerminalTypeUserConfiguration value should be included in the Types of data to be synchronized in Web POS reference 
depends on backport 005524124Q2 closed Rajesh_18 Data Import Entry of OBPOS2_UpdateTerminalTypeUserConfiguration type in Error if they are processed at the same time 
depends on backport 005524224Q1.2 closed Rajesh_18 Data Import Entry of OBPOS2_UpdateTerminalTypeUserConfiguration type in Error if they are processed at the same time 
Issue History
2024-03-21 09:59ngarciaNew Issue
2024-03-21 09:59ngarciaAssigned To => Retail
2024-03-21 09:59ngarciaTriggers an Emergency Pack => No
2024-03-21 10:00ngarciaRelationship addedrelated to 0055010
2024-03-26 15:19guilleaerStatusnew => acknowledged
2024-03-27 14:11Rajesh_18Assigned ToRetail => Rajesh_18
2024-03-27 14:11Rajesh_18Statusacknowledged => scheduled
2024-04-03 07:36hgbotNote Added: 0162797
2024-04-18 12:43marvintmStatusscheduled => acknowledged
2024-04-18 12:43marvintmStatusacknowledged => scheduled
2024-04-18 12:52hgbotResolutionopen => fixed
2024-04-18 12:52hgbotStatusscheduled => closed
2024-04-18 12:52hgbotFixed in Version => 24Q3
2024-04-18 12:52hgbotNote Added: 0163368
2024-04-18 12:52hgbotNote Added: 0163369

Notes
(0162797)
hgbot   
2024-04-03 07:36   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2538 [^]
(0163368)
hgbot   
2024-04-18 12:52   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2 [^]
Changeset: a6db87579bf05ae696fa32e33c08e22d764cb8a3
Author: Rajesh Senthilkumar <rajesh@qualiantech.com>
Date: 18-04-2024 16:16:38
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/a6db87579bf05ae696fa32e33c08e22d764cb8a3 [^]

Fixed ISSUE-55022: Added posTerminal id to set terminal in the import entry

---
A src/org/openbravo/pos2/importprocess/TerminalTypeUserConfigurationLoaderPREEntryProcessor.java
M web-jspack/org.openbravo.pos2/src/model/setting/hooks/UpdateTerminalTypeUserConfiguration.js
---
(0163369)
hgbot   
2024-04-18 12:52   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2538 [^]