× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


_______________________________________________
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.
-------------------------------------------------------------------------------------------



As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.