Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0051509 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | always | 2023-01-30 17:30 | 2023-02-13 08:07 | |||
| Reporter | sofidossant | View Status | public | |||||
| Assigned To | ranjith_qualiantech_com | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | RR23Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0146202) hgbot (developer) 2023-02-03 07:48 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1056 [^] |
|
(0146203) hgbot (developer) 2023-02-03 07:48 |
Merge Request created: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/263 [^] |
|
(0146411) hgbot (developer) 2023-02-13 08:07 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/1056 [^] |
|
(0146412) hgbot (developer) 2023-02-13 08:07 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^] Changeset: fbd73ffbfb5fe1b30c628ea1feda489c9f6f6d84 Author: Ranjith S R <ranjith@qualiantech.com> Date: 13-02-2023 07:07:15 URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/fbd73ffbfb5fe1b30c628ea1feda489c9f6f6d84 [^] Fixed ISSUE-51509: SearchKey should be update with AlphaNumeric instead of number * When adding customer and search is duplicate, then searchKwy should be appened with 5characters of AlphaNumeric --- M src/org/openbravo/retail/posterminal/CustomerLoader.java --- |
|
(0146413) hgbot (developer) 2023-02-13 08:07 |
Repository: https://gitlab.com/openbravo/ci/mobile-test [^] Changeset: 7c94f8d64d01279bc4887199379147c47430bd67 Author: Ranjith S R <ranjith@qualiantech.com> Date: 13-02-2023 07:07:39 URL: https://gitlab.com/openbravo/ci/mobile-test/-/commit/7c94f8d64d01279bc4887199379147c47430bd67 [^] Related to ISSUE-51509: Updated test I34168_verifyCustomerNameLength --- M src-test/org/openbravo/test/mobile/retail/pack/selenium/tests/receipts/I34168_verifyCustomerNameLength.java --- |
|
(0146414) hgbot (developer) 2023-02-13 08:07 |
Merge request merged: https://gitlab.com/openbravo/ci/mobile-test/-/merge_requests/263 [^] |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |