Just to let you all know - this issue was fixed yesterday and appears in today's beta build #4165, now on our web and ftp sites
ftp.safe.com/fme/beta/fme4165.exe ...and remember, details of all new features and fixes can be found in the "What's New" file: ftp://ftp.safe.com/fme/beta/whatsnew.txt Mark --- In [email protected], "mark2atsafe" <[EMAIL PROTECTED]> wrote: > > Hi there, > This looks like a fairly serious problem with FME - it's been filed > with our developers with a P1 (top) priority and I'll let you know > when a fix is available. > > In the meantime, I don't see much of a workaround I'm afraid. Can you > set up a database view with the where clause in? Perhaps then FME > would let you prefetch "select * from view" - because it seems to be > the where clause we are stumbling over. > > Regards, > > Mark > > Mark Ireland, Senior Product Specialist > Safe Software Inc. Surrey, BC, CANADA > [EMAIL PROTECTED] http://www.safe.com > Solutions for Spatial Data Translation, Distribution and Access > > --- In [email protected], "cmvonner" <cmvonner@> wrote: > > > > > > I have been unable to get a Joiner working with a SQL Server table or > > view when a prefetch query is used. Here is my prefetch query: > > > > select * from base_picklist where pfeature = 'all_base_features' and > > pcolumn = 'feature_status' > > > > Checking the log, whenever I use the prefetch query, I see the > > following message: > > > > MS SQL Server Reader: Opening `GDI_Temp' for read operation. > > MS SQL Server Reader: Closing `GDI_Temp' . Read operation complete. > > Opened table `JOINER-base_parcel:dbo.vw_base_picklist' for input with > > server type `MSSQL_ADO', server name `ESG-SQL', user name `fme', > > database name = `GDI_Temp'; > > Started SQL cache prefetch for table 'dbo.vw_base_picklist' with SQL > > statement 'select * from vw_base_picklist where pfeature = > > 'all_base_features' and pcolumn = 'feature_status''. > > Module `MSSQL_ADO' API version matches current core version (3.1 > > 20031010). > > ADO-based Reader: Opening `ESG-SQL' for read operation. > > ADO-based Reader: Connection failed. Connection string > > `[Microsoft][ODBC Driver Manager] Data source name not found and no > > default driver specified'. Provider error `%2'. > > Failed to open reader. > > Finished SQL cache prefetch for table 'dbo.vw_base_picklist', which > > added 0 rows to the cache. > > MS SQL Server Reader: Opening `GDI_Temp' for read operation. > > Using Dynamic Reader $Revision: 17.1 $ ( $Date: 2006/01/06 17:33:15 $ ) > > with module MSSQL_ADO to read data from dataset `GDI_Temp' > > > > However, if I remove the prefetch query, I get the following in the log: > > > > MS SQL Server Reader: Opening `GDI_Temp' for read operation. > > MS SQL Server Reader: Closing `GDI_Temp' . Read operation complete. > > Opened table `JOINER-base_parcel:dbo.vw_base_picklist' for input with > > server type `MSSQL_ADO', server name `ESG-SQL', user name `fme', > > database name = `GDI_Temp'; > > MS SQL Server Reader: Opening `GDI_Temp' for read operation. > > Using Dynamic Reader $Revision: 17.1 $ ( $Date: 2006/01/06 17:33:15 $ ) > > with module MSSQL_ADO to read data from dataset `GDI_Temp' > > > > Is there something wrong with the format of my prefetch query? > > > > Thanks > > > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. 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/
