RE: [fme] Re: Joiner Fails to get values from Oracle DB

[Richard Wilkinson]

Title: Message

Hi Mark & Dale,   Unfortunately I don't have the original (failed state) logfile.  I know just what you are saying about the key field not being matched up properly.  My original though too.  I checked it so many times.  But sometimes I just can't see for looking!   Anyway, I am unable to duplicate the problem so I guess I did get something wrong.  I have attached the current logfile in which I cannot find anything useful about the query joiner is attempting to do.  If you can, please look at the file and tell me if I am missing the elusive clue.   Its time to put this one to bed but I have several more very similar ones to do.  If I can repeat the problem I will keep the logfile.   Thanks very much   Richard Wilkinson Systems Analyst Resources - ICT Services Leicestershire County Council 0116 2657709 [EMAIL PROTECTED]     -----Original Message----- From: fme@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Lutz Sent: 28 September 2006 06:00 To: fme@yahoogroups.com Subject: Fwd: [fme] Re: Joiner Fails to get values from Oracle DB Hello Hairless Ones, I'd add that the key often in these situations is to look carefully at the log. It should indicate the kind of query that Oracle was being asked to do, and if I didn't know better, I'd wonder if somehow the key fields weren't properly matched up originally. The original log would indicate exactly how the query was being made. There is also an internal debug option for the Joiner that could come into play if we wanted to investigate it further if the problem becomes reproducable -- but right now to use it we'd have to make the workspace into a mapping file <mock shudder--sorry Peter L> and add it in. Dale On 9/26/06, mark2atsafe <mark.ireland@safe.com> wrote: > > Hi Richard, > Welcome to the land of the hairless - the natural state of those who > work with spatial data. > > Do you have the original log file? It might give us a clue as to what > was happening - whether it was a system failure of an fme related issue. > > Mark > _______________________________________________________________________ Leicestershire County Council - rated a 'four-star' council by the Audit Commission _______________________________________________________________________     This e-mail and any files transmitted with it are confidential. If you are not the intended recipient, any reading, printing, storage, disclosure, copying or any other action taken in respect of this e-mail is prohibited and may be unlawful. If you are not the intended recipient, please notify the sender immediately by using the reply function and then permanently delete what you have received.   Incoming and outgoing e-mail messages are routinely monitored for compliance with Leicestershire County Council's policy on the use of electronic communications. The contents of e-mails may have to be disclosed to a request under the Data Protection Act 1998 and the Freedom of Information Act 2000.   The views expressed by the author may not necessarily reflect the views or policies of the Leicestershire County Council.   Attachments to e-mail messages may contain viruses that may damage your system. Whilst Leicestershire County Council has taken every reasonable precaution to minimise this risk, we cannot accept any liability for any damage which you sustain as a result of these factors. You are advised to carry out your own virus checks before opening any attachment.     __._,_.___   Your email settings: Individual Email|Traditional Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe __,_._,___