Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

error while parsing ODBC column description types

joelharder
5 - Atom

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-relea... and https://help.alteryx.com/release-notes/en/release-notes/designer-release-notes/designer-2024-1-relea...).

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!

13 REPLIES 13
Arlete
5 - Atom

Thanks jrainone, with this version  v11.01, the error doesn't occur.

BLamb
6 - Meteoroid

This worked for me also! Thanks for sorting

Inactive User
Not applicable

Same! Just went back to 11 and I'm all good. Thanks!

msant9043
5 - Atom

Downgrading the drivers isn't an option due to NPT concerns. How to fix?

Labels
Top Solution Authors