I believe that you are miss-interpreting the results. The hard error stop in the translation was most likely over Harbinger's file as that is the file that they use and have open at the time. However, the logical file that you placed over the physical file caused the unique contstraint to be violated during the operation by the translation. You say the data could not have caused this, but I think if you put the physical file under journalling (without the logicals) and watch the translation operations, you will find that there is a point in time that the uniqueness of the logical file would be compromised. "Stone, Brad V (TC OASIS)" wrote: > > Hello. > > We just started setting up Trusted Link to receive an 850. We built > logicals over the files that the data is mapped to. They were uniquely > keyed (transaction number for header, transaction number, detail line number > for detail). > > When trying to map, the mapping program (Harbinger's) bombed (hard crash, > amazing for a purchased product) with a duplicate key error on one of their > files (not our files). > > We remove our logicals, and the program does not bomb when mapping. > > After looking at the data, there is no data that would have caused a > duplicate key error from our logicals. Then again, it is their file that it > is getting the duplicate key error on. > > Can you not have ANY logicals on the files that are used to map data from > EDI? Their tech support seemed to have think so, but I think it was just to > get off us the phone. Not to mention we told them what we did to make it > work. We're still waiting for a call from a developer to see why we can't > have logicals on our files for mapping. > > Anyone? > > Bradley V. Stone > BVS/Tools > http://www.bvstools.com > > +--- > | This is the Midrange System Mailing List! > | To submit a new message, send your mail to MIDRANGE-L@midrange.com. > | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. > | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. > | Questions should be directed to the list owner/operator: email@example.com > +--- -- =========================================================== R. Bruce Hoffman, Jr. -- IBM Certified AS/400 Professional System Administrator -- IBM Certified AS/400 Professional Network Administrator "The sum of all human knowledge is a fixed constant. It's the population that keeps growing!" +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.