Why does EXPORT TO VERTICA fail
Why does EXPORT TO VERITICA fail with vsql:export.sql:3: ERROR 4534: Receive on v_dw_node0001: Message receipt from v_test_node0001 failed [canceled] after a couple of hours? Exporting a smaller amount of data works fine.
+2Hi Serbaut, thanks for your question! We'll look into this and see why it's failing after a length of time.
Hi Serbaut, Please review the following link. https://community.vertica.com/vertica/topics/_copy_from_vertica_or_export_produces_receipt_failed_or_socket_error Hope this helps. Thanks, Bhawana
I believe it was a firewall issue. Export to vertica seems to keep an idle control channel open that the firewall dropped after about one hour.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
