Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

I am getting an error while loading data from Vertica to SSIS.

Open Database Connectivity (ODBC) error occurred. state: 'HY000'. Native Error Code: 20. [Vertica][VerticaDSII] (20) An error occurred during query execution: Renegotiate requested by the server. Schannel does not support renegotiation. For vertica server versions above 9.2.1, consider setting the configuration parameter 'TLSRenegotiationLimit' to zero. The connection will be closed. server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.


  • Bryan_HBryan_H Employee

    What is the Vertica server version? E.g. output of select version();
    If you are able, and the server version is indeed 9.2.1 or later, edit the ODBC data source to include the parameter TLSRenegotiationLimit=0

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.