Experiencing, Schema features output from the SQLExecutor only after the Data features. This is causing issues for dynamic workspace. Currently managing this by connecting FeatureHolder to the Result (Data features) port of SQLExecutor, to hold the Data features and let the Schema features reach dynamic writer first. From the above screenshot it can be noticed that, Schema features are started coming out only after the Data features. To address this, required either of the below for SQLExecutor.Schema features output first before Data features all the time.Required "Output Schema Before Data Features" parameter, similar to SchemaScanner. FME version: 2022.2.2

Solved

SQLExecutor - Required "Output Schema Before Data Features" parameter

Forum|Forum|2 years ago
November 4, 2023
2 replies
32 views

+9

ranga_tolapi
Contributor

Experiencing, Schema features output from the SQLExecutor only after the Data features. This is causing issues for dynamic workspace.

Currently managing this by connecting FeatureHolder to the Result (Data features) port of SQLExecutor, to hold the Data features and let the Schema features reach dynamic writer first.

SQLExecutor with Breakpoint From the above screenshot it can be noticed that, Schema features are started coming out only after the Data features.

To address this, required either of the below for SQLExecutor.

Schema features output first before Data features all the time.
Required "Output Schema Before Data Features" parameter, similar to SchemaScanner.

FME version: 2022.2.2

Best answer by takashi

Hi @ranga_tolapi ,

It seems that the issue has been addressed in FME 2023.0 or later. Try upgrading FME version.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.