Alteryx Designer Desktop Discussions

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

PostGreSQL Upload Issue

nlewis
7 - Meteor

I have a requirement to upload data to an instance of PostGreSQL in Amazon RDS. I can do this successfully with the PG ODBC connector but it is very slow. When using the PG Bulk Uploader I get the following error: Current transaction is aborted, commands ignored until end of transaction block. Usually when I see this error, it means there's some sort of mismatch in data types or field size between what I'm trying to upload and the destination table. But I had success with the same data set using the ODBC connector. Any insight would be much appreciated!

1 REPLY 1
apathetichell
18 - Pollux

What are the field types that you are uploading to your db? (ie can you post the results of a field info tool?)

Labels