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

[Jason Birch]

Title: Joiner Fails to get values from Oracle DB





Have you tried setting up an Oracle data source with the 
same parameters to see if it works?  If the data comes in (you can see it 
with a Visualizer), run it through a FeatureMerger to see if you get any 
matches.  Perhaps there are trailing blanks or something else that is 
causing the join to fail.
 
I haven't seen those greyed-out fields before; perhaps it's 
a new feature from the more recent betas?
 
Jason


From: fme@yahoogroups.com 
[mailto:[EMAIL PROTECTED] On Behalf Of Richard 
WilkinsonSent: Monday, September 25, 2006 03:39To: 
fme@yahoogroups.comSubject: [fme] Joiner Fails to get values from 
Oracle DB

Hi, 
Please can anyone help with a joiner problem when 
doing a lookup from an oracle table.  The problem is that I get no values 
returned and no errors or warnings.  The lookup table does exist and does 
contain matching values.  I have done the obvious checks, correct 
username/password, field names/types correct . . .
Performing the same lookup from an access database 
works fine.  (Both lookup tables in Oracle and access were created by the 
same FME transform).
Essentially my workspace does the following: 

1. Create lookup table:      
Ascii Tab separated ---> transform --->Oracle 10 table 2. Create spatial table:      Mapinfo 
.TAB --->transform including lookup from Oracle 10 table  ---> oracle 
spatial 10 
Not much to go on I agree but I am hoping that 
someone has had similar problems and can suggest a solution.  
Alternatively, How can I find out the query that FME is actually running to do 
the lookup  and can I turn on additional logging?  My suspicion is 
that there is an oracle error that is not being reported.
FME 2007 (20060829 - Build 4125) Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 
64bi MS Access 2002 SP3 Windows XP SP2 
Thanks 
Richard Wilkinson 
Systems Analyst 
Resources - ICT 
Services Leicestershire County Council 0116 2657709 
__._,_.___





  








   



  



      
      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 
       
 
    
  




__,_._,___