Forum Discussion
User configuration issue" Error When Copying Data from On-Premises Server to Microsoft Fabric
Hi Avadiya444 ,
Thank you for the update. Based on your note that the error only happens when multiple pipelines run in parallel, this might points to a resource or concurrency issue with the On-premises Data Gateway.
Here are a few things to check:
- Try limiting how many pipelines run at once. Too many can overwhelm the gateway or SQL Server.
- If load is high, you could set up a gateway cluster to distribute it.
- The gateway logs and system performance (CPU, memory) during failures might show if it’s being overloaded.
- Enable retry policies in your pipelines to handle temporary spikes.
Please refer the attached links for more infomation:
copy-activity-performance-and-scalability-guide
data-factory/data-factory-limitations
data-factory/connector-troubleshoot-overview
Manage on-premises data gateway high-availability clusters and load balancing
Hope this resolve your query.If so,give us kudos and consider accepting it as solution.
Resolver IHi Avadiya444,
I think, it comes from the Data Gateway configuration.
Did your gateway server is able to ping your SQL Server machine?
Can you try to update your gateway to the latest version?
Otherwise, are you able to access the Data Gateway logs to have more details about the error?
Regards,
Yohann
Hi yvaubourg,
Sorry for late response.
I checked the links that you attached, and this doesn't seem to be related to the On-premises data gateway program on the store servers. As I understand, it is more about the load on this program. For example, when I do not launch all 11 pipelines with Copy Data at once, but instead run them individually, the "User Configuration error" does not occur.
Additionally, this issue also appears when other pipelines are running in parallel — the same error can occur in one of them.Regards,
Avadiya
Hi Avadiya444 ,
Thank you for the update. Based on your note that the error only happens when multiple pipelines run in parallel, this might points to a resource or concurrency issue with the On-premises Data Gateway.
Here are a few things to check:
- Try limiting how many pipelines run at once. Too many can overwhelm the gateway or SQL Server.
- If load is high, you could set up a gateway cluster to distribute it.
- The gateway logs and system performance (CPU, memory) during failures might show if it’s being overloaded.
- Enable retry policies in your pipelines to handle temporary spikes.
Please refer the attached links for more infomation:
copy-activity-performance-and-scalability-guide
data-factory/data-factory-limitations
data-factory/connector-troubleshoot-overview
Manage on-premises data gateway high-availability clusters and load balancing
Hope this resolve your query.If so,give us kudos and consider accepting it as solution.
