Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0046864 | Retail Modules | Web POS | public | 2021-05-27 12:50 | 2021-06-02 09:46 |
| Reporter | nicola_uva | ||||
| Assigned To | rqueralta | ||||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | Fixed in Version | RR21Q3 | |||
| Merge Request Status | approved | ||||
| Review Assigned To | |||||
| OBNetwork customer | OBPS | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | pi | ||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0046864: SafeBox - NonUniqueResultException happen when is finalize the count safe box | ||||
| Description | In org.openbravo.retail.posterminal.ProcessCountSafeBox when is found the safebox missing the organization filter in the below query. OBCriteria<OBPOSSafeBox> safeBoxCriteria = OBDal.getInstance() .createCriteria(OBPOSSafeBox.class); safeBoxCriteria.add( Restrictions.eq(OBPOSSafeBox.PROPERTY_SEARCHKEY, jsonCountSafeBox.getString("safeBox"))); OBPOSSafeBox safebox = (OBPOSSafeBox) safeBoxCriteria.uniqueResult(); | ||||
| Steps To Reproduce | 1)Go in the erp 2)open the window safe box 3)configure two safe boxes with same searchkey and different organization 4)Login in the pos 5)Do the count safe box action and finalize it 6)Check the error in openbravo.log Below the error An error happened when processing a record: org.hibernate.NonUniqueResultException: query did not return a unique result: 2 | ||||
| Proposed Solution | Add to the query the organization filter | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2021-05-27 12:50 | nicola_uva | New Issue | |||
| 2021-05-27 12:50 | nicola_uva | Assigned To | => Retail | ||
| 2021-05-27 12:50 | nicola_uva | OBNetwork customer | => No | ||
| 2021-05-27 12:50 | nicola_uva | Resolution time | => 1622412000 | ||
| 2021-05-27 12:50 | nicola_uva | Regression introduced in release | => pi | ||
| 2021-05-27 12:50 | nicola_uva | Triggers an Emergency Pack | => No | ||
| 2021-05-27 12:53 | nicola_uva | OBNetwork customer | No => OBPS | ||
| 2021-05-27 12:53 | nicola_uva | Resolution time | 1622412000 => 1622844000 | ||
| 2021-05-27 12:53 | nicola_uva | Priority | normal => high | ||
| 2021-05-27 12:53 | nicola_uva | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=22612#r22612 | ||
| 2021-05-27 12:54 | nicola_uva | Severity | minor => major | ||
| 2021-05-28 18:22 | rqueralta | Assigned To | Retail => rqueralta | ||
| 2021-06-01 16:34 | hgbot | Merge Request Status | => open | ||
| 2021-06-01 16:34 | hgbot | Note Added: 0128875 | |||
| 2021-06-02 09:46 | hgbot | Merge Request Status | open => approved | ||
| 2021-06-02 09:46 | hgbot | Resolution | open => fixed | ||
| 2021-06-02 09:46 | hgbot | Status | new => closed | ||
| 2021-06-02 09:46 | hgbot | Note Added: 0128926 | |||
| 2021-06-02 09:46 | hgbot | Fixed in Version | => RR21Q3 | ||
| 2021-06-02 09:46 | hgbot | Note Added: 0128927 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||