error while parsing ODBC column description types

Hello,

I am currently experiencing an error in Alteryx Designer (v24.2). Every input/output data tool I use that accesses my (PostgreSQL) database gives the following errors:

Unexpected error while parsing ODBC column 1 description types:
Unexpected error while parsing ODBC column 2 description types:
...

repeated for however many columns are in the table.

This error only started occurring after I updated my PostgreSQL ODBC driver to the latest version (v17.00.00.04).

I could not find any instances of people having this error on the Alteryx community at all, but I did see that it was listed in more than one patch note as being fixed (such as https://help.alteryx.com/release-notes/en/release-notes/designer-release-notes/designer-2023-1-release-notes.html#idp112393 and https://help.alteryx.com/release-notes/en/release-notes/designer-release-notes/designer-2024-1-release-notes.html##).

It floods my output with error messages which is annoying, but everything appears to be working as usual, and the data is getting properly input/output to the database regardless of these errors.

I’ve been playing with it for about a day now, and nothing I can think of gets it to go away. Any help would be greatly appreciated!

Input

Output

Database Connection

Accepted answers

jrainone

just downgraded to v11.01 and it is not throwing an error.

https://www.postgresql.org/ftp/odbc/versions.old/msi/

All comments

apathetichell

turn on increased logging in your odbc 64 connection. look at the logs. I'd recommend 1) downgrading your driver. 2) opening a support ticket with Alteryx. You have the newest (most likely to have bugs) version of Alteryx. you're also running a newer driver. Get your errors in your logs - and use that to explain your issue to support.