Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039758ModulesAdvanced Warehouse Operationspublic2018-12-04 15:302019-03-25 12:42
Reportermaarten1962 
Assigned Toalekosmp86 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned Toguilleaer
Support ticket
OBNetwork customerOBPS
Regression introduced in release
Summary0039758: 18Q3.2: DO-Issue of Box with multiple products fails with "XXX Referenced Inventory is also located in bin BBB"
DescriptionDO-Issue of Box with multiple products fails with "XXX Referenced Inventory is also located in bin BBB"

When "Issue" is initiated, there are 2 (or more) tasks. So far so good.
On Confirm (from Front-End, as group) the system executes the 1st task-confirm and at that point the RI exists in the to-bin.
As the 2nd task is not confirmed yet, the RI also exists in the From-Bin!

So during a split-second, the RI "exists" in 2 places, something that is not physically posible.

If this is indeed the cause, than I think it will also happen with the DO-Receipt.
Steps To ReproduceCreate DO with 2 or more products; Pick; Box all products to the same RI.
Press "Issue" in the window Distribution Order Issue" and assign tasks to Openbravo (any front-end user).
The error message will appear, see attached image.

Proposed SolutionDO-issue and DO-receipt confirmations should be treated as a group (db commit as group?) to avoid intermediate situation where a RI 'exists' in two places.

Additional Information
TagsNo tags attached.
Relationships
Attached Filespng RIex3_error.png (76,091) 2018-12-04 15:30
https://issues.openbravo.com/file_download.php?file_id=12411&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2018-12-04 15:30maarten1962New Issue
2018-12-04 15:30maarten1962Assigned To => Triage Finance
2018-12-04 15:30maarten1962File Added: RIex3_error.png
2018-12-04 15:30maarten1962OBNetwork customer => No
2018-12-05 10:26vmromanosNote Added: 0108267
2018-12-05 10:27vmromanosResolution time => 1545778800
2018-12-05 10:27vmromanosOBNetwork customerNo => OBPS
2018-12-05 10:27vmromanosAssigned ToTriage Finance => guilleaer
2019-01-25 15:10marvintmResolution time1545778800 => 1550185200
2019-01-30 17:12RenateNieuwkoopIssue Monitored: RenateNieuwkoop
2019-02-13 12:56guilleaerResolution time1550185200 => 1552604400
2019-03-22 08:38guilleaerResolution time1552604400 => 1553986800
2019-03-22 08:38guilleaerAssigned Toguilleaer => alekosmp86
2019-03-22 11:06guilleaerStatusnew => feedback
2019-03-25 12:42guilleaerReview Assigned To => guilleaer
2019-03-25 12:42guilleaerNote Added: 0110622
2019-03-25 12:42guilleaerStatusfeedback => closed
2019-03-25 12:42guilleaerResolutionopen => unable to reproduce
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0108267)
vmromanos   
2018-12-05 10:26   
The issue is ONLY reproducible in FE.
When confirming the issue list directly in the BE it works properly.


Stacktrace when confirming in FE (from Errors while processing tasks window):

org.openbravo.base.exception.OBException: Unexpected exception processing grouped task: Error processing Goods Movement process: RT001 referenced inventory is also located in bin: DOCK
    at org.openbravo.warehouse.advancedwarehouseoperations.mobile.processors.ReceptionListProcessor.exec(ReceptionListProcessor.java:66)
    at org.openbravo.warehouse.advancedwarehouseoperations.mobile.sync.TaskLoader.saveRecord(TaskLoader.java:36)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:200)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:154)
    at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:86)
    at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:53)
    at org.openbravo.warehouse.advancedwarehouseoperations.mobile.sync.TaskImportEntryProcessor$TaskLoaderRunnable.processEntry(TaskImportEntryProcessor.java:48)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:367)
    at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:288)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.openbravo.base.exception.OBException: Error processing Goods Movement process: RT001 referenced inventory is also located in bin: DOCK
    at org.openbravo.warehouse.advancedwarehouseoperations.utils.Utilities.processGoodsMovement(Utilities.java:113)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.InternalMovementGenerator.processTransactionDocument(InternalMovementGenerator.java:119)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.InternalMovementGenerator.processTransactionDocument(InternalMovementGenerator.java:42)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.TransactionDocGenerator.processTransactionDocumentIfNotNull(TransactionDocGenerator.java:81)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.GroupOfTasksConfirmator.addTasksToTransactionDocLinesAndProcessIt(GroupOfTasksConfirmator.java:219)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.GroupOfTasksConfirmator.processGroupOfTasks(GroupOfTasksConfirmator.java:119)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.GroupOfTasksConfirmator.processGroupOfTasksDocument(GroupOfTasksConfirmator.java:99)
    at org.openbravo.warehouse.advancedwarehouseoperations.centralbroker.CentralBroker.processGroupOfTasks(CentralBroker.java:239)
    at org.openbravo.warehouse.advancedwarehouseoperations.mobile.processors.ReceptionListProcessor.exec(ReceptionListProcessor.java:44)
    ... 13 more
(0110622)
guilleaer   
2019-03-25 12:42   
This issue is not longer reproducible

Tested on PI (Code will be included in 19Q2 release)