Yes, I've seen this.  
The correction we do is to delete the duplicate costing set via /MDC (i.e.
where the item number and process group are the same) and leave the one
where the process group is *blanks.   

Lin

-----Original Message-----
From: system21-bounces+lin=linzone.com@xxxxxxxxxxxx
[mailto:system21-bounces+lin=linzone.com@xxxxxxxxxxxx] On Behalf Of Glen at
work
Sent: Friday, January 06, 2006 7:36 PM
To: jbausers-l@xxxxxxxxxxxx
Subject: [SYSTEM21] Dump in Transaction manager - MJ470

Has anyone else encountered this issue?

I am getting a dump on MJ470 - caused by a duplicate key found on MSP05 -
reason is that it is finding 2 records for the read:

WHERE CONO05=:CONO01 AND ITEM05=:ITEMWK AND RTCD05=:RTCD01
AND OPSQ05=:OPSQ56 and CSET05=:CSETSD

This is because we have records on MSP05 where the process group is
non-blank so the above is finding both records.
These records aren't required so I can soon get rid of the problem. I just
wondered if anyone else had found this and what they'd done to get over the
problem.

Thanks
Glen
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2022 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.