Skip to Content

Connection Error B/W DataServices and SQL Server

We have Data Services Designer Version is 14.2.6.1113

We have CMS & Repositories in both SQL Server Version is 2014 & 2017

All of these are hosted in AWS.

From last few days after the Job Server restart, all our jobs are failing with below error.

520 2224 DBS-070401 2/21/2019 10:59:01 AM ODBC data source <DB Server> error message for operation <SQLFetchScroll>: 520 2224 DBS-070401 2/21/2019 10:59:01 AM <[Microsoft][SQL Server Native Client 11.0]TCP Provider: A connection attempt failed because the connected party did not 520 2224 DBS-070401 2/21/2019 10:59:01 AM properly respond after a period of time, or established connection failed because connected host has failed to respond. 520 2224 DBS-070401 2/21/2019 10:59:01 AM [Microsoft][SQL Server Native Client 11.0]Communication link failure 520 2224 DBS-070401 2/21/2019 10:59:01 AM [Microsoft][SQL Server Native Client 11.0]Protocol error in TDS stream>. 520 2224 CON-120108 2/21/2019 10:59:01 AM |Dataflow DF_ETL_Validate_LOB_Version 520 2224 CON-120108 2/21/2019 10:59:01 AM Database connection to <DB Server> is broken. Retrying with retry count <6> and sleep 520 2224 CON-120108 2/21/2019 10:59:01 AM interval <10> seconds. 520 2224 CON-120109 2/21/2019 10:59:01 AM |Dataflow DF_ETL_Validate_LOB_Version 520 2224 CON-120109 2/21/2019 10:59:01 AM Database connection to <DB Server> was broken. Successfully obtained connection after <1> 520 2224 CON-120109 2/21/2019 10:59:01 AM attempts.

Or

ODBC data source <DB Server> error message for operation <SQLFetch>: <[Microsoft][SQL Server Native Client 11.0]TCP Provider: The semaphore timeout period has expired. [Microsoft][SQL Server Native Client 11.0]Communication link failure>.

any help is appreciated

Add a comment
10|10000 characters needed characters exceeded

  • Thank you for your question. Your question relates more to Data Services than the BI Platform. I fixed your tags for you. Please be more careful when selecting tags in the future. Thank you

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 21, 2019 at 12:34 PM

    the connectivity between your DS server and SQL server is not working properly. Either your SQL server is down or AWS network is.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.