Oracle Non Spatial Reader not reading all view features
I’m using an Oracle non spatial reader in FME Desktop 2019.1.3.1 to read an Oracle view. Using Oracle client (i.e. SQL+), the total count of this view is 6,982,320, but the FME Oracle reader reads in over a million less, and the total count differs each time I run it. I’ve played around with some of the reader parameters - bulk read size, persistent connection, etc. - but each run is still different. Two examples below which read in two different total numbers and while they’re close, they’re way off the total count according to SQL.
Any thoughts on this?
Page 1 / 1
According to the log there are two warnings the first run and one warning the second run. What are these warnings?
According to the log there are two warnings the first run and one warning the second run. What are these warnings?
I dumbed down the workspace so no warnings are thrown. I also added another, similar view (only differs in field returned) in the read (Oracle Non Spatial reader) - as you can see in the screenshot below, one of the views is read entirely while the other is not. I assume that points to an ‘issue’ with the view itself, but my Oracle client sees the full amount for both views.
Hi @timboberoosky ,
I’m curious…
Can you add a SQLCreator to your FME environment and run the same query to count features: select count(*) as count_viewname from <owner>.<viewname>
Expose this attribute in the SQLCreator and attach a logger. This will output this count (attribute).
I’ve never seen this sort of discrepancy before. Does the data change frequently in the underlying tables of the view?
At this point, it feels like there is a different database between your SQLPlus client and FME. So I have to ask… the obvious, I assume you have one Oracle Client and the environment variable TNS_ADMIN (if in play), is pointing to the same tnsnames.ora file for both FME and SQLPluse (or you are using ezconnect (host:port/servicename) and the same for both).
