question

tpnRel-2188 avatar image
0 Votes"
tpnRel-2188 asked tpnRel-2188 answered

Azure Data Factory - Data Flow: Internal Server Error:Failed to submit job on instance pool. Integration Runtime 'wirInt'

Hello, I am trying to create Data flow inside ADFs when I am preparing it inside debug mode, everything is working. Once I published it and try to trigger it after about 30s I receive this error: "Error 135, Internal Server Error: Failed to submit job on instance pool. Integration Runtime 'wirInt'". I have tried different integration runtimes. Is there someone who has managed it?

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

tpnRel-2188 avatar image
0 Votes"
tpnRel-2188 answered

Find out that this issue is based on unsupported "Latin" letters like "ščřžý" in the Resource Group name. Build data flow in another resource group without them it's working as it should.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Samy-7940 avatar image
0 Votes"
Samy-7940 answered tpnRel-2188 commented

Hi @tpnRel-2188 ,If you are using self-hosted integration run time, please go through below documentation to troubleshoot:

https://docs.microsoft.com/en-us/azure/data-factory/self-hosted-integration-runtime-troubleshoot-guide?tabs=data-factory

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @Samy-7940 unfortunately, no. I am using only Azure integration runtimes. I have tried setting up different TTL and even with and without "Virtual network configuration." Still same error 135.

Self-hosted even says that they aren't supporting Data Flows.
143030-image.png


0 Votes 0 ·
image.png (57.2 KiB)
Samy-7940 avatar image
0 Votes"
Samy-7940 answered tpnRel-2188 commented

Hi @tpnRel-2188 , unfortunately, Azure doesn't have robust list of error code which explicitly gives out cause and

probable workaround. All I could see is below which is not comprehensive enough

https://docs.microsoft.com/en-us/azure/data-factory/data-flow-troubleshoot-guide

Meanwhile below question on the similar lines was asked before, error code is different but

worth giving a shout. Thanks

https://docs.microsoft.com/en-us/answers/questions/47480/dataflow-in-azure-data-factory-giving-internal-ser.html

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for trying to help. I have tried to find if we have assigned some tag inside, and unfortunately, not. First, I thought that this error was strictly for data flow, but now I have tried to do the same with Power Query, and the same Error 135 "Failed to submit the job on instance pool" appeared. I can't understand what is meant by "submit the job on instance pool." And it is depressing when it's working inside debug mode but not in the production version.

0 Votes 0 ·
Samy-7940 avatar image
0 Votes"
Samy-7940 answered

Hi @tpnRel-2188 , below documentation is good read on instance pool. Please go through it.

Best practices: pools: https://docs.microsoft.com/en-us/azure/databricks/clusters/instance-pools/pool-best-practices Thanks

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.