Hello Prem, According to your log file you are losing some features to the unexpected input remover. If you upgraded to FME2006-GB then it would tell you which ones you are missing, but I don't think I can tell that from the log. The fact that both your source readers use the same mdb file is puzzling and might be related.
However - there are still 5067 features that do pass and are processed. A Tester transformer seems to filter out 5060 of these (again I can't tell what test is being performed) leaving you with just 7 features. It appears that these 7 features are then sent through a series of Joiners and then written to both the OWNERSHIP and PARCEL_AREA tables. I can't really see anything wrong. So I'd suggest... 1) If you are worried about the Joiners try bypassing them (just to see if any data is written without them) - I don't think it will help though. 2) How are you viewing the data? Have you tried to open the SDE tables in FME Viewer? This would help to confirm if there is any data or not. 3) Look at the underlying Oracle database to see if it contains any data. 4) Delete the SDE tables (using SDE tools, not Oracle) and try again. Sometimes if the first translation fails after creating the tables subsequent translations can also fail. If you're still having problems after all this then contact [EMAIL PROTECTED] and we'll investigate some more. Regards, Mark Mark Ireland, Product Support Engineer Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], prem kumar <[EMAIL PROTECTED]> wrote: > > Dear Mark > > Here is my comment in BLUE color > > > mark2atsafe <[EMAIL PROTECTED]> wrote: > Hi Prem, > Yes, in FME2006 the Tool->Route to... options were moved into the > navigation pane. I've updated the fmepedia to reflect this. > > OK. GOOD > > As to your problem I'd suggest making sure that you aren't writing > features with different geometries to the same output Feature Type. > > IT IS SURE THAT THERE ARE NO DIFFERENT GEOMETRIES (POLYGON GEOMETRY ONLY) > > As I understand it (and I do normally get it slightly wrong with SDE) > FME permits this because SDE supports this ability, but GeoDatabase > does not, so you would not see anything if you tried to view the data > in an ArcGIS product. It's impossible to tell from the log file if > you are doing this or not. > > As Mr.Raghavendran said, there is a sentence in log file saying that " > Emptying factory pipeline > Unexpected Input Remover(TestFactory)", this could be the cause of the problem. I have used nearly 6 JOINERS connect to the database and retrieve the value to add to the feature attributes. Is there any problem in using the JOINER? > > > If you need to check that then stick a GeometryFilter into the > workspace and see where features emerge. I guess you might also be > able to query the Oracle database directly to see what it contains > (but again, I'm no SDE expert so I won't say for certain). > > There is only POLYGON geometry type available. I tried to use geometry filter also as you said. > > > > Thanks > > Regards > Prem > > > > > > > > utions for Spatial Data Translation, Distribution and Access > > > --- In [email protected], prem kumar wrote: > > > > Hi Raghavendran, > > > > Thanks for imm. response. > > Still iam unable trace the problem. > > Please look into the attached log file, and also i would like to > mention that there are no options (route to visulizer, route to ffs > and route to null ) in Tool menu - Options. > > > > I am using FME 2006 evaluation copy > > > > Regards > > Prem > > > > > > "Raghavendran(SRG)" wrote: > > Hello Prem, > > This is something interesting with FME and have been a topic of > debate for years. > > > > This FME groups has seen many say(rather complain) "I see that > FME translation is successful, but I do not find any features written > in the destination format". > > > > After a translation, the log file should be scanned for warning > messages and the statistics examined to ensure that the translation > was successful. > > > > The FME log file is something worth looking at in such > situatuions and contains detailed messages describing > > what happened after each transformer(function/factory)in your > workspace. > > > > Perhaps the tips from FMEpedia pages are worth reading: > > http://www.fmepedia.com/index.php/FME_Applications_- > _Usage_and_Known_Issues#Basic > > > > I run a translation but I didn't get all the output features I > was expecting why? > > > > There are a number of potential reasons for this. > > > > The unexpected input remover filtered out all your features. Do > a search in the log window for the word "unexpected‿ to check > for this and see the Intermediate Workbench FAQs for more information > on Feature Type and the Unexpected Input Remover. > > You had the `route to visualiser' setting turned on (see Tools > menu option) with this option you would get output to the Universal > Viewer only. > > You had the `route to null' setting turned on (see Tools menu > option) with this option you would get output sent to a null > dataset (i.e. nothing) only. > > You had the `route to ffs' setting turned on (see Tools menu > option) with this option you would get output to a set of FFS > format files. > > Hope that helps. > > Happy FME-ing:-) > > Cheers > > SRG > > > > prem kumar wrote: > > Hi All, > > > > Here is our problem,When we migrate data from ESRI personal > geodatabase to ArcSDE geodatabase using FME, The translation was > successfull and it is showing > > feature count in Written Summery in log file. Finally we couldnt > find anything in > > ArcSDE geodatabase. > > > > Any help would be appreciated. > > > > Thanks in Advance. > > > > Regards, > > Prem. > > > > > > > > > > --------------------------------- > > Yahoo! Mail - Helps protect you from nasty viruses. > > > > Get the maximum benefit from your FME, FME Objects, or > SpatialDirect via our Professional Services team. Visit > www.safe.com/services for details. > > > > > > > > --------------------------------- > > YAHOO! GROUPS LINKS > > > > > > Visit your group "fme" on the web. > > > > To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service. > > > > > > --------------------------------- > > > > > > > > > > > > --------------------------------- > > Yahoo! Mail - Helps protect you from nasty viruses. > > > > > > > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. > Yahoo! Groups Links > > > > > > > > > > > --------------------------------- > Brings words and photos together (easily) with > PhotoMail - it's free and works with Yahoo! Mail. > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> 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/
