Hello Support Team!
I'm having an issue with Skyvia importing data into SQL and the issue seems to be inconsisntently happening. Today most of the automatic (Scheduled) package runs were successful however any manual run I try fails.
Some of the scheduled runs did also fail all with the following error:
A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
I did follow skyvia support documentation on setting up a TCP/IP connection to SQL. I have verified those settings are correct. Have you seen this error before?
Any help or clues you can provide would be much apprecited, thank you!!
SQL Transport Layer Error
- 32Views
- Last Post 3 weeks ago
- Topic Is Solved
0
votes
Technology Specialist
posted this
5 weeks ago
0
votes
Dmitriy Muzurov
posted this
4 weeks ago
1
votes
Technology Specialist
posted this
4 weeks ago
posted
4 weeks ago
Hi Dmitriy,
Thank you for the response.
We did have port forwarding setup and has been working for months. I believe a SQL update, or an increase in traffic through that port from another application was causing a conflict with Skyvia's connection traffic to SQL Server. I can't say for sure but speculation leads me to believe SQL connections were not terminating correctly.
However,
I was able to fix the issue above by switching from direct connection to using Skyvia Agent from a different server.
0
votes
Dmitriy Muzurov
posted this
3 weeks ago
posted
3 weeks ago
Hi,
We are glad to know the issue is solved.
Feel free to contact us, should you have any questions.