Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0037735 | Openbravo ERP | 04. Warehouse management | public | 2018-01-26 10:58 | 2018-01-26 11:00 |
| Reporter | ngarcia | ||||
| Assigned To | Triage Omni WMS | ||||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0037735: Fix Stock Process finishes with error if more than 1000 records are returned by updateReservedQuatities query | ||||
| Description | Fix Stock Process finishes with error if more than 1000 records are returned by updateReservedQuatities query. The problem is that commit made is in updateReservedQty function that is called in updateReservedQty function's scrollable results and the query's default fetch size is 1000 | ||||
| Steps To Reproduce | Check the following query returns more than 1000 records: select count(1) from (select r.m_product_id, rs.m_locator_id, rs.m_attributesetinstance_id, r.c_uom_id from m_reservation_stock rs, m_reservation r where r.m_reservation_id = rs.m_reservation_id and r.res_status <> 'DR' and ad_isorgincluded(rs.ad_org_id, '0', rs.ad_client_id) <> -1 group by r.m_product_id, rs.m_locator_id, rs.m_attributesetinstance_id, r.c_uom_id) as a As group admin role: Go to Process Request window and set the Fix Stock process to be run immediately Check the following error is shown in the log: ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: portal "C_..." does not exist ERROR org.openbravo.module.fixstock.RestoreStockValue - could not advance using next() | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | Fix Stock | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2018-01-26 10:58 | ngarcia | New Issue | |||
| 2018-01-26 10:58 | ngarcia | Assigned To | => Triage Finance | ||
| 2018-01-26 10:58 | ngarcia | Modules | => Core | ||
| 2018-01-26 10:58 | ngarcia | Triggers an Emergency Pack | => No | ||
| 2018-01-26 10:58 | ngarcia | Tag Attached: Fix Stock | |||
| 2018-01-26 11:00 | ngarcia | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=16591#r16591 | ||
| There are no notes attached to this issue. |