Project: 	
  | View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0055242 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [POS2] POS | major | unable to reproduce | 2024-03-21 09:59 | 2024-04-18 13:26 | |||
| Reporter | ngarcia | View Status | public | |||||
| Assigned To | Rajesh_18 | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | 24Q1.2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | 24Q1.2 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | approved | |||||||
| Review Assigned To | ||||||||
| OBNetwork customer | Gold | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0055242: Data Import Entry of OBPOS2_UpdateTerminalTypeUserConfiguration type in Error if they are processed at the same time | |||||||
| Description | 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 | |||||||
| Steps To Reproduce | 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
|  Relationships		[ Relation Graph ] 
		[ Dependency Graph ] | ||||||||
| 
 | ||||||||
|  Notes | |
| (0163372) hgbot (developer) 2024-04-18 13:11 | Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2575 [^] | 
| (0163378) hgbot (developer) 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: ff451d20d1bb1798dbdb2bd7ae89368b1b6d677f Author: Rajesh Senthilkumar <rajesh@qualiantech.com> Date: 18-04-2024 16:40:01 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/commit/ff451d20d1bb1798dbdb2bd7ae89368b1b6d677f [^] Fixed ISSUE-55242: 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 --- | 
| (0163379) hgbot (developer) 2024-04-18 13:26 | Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/2575 [^] | 
|  Issue History | |||
| Date Modified | Username | Field | Change | 
| 2024-04-18 12:43 | marvintm | Type | defect => backport | 
| 2024-04-18 12:43 | marvintm | Target Version | => 24Q1.2 | 
| 2024-04-18 13:11 | hgbot | Note Added: 0163372 | |
| 2024-04-18 13:26 | hgbot | Merge Request Status | open => approved | 
| 2024-04-18 13:26 | hgbot | Resolution | open => fixed | 
| 2024-04-18 13:26 | hgbot | Status | scheduled => closed | 
| 2024-04-18 13:26 | hgbot | Fixed in Version | => 24Q1.2 | 
| 2024-04-18 13:26 | hgbot | Note Added: 0163378 | |
| 2024-04-18 13:26 | hgbot | Note Added: 0163379 | |
| Copyright © 2000 - 2009 MantisBT Group |