Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023298Openbravo ERP04. Warehouse managementpublic2013-03-14 00:382013-03-14 00:41
Reporterjohnfandl 
Assigned Todmiguelez 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023298: Physical Inventory / Create Inventory Count List: excessive runtimes with large datasets
DescriptionThis process ran for about 25 hours before it finally completed successfully, writing 211k rows. Note that in this environment there were 1.3 million m_product rows.

Because the entire process commits at the end, it is very difficult to gauge the progress of the program when running in production. In this case, it was part of a live cutover to production, and the long runtime cause a lot of pain.
Steps To ReproduceExecute the process with high volumes, like above.
Proposed SolutionIdeally the process would be re-designed to handle larger data volumes.

However, a cheaper solution that would prevent ugly surprises is to add a warning process like this:

- Add a Preference Attribute, "Number of Physical Inventory Rows to Generate Warning"--default it to 3000
- When the OK button is pressed on the "Create Inventory Count List" modal dialog, run a query to count the output rows that will be generated.
- If the count is greater than the "Number of Physical Inventory Rows to Generate Warning", then show a warning message: "You are about to generate &count number of Physical Inventory Count records, which is above the recommended maximum of &WarningCount. This process may run for a very long time. Please consider adding addition criteria to generate few inventory counts."
- Allow the user to proceed (or to re-select and generate the same logic again)
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-03-14 00:38johnfandlNew Issue
2013-03-14 00:38johnfandlAssigned To => dmiguelez
2013-03-14 00:38johnfandlModules => Core
2013-03-14 00:38johnfandlTriggers an Emergency Pack => No
2013-03-14 00:41johnfandlNote Added: 0057237

Notes
(0057237)
johnfandl   
2013-03-14 00:41   
I had a typo in the suggested error message. I meant to write this (fewer, instead of few):

"You are about to generate &count number of Physical Inventory Count records, which is above the recommended maximum of &WarningCount. This process may run for a very long time. Please consider adding addition criteria to generate fewer inventory counts."