RE: ECM = File Listing

This is a multi-part message in MIME format.
--
I am assuming you are talking about the guid being duplicated? If so, you need 
to check tpeb, tpec and, if you killed ecm, check teib.

        -----Original Message-----
        From: Chick Doe [mailto:Cdoe@barton-instruments.com]
        Sent: Wed 6/5/2002 8:39 PM
        To: bpcs-l@midrange.com
        Cc:
        Subject: Re: ECM = File Listing



        i don't know ECM, but i do know that many other BPCS program hang (or 
go into a loop) when they process files that have records with duplicate keys. 
and this is irrespective of the record status (logical deletes). we have 
written a series of queries that extract the record keys and count the number 
of occurrences of each key. we then list any key that has more than one 
occurrence and we then fix the file. i know that the biggest offender that we 
have is the ECL file in order entry, MBM bill of material file, FRT routing 
operations, and MPN notes. also the FOD shop order operation file will cause 
shop order release to fail if there are multiple records with the same key.

        chick doe
        barton instrument systems


        >>> Rick.Briggs@corona.bellota.com 06/05/02 02:15PM >>>

        ECM Hangs when there are Duplicate File Entries...

        Is there anyone out there that knows of a List of Files to check in 
such an
        event?


        Rick Briggs
        Corona Clipper


        _______________________________________________
        This is the SSA's BPCS ERP System (BPCS-L) mailing list
        To post a message email: BPCS-L@midrange.com
        To subscribe, unsubscribe, or change list options,
        visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
        or email: BPCS-L-request@midrange.com
        Before posting, please take a moment to review the archives
        at http://archive.midrange.com/bpcs-l.


        _______________________________________________
        This is the SSA's BPCS ERP System (BPCS-L) mailing list
        To post a message email: BPCS-L@midrange.com
        To subscribe, unsubscribe, or change list options,
        visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
        or email: BPCS-L-request@midrange.com
        Before posting, please take a moment to review the archives
        at http://archive.midrange.com/bpcs-l.




--
[ winmail.dat of type application/ms-tnef deleted ]