Project:
| View Revisions: Issue #37735 | [ Back to Issue ] | ||
| Summary | 0037735: Fix Stock Process finishes with error if more than 1000 records are returned by updateReservedQuatities query | ||
| Revision | 2018-01-26 11:00 by ngarcia | ||
| 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() |
||
| Revision | 2018-01-26 10:58 by ngarcia | ||
| 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 |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |