Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0038108
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2018-03-13 10:282018-03-19 09:48
ReportermaiteView Statuspublic 
Assigned Toranjith_qualiantech_com 
PriorityurgentResolutionfixedFixed in VersionRR18Q2
StatusclosedFix in branchFixed in SCM revision1dd5a639244a
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket340
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0038108: Business Partner stuck in Errors While Importing due to "violates unique constraint "ad_user_un_username"" error

DescriptionWhen several business partners with same name are created, the 4 first digits of uuid are concatenated to the value field in order to try to synchronize it. But this 4 first digits could not be unique so error is raised

org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "ad_user_un_username"
  Detail: Key (username)=(test_9B28) already exists.
Steps To Reproduce1. From the POS terminal, run "New customer" process. Set name= test and any address
2. Repeat step 1
3. Repeat step 1
3. Access backoffice and realize that Business Partner records with value "test", "test_9535" and "test_4EDE" and User records with same usernames have been created

In case uuid generated starts with the same 4 digits you will obtain the error and Business Partner will be stuck in Errors While Importing window
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0103233)
hgbot (developer)
2018-03-14 09:48

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 1dd5a639244ae28edf77e6baf196137e2f3cdc21
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Wed Mar 14 14:18:10 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1dd5a639244ae28edf77e6baf196137e2f3cdc21 [^]

Fixed issue 38108 : Unique search key should be generated while adding new customers

* If Customer Search key already exists, new search key should be generated by appending 4 digit random number
* Same applies for User username

---
M src/org/openbravo/retail/posterminal/CustomerLoader.java
---

- Issue History
Date Modified Username Field Change
2018-03-13 10:28 maite New Issue
2018-03-13 10:28 maite Assigned To => Retail
2018-03-13 10:28 maite OBNetwork customer => Yes
2018-03-13 10:28 maite Support ticket => 340
2018-03-13 10:28 maite Resolution time => 1491170400
2018-03-13 10:28 maite Triggers an Emergency Pack => No
2018-03-13 10:28 maite Issue Monitored: networkb
2018-03-13 12:55 ranjith_qualiantech_com Assigned To Retail => ranjith_qualiantech_com
2018-03-13 12:55 ranjith_qualiantech_com Status new => scheduled
2018-03-13 13:05 marvintm Resolution time 1491170400 => 1522706400
2018-03-14 09:48 hgbot Checkin
2018-03-14 09:48 hgbot Note Added: 0103233
2018-03-14 09:48 hgbot Status scheduled => resolved
2018-03-14 09:48 hgbot Resolution open => fixed
2018-03-14 09:48 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1dd5a639244ae28edf77e6baf196137e2f3cdc21 [^]
2018-03-19 09:48 marvintm Review Assigned To => marvintm
2018-03-19 09:48 marvintm Status resolved => closed
2018-03-19 09:48 marvintm Fixed in Version => RR18Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker