You can translate the question and the replies:

Error opening "SELECT oid from pg_type where typname = 'geometry'"

I have made ODBC connection to Denodo from Alteryx. Connection is successful. But, when I ran the workflow to query a Denodo table/view in Alteryx, it throws below error. Start: Designer x64: Started running D:\Alteryx\New Workflow1.yxmd at 6/23/2017 5:10:02 PM Info: Input Data (1): ODBC Driver version: 03.50 Error: Input Data (1): Error opening "SELECT oid from pg_type where typname = 'geometry'": No Columns Returned. End: Designer x64: Finished running New Workflow1.yxmd in 1.3 seconds with 1 error Here are my queries. Is the Alteryx integration with Denodo supported ? Am I making anything wrong with respect to connection / query? Please suggest.
user
23-06-2017 08:46:02 -0400
code

4 Answers

Could you please update ??
user
03-07-2017 05:28:28 -0400
Hi, The “ Error opening “SELECT oid from pgtype where typname = ‘geometry’”: No Columns Returned” has been solved in the update 20170515 of Denodo. This update has been included in Denodo Express in June 2017. You can download the latest version of Denodo Express in the [STEP 1. Denodo Express Installers](https://community.denodo.com/express/download/) section and migrate your metadata from following the steps shown in the [STEP 4. (Optional) Upgrade & Migration from Denodo Express 5.5](https://community.denodo.com/express/download/) section (these steps are also valid for Denodo 6.0). Hope this helps!
Denodo Team
05-07-2017 07:48:21 -0400
code
Will this update fix this issue?
user
 Edited on: 18-05-2018 18:47:44 -0400
Hi, The answer is yes, updating to the version 20170515 (or higher) of denodo or using a Denodo Express later than June 2017 will fix the issue. Regards.
Denodo Team
03-08-2017 05:26:36 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here