Hi Carl, Perhaps I spoke too soon! Although the issue of the failing translation is fixed, I'm far from certain that the actual prefetch and cache filling is working properly. In my tests I'm getting some log results that really don't look right.
So my advice is to steer clear of the prefetch for ADO based formats at the moment, and I'll let you know when the issue is resolved. 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" <[EMAIL PROTECTED]> wrote: > > Mark, > > Thanks for the reply. I'm downloading build 4167 right now. > > Carl > > --- In [email protected], "mark2atsafe" <mark.ireland@> wrote: > > > > 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" <mark.ireland@> 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 > > > support@ 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/
