Consider setting the configuration parameter 'TLSRenegotiationLimit' to zero
Server version - Vertica Analytic Database v9.0.1-8
ODBC Driver used : 10.1.1.0
I am trying to use Vertica DB with Power BI. The PowerBI Vertica Connector seems to be using the latest drivers , however my Production Vertica DB sees to be of older version (9.0.1)
Now, I am continuously encountering the following error :
_“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”
I get this error everytime I try to read data more than 2 to 3 million. Actually I am not sure if the volume is the issue!
The error message tells me to set TLSRenegotiationLimit=0 if server is above 9.2.1.
Firstly, On the ODBC DSN setting, I dont see option to set - TLSRenegotiationLimit=0
Secondly my DB is NOT above 9.2.1!
How do I overcome this issue? I cannot downgrade the ODBC drivers on our Power BI gateway server, to an older version as many other reports seem to be working fine with latest drivers. Please help!