Records don't shrink by themselves of course, but I could not wait any longer to figure out what went wrong, so I just restored the mfg db from last backup, and we are back online (that's why we take backups, don't we?).
Thanks anyway.
Progress 9.1D, eb2 SP5
The number is the amount of ld_det records that shrinked from 15682 to 1648 records for unknown reason.
In the meanwhile I restored the MFG/PRO database, and will reschedule the dump/load.
from a tabanalys output, I also a lot of ld_det records "dissapeared" since the week before (from 15.682 to 1648), what could explain the reason why in_mstr has 0 qty's, but what is cleaning the ld_det records?
It appears like the inventory in_mstr (in_qty_oh) changed from 1 to 0 causing the ending balance to be negative (-1 in this case)? And this appears to have happend for a lot of items? What can cause this (probably an automated process/batch, since nobody was around last week or during the weekend)?
Here it is:
│ Item Number: L0271618501 Date: 12/04/10
│Performance Da: Trans Type: CST-ADJ
│ Loc: Begin Loc Bal: 0,0
│ Begin Balance: 0,0 Qty Required: 0,0
│ Qty Change: 0,0...
I did run 5.22/23 (closed PO/receipt PO delete/archive) until 01/07/07
I don't know if it's related, but for some reason the first ending balance of a lot of items is negative now? Any ideas where this can come from, and more important: how to solve it?
3.21.2 Transactions by Item Inquiry...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.