RE: Duplicates in BPCS files - illusion?

[James Touchtone <golem3@xxxxxxxxxxx>]

We also have the IWI and ILI duplicates problem. We are running HPUX
6002 with Informix. The IWI table is our biggest offender, while the ILI 
only occasionally creates duplicates. We have found that the ILI duplicates 
are often created when a user's PC crashes in the middle of
INV500D.


>From: Christine Hales <chales@schukra.com>
>Reply-To: BPCS-L@midrange.com
>To: "'BPCS-L@midrange.com'" <BPCS-L@midrange.com>
>Subject: RE: Duplicates in BPCS files - illusion?
>Date: Thu, 3 Jun 1999 07:57:46 -0400
>
>
>
>  What causes duplicates?
>
> >  I have seen duplicate records in some files cause this type of problem.
> >  You might want to verify that  IWIL04 does not have any duplicates.
>
>[Christine Hales]
>
>               We are a 6002 HP/Oracle shop, and are constantly trying to 
>battle
>system-created duplicates.  It seems the biggest offender is the IWI table.
>  I am not sure if and why it happens on the 400 side - but for us, if the
>transaction cannot obtain the lock on the IWI record, it just decides to
>create a new one.  Of course the helpline can't duplicate it......
>
>               We routinely clear these out, and run the update from ILI to 
>make sure
>everything is in sync.  Is this still happening in 6004?
>
>                               -Christine
>
>+---
>| This is the BPCS Users Mailing List!
>| To submit a new message, send your mail to BPCS-L@midrange.com.
>| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: dasmussen@aol.com
>+---


_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---