Unanswered

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

(0) Share

Report

Posted on by mapembert

Hello forum!

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

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mapembert ,

Firstly follow the troubleshooting steps listed in below documentation:

https://azure.microsoft.com/pt-br/blog/sql-azure-connectivity-troubleshooting-guide/

Regards,

Mona
mapembert 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! We can connect to DB2 remotely using the connection parameters but I will try these steps as close as I can to see if anything else applies. We use DB2 and not SQL Server so not everything will apply.
mapembert 4 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-monli-msft , Mona, Looks like all the suggestions are in place.
Any suggestions on how I can get more details, add tables manually, or give the discover of tables more time?
Mike