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(
'["' || 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(
'["' || 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'
)
);' 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 !
