Hi,
I have an error when completing an internal use inventory
of says SaveError
In the console it gives me the following message:
ADVERTENCIA: NOT found: Row
dic 20, 2019 3:11:30 PM org.compiere.model.PO load
GRAVE: NO Data found for M_InventoryLine_ID=1031371 AND M_AttributeSetInstance_ID=0 AND DateMaterialPolicy=TO_DATE('2019-08-11 01:00:00','YYYY-MM-DD HH24:MI:SS')
java.lang.Exception
at org.compiere.model.PO.load(PO.java:1348)
at org.compiere.model.PO.doInsert(PO.java:3038)
at org.compiere.model.PO.saveNew(PO.java:2817)
at org.compiere.model.PO.save(PO.java:2160)
at org.compiere.model.PO.saveEx(PO.java:2248)
at org.compiere.model.MInventory.checkMaterialPolicy(MInventory.java:799)
at org.compiere.model.MInventory.completeIt(MInventory.java:502)
at org.compiere.process.DocumentEngine.completeIt(DocumentEngine.java:500)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:317)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:281)
at org.compiere.model.MInventory.processIt(MInventory.java:289)
at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:1014)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:879)
at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:373)
at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:283)
at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:280)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:896)
at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:373)
at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:283)
at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:280)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:896)
at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:505)
at org.compiere.wf.MWorkflow.start(MWorkflow.java:690)
at org.adempiere.util.ProcessUtil.startWorkFlow(ProcessUtil.java:315)
at org.compiere.apps.AbstractProcessCtl.startWorkflow(AbstractProcessCtl.java:391)
at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:209)
at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)
at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1083)
at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
dic 20, 2019 3:11:30 PM org.compiere.model.PO doInsert
GRAVE: [WFP_265400cf-1339-4c9e-82af-b583f36100fe] - reloading
dic 20, 2019 3:11:30 PM org.compiere.wf.MWFActivity run
ADVERTENCIA: MWFNode[231-(DocComplete),Action=DocumentAction=CO]
org.adempiere.exceptions.AdempiereException: SaveError
at org.compiere.model.PO.saveEx(PO.java:2256)
at org.compiere.model.MInventory.checkMaterialPolicy(MInventory.java:799)
at org.compiere.model.MInventory.completeIt(MInventory.java:502)
at org.compiere.process.DocumentEngine.completeIt(DocumentEngine.java:500)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:317)
at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:281)
at org.compiere.model.MInventory.processIt(MInventory.java:289)
at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:1014)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:879)
at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:373)
at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:283)
at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:280)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:896)
at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:373)
at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:283)
at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:280)
at org.compiere.wf.MWFActivity.run(MWFActivity.java:896)
at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:505)
at org.compiere.wf.MWorkflow.start(MWorkflow.java:690)
at org.adempiere.util.ProcessUtil.startWorkFlow(ProcessUtil.java:315)
at org.compiere.apps.AbstractProcessCtl.startWorkflow(AbstractProcessCtl.java:391)
at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:209)
at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)
at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1083)
at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
The product has an existence of 84 units for 2019-08-11
and is trying to get a unit.
In the MInventory class on line 799 at the time of saving it does not and returns the error:
GRAVE: NO Data found for M_InventoryLine_ID=1031371 AND M_AttributeSetInstance_ID=0 AND DateMaterialPolicy=TO_DATE('2019-08-11 01:00:00','YYYY-MM-DD HH24:MI:SS')
Any idea why this happens.
Cheers