Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0051509 | Retail Modules | Web POS | public | 2023-01-30 17:30 | 2023-02-13 08:07 |
| Reporter | sofidossant | ||||
| Assigned To | ranjith_qualiantech_com | ||||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | Fixed in Version | RR23Q2 | |||
| Merge Request Status | approved | ||||
| Review Assigned To | |||||
| OBNetwork customer | Gold | ||||
| Support ticket | 6750 | ||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0051509: Business Partner stuck in Errors While Importing due to "violates unique constraint "ad_user_un_username"" error | ||||
| Description | Relation https://issues.openbravo.com/view.php?id=38108 [^] The solution for this problem 38108 in the JAVA CustomerLoader It has a for, with a limit of 10000 and in NORAUTO we have already passed to 10000. for (int i = 0; i < 10000; i++) { final OBCriteria<org.openbravo.model.ad.access.User> userCriteria = OBDal.getInstance() .createCriteria(org.openbravo.model.ad.access.User.class); userCriteria.add(Restrictions.eq("username", possibleUsername)); this generates the error and we cannot save the business partners, and we have already reached 10000 with the same name. openbravo=> select * from aD_user where username ilike '%. ._%' limit 10; openbravo=> select count(*) from aD_user where username ilike '%. ._%'; count ------- 10429 (1 row) | ||||
| Steps To Reproduce | 1- Do 10000 users with the same name 2- When you do the 10001 user with the same name, we have a ewi with null pointer | ||||
| Proposed Solution | add a preference with the number for the FOR | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2023-01-30 17:30 | sofidossant | New Issue | |||
| 2023-01-30 17:30 | sofidossant | Assigned To | => ranjith_qualiantech_com | ||
| 2023-01-30 17:30 | sofidossant | OBNetwork customer | => Gold | ||
| 2023-01-30 17:30 | sofidossant | Support ticket | => 6750 | ||
| 2023-01-30 17:30 | sofidossant | Triggers an Emergency Pack | => No | ||
| 2023-01-31 11:57 | ranjith_qualiantech_com | Status | new => scheduled | ||
| 2023-02-03 07:48 | hgbot | Merge Request Status | => open | ||
| 2023-02-03 07:48 | hgbot | Note Added: 0146202 | |||
| 2023-02-03 07:48 | hgbot | Note Added: 0146203 | |||
| 2023-02-13 08:07 | hgbot | Merge Request Status | open => approved | ||
| 2023-02-13 08:07 | hgbot | Resolution | open => fixed | ||
| 2023-02-13 08:07 | hgbot | Status | scheduled => closed | ||
| 2023-02-13 08:07 | hgbot | Note Added: 0146411 | |||
| 2023-02-13 08:07 | hgbot | Fixed in Version | => RR23Q2 | ||
| 2023-02-13 08:07 | hgbot | Note Added: 0146412 | |||
| 2023-02-13 08:07 | hgbot | Note Added: 0146413 | |||
| 2023-02-13 08:07 | hgbot | Note Added: 0146414 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||