TIBCO Scribe® Online Native Query Block Error: No eligible fields found. Description: No item selected
Article ID: KB0075846
Updated On:
| Products | Versions |
|---|---|
| TIBCO Cloud Integration - Connect ( Scribe ) | - |
Description
When running a map that uses a Native Query block which returns no results/ records, will cause error: "Source:No eligible fields found. Description: No item selected." The error is generated due to incorrect field mappings as fields do not exist because the Native Query block does not provide metadata when no results/ records are returned. The map will run successfully only when the Native Query block returns results/ records as the correct metadata is provided. This is a known limitation of the Native Query block.
Issue/Introduction
If no results are available when using a Native Query block and the solution runs.The Map will Error out with "Source:No eligible fields found. Description: No item selected"
Environment
TIBCO Scribe® Online
Resolution
To prevent the issue from happening ensure the Native Query block will always return results/ records. Another suggested workaround was to make sure the Native Query block would always return a dummy record which could then be filtered out with help of a If or Else block.
Feedback
Yes
No
Powered by
