I think is failing because the input feature to the SDE30QueryFactory does not have its sde30_type attribute set or is nil. Whats the source of the polygon input feature? If its non sde probably need to tranform it first. For example @Transform(ORACLE8I,SDE30). You Could also try taking out the spatial aspect of the query. Make you where clause the primary key of the feature your trying to retrieve. Then remove the SDE_AREA_INTERSECT method. This will make sure your problem is not connection related.
jim gillcrist raytheon --- In [email protected], "Matt Davis" <[EMAIL PROTECTED]> wrote: > > hello fme listers, > > I'm a bit of a newbie to the whole FME thing, and was wondering if anyone could offer me any help. I am having trouble using the ArcSDE Querier transformer, and whenever I try to use this function, i get the below error message: > > Making connection to server '...' for dataset 'sde' using instance '...' userId = '...'. > Connection made to server '...' for dataset 'sde' using instance '...' userId = '...'. > ArcSDE release: '9.1'. Underlying database: 'Oracle9i Build 1269 (Oracle) Thu Mar 3 18:54:58 PST 2005'. > ARCSDEQUERIER_Querier(SDE30QueryFactory): Querying Layer 'SIPS_DBA.PLANNING_ZONES'. > Unknown sde30_type '' or sde30_type not specified. > Unknown sde30_type '' or sde30_type not specified. > FME Session Duration: 4.2 seconds. > > Unknown sde30_type '' or sde30_type not specified. > Program Terminating > > Translation FAILED. > > The Where statement I'm using is: GEN_ZONE = 'Commercial and Business' (This works for a Select by Attributes query in ArcGIS - GEN_ZONE is a field in the query layer). > > This layer has Geometry Type = Polygon, and I'm using the SDE_AREA_INTERSECT search method. We are using FME 2006 (Build 2182). > > If anyone can shine any light on this for me, or give me any tips I'd be most appreciative. Also, if there is any more detailed information on transformers to query, select and export spatial data, as there doesn't seem to be any ready made transformers that allow direct querying using familiar ArcGIS-type queries. > > Thanks, Matt Davis > > > Matt Davis > Strategic Planning Analyst > State Infrastucture Planning System > Department of Infrastructure, Energy and Resources > Level 9, 10 Murray St, Hobart, Tasmania 7000 > AUSTRALIA > Ph - +61 3 6216 4348 > Fax - +61 3 6233 4978 > E-mail - [EMAIL PROTECTED] > 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/
