Problem writing data to ODBC

RuochanGao

Hi there,

I need to set up a scheduled workflow to update the output to Vertica database, and the connection has been made successfully, because I can write data into vertica table as long as I select first 20 rows or fewer, which is weird, my total records is around 200k rows, without error message.

Can anyone advise what's going on here? I have adjusted the DSN option to allow it batch insert and increase the buffer size to 32MB, but it doesn't really help. As for the Vertica constraint, it's confirmed that way larger size data can be written into it using Python. 

Failed without error message.png

Succeed when selected 20 rows.png

MeganBowers

@RuochanGao I think this may be a good candidate to report through MyAlteryx to ensure Customer Support is aware and can provide insight into resolution. The case submission process will also search the Knowledge Base in case there is a known solution!