Skip to main content
Question

Oracle Non Spatial Reader not reading all view features


timboberoosky
Contributor
Forum|alt.badge.img+6

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?

 

 

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+54

According to the log there are two warnings the first run and one warning the second run. What are these warnings?


timboberoosky
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • June 11, 2025
nielsgerrits wrote:

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. 

 


steveatsafe
Safer
Forum|alt.badge.img+12

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).


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings