Forum Discussion

DiegoPLAB's avatar
DiegoPLAB
Advocate I
1 year ago
Solved

On-premises gateway issue

Good morning, in our trial subscription we face an issue using on-prem gateway to ingest data from a local SQL Server instance. We built a pipeline with a Copy Data activity, that connects to our o...
data engineering
  • DiegoPLAB's avatar
    DiegoPLAB
    1 year ago

    Good morning,

    the Microsoft support team suggested us to downgrade the gateway to an older version (October 2024).
    With that version, we didn't faced the 9518 error anymore.

Sephir's avatar
Sephir
Frequent Visitor
11 months ago

I'm experiencing the same issue. Are there any other solutions besides downgrading? I can't determine why this is happening. Microsoft Support suggested increasing the server capacity, but the server appears to be performing well and is responsive (just had some spikes of 100% CPU for shor period of time).

v-menakakota's avatar
v-menakakota
Community Support
11 months ago

Hi Sephir ,

Thanks for sharing your case. From what we’ve seen in this thread, there seem to be two main directions:

  • In one case, downgrading the gateway to the October 2024 version stopped the 9518 errors. It may be worth trying that if you haven’t already.
  • Even if your SQL Server looks fine, short spikes in CPU or network can still cause this runtime busy error. Sometimes splitting the copy into smaller activities or running the pipeline when the server is less busy can help.

Since Microsoft Support is already involved, I’d suggest letting them know your exact gateway version and server load patterns. That will help confirm if this is a known gateway issue or something resource-related.

Best Regards, 
Community Support Team