Skip to main content
Solved

Oracle Reader - Different handling in null columns in an aggregate function in 25.1 and 25.2

  • January 20, 2026
  • 5 replies
  • 100 views
max_h
Enthusiast
Forum|alt.badge.img+23

I just updated to version 25.2 and my oracle reader is failing and throwing this warning (not an error):
An error occurred while fetching from query `SELECT a.*** FROM *** a' : OCI_SUCCESS_WITH_INFO: ORA-24347: Warning of a NULL column in an aggregate function

Which causes Translation FAILED with 0 error(s) and 1 warning(s) (0 feature(s) output).

My colleague tried the same on version 25.1 and whilst he also gets the warning his translation does not stop and he gets all features to work with. (As did I before my update)

Ignoring the fact that the view should be fixed, is there a way to continue the translation with all features? Troubleshoot option Ignoring failed readers simply skips the reader and thus returning zero features.

Furthermore I did see a few changes regarding oracle in the changelogs but I could not pinpoint which one is referring to this problem.

Best answer by desiree_at_safe

Hi ​@max_h! You’re right! This is an unintended change in behavior, but it should be fixed in FME 2025.2.3.

Look out for that build on the Download page

    5 replies

    david_r
    Celebrity
    • david_rCelebrity
    • January 20, 2026

    You can try to replace the reader with a FeatureReader (not very likely to make a difference, but you never know), or a SQLExecutor (which should work, but it’ll most likely be slower)

    max_h
    Enthusiast
    Forum|alt.badge.img+23
    • max_hEnthusiast
    • Author
    • Enthusiast
    • January 20, 2026

    Thanks for the suggestions, but sadly FeatureReader, SQLExecutor and SQLCreator are all writing to Rejected port with reader_error: ‘An error has occurred. Check the logfile above for details’ → ORA-24347: Warning of a NULL column in an aggregate function

    max_h
    Enthusiast
    Forum|alt.badge.img+23
    • max_hEnthusiast
    • Author
    • Enthusiast
    • January 20, 2026

    I fixed the view, issue was that listagg() had a few null values as it seems, so I had to add a few ‘not null’ conditions.

     

    Still wondering though, what changed between the FME versions in this regard as it definitly worked beforehand on 25.1

    desiree_at_safe
    Safer
    Forum|alt.badge.img+18

    Hi ​@max_h! You’re right! This is an unintended change in behavior, but it should be fixed in FME 2025.2.3.

    Look out for that build on the Download page

    Happy FME-ing!
      max_h
      Enthusiast
      Forum|alt.badge.img+23
      • max_hEnthusiast
      • Author
      • Enthusiast
      • January 26, 2026

      Hi ​@max_h! You’re right! This is an unintended change in behavior, but it should be fixed in FME 2025.2.3.

      Look out for that build on the Download page

      That’s great news, thank you very much!

      Community Stats

      32,398
      Posts
      122,888
      Replies
      40,119
      Members

      Latest FME

      Terms & ConditionsCookie settingsAccessibility statement
      A product of
      Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.