Skip to main content
Question

Query runs locally but not on FMEflow

  • March 11, 2026
  • 2 replies
  • 20 views

fme_hans
Contributor
Forum|alt.badge.img+6

Hi,

 

I have a query that reads data from a view. When I run the workspace that executes the query locally, it executes.
If I then set the workspace to FMEflow, the query no longer works. Local and FMEflow use the same Oracle client version.
The error message is meaningless: SQLCreator_11_<Rejected>: Termination Message: 'SQLCreator_11 output a <Rejected> feature. To continue translation when features are rejected, change 'Workspace Parameters' > Translation > 'Rejected Feature Handling' to 'Continue Translation''

The query does an select with a group by on a view. The same query runs in SQLdeveloper without errors.
The only strange thing i see is when i skip the 'group by' that there are fields with the value "<Missing>" Normally i see Null.

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+65

What versions FME Form & Flow are you using? Are both the same build?


fme_hans
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • March 11, 2026

FME Workbench = 2024.1  and FMEflow = 2025.2.2