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 --- In [email protected], "Richard Wilkinson" <[EMAIL PROTECTED]> wrote: > > Thanks to Jason and Mark for suggestions. > > Jason, Trying an Oracle Data source with the same parameters failed > spectacularly, with errors in the log, but it did put me on the patrh to > a workaround. > > I believe I have stumbled on an FME bug, would appreciate your comments. > > The final workaround was to use a concatenator immediately before the > joiner. The concatenated Item was my transform lookup key (in lower > case) and the destination attribute a made up key MYKEY (uppercase). > This worked fine but then I got to thinking what if I made the made up > key MKEY lower case mkey? So that worked as well destroying my theory > of a bug. > > Then I removed the concatenator and put my workspace back how it started > when I first posted on the forum. ARGHHHHH. That worked as well. > > If I had any hair left I'd be tearing it out. > > I don't get it. Yes, I do have a working transform but it's taken best > part of two days debuging/experimenting and the endpoint is actually the > start point! > > I still think FME is a fabulous tool though and just hope that one day > I'm smart enough with FME to contribute more to the forum. > > > Richard Wilkinson > Systems Analyst > Resources - ICT Services > Leicestershire County Council > 0116 2657709 > [EMAIL PROTECTED] > > > _______________________________________________________________________ > 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. > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
