cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mapembert
New Member

connection attempt failed.... did not properly respond after a period of time

Came across PowerApps yesterday and wanted to connect to our enterprise system in MS Azure instance running DB2. My connection is successful but it fails to load the tables. I suspect the timeout is due to the fact that our enterprise system has nearly 1000 tables. Is there a way to increase the timeout time or manually add 1 table? I know the schema and table name of course.

 

This is the full error message:

 

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond NNN.NNN.NN.NNN:50006 SQLSTATE=08S01 SQLCODE=-1037
inner exception: Microsoft Db2 Client: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond NNN.NNN.NN.NNN:50006 SQLSTATE=08S01 SQLCODE=-1037
clientRequestId: 1c39a92f-41e2-49e3-99e8-92186843ad45

Session ID: 9bfecc14-b0aa-4a3a-9ae5-42540f91a163

 

I attempted to get answers to the forum but had no luck:

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/connection-attempt-failed-did-not-p...

1 REPLY 1
v-xida-msft
Community Support
Community Support

Hi @mapembert ,

Could you please share a screenshot about the error message within your app?

Do you mean that the issue occurs when you create a connection to the DB2 table from your app?

 

Currently, there is a limit on each single outgoing request, the maximum Timeout value is 180 seconds, if the request could not be respond within 180 seconds, you may get the Timeout error.

 

If you want to increase the timeout time or manually add 1 table when you create a connection to your DB2 from PowerApps app, I afraid that there is no way to achieve your needs in PowerApps currently.

 

Also please consider re-create a new connecton to your DB2 table from your app, and make sure the Network is in a good condition, then check if the issue is solved. 

 

Please consider submit an assisted support ticket for further help through the following link:

https://powerapps.microsoft.com/en-us/support/pro

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,114)