Skip to main content
Question

Query runs locally but not on FMEflow

  • March 11, 2026
  • 3 replies
  • 61 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.

3 replies

nielsgerrits
VIP
Forum|alt.badge.img+66

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


hkingsbury
Celebrity
Forum|alt.badge.img+70
  • Celebrity
  • March 12, 2026

FME Workbench = 2024.1  and FMEflow = 2025.2.2

that should work, but ideally you’ll be running the same versions of Form and Flow.

Can you install Form 2025.2.2 and try uploading again?