Connection issue when copying from one DB to another

  • 14Views
  • Last Post 08 November 2018
0
votes
Marina Seredova posted this 08 November 2018

We are trying to copy from one table in one database to another table in another database. BOth the connections are available

But when we run the job it says :

 

"A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)"

0
votes
Mariia Zaharova posted this 08 November 2018

Most likely, this issue occurs at SQL Server side and doesn't relate to Skyvia. We recommend you take a look at these threads:

https://sqlserverscribbles.com/2013/02/15/tcp-provider-the-semaphore-timeout-period-has-expired/

https://stackoverflow.com/questions/853676/how-to-avoid-sql-query-timeout

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/d99b4d8e-feeb-43cb-80af-3d4826340a2c/the-semaphore-timeout-period-has-expired?forum=sqldataaccess

 

Also, you can try increasing timeout parameters of your SQL Server connections in Skyvia (Advanced options, Command and Connection Timeouts):

https://skyvia.com/resources/docs/index.html?sqlserver_connections.htm

Close