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()

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	View Revisions

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.