Known Issue: Job Containing Database Connections with Conditional or Optional Fields Fails on Remote Engines

Issue

When submitting a job to a remote engine that contains a database connection with Conditional or Optional fields or with an SSL Options field, the job submission fails and this error message is given:

PostgreSQL:

Remote job submission failed. Http status: 207 Response: [{"name":"postgres-db-conn-test-2.fmw","status":200,"entity":{"name":"postgres-db-conn-test-2.fmw","fileSize":39607}},{"name":"PostgreSQL 10.5 Testsuite","status":422,"message":"The connection parameter(s) are required but are missing: SSL_OPTIONS.

MariaDB:

Remote job submission failed. Http status: 207 Response: [{"name":"mariadb-db-conn-test.fmw","status":200,"entity":{"name":"mariadb-db-conn-test.fmw","fileSize":30933}},{"name":"MariaDB 10.4.12 Testsuite","status":422,"message":"The connection parameter(s) are required but are missing or empty: ENABLE_SSL, TLS_METHOD, REQUIRE_SSL, VERIFY_SERVER."}]

Snowflake:

Remote job submission failed. Http status: 207 Response: [{"name":"snowflake_nonspatial2none.fmw","status":200,"entity":{"name":"snowflake_nonspatial2none.fmw","fileSize":30916}},{"name":"Snowflake Testsuite","status":422,"message":"The connection parameter(s) are required but are missing or empty: AUTHENTICATION_METHOD, OAUTHCONNECTION."}]

Oracle:

{"name":"Oracle 12c Testsuite (ts-ora12c-rh-1-testsuite)","status":422,"message":"The connection parameter(s) are required but are missing or empty: CONNECTION_MODE, WALLET_PATH, SELECTED_SERVICE."}

Cause

This issue is present because the V3 connections API parameter validation is allowing FME Flow and FME Form to pass in different values. This may occur when the connection is uploaded from FME Form. If the connections are created or are updated on Flow, there should be no issue.

Database connection types that don’t have an SSL Options field (such as CartoDB) are not affected and will submit successfully to a remote engine.

Workaround

Have the database connection SSL Mode set to Disable and/or update the connection through the Flow UI. The Flow UI will provide a value for the missing parameter. There is no solution for MariaDB or Snowflake.

Resolution

This issue has been resolved in FME Flow 2024.0.1, please upgrade if possible.