Openbravo Issue Tracking System - POS2
View Issue Details
0055241POS2POSpublic2024-03-21 09:592024-04-18 13:26
ngarcia 
Rajesh_18 
urgentmajorunable to reproduce
closedfixed 
5
 
24Q224Q2 
No
0055241: 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.
blocks defect 0055022 closed Rajesh_18 Data Import Entry of OBPOS2_UpdateTerminalTypeUserConfiguration type in Error if they are processed at the same time 
Issue History
2024-04-18 12:43marvintmTypedefect => backport
2024-04-18 12:43marvintmTarget Version => 24Q2
2024-04-18 13:06hgbotNote Added: 0163370
2024-04-18 13:26hgbotNote Added: 0163380
2024-04-18 13:26hgbotResolutionopen => fixed
2024-04-18 13:26hgbotStatusscheduled => closed
2024-04-18 13:26hgbotFixed in Version => 24Q2
2024-04-18 13:26hgbotNote Added: 0163381

Notes
(0163370)
hgbot   
2024-04-18 13:06   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2573 [^]
(0163380)
hgbot   
2024-04-18 13:26   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2573 [^]
(0163381)
hgbot   
2024-04-18 13:26   
Directly closing issue as related merge request is already approved.

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

Fixed ISSUE-55241: 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
---