Re: Data Corruption Troubleshooting FMA

We're on 6.1.01 Mixed Mode AS/400, but I bet the field names haven't changed.
 Try this:

SELECT MORD,MSEQ,COUNT(*)
FROM FMA
GROUP BY MORD,MSEQ
HAVING COUNT(*)>1

That will at least ferret out the Shop Orders that have duplicate (or
triplicate or...) sequence numbers.

HTH,

Vince Rowe
MIS
Marietta Corp.


On Saturday 13 April 2002 10:59, you wrote:
> I have a wee problem in version V405CD mixed mode BPCS/400 & before I
> program this thing I was wondering if there is a better way to do it.
> Perhaps some other BPCS site has already seen this phenomena & knows
> exactly what causes it.
>
> We have non-indexed BPCS file FMA that lists what raw material inventory is
> needed for each factory order, and all programs access this data by keyed
> logicals against fields in different sequences.
>
> In theory for each order # there should be sequence # 1 2 3 4 5 etc. for
> each of the different sub-component items involved.
> but intermittently some orders are getting doubled up 1 1 2 2 3 3 4 4 5 5
> etc. or triple 1 1 1 2 2 2 3 3 3 4 4 4 etc. same item, only some of the
> item info duplicated (other fields zero in the duplicate records)
>
> First, I want to identify which orders are corrupted so that we can kill
> them & reissue them, or see if DFU delete excess is enough to uncorrupt
> them. Right now the end users stumble over corrupted orders & we never know
> how many other ones are out there that way.
>