An Azure service for ingesting, preparing, and transforming data at scale.
Hello Oleksii Roiko,
Welcome to the Microsoft Q&A and thank you for posting your questions here.
I understand that your Fabric Pipeline copy activities (source: on-premises MariaDB via on-premises data gateway) are failing.
The failure is occurring inside the Fabric Pipeline runtime on the on-premises data gateway, before the database connection is reached. That's not your MariaDB. Since the key errors are: FabricIntegrationRuntimeServi*eHost is not startedand FabricPipelineWorker.exe or Fbricworker.exe ... is unable to esablish a connection with the Fabri* Pipelines services.
What you can do to fix is to:
- Explicitly allow outbound HTTPS from the gateway server to:
*.frontend.clouddatahub.net TCP 43 - Ensure TLS/SSL inspection or endpoint security is not blocking Fabric Pipeline runtime traffic.
- Restart the supported on-premises data gateway service:
ne* stop PBIEgwServicenet start PBIE*wService - Retest the Fabric Pipeline Copy Activity.
- If the issue persists, export gateway logs and check Event Viewer for blocked startup, TLS, policy, or certificate errors involving
FabricPipelineWorker.exe,Fabricworker.exe, orFabricIntegrationRuntimeServiceHost.exe.
After allowing *.frontend.clouddatahub.net:443 and restarting the gateway service, the Fabric Pipeline runtime should be able to connect to Fabric services. If the same error continues after these validations, then this becomes a Microsoft Fabric Support/Product Group escalation with gateway logs, Event Viewer logs, activity ID, gateway version, and exact UTC failure time.
Use the below resource links for more reading and action/steps:
- https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-communication
- https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-tshoot
- https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-restart
- https://learn.microsoft.com/en-us/fabric/data-factory/how-to-access-on-premises-data
I hope this is helpful. Please! Do not hesitate to let me know if you have any other questions, steps or clarifications.
Please do not close the thread by upvoting and accepting the answer if any part of it is helpful.