Log in to AnswerLog in to Follow
sai charan
21Views
6Comments
Query Time out issue. "Internal Error " shown on page.
Question
Development

Hi All,

I am receiving Internal Error issue on the page.

When I checked in logs, it shows - The timeout period elapsed prior to completion of the operation or the server is not responding. 

I have manually ran the query in SQL Management studio, query got executed within 1 sec. But when we try from Browser, it is showing Query time out.

Thanks,

Saicharan

0
0
on 7th Jan
Salman Ansari
mvp_badge
MVP

Hi,

Please see the below screen shot and try

0
0
on 7th Jan

Hi @Salman Ansari  : 

This issue is occuring in multiple screens , do you suggest to increase time out in all the screens?

0
0
on 19th Jan

Hi Sai, 

Please check the detailed error in the service center, which will provide you enough information to further dig out which operation(Method or SQL) is getting timed out. If it is possible please share the screenshot over here. 

 Thanks,

Sachin

0
0
on 19th Jan
Salman Ansari
mvp_badge
MVP

Yes

0
0
on 19th Jan
Craig St.Jean
mvp_badge
MVP

Replying to Sachin Mahawar's comment on 19 Jan 2021 11:23:21

Hello Sai,

In addition to taking a look at the logs in Service Center as @Sachin Mahawar mentioned, are you able to post the OML file? Or possibly a screenshot of your flow and the SQL you are executing?

If it takes 1 second in SSMS then it should not take that much more from OutSystems, unless there are network issues between OutSystems and the database.

Also, can you please answer:

  • Is OutSystems On-Premise, on a private cloud, or in the OutSystems cloud?
  • Is this the internal OutSystems database or an external one?
    • If external, is it On-Premise, a private cloud, or the OutSystems cloud?
  • Are there any VPN connections between OutSystems and your SQL database?
0
0
on 19th Jan

Hi @Craig St.Jean  

This issue is occurring for bunch of screens. There is no integrations as such to fetch the data while loading these screens.

  • Is OutSystems On-Premise, on a private cloud, or in the OutSystems cloud? - Outsystems On-Premise
  • Is this the internal OutSystems database or an external one? - Internal Outsystems Database
    • If external, is it On-Premise, a private cloud, or the OutSystems cloud?
  • Are there any VPN connections between OutSystems and your SQL database? - No , it is direct connection to Database.


Thanks,

Saicharan

0
0
on 20th Jan
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.