1. Miguel Alzate
  2. PowerServer
  3. Monday, 22 April 2024 18:09 PM UTC

Hello everyone!

When performing a retrieve on a datawindow with a rather complex SELECT in my Cloud application, the system throws the message “HTTP Error!” and, in the end, it does not bring any data.

If the SELECT is run in Microsoft's SQL Server Management Studio, it takes just over 10 minutes to bring back the results, which leads me to think that it may be a time out problem. However, I have all Web API timeouts set to zero (0), so it shouldn't abort the transaction.

If it is not a timeout error, what else could be the cause of the “HTTP Error!” message?

I am working with PB and PS 2022 R3 Build 3289.

Thank you very much for your usual attention and collaboration.

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 22 April 2024 18:48 PM UTC
  2. PowerServer
  3. # 1

Hi Miguel;

   Have you tried ...

SQLCA.DBParm = 'LongConnection=1"

Regards ... Chris 

Comment
There are no comments made yet.
mike S Accepted Answer Pending Moderation
  1. Monday, 22 April 2024 18:25 PM UTC
  2. PowerServer
  3. # 2

"takes just over 10 minutes"

 

there are timeout settings in the webapi that you will need to change if it is taking that long.  also look at the log files on the webserver to get the specifics of what went wrong.

 

in general, you will want to optimize your sql for any processes that take that long.  so maybe add indexes or change the sql 

 

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.