Connection issue when copying from one DB to another

  • 8Views
  • Last Post 2 weeks ago
0
votes
Marina Seredova posted this 2 weeks ago

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 2 weeks ago

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