Openbravo Issue Tracking System - Modules
View Issue Details
0039758ModulesAdvanced Warehouse Operationspublic2018-12-04 15:302019-03-25 12:42
maarten1962 
alekosmp86 
urgentmajoralways
closedunable to reproduce 
5
 
 
guilleaer
0039758: 18Q3.2: DO-Issue of Box with multiple products fails with "XXX Referenced Inventory is also located in bin BBB"
DO-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.
Create 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.

DO-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.

No tags attached.
png 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
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-05 10:26vmromanosNote Added: 0108267
2018-12-05 10:27vmromanosResolution time => 1545778800
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)