locked
when we read data from Google Big query compoment in Azure Data Factory , when no of recored more than 6000 it will error out RRS feed

  • Question

  • Hi All,

    when we read data from  Google Big query component in Azure Data Factory , when no of record more than 6000 it will error out,

    below is error message,

        "errorCode": "2200",

        "message": "ErrorCode=UserErrorFailedToConnectOdbcSource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.\r\nERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.\r\nERROR [HY000] [Microsoft][DriverSupport] (1160) Cannot enable SSL for the connection when connecting to a server that has not enabled SSL. If the server has SSL enabled, please check if it has been configured to use a SSL protocol version that is lower than what is allowed for the connection. The minimum SSL protocol version allowed for the connection is: TLS 1.2.,Source=,'",

        "failureType": "UserError",

        "target": "435673422_Sessions",

        "details": []


    • Edited by manish0000 Wednesday, March 18, 2020 7:27 AM eroor code
    Wednesday, March 18, 2020 7:27 AM

All replies

  • Hello manish0000 and thank you for bringing this to our attention.  To better troubleshoot your issue, could you please confirm my understanding is correct, and supply some additional information?

    Your source is Google BigQuery.  For the same query/request, no error is thrown when there are fewer than 6000 records in the result.  Only when there are 6000 or more records you get the error.

    In the Google BigQuery limitations documentation it says:

    The following limits apply to ReadRows calls using the BigQuery Storage API:

    • ReadRows calls per minute: 5,000 : When you read data using the BigQuery Storage API, you are limited to 5,000 ReadRows calls per minute, per user, per project.

    I suspect you are hitting the limit.  The error you reported talks about SSL / TLS rather than reporting a limitation message from Google BigQuery.  This does not preclude the limitation being the root cause of your issue.  A second problem may have arisen in the process of reporting the limit.  To help determine if this is the root cause, can you tell me:

    • How long did the copy activity run?  Was it less than 2 minutes?
    • Does Google report hitting limitations to you?
    • Is the issue intermittent, or consistent?
    • What are you using for the sink of you copy activity?
    • What happens if you try to pull this much data so quickly without using Data Factory?


    Wednesday, March 18, 2020 8:30 PM
  • We have not received a response from you.  Are you still facing the issue?  If you found a solution, would you please share it here with the community?  Otherwise, let us know and we will continue to engage with you on the issue.
    Friday, March 20, 2020 8:35 PM
  • Since we have still not heard back from you, we will assume you found your own resolution.  If you found a solution, would you please share it here with the community?
    Monday, March 23, 2020 10:26 PM