PostgreSQL bulk load invalid value error

Question

I set up a connection to write Bulk data into PostgreSQL database and i get an invalid value error. I have tried using the data cleansing tool and I have also tried reading various different tables and I get the same error. I have enabled logging, but it does not give additional information on this error. I have uploaded the same dataset using non-bulk write tool and it works fine, however it takes hrs. to load 250k records, which the bulk load is supposed to speed up. I have also tried data stream using the same bulk load option.

Has anyone experience the same?

Started running scenario 5 Bulk.yxmd at Thu Jun 19 09:03:01 2025
00:00:00.000 - Alteryx: Running at a Low Priority.
00:00:00.040 - Alteryx: Allocating requested memory would be more than available physical memory. Reverting to 5720.9 MB of memory.
00:00:00.040 - WorkflowId - Alteryx: 1e44b518-6934-44dd-9cc1-49bec449e33f
00:00:00.040 - RunId - Alteryx: 60b663ed-96f7-4bbb-8d22-089e718a41d4
00:00:00.060 - Alteryx: This is AMP Engine; running 18 worker threads; memory limit 5720.9 MB.
00:00:00.950 - ToolId 1: ODBC Driver version: 03.51
00:00:00.950 - ToolId 1: There is no Lua script, using generic ODBC for DSN: ecsanltyxd
00:00:01.793 - ToolId 1: 227 records were read from "alt_wf_pub"."m_0account_hier_pub"
00:00:01.793 - ToolId 3: 227 records were summarized to 1 groups
00:00:01.793 - ToolId 10: 0 null rows were removed
00:00:01.808 - ToolId 10: 0 null columns were removed
00:00:02.320 - ToolId 7: ODBC Driver version: 03.51
00:00:02.320 - ToolId 7: There is no Lua script, using generic ODBC for DSN: ecsanltyxd
00:00:03.462 - Error - ToolId 7: Invalid value.
Finished in 00:00:03.482 with 1 error

stevemarkovick · Answer

I hit the same bulk load error in PostgreSQL using Alteryx—it turned out to be data type mismatch. A date field had text values like “N/A,” which PostgreSQL couldn’t cast. I fixed it by using a Select tool to explicitly set types and a Filter to clean invalid rows before writing. Always sanitize data before pushing it into a typed DB.

apathetichell · Answer

Do you have this configured in your ODBC in Alteryx? Are you using a greenplum driver or one of these? https://www.postgresql.org/ftp/odbc/releases/? What do you see on logging in your ODBC 64 logs (not your Alteryx logs) --- this looks like you are not using the correct driver. Data cleanse is a net negative here --- not a positive. Autofield could help --- but if it's a driver issue - that's not doing anything for you..