Hi all,

I’m encountering an issue with the InlineQuerier transformer in FME Form 2024.2.1 (pre-production environment) that seems to differ from previous behavior.(FME Form 2024.1.3 in developement environment)

Workspace Setup:

The InlineQuerier has two input ports:

tubes (can sometimes receive no features)

parametre_generique (always receives data)

I’m using this request :

Problem:

When no data arrives at the tube input port, the transformer throws the following errors:

InlineQuerier_2 (InlineQueryFactory): Generating output 'tubes_statuts_inactifs' using query 'SELECT * FROM "tubes"

WHERE (

    UPPER("statut_administratif") NOT IN (

        SELECT TRIM(UPPER(value))

        FROM "parametre_generique",

             json_each(

                 '7"' || REPLACE("valeur_parametre_text", '|', '","') || '"]'

             )

        WHERE code_parametre = 'STATUT_ADMINISTRATIF_RETENU_TUBES'

    )

    OR

    UPPER("statut_operationnel") NOT IN (

        SELECT TRIM(UPPER(value))

        FROM "parametre_generique",

             json_each(

                 '_"' || REPLACE("valeur_parametre_text", '|', '","') || '"]'

             )

        WHERE code_parametre = 'STATUT_OPERATIONNEL_RETENU_TUBES'

    )

);'

SQLite Reader: Opening `C:\Users\ADMINI~1\AppData\Local\Temp\2\wbrun_1754489245451_4360\fmetmp_2\_inlinequery_1754555895273_11956.db' for read operation

Database query 'SELECT * FROM "tubes"

WHERE (

    UPPER("statut_administratif") NOT IN (

        SELECT TRIM(UPPER(value))

        FROM "parametre_generique",

             json_each(

                 'o"' || REPLACE("valeur_parametre_text", '|', '","') || '"]'

             )

        WHERE code_parametre = 'STATUT_ADMINISTRATIF_RETENU_TUBES'

    )

    OR

    UPPER("statut_operationnel") NOT IN (

        SELECT TRIM(UPPER(value))

        FROM "parametre_generique",

             json_each(

                 'e"' || REPLACE("valeur_parametre_text", '|', '","') || '"]'

             )

        WHERE code_parametre = 'STATUT_OPERATIONNEL_RETENU_TUBES'

    )

);' failed. SQLite3 Engine error: 'no such table: tubes'

An error has occurred. Check the logfile above for details

InlineQuerier_2 (InlineQueryFactory): Wrote 0 features to output 'tubes_statuts_inactifs'

InlineQuerier_2 (InlineQueryFactory): An error has occurred. Check the logfile above for details

InlineQuerier_2 (InlineQueryFactory): Database was unable to execute query for output named 'tubes_statuts_inactifs'

SQLite Reader: Closing `C:\Users\ADMINI~1\AppData\Local\Temp\2\wbrun_1754489245451_4360\fmetmp_2\_inlinequery_1754555895273_11956.db' . Read operation complete

An error has occurred. Check the logfile above for details

Translation FAILED with 4 error(s) and 1 warning(s) (0 feature(s) output)

FME Session Duration: 2.1 seconds. (CPU: 1.3s user, 0.5s system)

END - ProcessID: 11956, peak process memory usage: 203756 kB, current process memory usage: 189332 kB

Program Terminating

Translation FAILED.

This results in the translation failing completely, rather than just returning an empty result set.

Notes:

The tubes port is connected, just sometimes receives no features.

In previous versions of FME (e.g., 2024.1.3), the InlineQuerier would log the error but the translation would continue — now it fails entirely.

🧩 Question:

Has anyone else encountered this behavior in FME 2024.2.1?

Is this change documented anywhere?

What is the best practice for handling optional/empty input streams in the InlineQuerier under this version?

Thanks in advance !