Re: ECM = File Listing -- BPCS-L

AS/SET generated code does not like duplicate keys. It will hang every time.

>>> Cdoe@barton-instruments.com 06/05/02 09:39PM >>>
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.

-------------------------------------------------------------------------------------------
Note: Please update your email address for this user to reflect the
new MeadWestvaco Corporation. MeadWestvaco employee
email addresses are in the format of user@MeadWestvaco.com

This electronic message contains information from MeadWestvaco
Corporation or subsidiary companies, which may be confidential,
privileged or otherwise protected from disclosure. The
information is intended to be used solely by the recipient(s)
named. If you are not an intended recipient, be aware that
any review, disclosure, copying, distribution or use of this
transmission or its contents is prohibited. If you have
received this transmission in error, please notify MeadWestvaco
immediately at postmaster@MeadWestvaco.com.
-------------------------------------------------------------------------------------------