How to execute a TIBCO Data Virtualization Packaged Query that fails with error 'The output cursor must have at least one column'?
Article ID: KB0073166
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions, |
Description
A Packaged Query is a database specific query that is defined in TIBCO Data Virtualization (TDV). It is associated with a specific data source and at execution time TDV pushes the query unchanged down to the physical data source. However, when a TDV packaged query is executed, it fails with the following error:
This article provides details on how to resolve this.
The output cursor must have at least one column. [qengine-1900441] [Log ID: 116f19fd-0767-437c-a021-c7203416bef4]Screenshot for reference:
This article provides details on how to resolve this.
Environment
All supported Operating Systems
Resolution
Every Packaged Query in TDV must have exactly one OUT parameter that is a cursor with at least one column. Optionally, you may add a variable number of scalar outputs, but the single cursor parameter is always required. To define the cursor, navigate to the 'Parameters' tab and select the button 'Design by example'. With this, TDV will build the complete cursor. Now the Packaged Query will run as expected
Here is a GIF with an example:
Here is a GIF with an example:
Issue/Introduction
How to execute a TIBCO Data Virtualization Packaged Query that fails with error 'The output cursor must have at least one column'?
Feedback
Yes
No
Powered by
